Senior Manager - DBA | 10+ years | Gurgaon

Michael Page; Gurugram District; On-site; INR 3,500,000 - 6,000,000; Full time

Benefits offered by this job

Permanent role based in Gurugram

Collaborative technology team

Job summary

Michael Page is seeking a Senior Database Administrator with 10+ years of experience to lead complex IBM DB2 environments and IIDR-based replication. The role requires expertise in HADR, HACMP, and high-availability architecture, along with cloud familiarity across AWS/Azure/Oracle Cloud.

You will manage DBAs and partner with service vendors, drive performance tuning, and oversee backup/DR planning to ensure 24x7 production readiness.

Qualifications

• Extensive experience with IBM DB2 and IIDR environments.
• Experience in supervising complex databases and architecture.
• Strong knowledge of data replication, RPO/RTO planning and DR strategies.
• Proficiency with IBM HADR, HACMP, and high availability configurations.
• Hands-on troubleshooting of performance, availability and topology challenges in large databases.

Responsibilities

• Install, configure and upgrade DB2 Advanced Enterprise Edition (LUW) and IIDR, and related products.
• Maintain IIDR replication and setup new replication environments on request.
• Troubleshoot DB2, IIDR and OS performance issues with data-driven analysis.
• Support development teams during pre-launch reviews for DB changes and replication tuning.
• Maintain HADR databases and perform DR drills and failover testing.
• Implement and maintain database security, access control, and vulnerability assessments.
• Define and enforce backup, recovery policies, data purging and archival.

Skills

DB2

MongoDB

Oracle

SQL Server

PostgreSQL

MySQL

Infosphere CDC

Infosphere Data Server

Oracle Enterprise Manager

AWS

Azure

Oracle Cloud

HADR

HACMP

Logshipping

Performance Tuning

Data Pipeline

BI

Data Analytics

Team Leadership

Tools

DB2dart

DB2explain

DB2top

db2diag

OPM

Job description

About Our Client

A business services company based in Gurugram.

Job Description

• Technical database admin with good technology knowledge, Vendor and stakeholder management & communication skills.
• 10+ years with expertise and knowledge on supervision of complex & combination of technology like IBM DB2, MongoDB, Oracle, SQL Server, Postgres, MySQL, Infosphere Change Data Capture, Infosphere Data Server, Oracle Enterprise Manager.
• Should be expert in design, architecture and maintenance of large and complex databases.
• Understanding of Cloud technologies like AWS, Azure, Oracle cloud - Iaas, Paas and SaaS environments.
• Must have experience in leading teams of DBAs and managing managed service partners.
• Hands-on experience in configuring & maintaining IBM HADR, HACMP, Oracle Physical Standby, SQL Server AAG, Replication, Logshipping
• Hands-on experience in troubleshooting complex database performance, availability and fine-tuning issues of large databases.
• Hands on experience in integration projects, building information framework, data pipeline, business intelligence, data analytics replication through IBM CDC.
• Should be able to design solutions for workloads on virtual & physical server to meet business continuity & DR plans and RTO/RPO targets.
• Performs all DBA tasks to support 24x7 production environments including Index rebuild & update statistics .

The Successful Applicant

We're looking for someone who has:

• Installation, configuration and up-gradation of Database server software - IBM DB2 Advanced Enterprise Edition (AESE 11.5) for LUW, IBM Infosphere Data Replication (IIDR 11.4) and related products.
• Maintain IIDR Replication environment and new replication setup on request. Knowledge of setup Access Manager and configure Data Store with DB2 I Server (LUW) and P Series (AS400).
• Trouble shooting DB2 & IIDC environmental issues and detailed analysis of system performance based on data from both DB2 and the operating system.
• Extensive Hands-on on tools DB2dart, DB2explain, DB2top, db2diag, notification logs, snapshot, event monitor, db2hc or enabling hmon and Infosphere Optim Performance Manager (OPM 5.3) for trend analysis.
• Provide support to Development teams in pre-launch review for planned Database & Replication changes and advice for tuning opportunities. Validate and maintain fallback plan for Production changes.
• Maintain High Availability & Disaster Recovery (HADR) databases and perform Business Continuity Drill (BCP) activities. Troubleshooting HADR sync issues and configure new HADR on request.
• Implement and maintain database security & access control. Perform Vulnerability Assessment (VA).
• Establish and maintain backup and recovery policies procedures, perform data purging and archival.

What's on Offer

• Permanent role based in Gurugram.
• Opportunity to work in the business services sector.
• Be part of a collaborative and skilled technology team.