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.