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 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:

812 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.