Mainframe Database Administrator

Programmers.io is hiring apply now if you interested at kanika.agrawal@programmers.io

DB2 Database Administrator

Responsibilities:

• Database administration of DB2 for Mainframe z/OS
• Monitoring of all DB2 performance utilizing IBM tools and TOAD for DB2 LUW
• DB2 connectivity direct data drivers, remote system connectivity
• DB2 Federated Database on AIX
• SQL tuning
• Introduction of new functionality of DB2 on z/OS
• Application support for changes and problems
• Production data updates
• Table definitions, design, and modifications
• Design/development of Triggers and Stored Procedures
• Configure and customize DB2 Tools (Admin Tool, Query Monitor, QMF)
• Business Recovery
• Support for SMARTIS
• DB2 Bufferpool tuning
• Manage zParms
• Acceptance environment refresh with Production Data
• PCI Interviews
• Participate in on-call support rotation
• Ensure compliance to all relative security policies and procedures.

Requirements:

• Bachelor's degree in management information systems (MIS), computer science, information systems, or information technology.
• Advanced knowledge of DB2 z/OS and DB2 LUW a plus
• Proficiency in Structured Query Language (SQL).
• In-depth knowledge of database technologies, architecture, and data security.
• Knowledge of best practices in database management.
• Advanced analytical, leadership, and problem-solving skills.
• Exceptional organizational skills and attention to detail.
• Excellent interpersonal and communication skills.
• 5-7 years experience with database administration.
• DB2 LUW for AIX a plus