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 SQL Server Senior Tech Lead, you will design, implement, develop and fine-tune. You will work with a fast-paced, skilled team of engineers and developers across multiple high-profile projects. You will also participate in IT projects from the inception of the project through the daily maintenance phase of a project. If you are a top-notch SQL Developer with Performance tunning and looking for the next challenge, apply now!

Core Requirements and Responsibilities:

Essential job functions included but are not limited to the following:

• Subject matter expert in Microsoft SQL Server, with advanced experience in T-SQL, execution plan interpretation, DMVs, and performance tuning for high-scale enterprise systems. Experience with SQL Server 2012+ is strongly preferred.
•  Deep expertise in T-SQL and strong PL/SQL debugging skills, with practical experience troubleshooting issues across the full stack, including database code, application integration, and data access layers.
• Strong track record of performance tuning and stabilizing legacy SQL codebases, including optimizing long-running queries, improving stored procedure efficiency, and remediating systemic database bottlenecks in production environments.
• Extensive experience with large-scale OLTP and reporting databases, including expert-level knowledge of indexing, partitioning, schema and storage design, and database performance engineering.
• Expected to operate at a senior/expert level, providing technical leadership, driving database design and optimization standards, and solving highly complex performance and scalability challenges.

·        Address issues such as parameter sniffing, blocking, and deadlocks.

Knowledge, Skills and Abilities:

• Senior TL SQL Server Database Engineer with 10- 12 years of enterprise experience in database engineering, architecture, administration, and performance optimization.
• Subject matter expert in SQL Server database design, architecture, and programming, with a strong focus on scalability, reliability, and operational excellence.
• Extensive expertise in performance tuning, query optimization, and troubleshooting in large-scale, mission-critical database environments.
• Highly skilled in trace analysis, root cause identification, and recommending effective, long-term solutions for database issues.
• Advanced command of Transact-SQL (T-SQL) for developing complex queries, stored procedures, functions, and performance-focused database code.
• Experience with SQL Server DTS and SSIS for ETL, data migration, and enterprise data integration initiatives is a added advantage.
• Working knowledge of PowerShell scripting to support automation, monitoring, and administrative efficiency.
• Understanding of SQL Server installation, configuration, maintenance, and environment management.
• Strong practical experience with SQL Server 2017 and its capabilities in enterprise deployments.
• Quick learner with a demonstrated ability to adopt new technologies and deliver value rapidly.
• Effective communicator with strong documentation, collaboration, and stakeholder engagement skills.
• Senior team player who fosters a positive engineering culture and leads by example through ownership and accountability.
• Solution-oriented professional who thrives on solving new, complex, and high-impact technical challenges.
• Goal-focused and execution-driven, with a consistent track record of delivering measurable results.
• Proactive in learning products and business context to align technical solutions with organizational needs.
• Skilled at multitasking and adapting to changing priorities while maintaining high standards of quality.
• Exceptional problem-solving and troubleshooting capabilities in both project and production support scenarios.
• Proven ability to manage and deliver across multiple concurrent initiatives in demanding environments.

Qualifications:

• Qualification B.E/MCA/MTech.

THE VERTAFORE STORY

Over the past 50 years, Vertafore has advanced the entire insurance distribution channel with the best software solutions in the industry. Today, we’re proud to say hundreds of thousands of Vertafore users rely on our solutions to write business faster, reduce costs, and fuel growth by increasing collaboration and streamlining processes. Vertafore leads the industry with secure, cloud-based mobile products that provide superior reporting and analytics, delivering actionable insight— right when customers need it most. We partner with other leading technology companies to deliver comprehensive solutions to improve the way our customers do business and serve their customers.

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 conducts preemployment background screenings. 

We do not accept resumes from agencies, headhunters, or other suppliers who have not signed a formal agreement with us.