Trimble Viewpoint | Cloud OPS Database Administrator (DBA)
Reports to: Trimble Viewpoint Cloud OPS
Department: Trimble Viewpoint Cloud OPS
Location: Remote
Job Summary
You'll be an integral part of the SRE team at Viewpoint, who are responsible for the health of the infrastructure and work to empower the engineering team to design highly scalable, robust, and performant applications. We heavily use SQL Server, and our multi-region deployments are multi-terabyte, high throughput, and highly available.
We are looking for a DBA, but you must have competency with T-SQL, automating and optimizing processes, and being able to write in T-SQL.
Duties and Responsibilities
Administering the production SQL Server and Azure SQL Database estate
Performing daily checks, such as checking backups, database integrity, index performance
Ensuring the availability and security of databases and infrastructure
Maintaining database standards and access
Overseeing installation, patching, upgrades, and maintenance of the SQL estate.
Assisting with the optimization and tuning of database systems
Supporting the Development team with database and SQL-related queries/issues
Escalating issues where necessary to the DBA, Infrastructure, project teams or the IT management team
Participating in the on-call rota
On an occasional basis, provide cover for releases
Qualifications
Required Knowledge, Skills, Abilities, and Qualities
BS degree in a field directly related to software development, and 5+ years of relevant technical experience in application design and programming or an equivalent combination of education and experience
Proven experience in a DBE and/or DBA role, with a focus on tooling, automation, and database systems operation
Advanced T-SQL (to be understandable by others and to be clear and neat.) skills with practical experience in automating processes
Strong experience running MSSQL at TB scale on a cloud provider (Azure SQL, AWS RDS) focusing on high throughput and low latency
Understanding of execution plans, concurrency, indexing and performance tuning
Ability to troubleshoot database performance issues in a production environment
Experience collaborating with software engineers to define best practices related to the database, including schema design, query optimization, and CICD practices
Experience in High Availability and Disaster Recovery Methods
Experience in the automation of systems and infrastructure