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 24x7 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