Sr Database Administrator

Medata Inc.; Northern (KY); Hybrid; USD 120,000 - 140,000; Full time

Job summary

Medata Inc. in the United States seeks a Senior Database Administrator to own SQL Server environments across production and non-production, ensuring security, performance, and reliability.

You will mentor DBAs, lead upgrades and cloud migrations (Azure SQL), implement standards, and collaborate with application teams. This senior role requires strong T-SQL, HA/DR expertise, and excellent communication.

Qualifications

• Minimum 8 years' experience administering Microsoft SQL Server in a production enterprise environment.
• Proven expert in T-SQL, query optimization, and performance tuning.
• Experience with HA/DR architectures (Always On, failover clustering, log shipping).
• Cloud experience with Azure SQL and/or AWS RDS preferred.
• Strong leadership, mentoring, and communication skills; Agile familiarity.

Responsibilities

• Architect, implement, and maintain highly available, secure, and scalable SQL Server databases.
• Own HA/DR strategy and lead regular DR testing.
• Lead capacity planning and performance initiatives; resolve systemic issues.
• Establish and enforce database standards, security, backup/recovery, and monitoring.
• Serve as escalation point for critical incidents; drive root cause analysis.
• Lead upgrades, migrations, and cloud consolidations (Azure SQL).
• Evaluate tools and automation (PowerShell, RedGate, IaC) to improve reliability.
• Mentor DBAs and provide technical leadership and career guidance.
• Collaborate on database design reviews and performance tuning with dev teams.
• Manage vendor relationships and licensing for database platforms.

Skills

Leadership

Mentoring

Communication

Project management

Agile

T-SQL

SQL Server

On-call

Tools

Azure SQL Database/Managed Instance

AWS RDS

PowerShell

dbatools

RedGate SQL Monitor

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Sr Database Administrator

Full Time Regular Professional CA, US

8 days ago Requisition ID: 2899

Salary Range: $120,000.00 To $140,000.00 Annually

Position Summary

The Senior Database Administrator is a senior-level technical role responsible for the architecture, high availability, performance, security, and lifecycle management of enterprise SQL Server database environments. The role serves as the technical authority on database platform strategy, capacity planning, and disaster recovery, and provides mentorship and technical leadership to the Database Administrator team. Partners with the Senior Database Engineer and application development teams to establish and enforce database standards, and leads complex upgrade, consolidation, and migration initiatives.

Primary Duties & Responsibilities

• Architect, implement, and maintain highly available, secure, and scalable SQL Server database environments across production and non-production tiers.
• Own the organization's high availability and disaster recovery strategy (Always On Availability Groups, failover clustering, log shipping/mirroring), including planning and leading regular DR testing.
• Lead capacity planning and performance/scalability initiatives, proactively identifying and resolving systemic performance issues before they impact the business.
• Establish, document, and enforce database standards, policies, and best practices for security, backup/recovery, monitoring, and change management.
• Serve as an escalation point for critical database incidents; lead root cause analysis and drive preventive remediation.
• Lead complex, cross-functional projects such as SQL Server version upgrades, platform consolidations, and cloud migrations (e.g., Azure SQL).
• Evaluate, recommend, and implement database technologies, tools, and automation (e.g., RedGate, PowerShell, infrastructure-as-code) to improve reliability and reduce manual effort.
• Own the database security and compliance posture, including access controls, auditing, and encryption, in alignment with regulatory requirements.
• Mentor and provide technical leadership and career development guidance to Database Administrators and other team members.
• Partner with the Senior Database Engineer and application development teams on database design reviews, T-SQL performance tuning, and development standards.
• Manage vendor relationships and licensing for database platforms and tooling.
• Participate in an on-call rotation and provide senior-level guidance during off-hours escalations as needed.

Qualifications

• Minimum 8 years' experience administering Microsoft SQL Server in a production enterprise environment.
• Demonstrated experience with SQL Server 2017/2019/2022/2025, including planning and executing major version upgrades.
• Expert-level knowledge of T-SQL, including complex query optimization and performance tuning.
• Proven experience designing and supporting high availability and disaster recovery architectures (Always On Availability Groups, failover clustering, log shipping).
• Strong knowledge of RDBMS principles, schema design, normalization, and index strategy.
• Experience with cloud-hosted SQL Server environments (Azure SQL Database/Managed Instance or AWS RDS) strongly preferred.
• Experience with database security, auditing, and compliance frameworks (e.g., HIPAA) preferred, given the health care industry context.
• Experience with automation and scripting (PowerShell, dbatools, or equivalent) for routine database operations.
• Demonstrated technical leadership experience, including mentoring junior/mid-level DBAs.
• Familiarity with Agile principles and methodologies.
• Experience with RedGate SQL Monitor or similar monitoring/tooling a plus.
• Excellent communication skills, with the ability to translate technical concepts for both technical and non-technical/executive audiences.
• Strong project management skills, with the ability to manage multiple concurrent initiatives and competing priorities.
• Ability to work independently, exercise sound judgment, and drive initiatives with minimal supervision.