Database Administration Position
This role involves overseeing the configuration, installation, and maintenance of IMS and DB2 databases to ensure optimal performance.
Main Responsibilities:
* Configure, install and maintain database management systems
* Implement user access controls and security measures to safeguard valuable data
* Develop and implement disaster recovery plans to protect against system failures
* Provide technical support for end users and application developers in resolving complex database-related issues
* Establish policies and procedures to secure data from external threats
Requirements:
* Bachelor's degree required or equivalent work experience
* At least 10 years of professional experience in IMS and DB2 database administration
* Proficiency in BMC COPE and IBM tools for IMS and DB2
* Experience with IMS and DB2 systems programming support is an asset
Key Skills:
* In-depth knowledge of IMS database organization using VSAM and OSAM access methods
* Familiarity with full-function database organization types
* Comprehensive understanding of DB2 for Z/OS database components and concepts
* Coding and usage expertise of IMS and DB2 DBA utilities (including IBM, BMC, CA)
* Experience with IBM DB2 V12+ and IMS V15
* Proficiency in database performance monitoring tools such as Query Monitor, DB2 Explain, SQL Performance Analyzer, and access path evaluation