TL, Software Engineer (MS SQL database, SSIS, performance tuning)

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 

We are seeking a highly skilled and experienced Database Development Team Lead with deep expertise in database development, performance tuning, query optimization, ETL pipelines, and reporting solutions. This role combines technical leadership, database performance engineering, and data platform ownership, including SSIS (ETL) and SSRS (reporting). The ideal candidate will lead a team responsible for designing, optimizing, and maintaining enterprise-grade data systems, ensuring high availability, scalability, and performance across applications. You will be involved in troubleshooting production issues, implementing bug fixes, improving system stability, and designing technical solutions. You will play a critical role in analyzing performance bottlenecks, driving optimization strategies, and mentoring team members to deliver high-performing database solutions. You will also have the opportunity to bring your creative ideas to the table to deliver better solutions to our users.

All of this will be accomplished with cutting edge, lean-agile, software development methodologies. Our culture fosters collaboration, innovation, integrity, mentorship, commitment to success and fun. Our managers are dedicated to growing their people and offering an opportunity that allows you to make impact in your career.

Core Requirements and Responsibilities:

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

Database Design & Architecture

·        Design scalable and efficient database schemas and data models

·        Ensure adherence to data integrity, security, and compliance standards

·        Collaborate with architects and developers to align database design with application needs

Database Performance & Optimization

·        Lead initiatives for query optimization, execution plan analysis, and indexing strategies

·        Fine-tune database performance for high-volume transactional and analytical workloads

·        Optimize stored procedures, triggers, functions, and complex joins

·        Identify and eliminate performance bottlenecks across database layers

·        Improve IO, CPU, memory utilization, and concurrency handling

ETL & Data Integration (SSIS)

·        Design, develop, and optimize ETL pipelines using SQL Server Integration Services (SSIS)

·        Ensure efficient data extraction, transformation, and loading processes

·        Improve ETL performance through parallelism, batching, and data partitioning

·        Manage data workflows, scheduling, and error handling

·        Collaborate with data consumers to ensure reliable data delivery

Reporting & Analytics (SSRS)

·        Optimize report queries for performance and scalability

·        Ensure report availability and performance in production environments

Incident Management & Root Cause Analysis

·        Resolve complex production issues related to database performance and data pipelines

·        Perform deep root cause analysis (RCA) and implement long-term fixes

·        Support critical incidents with minimal downtime and business impact

Leadership & Team Management

·        Lead, mentor, and grow a team of database developers, ETL engineers, and reporting specialists

·        Conduct code reviews and enforce best practices in SQL development, ETL, and reporting

·        Provide technical guidance and training on performance optimization and SSIS/SSRS best practices

Monitoring & Performance Analysis

·        Knowledge of monitoring tools like Dynatrace, Splunk to track database performance

·        Analyze trends and recommend improvements for long-term scalability

·        Develop automated scripts/tools for performance monitoring and tuning

Cross-Functional Collaboration

·        Work closely with product development, QA, and Professional Services teams

·        Support performance testing, releases, and deployment optimization

·        Drive cross-team initiatives for performance improvements

Automation & Continuous Improvement

·        Introduce automation for ETL processes, reporting, and performance tuning

·        Introduce best practices for addressing performance issues

·        Continuously improve system reliability and efficiency

Knowledge, Skills and Abilities:

·        Should have good knowledge of database designing, stored procedures, user defined functions, triggers and joins.

·        Should have good knowledge of data analysis.

·        Should have good communication skills.

·        Fix the issues on time and able to provide detailed information with root cause analysis and issue fix details.

• Mentoring junior support engineers on troubleshooting techniques.

·        Should have knowledge of applications monitoring tools like Dynatrace, Splunk.

·        Curious and avid learners.

·        Self-motivated and excellent problem-solvers.

·        Collaborate with their peers, designing pragmatic solutions.

·        Operate best in a fast-paced, flexible work environment.

·        Prepare technical training and information sessions for other staff.

·        Should be able to take decisions quickly.

Qualifications:

·        8–12 years of experience in SQL Server database development and performance tuning

·        Strong expertise in:

·        Query optimization and execution plan analysis

·        Indexing strategies, partitioning, and database tuning

·        Stored procedures, triggers, UDFs

·        Hands-on experience with:

• SQL Server Integration Services (SSIS) – ETL development and optimization
• SQL Server Reporting Services (SSRS) – report design and performance tuning

·        Strong experience in data modeling and database design

• Have an intense passion for building software and mentoring their teams
• Are very strong in both design and implementation at an enterprise level
• Can work advanced database magic with relational and NoSQL databases
• Are in-tune with high performance and high availability design/programming
• Have experience in security best practices for software and data platforms
• Design 'perfect-fit' solutions with engineering teams and business units to drive business growth and customer delight
• Enjoy solving problems through the entire application stack
• Are interested and capable of learning other programming languages as needed.