Key points: people 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.
* 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 24x7 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