Senior Consultant - IT
Guardian Life
- Location
- Chennai, Tamil Nadu, India
- Job type
- Full-time
Required skills
- Agile
- Azure
- compliance
- database
- DevOps
- end-to-end
- ETL
- production support
- project management
- Root Cause Analysis
- SQL
About the role
Guardian Life
Website:
guardianlife.com
Job details:
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
Click on Apply to know more.
This page is fully interactive when JavaScript is enabled. Please enable JavaScript to apply or browse related roles.