Administrator (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