Senior SQL Server DBA — Cloud, HA/DR & Automation

Vertafore Career Center; Colorado; On-site; USD 125,000 - 150,000; Full time

Job summary

Vertafore is seeking a Sr. Database Administrator to design, administer, and optimize our enterprise SQL Server platforms across on-premises and AWS.

You’ll drive performance, reliability, and automation to support critical business applications and production services, collaborating with SRE, Cloud Ops, and application teams. You will implement high availability, DR, backups, and monitoring, plus PowerShell-based automation, always focusing on security, scalability, and efficient incident

Qualifications

• Strong experience with SQL Server administration in on-premises and AWS environments.
• Advanced T-SQL scripting, troubleshooting, and database administration skills.
• Strong experience with SQL Server performance tuning and query optimization, including execution plan analysis, wait statistics, indexing, statistics, and workload analysis.
• Proactively identify and remediate regressed queries, long-running and resource-intensive queries, inefficient execution plans, CPU/IO bottlenecks, blocking, deadlocks, and other performance issues.
• Strong knowledge of SQL Server Always On Availability Groups, Failover Clustering, Transactional Replication, and Log Shipping.
• Experience designing, implementing, and supporting High Availability (HA) and Disaster Recovery (DR) solutions.
• Troubleshoot and resolve complex issues involving database integrity, performance, availability, migrations, replication, connectivity, security, backup/recovery, and database operations.
• Perform SQL Server installation, configuration, upgrades, patching, migrations, maintenance, and performance optimization.
• Develop and enhance database automation for provisioning, monitoring, backup/recovery, maintenance, access management, and other repetitive operational activities.
• Strong experience with PowerShell scripting for database administration and automation.
• Understand application and business requirements and recommend database solutions that meet performance, scalability, availability, security, and supportability requirements.
• Provide technical guidance and recommendations on database standards, performance, architecture, and best operational practices.
• Work effectively as an individual contributor while collaborating with application teams, SRE, Cloud Operations, vendors, consultants, and other technology teams.
• Participate in an on-call rotation supporting 24x7 database services.
• Familiarity with tools and platforms such as GitLab and ServiceNow.
• Experience supporting multi-tenant database environments is a plus.
• Strong analytical, problem-solving, troubleshooting, written, and verbal communication skills.
• Ability to manage multiple priorities, adapt to changing requirements, and quickly learn new database and cloud technologies.

Responsibilities

• Strong experience with SQL Server administration in on-premises and AWS environments, including SQL Server on EC2 and Amazon RDS.
• Advanced T-SQL scripting, troubleshooting, and database administration skills.
• Strong experience with SQL Server performance tuning and query optimization, including execution plan analysis, wait statistics, indexing, statistics, and workload analysis.
• Proactively identify and remediate regressed queries, long-running and resource-intensive queries, inefficient execution plans, CPU/IO bottlenecks, blocking, deadlocks, and other performance issues.
• Strong knowledge of SQL Server Always On Availability Groups, Failover Clustering, Transactional Replication, and Log Shipping.
• Experience designing, implementing, and supporting High Availability (HA) and Disaster Recovery (DR) solutions.
• Troubleshoot and resolve complex issues involving database integrity, performance, availability, migrations, replication, connectivity, security, backup/recovery, and database operations.
• Perform SQL Server installation, configuration, upgrades, patching, migrations, maintenance, and performance optimization.
• Develop and enhance database automation for provisioning, monitoring, backup/recovery, maintenance, access management, and other repetitive operational activities.
• Strong experience with PowerShell scripting for database administration and automation.
• Understand application and business requirements and recommend database solutions that meet performance, scalability, availability, security, and supportability requirements.
• Provide technical guidance and recommendations on database standards, performance, architecture, and best operational practices.
• Work effectively as an individual contributor while collaborating with application teams, SRE, Cloud Operations, vendors, consultants, and other technology teams.
• Participate in an on-call rotation supporting 24x7 database services.
• Familiarity with tools and platforms such as GitLab and ServiceNow.
• Experience supporting multi-tenant database environments is a plus.
• Strong analytical, problem-solving, troubleshooting, written, and verbal communication skills.
• Ability to manage multiple priorities, adapt to changing requirements, and quickly learn new database and cloud technologies.

Skills

SQL Server admin

T-SQL scripting

Query optimization

HA/DR design

PowerShell

On-call support

Multi-tenant DB

System troubleshooting

Tools

AWS EC2

Amazon RDS

GitLab

ServiceNow

Job description

Vertafore is seeking a Sr. Database Administrator to design, administer, and optimize our enterprise SQL Server platforms across on-premises and AWS.

You’ll drive performance, reliability, and automation to support critical business applications and production services, collaborating with SRE, Cloud Ops, and application teams. You will implement high availability, DR, backups, and monitoring, plus PowerShell-based automation, always focusing on security, scalability, and efficient incident