Quick overview
Job description
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.
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.
• 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).
Haystack's AI agent can fill in and submit this application for you. How AI auto apply works
Will your resume get past this employer's screening? Check your resume against this job, free
Similar jobs
- OP

Sr. Software Engineer (Full Stack)Recently posted Auto Apply
Opengov · Pune · On-site · Posted 20 Nov 2026 🇮🇳
AWSGrafanaGraphQL+5TechnologySalary not listed - OK

Senior Software Engineer - (Java & DSA)Recently posted Auto Apply
Okta · Bengaluru · Hybrid · Posted 19 Nov 2026 🇮🇳
MySQLSpringSpring Boot+12TechnologySalary not listed - IV

Associate Customer Application Engineer (.NET, SQL, C#)Recently posted Auto Apply
Ivalua · Pune · Hybrid · Posted 19 Nov 2026 🇮🇳
SQLC#.NET+2TechnologySalary not listed - FI

Staff Software EngineerRecently posted Auto Apply
Fivetran · Bengaluru · Hybrid · Posted 19 Nov 2026 🇮🇳
DockerGCPOracle+13TechnologySalary not listed - DA
Software Engineer II - IAM TeamRecently posted Auto Apply
DAT · Bengaluru · Hybrid · Posted 19 Nov 2026 🇮🇳
DockerGCPMicroservices+23TechnologySalary not listed - VS

Software Engineer Test - IIIRecently posted Auto Apply
Veeam Software · Bengaluru · Hybrid · Posted 19 Nov 2026 🇮🇳
DockerGCPMicroservices+35TechnologySalary not listed - VS

Senior Software Engineer, TestRecently posted Auto Apply
Veeam Software · Bengaluru · Hybrid · Posted 19 Nov 2026 🇮🇳
DockerGCPSQL+22TechnologySalary not listed - VS

Software Engineer Test - IIRecently posted Auto Apply
Veeam Software · Bengaluru · Hybrid · Posted 19 Nov 2026 🇮🇳
AWSC++Helm+9TechnologySalary not listed - TH

Senior Software Engineer - (JAVA , Springboot, Angular Expertise is Must)Recently posted Auto Apply
Tech Holding · Ahmedabad · Hybrid · Posted 19 Nov 2026 🇮🇳
DockerSQLSpring+12TechnologySalary not listed - TO
Staff Software Engineer, AndroidRecently posted Auto Apply
Toast · Bengaluru · Hybrid · Posted 19 Nov 2026 🇮🇳
Apache SparkAWSLoad Balancing+6TechnologySalary not listed - ST

Software Engineer, New GradRecently posted Auto Apply
Stripe · Bengaluru · Hybrid · Posted 19 Nov 2026 🇮🇳
RubyScalaJava+1TechnologySalary not listed - EV

Member of Techincal Staff - FirmwareRecently posted Auto Apply
Everpure · Bengaluru · Hybrid · Posted 19 Nov 2026 🇮🇳
ComplianceC++Python+1Salary not listed