Maximo Database Administrator

Vbeyond

Derby, UK

10 days ago

Apply on www.reed.co.uk

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Working hours

Regular working hours

Job source

www.reed.co.uk

Tech stack

Software Suite Microsoft Azure Databases IBM DB2 Database Security Oracle (Applications) Performance Tuning SQL Stored Procedures PL-SQL Backup and Restore Database Performance Database Migration

+3 more

Database Installation Code Restructuring Oracledb

Job description

We are seeking an experienced Maximo Database Administrator to support a major Maximo upgrade and database migration programme within the Aerospace & Defence sector.

The project involves the technical upgrade of an existing Maximo 7.6 environment running on Oracle to Maximo Application Suite (MAS) 9.x running on DB2, hosted in Azure Cloud.

This is primarily a technical lift-and-shift migration and upgrade, involving the migration of existing Maximo designs and configurations into MAS 9.x, together with the technical changes and remediation required as part of the upgrade., * Lead and support Oracle-to-DB2 database migration activities.

Perform DB2 database administration, configuration and tuning.
Install and configure DB2 environments across the required infrastructure.
Develop and implement database backup and recovery strategies.
Perform database performance optimisation for Maximo Application Suite (MAS).
Support database security, access controls and compliance requirements.
Refactor and remediate existing PL/SQL stored procedures for compatibility with DB2.
Identify and resolve database-related issues arising during the Maximo upgrade and migration.
Support technical remediation and optimisation activities throughout the migration programme.
Ensure database environments are stable, secure, performant and ready for production use., Technical lift-and-shift upgrade and database migration, including remediation of components affected by the platform and database changes. Skills
DB2
Migration
Oracle DB
Backup and Recovery
PL/SQL

Requirements

Strong hands-on experience as a DB2 Database Administrator.
Proven experience with Oracle-to-DB2 migrations.
Experience with database installation, configuration, administration and tuning.
Strong knowledge of DB2 performance optimisation.
Experience developing backup and recovery strategies.
Experience with database security and compliance.
Strong understanding of PL/SQL and experience refactoring stored procedures for DB2.
Experience supporting Maximo / Maximo Application Suite environments.
Experience with database migration and upgrade programmes.
Exposure to Azure Cloud environments.