Db2 Administrator

Pragma Edge Software Services; Hyderabad; On-site; INR 1,200,000 - 2,000,000; Full time

Job summary

Pragma Edge Software Services seeks an IBM DB2 Database Administrator to manage, optimize, and maintain IBM DB2 databases across Linux/Unix and cloud environments. You will ensure availability, reliability, and performance for business-critical applications, handling configuration, tuning, security, and disaster recovery.

You will install, upgrade, monitor, and troubleshoot DB2 databases, manage data objects, and coordinate partitions, clustering, and replication.

Qualifications

• Experience administering IBM DB2 databases on Linux/Unix and cloud platforms.
• Strong SQL tuning and query optimization skills for OLTP/OLAP workloads.
• Hands-on in backup, restore, and disaster recovery planning and testing.
• Experience supporting high-availability environments and on-call rotations.

Responsibilities

• Install, configure, and maintain IBM DB2 databases on Linux/Unix and cloud platforms.
• Monitor performance, identify bottlenecks, tune SQL and database objects.
• Design and implement robust backup/restore strategies with PITR.
• Maintain data integrity, partitioning, clustering, and data archiving.
• Provide support to development teams for DB schema design and query optimization.

Skills

IBM DB2

Linux/Unix

SQL Tuning

Backup & Recovery

Performance Monitoring

Tools

IBM Data Studio

DB2 Connect

Job description

JobDescription

As an IBMDB2Database Administrator, you will be responsible for the management, optimization, and overall administration of IBMDB2databases. You will ensure the availability, reliability, and performance ofDB2databases that support business-critical applications. This position requires expertise in database configuration, tuning, security, backup, recovery, and troubleshooting within both distributed and mainframe environments.

Key Responsibilities

Database Administration

Install, configure, and maintain IBMDB2databases on Linux, UNIX, IBM Could platforms. Perform database upgrades and patches to ensure the environment is up to date and secure. Manage database objects (tables, indexes, views, etc.) and ensure proper data integrity and normalization. Handle database partitioning, clustering, and replication tasks.

Performance Tuning & Optimization

Monitor and analyze database performance, identifying bottlenecks and tuning SQL queries for optimal performance. Utilize tools such as IBM Data Studio, or third-party software for performance monitoring. Conduct regular database health checks and make recommendations for improvements.

Backup & Recovery

Design and implement robust backup strategies, including automated backups, point-in-time recovery, and disaster recovery planning. PerformDB2database restores and recoveries, ensuring minimal downtime. Manage database log files and ensure recovery capabilities.

Data Management & Maintenance

Perform regular maintenance tasks, including reorganization, compression, and data archiving. Manage large volumes of transactional data and optimize database performance for OLTP and OLAP systems. Expertise on of cloud platforms.

Troubleshooting & Support

Troubleshoot and resolve database issues, including connectivity, performance, and corruption problems. Provide support to development teams for database design, query optimization, and performance tuning. Support high-availability environments and participate in on-call rotations for after-hours support.