DB2 DBA

About Persistent:

We are a trusted Digital Engineering and Enterprise Modernization partner, combining deep technical expertise and industry experience to help our clients anticipate what’s next. Our offerings and proven solutions create a unique competitive advantage for our clients by giving them the power to see beyond and rise above. We work with many industry-leading organizations across the world including 14 of the 30 most innovative US companies, 80% of the largest banks in the US and India, and numerous innovators across the healthcare ecosystem.

About Position and details:

• Role: DB2 DBA
• Location: Harbour Exchange Square, London
• Mode: Hybrid(2 to 3 days to office)
• Experience: 6 to 15 years
• Job Type: Permanent role

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

Benefits:

• Competitive salary and benefits package
• Culture focused on talent development with quarterly promotion cycles and company-sponsored higher education and certifications.
• Opportunity to work with cutting-edge technologies.
• Employee engagement initiatives such as project parties, flexible work hours, and Long Service awards
• Annual health check-ups
• Insurance coverage: group term life, personal accident, and Mediclaim hospitalization for self, spouse, two children, and parents

Let’s unleash your full potential at Persistent - persistent.com/careers.

“Persistent is an Equal Opportunity Employer and prohibits discrimination and harassment of any kind.”