Mainframe Db2 Dba Performance And Sql Tuning, Ha, Dr

Year    TN, IN, India

Job Description

3 - 5 Years
1 Opening
Chennai


###

Role description




Install, configure, and upgrade DB2 databases (LUW and/or z/OS as applicable). Perform regular database maintenance, patching, and health checks. Monitor database performance and conduct tuning as needed. Implement backup and recovery strategies using native DB2 tools or third-party solutions. Manage database security, user access, and roles. Support disaster recovery planning and testing. Collaborate with application teams to design and optimize DB2 solutions. Perform root cause analysis and resolve DB2 incidents and performance issues. Document procedures, processes, and system configurations. Participate in on-call support rotations if required.

Key Skills Required:




Strong hands-on experience with

IBM DB2 (LUW and/or Mainframe/z/OS environments)

Proficiency in

DB2 installation, configuration, and version upgrades

Experience with

DB2 performance tuning and optimization

Knowledge of

database backup, recovery, and disaster recovery planning

Familiarity with

high availability setups

(e.g., HADR, TSA, or clustering) Experience in

database security management and compliance

Proficient in

SQL scripting, stored procedures, and query optimization

Exposure to

Linux, UNIX, or Windows environments

for DB2 administration Experience with

monitoring tools

(e.g., IBM Data Server Manager, Tivoli, or equivalent) Good understanding of

ITIL processes

and change management procedures Performance tuning and

Capacity planning

Tools - SYSVIEW , OMEGAMON , RMF for performance monitoring



Preferred Skills:




Knowledge of

cloud-based DB2 environments

(IBM Cloud Pak, AWS RDS for DB2, etc.) Scripting skills in

Shell, Python, or PowerShell

Exposure to

DevOps/Automation tools

(Ansible, Jenkins, etc.) Understanding of

other database systems

(Oracle, SQL Server) is a plus Relevant certifications such as

IBM Certified Database Administrator - DB2

are preferred
###

Skills




Mainframe, DB2, DBA, performance tuning and optimization



###

About UST




UST is a global digital transformation solutions provider. For more than 20 years, UST has worked side by side with the world's best companies to make a real impact through transformation. Powered by technology, inspired by people and led by purpose, UST partners with their clients from design to operation. With deep domain expertise and a future-proof philosophy, UST embeds innovation and agility into their clients' organizations. With over 30,000 employees in 30 countries, UST builds for boundless impact--touching billions of lives in the process.

Beware of fraud agents! do not pay money to get a job

MNCJobsIndia.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.


Job Detail

  • Job Id
    JD3946986
  • Industry
    Not mentioned
  • Total Positions
    1
  • Job Type:
    Full Time
  • Salary:
    Not mentioned
  • Employment Status
    Permanent
  • Job Location
    TN, IN, India
  • Education
    Not mentioned
  • Experience
    Year