DB2 Senior Consultant

Apps Associates LLC; Hyderabad; On-site; INR 3,000,000 - 5,500,000; Full time

Job summary

Apps Associates LLC is seeking an experienced DB2 technology lead in Hyderabad to architect and modernize enterprise databases. You will drive upgrades, migrations, and cloud transformations with minimal operational disruption, while ensuring highly available DB2 environments and robust DR/BC plans.

The role requires deep DB2 LUW expertise, cloud migration experience, and leadership across global delivery teams.

Qualifications

• 8–15 years of experience with IBM DB2 enterprise environments.
• Strong expertise in DB2 LUW architecture, upgrades, and modernization.
• Proven track record in cloud migrations and DR/HA design.

Responsibilities

• Lead installation, configuration, and upgrade of IBM DB2 LUW across large enterprises (hybrid environments).
• Design and execute complex DB2 version upgrades and migrations with minimal business disruption.
• Architect and manage highly available DB2 setups (HADR, replication, failover, DR).
• Drive migrations from on-prem DB2 to Amazon RDS for Db2 using DMS, with validation and performance baselining.
• Design cloud-native database architectures using IaaS, PaaS, and managed services.
• Implement backup, recovery, BC/DR strategies aligned with standards.
• Provide cloud governance guidance for hybrid cloud deployments.
• Perform advanced performance tuning, workload optimization, indexing, and capacity planning.
• Develop automation with Shell, SQL, Python, Ansible, Terraform, and IaC practices.
• Collaborate with architects, project managers, application/infrastructure teams, and stakeholders.

Skills

DB2 LUW

Enterprise DB architecture

Cloud migration

High availability

Automation (Shell, Python, Ansible, Ia

Performance tuning

Team leadership

On-call escalation

DMS migration

Tools

Terraform

Ansible

AWS

Job description

• Experienced DB2 technology lead with 8-15 years of expertise in enterprise database architecture, modernization, cloud migration, and operational excellence.
• Professional attitude, with a growth mindset seeking to drive change and improvement in all aspects of the role
• Lead the installation, configuration, administration, and upgrade of IBM DB2 LUW environments across enterprise landscapes.
• Design and execute complex DB2 version upgrades, migrations, and cloud transformation projects with minimal disruption to business operations.
• Architect and manage highly available DB2 environments utilizing HADR, pureScale, replication technologies, failover automation, and disaster recovery solutions.
• Drive migration of on-premises DB2 databases to Amazon RDS for Db2 including DMS-based migration, backup/restore via S3, endpoint and connectivity validation, network isolation/security review, and post-migration performance baselining.
• Design and support cloud-native database architectures using Infrastructure-as-a-Service (IaaS), Platform-as-a-Service (PaaS), and managed database offerings.
• Implement enterprise backup, recovery, business continuity, and disaster recovery strategies aligned with organizational standards.
• Provide guidance on cloud database services, hybrid cloud architectures, security, governance, and operational best practices.
• Perform advanced database performance tuning, workload optimization, indexing strategies, capacity planning, and storage optimization.
• Develop automation solutions using Shell Scripting, SQL, Python, Ansible, Terraform, and Infrastructure-as-Code (IaC) practices.
• Collaborate with architects, project managers, application teams, infrastructure teams, and business stakeholders to deliver strategic database solutions.
• Support production environments, including critical issue resolution, root cause analysis, and on-call escalation management.
• Establish database standards, operational procedures, and cloud migration frameworks for enterprise adoption.
• Mentor technical teams and provide leadership across global delivery engagements.