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.

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
• We have a Flexible First work environment! Our North America team members use our offices for collaboration, community and team-building, with members asked to sometimes come into an office and/or travel depending on job responsibilities. Other times, our teams work from home or a similar environment.
• 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 - Tuition Reimbursement, 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 recruiting@vertafore.com Just a note, this contact information is for accommodation requests only.