Job Title: DB2 DBA z/OS – Senior Technical Specialist
Education: Any Graduate
Experience: 10+years
Location: Bengaluru/Hyderabad/Mumbai
Job Description:
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
- Learn from a vast pool of total X days of industry experience.
- You would be working with multiple customers in a multi domain environments.
- Work would range from On-Prem DB’s to the Cloud.
- Your Certifications would be on us.
- 100 days of working from home (since inception of Datavail).
- Future Opportunity for permanent deputation on H1B to work in US.
- Leverage the DV Training program to upscale the technical skills.
Skills Required
- 10+ years of experience in DB2 DBA
- Experience with z/OS
- Experience in REXX programming
- Experience in various DB2 tools
- Experience in analyzing Catalog tables
- Ability to troubleshoot database service outages
What We Do
A premiere data services company serving clients in North America, Datavail has 1,000 data professionals, data engineers, developers, project managers, consultants, and business experts, supported by industry-leading automation and intellectual property. For more than 17 years, Datavail has worked with thousands of companies spanning different industries and sizes. At Datavail, we look for more than smarts, experience and proficiency. On top of those requirements, we seek people who mesh with our corporate values. We seek brilliance without bravado and know-how without a know-it-all attitude. We hold low ego in high regard, embrace problem-solving as a passion and welcome every day as a new opportunity to learn. We’re flexible and hard working. We’re committed to our clients and colleagues. We help our people grow so they can help our clients grow. That makes us grow so we can help even more customers leverage organizational data for business value. Our Core Values: 1. We desire to serve. 2. We embody flexibility for availability 3. We exemplify low ego. 4. We work hard. 5. We strive for continuous improvement. 6. We are growth-oriented.
