Principal SQL Database Administrator (SQL DBA, AWS, Performance Tuning, Architect)

Our fast-paced and collaborative environment inspires us to create, think, and challenge each other in ways that make our solutions and our teams better. Whether you’re interested in engineering or development, marketing or sales, or something else – if this sounds like you, then we’d love to hear from you!

We are headquartered in Denver, Colorado, with offices in the US, Canada, and India.

The insurance industry runs on Vertafore We equip agencies, MGAs, and carriers with the core digital systems, specialized AI, and data-driven foundation to eliminate distribution drag across the insurance lifecycle, spanning sales, servicing, and back-office operations.

Underpinned by unmatched speed and performance power, we are the trusted backbone that’s taking the insurance industry from friction to flow with Distribution Velocity – speed, performance, and trust - to drive growth at scale.

With over 95% of the top agencies and insurers and 50% of industry compliance transactions running through Vertafore, we lead at the intersection of innovation and trust, giving insurance professionals the confidence to transform and win in the AI era.

Our reach is global, with headquarters in Denver, Colorado, and offices across the U.S., Canada, and India.

Job Description

As a Principal DBA, you will provide technical leadership and hands-on expertise across Vertafore's enterprise database ecosystem supporting large-scale, business-critical applications. This role is focused on Microsoft SQL Server Administration, SQL Development, Performance Engineering, Query Optimization, AWS Database Services, and Database Modernization.

You will partner with Engineering, Architecture, Product, DevOps, and SRE teams to drive database performance, scalability, reliability, and operational excellence. The ideal candidate combines deep expertise in SQL Server Administration, T-SQL Development, Performance Engineering, AWS database technologies, automation, and high availability solutions, with the ability to influence technical strategy and mentor engineering teams.

Core Requirements and Responsibilities

Essential job functions include but are not limited to the following

Provide technical leadership for the architecture, administration, modernization, and support of SQL Server database platform across on-prem and AWS (EC2,RDS) supporting mission-critical applications.

Partner with development teams to improve database architecture, SQL coding standards, application performance, and cloud database adoption across On-prem and AWS platforms.

Lead database performance engineering initiatives through query tuning, Query Store, DMVs, execution plan analysis, wait statistics, indexing strategies, and workload optimization.

Analyze, troubleshoot, and resolve complex production database issues involving performance, scalability, availability, and reliability while implementing long-term engineering solutions.

Drive modernization efforts by optimizing database designs, T-SQL code, stored procedures, functions, views, ETL processes, and legacy database architectures.

Participate in production support, critical incident management, root cause analysis, and on-call activities as required.

Lead on-premises to AWS (EC2/RDS) database migrations, independently driving migration strategy, architecture decisions, risk mitigation, and performance optimization to ensure successful cloud transformation.

Develop and enhance database automation, CI/CD pipelines, Infrastructure as Code solutions, monitoring frameworks, and operational tooling to improve deployment reliability and engineering productivity.

Establish database engineering standards, governance, security controls, monitoring practices, and operational best practices across the organization.

Why Vertafore is the place for you: *Canada Only

The opportunity to work in a space where modern technology meets a stable and vital industry

Medical, vision & dental plans

Life, AD&D

Short Term and Long Term Disability

Pension Plan & Employer Match

Maternity, Paternity and Parental Leave

Employee and Family Assistance Program (EFAP)

Education Assistance

Additional programs - Employee Referral and Internal Recognition

Why Vertafore is the place for you: *US Only

The opportunity to work in a space where modern technology meets a stable and vital industry

We have a Flexible First work environment! Our North America team members use our offices for collaboration, community and team-building, with members asked to sometimes come into an office and/or travel depending on job responsibilities. Other times, our teams work from home or a similar environment.

Medical, vision & dental plans

PPO & high-deductible options

Health Savings Account & Flexible Spending Accounts Options

Health Care FSA

Dental & Vision FSA

Dependent Care FSA

Commuter FSA

Life, AD&D (Basic & Supplemental), and Disability

401(k) Retirement Savings Plain & Employer Match

Supplemental Plans - Pet insurance, Hospital Indemnity, and Accident Insurance

Parental Leave & Adoption Assistance

Employee Assistance Program (EAP)

Education & Legal Assistance

Additional programs - Tuition Reimbursement, Employee Referral, Internal Recognition, and Wellness

Commuter Benefits (Denver)

The selected candidate must be legally authorized to work in the United States.

The above statements are intended to describe the general nature and level of work being performed by people assigned to this job. They are not intended to be an exhaustive list of all the job responsibilities, duties, skill, or working conditions. In addition, this document does not create an employment contract, implied or otherwise, other than an "at will" relationship.

Vertafore strongly supports equal employment opportunity for all applicants regardless of race, color, religion, sex, gender identity, pregnancy, national origin, ancestry, citizenship, age, marital status, physical disability, mental disability, medical condition, sexual orientation