Senior DB2 LUW DBA

EPAM Systems; Coimbatore District; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

A leading technology solutions provider is seeking a Senior DB2 LUW DBA in Tamil Nadu. The ideal candidate will be responsible for managing, optimizing, and upgrading database systems, ensuring high availability, performance, and reliability. Responsibilities include monitoring production issues, managing configurations, and performing database versions upgrades. Requirements include 6 to 9 years of experience in DB2 LUW databases, expertise in advanced configurations, and collaboration with cross-functional teams.

Qualifications

• 6 to 9 years of experience in managing DB2 LUW databases.
• Expertise in advanced database configurations.
• Proficiency in cross-platform database migrations.

Responsibilities

• Monitor and manage production database issues.
• Handle complex database configurations.
• Perform DB2 version upgrades.

Skills

DB2 LUW management

DPF and Blu Acceleration

HADR setups

Cross-platform migrations

Database optimization

Data transformation

Collaboration with teams

Tools

AIX

Linux

Windows

Job description

We are seeking a highly skilled and experienced Senior DB2 LUW DBA to join our team.

The ideal candidate will play a crucial role in managing, optimizing and upgrading our database systems while ensuring high availability, performance and reliability.

Responsibilities

• Monitor, manage and troubleshoot production database issues
• Handle complex database configurations like DPF and Blu Acceleration
• Build and maintain HADR setups (Primary-Standby and Auxiliary Standby)
• Perform DB2 version upgrades to ensure system compliance and performance
• Execute cross-platform database migrations including AIX to Linux and Windows to Linux
• Manage database migrations from Windows to Cloud Linux with HADR setups
• Conduct health check scans and remediation processes for database optimization
• Perform weekly health checkups covering DB size, HADR status, reorganization and log space reviews
• Execute database backups using various modes (online, offline, compressed, non-compressed)
• Manage DB2 LUW installations and configurations across versions 10.1/10.5/11.1/11.5
• Design and maintain effective data ingestion and transformation processes including batch and incremental pipelines
• Perform complex data transformations, cleansing and enrichment to meet project requirements
• Collaborate with business analysts, developers and testers to understand data needs and ensure streamlined processes
• Optimize data pipelines for performance, scalability and operational efficiency
• Ensure data quality, consistency and traceability across environments
• Document data models, flows and transformation logic

Requirements

• 6 to 9 years of experience in managing DB2 LUW databases and related technologies
• Expertise in DPF and Blu Acceleration for advanced database configurations
• Proficiency in building and maintaining HADR setups across various platforms
• Qualifications in cross-platform migrations including AIX to Linux and Windows to Linux
• Experience with DB2 LUW versions 10.1/10.5/11.1/11.5 installations and configurations
• Background in performing database health checks, optimizations and backup processes
• Capability to design robust data pipelines for ingestion and transformation
• Familiarity with handling database migrations to cloud environments with HADR setups
• Understanding of data transformation and cleansing techniques
• Showcase of collaboration with cross-functional teams to meet data requirements