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:

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.

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.