Db2 Database Administrator

Pragma Edge Software Services

Hyderabad

On-site

INR 900,000 - 1,500,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Pragma Edge Software Services in Hyderabad is seeking an experienced DB2 Database Administrator to provide 24/7 production support for IBM Db2 LUW databases, ensuring high availability and reliability.

The role involves performance tuning, backup/recovery, HADR management, runstats, reorg, space management, and collaboration with application teams to optimize queries and resolve incidents in a fast-paced, office-based environment.

Qualifications

  • 4-8 years experience required.

Responsibilities

  • Provide 24/7 production support for IBM Db2 LUW databases, ensuring high availability and reliability.
  • Monitor database health, performance, and availability, and handle incidents, service requests, and problem management.
  • Perform backup and recovery operations, including full, incremental, and point-in-time recovery.
  • Execute server-to-server database restore activities ensuring data consistency and minimal downtime.
  • Manage and support HADR environments (Primary/Standby).
  • Perform planned and unplanned failover / takeover activities with minimal business impact.
  • Troubleshoot HADR issues such as log gaps, replay delay, and synchronization problems.
  • Analyze and resolve performance issues, including high CPU usage, I/O bottlenecks, and memory constraints.
  • Identify and tune long-running and high-cost SQL queries for optimal performance.
  • Perform index creation and optimization based on query requirements.
  • Monitor and resolve locking, blocking, and deadlock situations.
  • Execute regular database maintenance tasks, including RUNSTATS and REORG (table/index).
  • Perform space management and storage optimization activities.
  • Handle data movement utilities such as EXPORT, IMPORT, and LOAD.
  • Develop and maintain automation scripts for routine database tasks and scheduling activities.
  • Monitor db2diag logs and system metrics to detect issues proactively.
  • Perform root cause analysis (RCA) and implement preventive measures for recurring issues.
  • Support application teams with query tuning, performance improvements, and data-related issues.
  • Coordinate with cross-functional teams during critical production incidents.
  • Maintain documentation, runbooks, and standard operating procedures (SOPs) for database operations.

Job description

Hiring: DB2 Database Administrator | 4-8 Years Experience

Location: Hyderabad

Experience: 4-8 Years

Shift Timings: Rotational Shifts

Work Mode: Work from Office (as applicable)

Roles & Responsibilities:
  • Provide 24/7 production support for IBM Db2 LUW databases, ensuring high availability and reliability.
  • Monitor database health, performance, and availability, and handle incidents, service requests, and problem management.
  • Perform backup and recovery operations, including full, incremental, and point-in-time recovery.
  • Execute server-to-server database restore activities ensuring data consistency and minimal downtime.
  • Manage and support HADR (High Availability Disaster Recovery) environments (Primary/Standby).
  • Perform planned and unplanned failover / takeover activities with minimal business impact.
  • Troubleshoot HADR issues such as log gaps, replay delay, and synchronization problems.
  • Analyze and resolve performance issues, including high CPU usage, I/O bottlenecks, and memory constraints.
  • Identify and tune long-running and high-cost SQL queries for optimal performance.
  • Perform index creation and optimization based on query requirements.
  • Monitor and resolve locking, blocking, and deadlock situations.
  • Execute regular database maintenance tasks, including RUNSTATS and REORG (table/index).
  • Perform space management and storage optimization activities.
  • Handle data movement utilities such as EXPORT, IMPORT, and LOAD.
  • Develop and maintain automation scripts for routine database tasks and scheduling activities.
  • Monitor db2diag logs and system metrics to detect issues proactively.
  • Perform root cause analysis (RCA) and implement preventive measures for recurring issues.
  • Support application teams with query tuning, performance improvements, and data-related issues.
  • Coordinate with cross-functional teams during critical production incidents.
  • Maintain documentation, runbooks, and standard operating procedures (SOPs) for database operations.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

IBM DB2 DBA Database Administrator L2 for Delhi
IBM DB2 DBA Database Administrator L2 for Delhi

DCM Infotech Limited • Delhi

On-site
INR 900,000 - 1,100,000
Senior DB2 z/OS Database Administrator
Senior DB2 z/OS Database Administrator

HCL Technologies Limited • Pune District

On-site
INR 1,500,000 - 2,700,000
Db2 Luw Database Administrator
Db2 Luw Database Administrator

Tata Consultancy Services Limited • Kolkata District, Bengaluru, Mumbai

On-site
INR 1,200,000 - 1,900,000
Application Database Administrator – RDBMS (PostgreSQL)
Application Database Administrator – RDBMS (PostgreSQL)

SWITS Digital Pvt Ltd. • Maharashtra

On-site
INR 800,000 - 1,200,000
DB2 Administrator (Cloud Pak for Data & DB2 Warehouse)
DB2 Administrator (Cloud Pak for Data & DB2 Warehouse)

Quantum Strides LLC • Chennai

On-site
INR 800,000 - 1,200,000
IBM DB2 Support
IBM DB2 Support

VOIS • Pune District

On-site
INR 900,000 - 1,300,000
Database Administrator
Database Administrator

Arohana Tech Solutions Private Limited • Tamil Nadu

On-site
INR 600,000 - 1,000,000
Database Administrator
Database Administrator

Arohana Tech Solutions Private Limited • Chennai

On-site
INR 900,000 - 1,300,000
SeniorAdministrator - IBM DB2 for z/OS
SeniorAdministrator - IBM DB2 for z/OS

HCL Technologies Limited • Pandhurna

On-site
INR 1,200,000 - 1,800,000
Database Administrator - z/OS
Database Administrator - z/OS

SourcingXPress • Maharashtra

On-site
INR 1,200,000 - 2,400,000