City of London
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, • 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. 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 “Persistent is an Equal Opportunity Employer and prohibits discrimination and harassment of any kind.”