AddressMust have Negative Vetting Level 1 Security clearance.
The Db2 Database Administrator will be involved with the:
Migration of ObjectStar Table data store to DB2 on Z/OS; design, maintenance and optimising DB2 databases; and upgrading DB2 to V13.
Database Administrator Experts will engage in scoping, sourcing, and optimising database environments for analysis.
They will apply innovative analysis techniques and model results and scenarios, while maintaining the integrity of the system.
The Database Administrator Experts will be proficient with system databases, data elements, application software, and other tool sets to develop enterprise data solutions.
Key duties may include, but are not limited to:
• Provide expert advice to technical specialists and stakeholders and seek their cooperation in the provision of database administration.
• Schedule and manage database software installations and upgrades to maintain currency with supported environments.
• Administer the database configuration, security, scheme and objects, ensuring compliance against agreed standards and guidelines.
• Manage the data management process including initial loading, creating, maintaining, and distributing data.
• Implement corrective actions to improve performance and availability of databases.
• Design and plan operational backup, archival and recovery activities and cyclical disaster recovery exercises.
• Escalate unresolved system issues to appropriate vendors or stakeholders and manage these in accordance with agreed service level agreements to minimise user/system downtime.
• Manage the development of processes, security measures, standards and best practices aimed at enhancing the availability, security and performance of data assets.
• Prepare and review corporate and technical documentation.
• Develop data capability through coaching, mentoring and succession planning to increase performance, engagement and retention.
Primary Technologies required for role include:
• DB2 on z/OS Mainframe
Mandatory Criteria• 2.5+ years of Mainframe Db2 Database Administration experience.
Desirable Criteria
- 1.5+ years of experience with IBM Db2 tools (Recovery expert, clone tool etc.).
- 2.5+ years of experience with monitoring and diagnostics using Omegamon and query monitor.
- Experience with rolling out maintenance for Db2 across mainframe systems.
- Experience with z/OS interfaces (ISPF, REXX, JCL etc.).
- Understanding of z/OS software installation methodologies (SMP/E etc.).
