Senior Database Administrator (DBA) - IBM Db2 (UDB)

Location

Gurugram/Noida/Hyderabad, India (Hybrid)

Experience

8-12 years

Role Summary

We are looking for a Senior DBA - IBM Db2 (UDB) with hands on experience in AWS RDS environments to provide end-to-end database operations support for enterprise-critical systems. The role involves ensuring high availability, performance, security, and compliance of Db2 databases along with managing cloud-based database services(AWS RDS). Strong understanding of cloud-native database operations is essential.

At Zensar, we're "experience-led everything". We are committed to conceptualizing, designing, engineering, marketing, and managing digital solutions and experiences for over 130 leading enterprises. We are a company driven by a bold purpose: Together, we shape experiences for better futures. Whether for our clients, our people, or the world around us, this belief powers everything we do. At the heart of our culture is ONE with Client - a set of four core values that reflect who we are and how we work: One Zensar, Nurturing, Empowering, and Client Focus.

Part of the $4.8 billion RPG Group, we're a community of 10,000+ innovators across 30+ global locations, including Milpitas, Seattle, Princeton, Cape Town, London, Zurich, Singapore, and Mexico City. Explore Life at Zensar and join us to Grow. Own. Achieve. Learn. to be the best version of yourself.

We believe the best work happens when individuality is celebrated, growth is encouraged, and well-being is prioritized. We are an equal employment opportunity (EEO) and affirmative action employer, committed to creating an inclusive workplace. All qualified applicants will be considered without regard to race, creed, color, ancestry, religion, sex, national origin, citizenship, age, sexual orientation, gender identity, disability, marital status, family medical leave status, or protected veteran status.

Required Skills & Qualifications

• Strong hands-on experience with IBM Db2 UDB administration
• Proven experience managing AWS RDS environments (any engine: Db2 on EC2, Oracle, MySQL, PostgreSQL, etc.)
• Experience in production DBA operations in high availability environments
• Strong knowledge of HA/DR concepts (HADR, Multi-AZ, backups, failover mechanisms)
• Solid understanding of performance tuning (on-prem + cloud)
• Experience in data masking and data archiving solutions
• Proficiency with Linux/Unix systems
• Hands-on scripting experience (Shell, Python, or similar)

Nice to Have

• Experience in regulated industries (banking/financial services)
• Exposure to hybrid environments (on-prem Db2 + cloud RDS)
• AWS certifications (e.g., AWS Certified Database Specialty / Solutions Architect)
• Experience with multiple database platforms

Key Responsibilities

Db2 (UDB) Core Responsibilities

• Provide operational support for IBM Db2 UDB databases (Prod & Non-Prod)
• Perform Db2 installation, configuration, upgrades, and patching
• Monitor performance, capacity, and availability; proactively resolve issues
• Manage backup, restore, recovery, and DR readiness (including HADR)
• Conduct root cause analysis and implement preventive measures
• Ensure database security, access controls, and compliance adherence

AWS RDS Responsibilities

• Manage and support AWS RDS instances (provisioning, configuration, patching, and upgrades)
• Monitor RDS performance using CloudWatch, Enhanced Monitoring, and Performance Insights
• Handle RDS backups, snapshots, point-in-time recovery, and cross-region replication
• Implement and support high availability (Multi-AZ) and disaster recovery strategies in RDS
• Optimize database performance in RDS (parameter groups, indexing strategies, query tuning)
• Manage RDS security configurations (IAM roles, security groups, encryption, auditing)
• Support troubleshooting and incident resolution for RDS instances
• Work on cost optimization and right-sizing of RDS resources