Database Administrator

Role Title: Database Administration

Role Location: London, UK

Role Type: Permanent (Hybrid)

Job Description:-

Key points: 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.

Having hands-on experience in DBA activities like Implementing Data Maintenance, Authorization and privileges for DB2 access, Regular Backup and Recovery Activities.

Experience in operational 24×7 support, best practice trouble shooting, monitoring, and maintenance.

Result oriented, Customer focused with healthy relationship 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.

Roles & Responsibilities:

• 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 stand alone and DPF environments.

• Creating various db2 objects like databases, tablespaces, tables, views and indexes etc.

• Configuring HADR between servers.

• Supporting various windows applications in State Farm like Philbert, WinSQL and NLP etc.

• Involved in Disaster Recovery exercise.

• Cataloging mainframe databases in open systems to make the mainframe databases available to open systems users.

• Resolving user issues related to database.

• Granting access to users and revoking it from users.

• Monitoring Tools: top, db2top, db2pd, snapshots etc.

• Working with partitioned tables, Materialized query tables and views.

• Performing restorations frequently on basis of business requirements.

• Table space level backups and restorations based on business requirement.

• Supporting DB2 based tools like IBM Data Studio, IBM rational manager and IBM Installation Manager.

• Working with Q Replication.

• Incident management and change management using HPSM