Database Administrator (Mainframe DB2) - (6 Month Contract)

We are seeking an experienced Database Administrator with strong Mainframe DB2 on z/OS expertise to support database administration, data migration, performance monitoring and application database activities. The successful candidate will be responsible for database setup, database object maintenance, backup and recovery, SQL tuning, database design reviews and technical documentation. The role will work closely with application teams, infrastructure teams and customers to ensure database environments remain secure, available and optimised.

Key Responsibilities

• Extract and migrate data from Mainframe DB2 on z/OS to flat files using scripts or tools within the mainframe environment.
• Plan, coordinate and execute database migration activities.
• Perform database setup, configuration, administration and maintenance.
• Define, create and maintain database objects, including tables, indexes, views and schemas.
• Perform database backup, restoration and recovery activities.
• Monitor database performance, availability, capacity and service levels.
• Identify database performance issues and implement corrective actions.
• Perform application SQL review, troubleshooting and performance tuning.
• Maintain database configurations, operational procedures and technical documentation.
• Prepare regular database performance and availability reports.
• Ensure database services meet agreed service-level requirements.
• Propose and implement action plans where service levels are not achieved.
• Implement database backup, restoration and disaster recovery procedures.
• Support business continuity and disaster recovery testing.
• Manage database access permissions, user privileges and security controls.
• Establish and maintain database hardening, naming and operational standards.
• Contribute to data governance policies relating to database operations.
• Review database designs and recommend improvements to data models.
• Work with application teams to understand business and technical requirements.
• Develop and enforce database standards, procedures and implementation guidelines.
• Engage customers and stakeholders to explain database designs and technical recommendations.
• Educate application teams on database coding, SQL and design best practices.
• Keep abreast of database technologies, tools and industry practices.
• Share knowledge through internal forums and communities of practice.
• Contribute lessons learned and technical solutions to the organisation’s knowledge repository.

Requirements

• Minimum 4 years of hands-on Mainframe DB2 on z/OS database administration experience.
• Mainframe DB2 on z/OS experience is mandatory.
• Proven experience extracting and migrating data from DB2 on z/OS to flat files using mainframe scripts or tools.
• Strong knowledge of database administration, implementation and production support.
• Experience in database setup, configuration, maintenance, backup and recovery.
• Experience in database migration planning and execution.
• Good knowledge of SQL performance tuning and database performance monitoring.
• Knowledge of database security, access controls, hardening and governance standards.
• Experience reviewing database designs, data models and application SQL.
• Strong analytical, troubleshooting and problem-solving skills.
• Good written and verbal communication skills.
• Ability to work effectively with customers, application teams and technical stakeholders.
• A good team player with a collaborative working style.

Added Advantages

• Knowledge or experience in Microsoft SQL Server.
• Knowledge or experience in DB2 UDB.
• Exposure to AWS or Microsoft Azure.
• Experience in database performance consultancy or data governance.

Employment Details

• Employment type: Contract
• Contract duration: 6 months

To apply,simply click the "Apply" button or send your updated profile to Sign in to view email

EA Licence No.:18S9405 / EA Reg. No.:R1330864

Percept Solutions is expanding and actively seeking talented individuals. We encourage applicants to follow Percept Solutions on LinkedIn at https://www.linkedin.com/company/percept-solutions/ to stay informed about new opportunities and events.