Database Administrator (Hybrid) (Permanent)

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 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 24×7 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