Senior Consultant - IT

Guardian Life Insurance; Chennai; Hybrid; INR 4,000,000 - 6,000,000; Full time

Job summary

Guardian Life Insurance, based in Chennai, seeks an experienced SQL Server & SSIS Technical Manager with 10–15 years in database development, data integration, ETL solutions, and team leadership. You will own delivery excellence and guide end-to-end projects across enterprise-scale databases and migration initiatives.

You will architect data integration, optimize performance, manage production support, and mentor a team of SQL Developers and DB Engineers while coordinating with stakeholders and

Qualifications

• 10–15 years of experience in database development, data integration, ETL solutions, and team management.
• Strong expertise in SQL Server, SSIS, performance tuning, data migration, and production support.
• Experience leading end-to-end delivery teams with technical leadership and stakeholder management.

Responsibilities

• Lead design, development, and maintenance of enterprise SQL Server databases and ETL solutions.
• Architect and implement data integration using SSIS.
• Drive query optimization, indexing strategies, and performance improvements.

Skills

SQL Server

SSIS

ETL

Performance Tuning

Data Migration

Team Leadership

Stakeholder Management

Education

Bachelor's/Master's in CS/IT

Tools

Azure Data Services

CI/CD pipelines

Job description

Job Description:

Experience Level: 10 - 15 Years

Location: Chennai (Hybrid)

Job Summary:

• We are looking for an experienced SQL Server & SSIS Technical Manager with 10 - 15 years of experience in database development, data integration, ETL solutions, and team management.
• The ideal candidate should have strong expertise in SQL Server, SSIS, database performance tuning, data migration, and production support, along with proven experience managing end-to-end delivery teams. The role requires technical leadership, stakeholder management, solution design, and ownership of delivery excellence.

Key Responsibilities:-

Technical Leadership

• Lead the design, development, and maintenance of enterprise-scale SQL Server databases and ETL solutions.
• Architect and implement robust data integration solutions using SSIS.
• Drive database optimization, query tuning, indexing strategies, and performance improvements.
• Lead data migration and modernization initiatives across multiple platforms.
• Review and approve technical designs, code reviews, and deployment plans.
• Ensure adherence to coding standards, security guidelines, and best practices.

Delivery & Project Management

• Manage end-to-end delivery of SQL and ETL projects.
• Own project planning, estimation, resource allocation, and execution.
• Track project milestones, risks, dependencies, and delivery commitments.
• Ensure timely releases with high quality and minimal production issues.
• Work closely with Product Owners, Architects, Business Analysts, and Engineering teams.

Team Management

• Manage a team of SQL Developers, SSIS Developers, and Database Engineers.
• Mentor and guide team members on technical and functional aspects.
• Conduct performance reviews, career development discussions, and skill enhancement initiatives.
• Drive team productivity, utilization, and engineering excellence.
• Support hiring, onboarding, and competency development activities.

Production Support & Governance

• Provide leadership during critical production incidents.
• Drive root cause analysis and preventive action plans.
• Monitor database health, availability, and performance.
• Establish operational dashboards, KPIs, and SLA adherence.
• Ensure backup, recovery, disaster recovery, and data security compliance.

Stakeholder Management

• Collaborate with business stakeholders to understand requirements and translate them into technical solutions.
• Present project updates, risks, and delivery status to senior leadership.
• Manage customer expectations and ensure high stakeholder satisfaction.

Required Skills:-

Technical Skills

• Strong hands-on experience with Microsoft SQL Server (2012/2016/2019/2022).
• Extensive experience in SSIS (SQL Server Integration Services).
• Expert in SQL programming, Stored Procedures, Functions, Triggers, Views, and Indexing.
• Strong experience in query optimization and performance tuning.
• Experience with ETL design, data warehousing concepts, and data migration.
• Knowledge of SQL Server Agent, Replication, Backup & Recovery.
• Experience with Azure Data Services is a plus.
• Understanding of CI/CD pipelines and DevOps practices.

Leadership Skills

• End-to-end team management experience.
• Strong stakeholder and client management skills.
• Experience leading distributed teams across multiple locations.
• Excellent communication and presentation skills.
• Strong problem-solving and decision-making abilities.

Preferred Qualifications

• Bachelor’s or Master’s degree in Computer Science, IT, or related field.
• Microsoft SQL Server certifications preferred.
• Experience in Insurance, Financial Services, Healthcare, or Enterprise applications is an added advantage.
• Exposure to Agile/Scrum delivery methodologies.

Location:

This position can be based in any of the following locations:

Chennai