Senior Associate Database Administrator - Db2 DBA Z/os

Job Title : Senior Associate Database Administrator – DB2 DBA Z/os

Education: Any Graduate 

Experience: 6+ yrs 

Location: Bengaluru /Hyderabad /Mumbai

Key Skills: DB2 ZOS DBA, Mainframe, COBOL, JCL, REXX, VSAM, AWS

Job Functions:

• Responsible for all functions associated with the design, implementation and maintenance of DB2 for z/OS.

• Manage all technical aspects of the databases and processes. Troubleshoot Database service outages as they occur, including after-hours and weekends.

• Assist in maintaining and improving database operational efficiency. Perform daily, weekly, and monthly data maintenance tasks, preferably via automation Tuning queries to improve performance. Ensure all databases are backed up in a way that meets the business's Recovery Point Objectives (RPO).

• Test backups to ensure we can meet the business' Recovery Time Objectives (RTO) When performance issues arise, determine the most effective way to increase performance including hardware or software purchases, configuration changes, or index/query change.

• Experience in REXX programming.

• Experience in various DB2 tools.

• Experience in analyzing Catalog tables.

Preferred Skills:

• Design, test, implement and maintain complex databases with the required organization, access methods, access time, validation checks and security to meet or exceed requirements.

• Develop, edit and maintain required documentation.

• Proactively evaluate, recommend and perform database upgrades and changes.

• Recommend system optimization and improvement planning including, but not limited to, database performance analysis, capacity planning and system sizing.

• Stay abreast of and recommend improvements in technology and methodology to meet changing business needs and market demands, as well as provide for overall optimization of database administration function.

• Pro-actively monitor the performance of production databases to detect existing or potential incidents and/or performance issues.

• Perform tuning and maintenance to correct and prevent unplanned downtime or performance degradation.

• Ensure operation of database environments meet or exceed agreed upon service levels (e.g. availability and performance).

• Plan, schedule and manage the implementation of new databases and modifications to existing databases in a manner that avoids disruption to production and development systems.

• Set-up and manage day-to-day database administration activities.

• Provide ongoing support to operations and support teams as needed.

• Escalate and manage escalated issues as appropriate.

• IMS Database administration/development experience is an added advantage.

• REXX programming language experience is an added advantage.

• Eager to learn new aspects of Db2 and apply in practical scenarios.

• Sound experience in Database upgrade and patching methodologies.

• Data partitioning and archival.

• Proficient in Linux/Unix technical scripting and utilities

• Excellent verbal and written communication skills and email and Instant Messenger (IM) etiquette.