DBA / Senior SQL Server Database Administrator

Position Overview:

We are seeking a highly skilled Senior SQL Server Database Administrator (DBA) to manage the design, performance, integrity, and security of production databases within a highly available 24/7 enterprise environment. This role will lead database architecture initiatives, support large-scale distributed systems, and ensure optimal database performance and reliability.

The Senior DBA will also play a critical role in planning and developing new database systems, troubleshooting complex issues, and advising development teams on best practices.

Key Responsibilities:

• Design, architect, implement, and maintain Microsoft SQL Server databases in a 24/7/365 production environment

• Support large, highly available, distributed enterprise database systems

• Manage database replication, clustering, hot standby configurations, and table partitioning

• Perform performance tuning, indexing optimization, query optimization, and stored procedure tuning

• Implement and maintain backup/recovery strategies and high-availability solutions

• Monitor databases, configure alerts, and enforce maintenance best practices

• Troubleshoot and resolve complex production database issues

• Advise developers on SQL best practices, data consistency, and performance optimization

• Lead database initiatives and provide technical leadership within a collaborative team environment

• Participate in on-call support rotation and respond to after-hours technical issues as needed

Required Qualifications:

• 5+ years of hands-on experience with Microsoft SQL Server database architecture, management, modification, and support

• Experience managing large-scale, highly available enterprise production databases

• Strong expertise in:

• Query development and stored procedure optimization

• Indexing strategies and data structure tuning

• Replication, clustering, and high-availability configurations

• Backup and recovery processes

• Deep understanding of database technical architecture, ETL processes, and reporting tools

• Strong knowledge of database structures, theories, principles, and best practices

• Fluency in at least one scripting or programming language

• Proven ability to work in a 24/7 production environment

• Demonstrated leadership capabilities

Preferred Qualifications:

• Experience working with both Windows and Linux operating systems

• Background in programming, systems development, or systems administration

• Experience in a healthcare environment