Lead SQL DBA (L3) – Enterprise Data Platforms & Reporting

Keka Technologies Private Limited; Gurugram District; On-site; INR 3,500,000 - 5,500,000; Full time

Job summary

Keka Technologies Private Limited in Gurgaon, India seeks a senior SQL Server DBA/ETL specialist to administer enterprise SQL Server environments and lead data integration initiatives. You will implement HA/DR, optimize performance, ensure security and compliance, and mentor junior DBAs.

Key duties include ETL design with Informatica PowerCenter/IICS, SSIS, and BI reporting using Power BI and SSRS. Strong experience in enterprise ERP data handling, cloud and on‑prem environments, and automation

Qualifications

• 10–15 years of SQL Server Database Administration.
• 5+ years supporting enterprise production environments.
• 3+ years of Informatica PowerCenter/IICS experience.
• Strong experience with enterprise reporting and BI platforms.
• Experience supporting Higher Education ERP systems is highly preferred.

Responsibilities

• Administer and support enterprise SQL Server environments (SQL Server 2016–2022).
• Manage installation, configuration, patching, upgrades, migrations, and capacity planning.
• Implement High Availability (Always On AG, Clustering, Replication, Log Shipping) and Disaster Recovery solutions.
• Perform database performance tuning, optimization, monitoring, and health assessments.
• Ensure database security, backup, recovery, and compliance with enterprise standards.
• Design, develop, and support ETL solutions using Informatica PowerCenter, Informatica IICS, and SSIS.
• Develop scalable data pipelines, source-to-target mappings, and data quality processes.
• Support enterprise data warehouse and ERP integration initiatives.
• Develop and optimize enterprise reports, dashboards, and analytics using: SSRS, Power BI, Cognos, Tableau, Oracle BI Publisher.
• Optimize complex SQL queries and reporting databases for high-performance analytics.
• Troubleshoot database, integration, ETL, and reporting issues in production environments.
• Support ERP upgrades, migrations, and data conversion projects.
• Support Azure SQL, AWS RDS, and hybrid database environments.
• Automate administrative tasks using T‑SQL, PowerShell, Python, and SQL Agent.
• Participate in database modernization and cloud migration initiatives.
• Provide L3/L4 production support and technical leadership.
• Mentor junior DBAs and conduct technical reviews.
• Develop database standards, SOPs, and operational best practices.

Skills

T-SQL

Query Optimization

Always On Availability Groups

Clustering

Power BI

SQL Server Performance Tuning

Mentoring/Leadership

PowerShell

SQL Agent

Extended Events

Query Store

Azure SQL

Informatica PowerCenter/IICS

Tools

PowerShell

SQL Agent

Extended Events

Query Store

Job description

• Administer and support enterprise SQL Server environments (SQL Server 2016–2022).
• Manage installation, configuration, patching, upgrades, migrations, and capacity planning.
• Implement High Availability (Always On AG, Clustering, Replication, Log Shipping) and Disaster Recovery solutions.
• Perform database performance tuning, optimization, monitoring, and health assessments.
• Ensure database security, backup, recovery, and compliance with enterprise standards.

ETL & Data Integration

• Design, develop, and support ETL solutions using Informatica PowerCenter, Informatica IICS, and SSIS.
• Develop scalable data pipelines, source-to-target mappings, and data quality processes.
• Support enterprise data warehouse and ERP integration initiatives.
• Develop and optimize enterprise reports, dashboards, and analytics using:
  • SSRS
  • Power BI
  • Cognos
  • Tableau
  • Oracle BI Publisher
• Optimize complex SQL queries and reporting databases for high-performance analytics.

ERP & Application Support

• Troubleshoot database, integration, ETL, and reporting issues in production environments.
• Support ERP upgrades, migrations, and data conversion projects.
• Support Azure SQL, AWS RDS, and hybrid database environments.
• Automate administrative tasks using T‑SQL, PowerShell, Python, and SQL Agent.
• Participate in database modernization and cloud migration initiatives.

Leadership

• Provide L3/L4 production support and technical leadership.
• Mentor junior DBAs and conduct technical reviews.
• Develop database standards, SOPs, and operational best practices.
• Collaborate with Infrastructure, Cloud, Security, Development, and Product teams.

Required Technical Skills

Database

• T‑SQL, Query Optimization
• Always On Availability Groups
• Clustering

ETL & Data Integration

Reporting & BI

Monitoring Tools

• Extended Events
• Query Store

Experience

• 10–15 years of SQL Server Database Administration.
• 5+ years supporting enterprise production environments.
• 3+ years of Informatica PowerCenter/IICS experience.
• Strong experience with enterprise reporting and BI platforms.
• Experience supporting Higher Education ERP systems is highly preferred.