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 businesss 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.
Required Experience:
Senior IC
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 leadi ... View more