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).
Our global network spans 140 countries, 400 offices, and a growing portfolio of terminal and infrastructure investments. This scale enables us to deliver consistent, high‑quality service across continents and to support our customers in even the most complex supply chains.
When you join us, you become part of more than 18,000 colleagues working across borders, functions, and cultures, to not only to deliver quality for our customers, but to create innovation and opportunities across roles, regions, and perspectives.
We believe that every exploration is a chance to grow, and every port is a place to belong.
Technology center in Chennai
Welcome to Hapag-Lloyd Technology Center Chennai: Where Innovation Thrives
Hapag-Lloyd Technology Center Chennai, located in the Chennai World Trade Center, is more than just a captive center; it's a beacon of technological innovation. Hand in hand, with two other Hapag-Lloyd IT Hubs in Hamburg (Germany) and Gdansk (Poland), we are ushering in a new era of IT excellence.
Hapag Lloyd Technology Center was opened on June 1st, 2023, with a goal to rapidly expand, envisioning a team of 400+ experts in the coming years.
HLTC Leaders of Innovation
Leading HLTC Chennai are Balamurugan Palanivelu (CEO), Balaji Ramamoorthy (CTO), Vaishali Shetty (CHRO), and Sameer Saxena (CFO).
At Hapag-Lloyd Technology Center, our team is in constant expansion mode. Join us as we continue to grow and innovate! Your expertise can play a vital role in our dynamic and evolving environment.
Global Excellence in IT – Trusted Partner to Grow Your Career
Our Global ONE IT operates across three strategic hubs worldwide: Germany, Poland, and India. Together, we are dedicated to perfecting Hapag-Lloyd's IT solutions. With nearly 200 years in the business, innovation has always been in our DNA.
Our enduring presence makes us a reliable employer for those seeking a workplace that successfully adapts to a changing world, embracing ecological trends and innovation. At Hapag-Lloyd, your work is not only engaging but also has a real impact on our reality.
As we continue to evolve and enhance our market position, we are actively seeking the best IT experts to bring their diverse perspectives to our team.
Join us and be part of a team that is driving innovation, ecological responsibility, and excellence in IT. Your career will thrive with us!
https://www.hapag-lloyd.com/en/company/career/working-in-tech/our-offices/office-chen.html
Perks and Benefits at HLTC :
- Recreation: Play area with PS5, Table Tennis, Foosball, Carrom, and Chess
- Financial & Health: Provident Fund, Gratuity, Performance Bonus, Medical Insurance, Leave Travel Allowance
- Work-Life Balance: Hybrid model after 3 months based on Manager's approval (3 days in office, 2 days WFH), Generous Leave Policies
- Facilities: Car/Bike Parking, Food Court, Modern Office Environment
- Professional Development: HL Academy - Training Programs, Career Growth Opportunities, Employee Referral Policy,IJP.
Skills Required
- 7-12 years of technology experience
- 7+ years hands-on DB2 DBA experience on Linux
- Administer and optimize DB2 LUW environments
- Deploying and administering DB2 on AWS (EC2, S3, EBS) and migrating to RDS
- Expertise in backup & recovery, HADR & TSA, and PITR
- SQL performance tuning, locking, isolation levels, concurrency, WLM
- Experience with DB2 tooling: db2pd, db2top, db2mtrk, db2backup, db2load, db2move, db2look, db2diag.log, db2support, db2dart, db2fodc
- Hands-on scripting with Shell, Python, or Perl for automation
- Deep understanding of Linux OS performance (CPU, memory, I/O)
- Infrastructure as Code experience (Terraform, CloudFormation, or CDK)
- Implement encryption (KMS and database-native) and manage IAM, Secrets Manager/Parameter Store
- Experience enforcing auditing, logging, and compliance controls (CIS, PCI, HIPAA, SOC2)
- Experience building monitoring, automated health checks, failover tests, and DR drills
What We Do
With a fleet of 280 modern container ships and a total transport capacity of 2.1 million TEU, Hapag-Lloyd is one of the world’s leading liner shipping companies. In the Liner Shipping segment, the Company has around 13,700 employees and 400 offices in 140 countries. Hapag-Lloyd has a container capacity of 3.1 million TEU – including one of the largest and most modern fleets of reefer containers. A total of 114 liner services worldwide ensure fast and reliable connections between more than 600 ports on all the continents. In the Terminal & Infrastructure segment, Hapag-Lloyd has equity stakes in 20 terminals in Europe, Latin America, the United States, India, and North Africa. Around 2,900 employees are assigned to the Terminal & Infrastructure segment and provide complementary logistics services at selected locations in addition to the terminal activities.
.jpeg)
