Job Description

Job Title: DB2 DBA z/OS – Senior Technical Specialist

Education: Any Graduate

Experience: 10+years

Location: Bengaluru/Hyderabad/Mumbai

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 analysing 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

Datavail is a leading provider of data management, application development, analytics, and cloud services, with more than 1,000 professionals helping clients build and manage applications and data via a world-class tech-enabled delivery platform and software solutions across all leading technologies. For more than 17 years, Datavail has worked with thousands of companies spanning different industries and sizes, and is an AWS Advanced Tier Consulting Partner, a Microsoft Solutions Partner for Data & AI and Digital & App Innovation (Azure), an Oracle Partner, and a MySQL Partner.