Note: Please share me your updated resume with contact details to hari@dnsinfoltd.com
Hope you are doing well,
Please find the below requirement and if you comfortable and interested please share me your updated resume with contact details ASAP.
Role: DB2/IMS Lead Database Administrator
Location: Houston, TX (Hybrid)
Duration: Long Term
Technical Skills:
· Proven experience as a DB2/IMS Databases Administrator or similar role in production support environments.
· 10+ years of hands-on experience supporting DB2 for z/OS and IMS (Information Management System) in a production environment.
· Strong knowledge of mainframe tools such as SPUFI, QMF, BMC, CA-DB2/IMS tools, and IBM utilities.
· Deep understanding of DB2 database internals, logs, buffer pools, catalog/directory, and utilities.
· Proficient in IMS Full-Function and Fast Path databases, DL/I calls, PSB/DBD maintenance.
· Solid experience with JCL, TSO/ISPF, SDSF, and mainframe batch job troubleshooting
· Experience with modern mainframe automation tools and schedulers (e.g., Control-M, CA-7).
· Knowledge of COBOL, CICS, and batch job data flows.
· Understanding of DB2 Data Sharing and IMS Sysplex environments.
· Experience with backup and recovery solutions
· Solid knowledge of Linux/Unix systems and scripting (Shell, Python, or similar).
· Proficiency in troubleshooting performance tuning, and capacity planning.
· In-depth understanding of data management (e.g. permissions, recovery, security and monitoring)
· Strong troubleshooting and problem-solving skills.
· Excellent communication and collaboration abilities.
· Ability to work in a 24/7 support rotation and handle urgent production issues.
· Familiarity with data security is the best practice and backup procedures.
Responsibilities
Production Support & Monitoring:
o Provide 24x7 support for DB2 and IMS database environments, including on-call rotation.
o Monitor database performance, availability, and integrity using mainframe tools and utilities.
o Respond to incidents, troubleshoot issues, and resolve problems related to DB2/IMS systems.
Database Maintenance & Administration:
o Perform database backup and recovery procedures for DB2 and IMS databases.
o Conduct regular reorgs, image copies, and utilities execution (RUNSTATS, REORG, CHECK).
o Support DB2 and IMS subsystem maintenance, upgrades, and patching.
Performance Tuning & Optimization:
o Analyze and tune SQL queries, buffer pools, and access paths in DB2.
o Optimize IMS database segments, DBDs, PSBs, and access methods.
o Work with developers to design efficient data access strategies .
Change Management & Deployments:
o Review and implement database schema changes via Change Control processes.
o Participate in software releases, ensuring database readiness and minimal impact on production.
Security & Compliance:
o Manage user access, RACF integration, and permissions in DB2/IMS environments.
o Ensure compliance with enterprise security standards and data privacy regulations.
Documentation & Collaboration:
o Maintain accurate and up-to-date documentation, including runbooks, architecture diagrams, and operational procedures.
o Collaborate with application teams, infrastructure, and middleware teams to support business applications
Qualification:
· Experience working in regulated environments (e.g., insurance, banking, healthcare) with audit and compliance exposure.
· IBM Certified Database Administrator – DB2 for z/OS certification
· Knowledge of COBOL, CICS, and batch job data flows.
· Understanding of DB2 Data Sharing and IMS Sysplex environments.
· Education qualification: Any degree from a reputed college
· 10+ years overall IT experience.
You received this message because you are subscribed to the Google Groups "Xrecnet IT Recruiters Network - Corp to Corp IT Jobs & Hotlists" group.
To unsubscribe from this group and stop receiving emails from it, send an email to xrecnet+unsubscribe@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/xrecnet/CAGZ%2BRrc1-oHj34kL7iJuv9%2BjWStBnAQiORPUMkU8bZVw1FNWwA%40mail.gmail.com.
No comments:
Post a Comment