Lead Database Engineer

JOB DESCRIPTION

- 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.
- Strong 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.