Senior Consultant - IT

About the job

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