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.
$125,000 - $150,000 / year
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.
Sr. Database Administrator
As a Sr. Database Administrator, you will be responsible for the design, administration, performance, reliability, and operational support of enterprise SQL Server database platforms supporting critical business applications. This role requires strong expertise in SQL Server across on-premises and AWS environments, with a focus on performance tuning, high availability, automation, operational stability, and production support.
You will work closely with application teams, SRE, Cloud Operations, and other stakeholders to understand database requirements, troubleshoot complex issues, recommend solutions, and continuously improve database reliability and operational efficiency. You will participate throughout the technology lifecycle, from project planning and implementation through production readiness and ongoing operational support.
Core Requirements and 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.
Knowledge, Skills and Abilities:
· Experience in troubleshooting and resolving database integrity issues, migration issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
· Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tool
· Enhance automated functions including monitoring, backing up, recovering, increasing availability, user management, access to controls and logging audits.
· MS SQL Server, SSRS experience required.
· Strong T-SQL scripting abilities and understanding of complex stored procedures, views, data aggregation/manipulation through table joins/queries, database design, normalization and de-normalization techniques.
· RDS/Aurora Postgres, RedShift or Oracle administration experience desirable
· Familiarity with standard tools and platforms such as Terraform, GitLab, Kubernetes and ServiceNow.
· Nice to have experience with multi-tenant systems
· Demonstrated desire and ability to learn technologies quickly
· Possesses good oral and written communication skills.
· Effectively multi-tasks and adapts to change.
· Strong problem solving and troubleshooting abilities
Qualifications:
· Bachelor’s Degree or higher in Computer Science, Engineering, Mathematics, or similar field or related work experience.
· 6 or more years of expert knowledge and experience in SQL Server administration, performance optimization, T-SQL development
· 3+ years of AWS cloud experience preferred
- Automation experience using languages like PowerShell and Python and automation tools like Terraform or Ansible
Additional Requirements and Details:
· Travel required up to 10% of the time.
· Ability to work remote with a stable internet connection on an as needed basis
· Located and working from an office location (when required)
· Occasional lifting and/or moving up to 10 pounds.
· Frequent repetitive hand and arm movements required to operate a computer.
· Specific vision abilities required by this job include close vision (working on a computer, etc.).
· Frequent sitting and/or standing.
#LI-HYBRID
#LI-REMOTE
Is this role not an exact fit for you? Keep an eye on our Careers Page for other positions!
Vertafore is a drug free workplace and conducts preemployment drug and background screenings.
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, genetic information, or any other characteristic protected by state or federal law.
We do not accept resumes from agencies, headhunters, or other suppliers who have not signed a formal agreement with us.
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 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, genetic information, or any other characteristic protected by state or federal law.
The Professional Services (PS) and Customer Success (CX) bonus plans are a quarterly monetary bonus plan based upon individual and practice performance against specific business metrics. Eligibility is determined by several factors including: start date, good standing in the company, and actives status at time of payout.
The Vertafore Incentive Plan (VIP) is an annual monetary bonus for eligible employees based on both individual and company performance. Eligibility is determined by several factors including: start date, good standing in the company, and actives status at time of payout.
Commission plans are tailored to each sales role but common components include quota, MBO's and ABPMs. Salespeople receive their formal compensation plan within 30 days of hire.
Vertafore is a drug free workplace and conducts preemployment drug and background screenings.
We do not accept resumes from agencies, headhunters or other suppliers who have not signed a formal agreement with us.
We want to make sure our recruiting process is accessible for everyone. if you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact [email protected]
Just a note, this contact information is for accommodation requests only.
Skills Required
- Bachelor's degree or higher in Computer Science, Engineering, Mathematics, or a similar field, or related work experience
- 6 or more years of expert experience in SQL Server administration, performance optimization, and T-SQL development
- Strong SQL Server administration experience in on-premises and AWS environments, including SQL Server on EC2 and Amazon RDS
- Advanced T-SQL scripting, troubleshooting, database administration, and complex stored procedure experience
- Experience with SQL Server performance tuning, query optimization, execution plans, wait statistics, indexing, statistics, and workload analysis
- Experience with SQL Server Always On Availability Groups, Failover Clustering, Transactional Replication, and Log Shipping
- Experience designing, implementing, and supporting high availability and disaster recovery solutions
- Experience with SQL Server installation, configuration, upgrades, patching, migrations, maintenance, and optimization
- Strong PowerShell scripting and database automation experience
- Microsoft SQL Server and SSRS experience
- Automation experience using PowerShell or Python and tools such as Terraform or Ansible
- 3 or more years of AWS cloud experience
- RDS/Aurora PostgreSQL, Redshift, or Oracle administration experience
- Familiarity with Terraform, GitLab, Kubernetes, and ServiceNow
- Experience supporting multi-tenant systems
- Strong analytical, problem-solving, troubleshooting, written, and verbal communication skills
- Ability to manage multiple priorities, adapt to changing requirements, and learn new technologies quickly
- Ability to participate in a 24x7 database on-call rotation
- Legal authorization to work in the United States
What the Team is Saying
Vertafore Compensation & Benefits Highlights
-
Leave & Time Off Breadth — Paid time off is described as flexible or unlimited, with additional paid holidays and periodic companywide recharge days. This breadth is positioned as a standout aspect of the package across public benefits materials.
-
Healthcare Strength — Medical, dental, and vision coverage are offered with multiple plan options, alongside life and disability insurance. Across employer-verified listings, health benefits are portrayed as solid and mainstream.
-
Parental & Family Support — Parental leave and adoption assistance are included, complemented by resources like dedicated mothers’ rooms and family-oriented events. These elements signal meaningful support for families in addition to core coverage.
Vertafore Insights
What We Do
We believe insurance is about relationships. And technology should only make them stronger. We exist to empower independent agents, carriers, and MGAs. To drive their success. Because their success is our success. And their ambitions for tomorrow are our goals for today. Since our inception, we’ve been the technology backbone of the insurance industry. We began punching cards for independent agents over 50 years ago and turned this passion for technology into a relentless pursuit. Born of human-centric purpose, we empower our customers with the technology to garner trust. Built to adapt, we equip the insurance channel for the future—transforming business and relationships along the way. Where others see opposition, we see opportunity. To look ahead. To modernize. To prepare our customers for what’s next—because we’re always thinking about it. Always innovating. Always building. Always creating. Quite simply…we love insurance. Because behind every policy—is a person. And we’re obsessed with powering the spirit of our industry.
Why Work With Us
Our team is bright and talented, and we bring passion to the work we do every day and continually strive to improve. We’re a Flexible First work environment, meaning team members work from home as often as they’d like, while using our offices as a place for collaboration, community, and team building. We work hard and we have fun doing it!
Gallery
Vertafore Offices
Hybrid Workspace
Employees engage in a combination of remote and on-site work.
Our Flexible First working environment allows team members to work from home as often as they'd like, while using our offices for collaboration and team building.
