Job Description

ZOS DB2 DBA
3.00 to 5.00 Years
2
PUNE [India]
IT
08/06/2020
17/07/2020
• Physical implementation and support of DB2 databases.• Maintain, Monitor, Troubleshoot and Tune databases for efficiency & stability of environments.• SQL Query tuning.• Database helpdesk support.• Capability to troubleshoot & work on reported production issues.• Backup and recovery of databases.• Collaborate with data modelers, project teams and vendors to implement database changes.• Ensure secure database by creating and following corporate security policies.• Consult with developers on design, conversions and testing data needs.• Develop & record certified processes/procedures for DBA support group.Required Skills• DB2 z/OS Database Administration Experience (9/10/11)• Performs software installation, database creation, configurations, migrations, upgrades.• Excellent Debugging & troubleshooting skills.• Must be familiar with mainframe operation in z/OS and necessary z/OS commands. Good knowledge of JCL and COBOL is needed.• Excellent knowledge on SQL writing (DML/DDL/DCL/TCL).• Hands on experience on Performance tuning of SQL query & database.• Experience in implementing security access controls to safeguard database integrity to comply with company security policies.• Improve database availability by ensuring the appropriate monitoring and alerting configurations are in place.• Strong knowledge of relational database. Understanding of physical & logical database design.• Experience with Database Backup, Restore, Recoveries and other DB2 utility operations• Knowledge on BMC or IBM tools for change management and monitoring will be beneficial.• Hands on experience on abend analysis thru SPUFI, B92, Apptune and Abend Aid.• ReXX scripting/other automation script knowledge is add on advantage