Senior Consultant - IT

Guardian; Chennai District; Hybrid; INR 3,500,000 - 6,000,000; Full time

Job summary

Guardian is seeking an experienced SQL Server & SSIS Technical Manager with 10–15 years of hands-on expertise in database development, data integration, and ETL solutions. The role emphasizes team leadership, end-to-end delivery ownership, and strong stakeholder management to ensure delivery excellence.

The candidate should excel in SQL Server, SSIS, performance tuning, and data migration, and will oversee production support and governance across enterprise-scale projects in a hybrid Chennai

Qualifications

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

Responsibilities

• Technical Leadership: Lead design, development, and maintenance of enterprise SQL Server databases and ETL solutions.
• Delivery & Project Management: Own project planning, estimation, resource allocation, and execution; track milestones and risks.
• Team Management: Manage SQL Developers, SSIS Developers, and Database Engineers; mentor and conduct performance reviews.
• Production Support & Governance: Lead during production incidents; ensure monitoring, backups, DR, and security compliance.
• Stakeholder Management: Translate requirements into technical solutions; report updates to senior leadership.

Skills

SQL Server

SSIS

Performance tuning

Data migration

Team management

Stakeholder management

ETL design

Education

Bachelor's or Master's degree in Computer Science/IT

Tools

Azure Data Services

CI/CD

Job description

• 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.

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