JOBSEARCHER

Mainframe IMS Application DBA / IMS DBA Analyst

Mainframe IMS Application DBA / IMS DBA Analyst (Openings: 1 Position) Open for W2 and C2C arrangements (W2 Folks Preferred first)
Location: Chandler, AZ; Plano, TX; Charlotte, NC; and Jersey City, NJ from Day 1 (Client prefer local folks) Hybrid Schedule: 3 Onsite Days (Tue, Wed, Thur) & 2 Remote Days (Mon, Fri)
Duration: 6+ months, extendable
Direct client opportunity No mid layer / No Implementation partners are Involved Mode of Interview: 2 Rounds mostly virtual
Job Description:
  • Mainframe IMS Application DBA / IMS DBA Analyst
  • The IMS Application DBA will manage and support IMS database environments in a high-availability enterprise environment.
  • The role will focus on database design support, performance optimization, data integrity, backup and recovery, and database administration for mission-critical applications running on IBM z/OS.
Mandatory requirements include:
  • Minimum 7 years of DBA experience supporting IMS databases in a z/OS environment using Sysplexed Data Sharing.
  • Strong knowledge of Full Function, Fast Path, and HALDB databases
  • Experience with secondary indexing, logical relationships, sparsing routines using Assembler, replication, compression, and encryption.
  • Experience with database performance and tuning, monitoring, troubleshooting, physical database design and build, backup, and recovery.
  • Strong IBM z/OS experience
  • Hands-on experience as an IMS Application DBA supporting IMS DB.Experience with IMS utilities and database maintenance activities.
  • Experience troubleshooting database abends, including Uxxx and S0Cxx errors.
  • Experience resolving data corruption and data integrity issues
  • Knowledge of JCL, TSO/ISPF, SDSF, and REXXExperience with batch and online IMS environments, including IMS DB/DC.Experience with IMS Database Administration Utilities and BMC utility/monitoring tools or equivalent.
  • Experience with IMS database types, including Full Function DB, Fast Path DB, and HALDBExperience with database definition, allocation, dataset management, REORGs, and space management.
  • Knowledge of DBD, PSB, ACB libraries, and IMS Catalog
  • Experience with Load/Unload, Reorganization, Image Copy, and recovery utilities such as DFSURGL0 and DFSUICP0.Experience performing Image Copy recovery and point-in-time recovery.
  • Strong database performance and tuning experience.
  • Willingness to work onsite three days per week.
Preferred experience:
  • Experience integrating IMS with DB2, CICS, MQ, and distributed systems.
  • Experience with OMEGAMON, MainView, or similar performance-monitoring tools.
  • Exposure to IMS modernization, APIs, or z/OS ConnectREXX or other scripting/automation experience
  • Experience with large-scale IMS database migrations or consolidation.
  • Experience with data replication or data integration solutions
  • Experience in regulatory or compliance-driven environments, including SOX or PCIExperience with ISPW or Service
  • NowExperience with Visio
Pay Range: $65/hr - $70/hrThe specific compensation for this position will be determined by a number of factors, including the scope, complexity and location of the role as well as the cost of labor in the market; the skills, education, training, credentials and experience of the candidate; and other conditions of employment. Our full-time consultants have access to benefits including medical, dental, and vision as well as 401K contributions.