Principal Database Engineer

$130,000-$160,000 + VIP Bonus
Vertafore is a leading technology company whose innovative software solution are advancing the insurance industry. Our suite of products provides solutions to our customers that help them better manage their business, boost their productivity and efficiencies, and lower costs while strengthening relationships.
Our mission is to move InsurTech forward by putting people at the heart of the industry. We are leading the way with product innovation, technology partnerships, and focusing on customer success.
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.
We are headquartered in Denver, Colorado, with offices across the U.S., Canada, and India.
JOB DESCRIPTION
As a Principal Database Engineer, you will be a technical subject matter expert and set the standard for database engineering excellence on database performance, availability, scalability, administration, design, development, and support applications. You'll collaborate with DBAs, product owners, lead top-notch software engineers and world-class database engineers to design and implement our next generation database infrastructure. Microsoft SQL Server is a core focus and Postgres/MongoDB as the secondary skillset.
You will design, develop, implement and maintain database, procedures, and functions that accommodate changing business priorities and technological changes while providing availability, scalability, performance, recoverability, reliability, and security. You should have good understanding of cloud concepts. If you are a top-notch Principal Database Engineer and looking for the next challenge, apply now!
Core Requirements and Responsibilities:
Essential job functions included but are not limited to the following:• Experience and expertise with database performance, availability, understanding of database load and scalability on on-premises and cloud.• Experience in creating optimal infrastructure configurations and optimization best practices or recommendations for various workload types on various infrastructure environments - on-premises and AWS.• Experience with architecting, setting up and managing scalable databases in AWS RDS and self-managed SQL instances.• Experienced with planning and execution of large-scale database migrations from on-premises to AWS.• Significant experience in cloud native applications, workload optimization, automation programming models to automate running database performance tests.• Subject Matter Expert (SME) SQL Server Database Internals.• Tackle the database performance issues, rapidly analyze and debug database performance issues identify bottlenecks and optimize product/service performance to improve user experience.• Deep expertise with relational/distributed database implementation and advanced SQL query optimization and SQL query tuning.• Work with software developers closely to improve code base performance (e.g-algorithm redesign), reduce resource consumption and shorten request latency.• Analyze and trend performance of SQL Server, PostgreSQL, MongoDB environment.• Proactively identify performance issues or concerns and respond quickly to performance monitor alerts.• Perform capacity planning to ensure all SQL Server, PostgreSQL database systems grow proactively with the business growth.• Create monitoring, reporting, data-mining tools to do performance and capacity-related tests and analysis.• Identify database performance/capacity-related issues proactively and work with systems, network, SRE and engineering teams to discover resolutions.• Performance testing background - built test plans/scripts from scratch and report on results/risk.• Experience with AWS database administration, deployments, ideally EC2 and RDS SQL Server.• Provide performance improvement solutions; collaborate with development/DevOps teams.• Engage and resolve (or supervise and guide other DBAs) in highly escalated and complex issues related to performance, corruption, data recovery or application related P1 scenarios.• Responsible for configuration, tuning, identifying/resolving complex query bottlenecks and maintenance of database management.• Partner with multiple product teams to ensure appropriate integration of functions to meet goals as well as identify and define necessary system enhancements to deploy new products and process improvements.

• Hands-on end-to-end Database Development encompassing Database Design and Development working with cross-functional teams.
• Should be able to debug application code written in PL SQL and T SQL for different applications.
• Understand the business priorities and requirements; architect/develop solutions to meet the business need and lead execution.
• Work as an individual contributor and collaborate with multiple teams/vendors/consultants in an effective manner.
• Advanced knowledge in Transactional Replication, Clustering, SQL Always-on
• Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server in AWS and on-premises environments.
• Experience in infrastructure automation through Powershell, Terraform, Chef, Ansible, Puppet or other automation tool is highly advantageous.
• Meet database availability, and reliability goals and service level objectives.

Knowledge, Skills and Abilities:

• 8+ years of expert knowledge and experience in SQL Server performance tuning, PL/SQL development and other DB types (PostgreSQL, MongoDB) with a bachelor's degree in computer science (or related field).
• 7+ years' experience in System Architecture, Performance Analysis and Data Analysis.
• 6+ Years Prior Database architecture, performance, and solutions design.
• 4+ years of AWS cloud and DevOps experience preferred.
• Experience with security and hardening database platforms.
• RDS/Aurora Postgres, or MongoDB administration experience desirable.
• Enhance automated functions including monitoring, backing up, recovering, increasing availability, user management, access to controls and logging audits.
• 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.
• Knowledge of SQL, data warehousing and data management concepts.
• Familiarity with standard tools and platforms that enable continuous delivery such as GitLab, Kubernetes and ServiceNow.
• Demonstrated detailed knowledge of BI areas including ETL and ELT design, analytics and reporting, warehouse staging, data lake creation.
• Nice to have experience with multi-tenant systems.
• Demonstrated desire and ability to learn technologies quickly.
• Deep understanding of different software stacks including OS, DB technologies run on the clouds and ability to interpret benchmark results to applications performance tuning.
• Contributes to a positive team environment.
• Enjoys finding and implementing solutions to new challenges.
• Excellent multitasking skills and task management strategies.
• Train and mentor database engineers.
• Provide guidance and support to the enterprise, act as single point of contact for database related issues.
• Strong problem solving and troubleshooting abilities.
• Participate in On Call rotation schedule as part of 24x7 service requirement
• Exceptional written and verbal communication skills with experience in writing white papers, interacting with customers, partners and presenting solutions to a wide range of end-users.
• Certifications in MSSQL Server or other Cloud database certifications preferable.

Additional Requirements and Details:

• Travel required up to 10% of the time.
• Located and working from an office location.
• 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

The Vertafore Way
Insurance is about relationships, and technology should make those relationships stronger. That's why, at Vertafore, it's our mission to transform the way the industry operates by putting people at the heart of insurance technology. By focusing on our customers, becoming better every day, and delivering results you can see, we provide the level of trust and security that insurance is all about.• Bias to Action: We're united by an innate drive to take action and make a difference in the technology and insurance spaces.• Win Together: We work together as one team, showing empathy and respect along the way.• Show Up Curious: We work to challenge one another to push boundaries and think beyond the box.• Say It, Do It: We honor every one of our commitments because integrity is important to us.• Customer Success is Our Success: We cultivate authentic relationships and follow up by actively listening to their needs.• We Love Insurance: We appreciate the impact insurance has on the world.
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
• Vertafore is a Flexible First working environment which allows team members to work from home as often as you'd like, while using our offices as a place for collaboration, community, and teambuilding. There are times you may be asked to come into an office and/or travel for specific meetings for a specific business purpose and this varies by job responsibilities.
• 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 - 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, 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.