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

Current Guardian Colleagues: Please apply through the internal Jobs Hub in Workday

Finance Jobs in Chennai, Tamil Nadu, India

Active Roles Feed

Senior Consultant - IT