db2 dba

DB2 Database Administrator

Our client, a consulting organisation specialising in enterprise solutions and IBM Platinum partner is looking to recruit an experienced DB2 Database Administrator with an excellent track record deploying, supporting, and managing databases on premise and in the cloud.

The current data platform estate is a mix of Oracle, IBM DB2, and SQL Server. This role requires strong production DBA experience.

This role involves working in secure environments and will involve security clearance. Accordingly, suitable candidate will need to have been resident in the UK for the last five years.

Specific Responsibilities:

Industry standard, and general DBA responsibilities across a portfolio of supported databases

Work with production databases for continual optimal performance tuning, standardisation, troubleshooting, design, and architecture

Patching/updating/upgrading hosted cloud solution database infrastructure

Security best practice, working with the existing quality framework (ISO27001?)

Log, update and track technical issues and requests raised by clients. Accurately documenting, diagnosing, investigating, and resolving these issues.

Work with 3rd party suppliers to quickly resolve technical issues with the database and other systems.

Perform routine daily maintenance checks to ensure client databases are running efficiently as per defined procedures.

Perform installations and patches of IBM WebSphere, Server and IBM Maximo software using IBM middleware and multiple database technologies (SQL, Oracle, DB2, MySQL)

Involvement in data migration and data transformation activities

Skills required:

Demonstrable working experience as a DBA

DB2 Tools, DB2 Monitoring and System performance (Data Management Console)

Previous experience of supporting an enterprise DB estate.

Knowledge of Linux operating systems

In-depth knowledge in the structure and implementation of databases (Oracle/DB2/SQL databases in particular)

Excellent communication skills both verbal and written

Constant attention for minimising database unplanned downtime, management of parameters, configuration and tuning methods to provide fast query responses

High availability/clustering and disaster recovery design

Testing maintenance processes and schedules (Backup and DR testing)

Develop and maintain system documentation for all database instances and interfaces

Skills & Personal Qualities Desireable:

A knowledge of integration tools like MQ Series, IIB or ACE

Previous experience with data migration.

An enthusiasm for technologies.

A willingness to share knowledge and information among colleagues and relevant business partners

Ability to automate installations/configuration of database software using automation