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. Role: DB2 DBA
Mode: Hybrid(2 to 3 days to office)
Job Type: Permanent role
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.
~ 2 years of experience as DB2 DBA on Mainframes.
Windows XP, Linux, AIX and AWS ec2
Database : DB2 on open systems
Database Tools :db2top, db2advise, db2pd, db2dart, db2look, db2support, SPUFI, QMF, QREP
Working on both logical and physical partitioning databases.
• Data refresh in Development regions.
• 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.
• Cataloging mainframe databases in open systems to make the mainframe databases available to open systems users.
• Resolving user issues related to database.
• Monitoring Tools: top, db2top, db2pd, snapshots etc.
• Supporting DB2 based tools like IBM Data Studio, IBM rational manager and IBM Installation Manager.
• Competitive salary and benefits package
Culture focused on talent development with quarterly promotion cycles and company-sponsored higher education and certifications.
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