Senior MS SQL Database Administrator
Job Description
OperAxis is hiring a Senior MS SQL Database Administrator for a State Government / Public Sector transportation client. You'll join a tolling engineering and operations team, administering and tuning large SQL Server and cloud databases that support electronic toll collection. The role includes a rotation through help desk and application support. Duration: 9 months Requirements • 6+ years of MS SQL Server database administration • 3+ years of SQL Server performance tuning • 4+ years installing, upgrading, patching and migrating SQL Server • Upgrade experience with tolling SQL Server environments, including Query Tuning Assistant and Database Migration Assistant • 3+ years with SSIS, SSRS and SSAS • Transact-SQL coding and debugging • At least 1 year of Azure, Snowflake or Databricks • Clear communication using standard requirements and design artifacts • Preferred: SQL Server 2019 and later • Preferred: Cloud databases on Azure, Snowflake or Databricks • Preferred: Data modeling principles • Master's degree in computer science, information systems or a related field, or equivalent experience
Responsibilities
- Administer, monitor and tune SQL Server databases for uptime and availability
- Upgrade and migrate tolling SQL Server environments, including SQL 2012 to 2019 upgrades
- Diagnose and resolve deadlocks and blocking in production workloads using Extended Events, Query Store and wait statistics
- Tune very large databases (2 TB+), including index optimization and long-running workload analysis
- Install SQL Server 2022 and later with failover clustering, and manage clustering, mirroring and high availability
- Troubleshoot connectivity, access and security issues, and tune long-running SQL
- Review the existing database setup and propose and carry out improvements