Db2 Data Base Administrator

Social network you want to login/join with:

Db2 Data Base Administrator, Bolton, Greater Manchester

col-narrow-left

Client:

Infinity Quest

Location:

Bolton, Greater Manchester, United Kingdom

Job Category:

Other

–

EU work permit required:

Yes

col-narrow-right

Job Views:

3

Posted:

04.06.2025

Expiry Date:

19.07.2025

col-wide

Job Description:

Key points: Not more on Db2 mainframe people but need Unix / Linux skills with DBA DB2

Requirements:

• 7+ years of experience as a DB2 Database Administrator involved in Development, Enhancements, and Production Support.
• Certified IBM DB2 DBA or equivalent experience.
• Hands-on experience in DBA activities like Data Maintenance, Authorization, privileges for DB2 access, Backup, and Recovery activities.
• Experience in operational 24×7 support, troubleshooting, monitoring, and maintenance.
• Result-oriented, customer-focused with healthy relationships with team members.
• 2 years of experience as DB2 DBA on Mainframes.

Skills:

Operating Systems: Windows XP, Linux, AIX, and AWS EC2

Database: DB2 on open systems

Database Tools: db2top, db2advise, db2pd, db2dart, db2look, db2support, SPUFI, QMF, QREP, DB2 Admin tool, Log analyzer.

• Providing 24/7 Production support.
• Providing solutions to application teams.
• Working on both logical and physical partitioning databases.
• Data refresh in Development regions.
• Involved in DB2 V10 upgrade.
• Involved in Quarterly Disaster Recovery activity.
• Restorations of database and redirect restorations.
• Responsible for DB backups and recovery in both standalone and DPF environments.
• Creating various DB2 objects like databases, tablespaces, tables, views, and indexes.
• Supporting various Windows applications in State Farm like Philbert, WinSQL, and NLP.
• Involved in Disaster Recovery exercises.
• Cataloging mainframe databases in open systems to make mainframe databases available to open systems users.
• Resolving user issues related to databases.
• Granting and revoking user access.
• Working with partitioned tables, materialized query tables, and views.
• Performing restorations based on business requirements.
• Table space level backups and restorations.
• Supporting DB2 tools like IBM Data Studio, Rational Manager, and Installation Manager.
• Working with Q Replication.
• Incident and change management using HPSM.

#J-18808-Ljbffr