Associate Database Administrator

Job Description

Datavail provides a broad range of services in support of databases, analytics, and applications and specializes in Oracle, Oracle E-Business Suite, OBIEE and OBIA, Hyperion, Microsoft SQL Server, MySQL, MongoDB, DB2 and SharePoint. Datavail is a leading provider of data integration and database administration services in North America, offering 24 7 managed database, applications, and BI/DW services, design, architecture, and consulting.With more than 850 employees on payroll and core operations in four countries, Datavail offers deep technical expertise in a flexible, agile engagement model that focuses on customer success. Founded in 2007, Datavail is based in Broomfield, Colorado and supports enterprise clients located worldwide. For more information, visit www.datavail.com . As part of the Datavail team, you ll have the opportunity to work on exciting projects with a mandate to innovate, create, and deploy some of the best technology solutions in the world.The opportunity to work alongside our broad team of experts to learn, grow and build your career can only be found in one place Datavail. Working at Datavail is not just a career, but an opportunity to be a part of something bigger. Come grow with us!Job Title: Associate DBALocation: Hyderabad / Bengaluru / MumbaiEducation: BE / B.Tech / ME / M.Tech / MCAExperience: 4 to 9 YearsSkills: zOS DB2 DBA, JCL, DB2, REXX, IMS(added advantage),DB2 on LUW (added advantageJob 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

• 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

Keyskills :
sqldatabase administrationdatabasessql serverschedulingmicrosoft sql serverdb2 dbaservice levelsdata integrationcapacity planningoracle ebusiness suite