Lead DBA
Job ID 2023-4972
Description
Responsible for all aspects of database administration for SQL Server including implementation efforts for large and/or complex projects
Provide operational excellence as well as efforts for continuous improvement of database related processes and procedures
Work with SQL Server maintenance routines, such as backups, index and statistic maintenance, performance monitoring, etc.
Responsible for ensuring high levels of data availability and database performance.
Tunes and optimizes SQL Statements, Instance Parameters, and Data Storage, including the identification of performance related issues
Work in a complex environment with very large, highly secured datasets
Responsible for quality control and auditing of databases to ensure accurate and appropriate use of data
Work with multiple teams to deliver top quality solutions
Work with PowerShell to prepare and deploy database updates (internally developed processes)
Create and maintain PowerShell tooling.
Participation in on-call rotation
Qualifications:
Minimum of 8 years of SQL Server database administration experience
Thorough understanding of T-SQL
Experience with some form of HA/DR (replication, mirroring, AG, log shipping, etc.)
Experience with query tuning / performance tuning
SQL Server 2016 - 2019 experience
Experience with SQL backups and other maintenance tasks
Experience writing and modifying PowerShell automation scripts (dbatools.io, SMO, etc.)
SQL Security knowledge
A sense of ownership and a desire to make an impact
Good interpersonal skills while working with other teams
A willingness to create and update department relevant documentation
Ability to plan and lead a project