- Experienced in managing and optimizing DB2 LUW databases on Linux and AWS Cloud environments
- Strong expertise in utilities and command-line tools for administration, performance tuning, monitoring, backup/restore, and problem determination.
- Monitoring database health using db2pd, db2top, db2mtrk and optimizing database performance, slow queries, indexing, replication, and storage utilization.
- Experience in troubleshooting complex performance issues, optimizing SQL workloads, and automating day-to-day DBA operations using scripting language
- Great understanding on of locking, isolation levels, concurrency, and row/page architecture
- Configuring and maintaining DB2 registry variables, DBM CFG and DB CFG parameter and Managing instance, cataloging, and client configurations
- Experience in implementing and managing online/offline backup strategies using db2backup and Performing restore, rollforward recovery, and PITR.
- Data movement by using db2load, db2move, export/import, db2look for migration activities
- Problem determination and troubleshooting by analysing DB2 diagnostic logs (db2diag.log) and issue resolution by using db2support, db2dart, db2fodc.

- Adept at supporting high-availability production systems, performing DR drills, and collaborating with development and cloud teams to deliver stable and efficient DB2 environments.

- Implement Infrastructure as Code (Terraform, CloudFormation, or CDK) for database resources.
- Build automated health checks, failover tests, and data validation tools.
- Implement encryption at rest and in transit using KMS and database-native encryption.
- Manage IAM roles, database authentication, parameter groups, and secrets using AWS Secrets Manager or Parameter Store.





- Enforce least privilege, auditing, logging, and compliance controls such as CIS, PCI, HIPAA, or SOC2.

- Set up database monitoring using CloudWatch, Performance Insights, Enhanced Monitoring, or third-party tools.

- Troubleshoot performance bottlenecks, connection issues, replication delays, and scaling challenges.
- Conduct root cause analysis (RCA) and implement preventive measures.
- Work with application teams to design optimal schemas and query patterns.

- Collaborate with DevOps for CI/CD integration and automated database deployments.
- Require 7-12 years of technology experience.
- 7+ years of hands-on experience as DB2 DBA on Linux.

- Robust experience administering DB2 LUW environments.
- Experience deploying and administering DB2 on AWS Cloud (EC2, S3, EBS, )
- Strong understanding on backup recovery strategies, HADR

TSA, SQL performance tuning, locking concurrency, workload management (WLM)

- Expertise with monitoring tools: db2top, Data Studio, DSM.
- Hands-on scripting using Shell, Python, or Perl.
- Deep understanding of Linux OS performance (CPU, memory, I/O).

DATABASE-SPECIFIC DUTIES

- Implement and manage database services in the AWS cloud infrastructure.
- Ensure compliance with security standards and policies for all databases.

- Monitor system performance and identify downtimes along with underlying causes.
- Managed migrations of DB from Onprem to RDS services.
- Manage backup and restores of DB s on requirement basis.

Disclaimer: This job posting and Location has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.

📌 Lead Database Engineer (Chennai)
🏢 Hapag Lloyd
📍 Chennai