Mainframe IMS Application DBA / IMS DBA Analyst

Job Description

Mainframe IMS Application DBA / IMS DBA Analyst (Openings: 1 Position)

\n

Open for W2 and C2C arrangements (W2 Folks Preferred first)

\n

Location: Chandler, AZ; Plano, TX; Charlotte, NC; and Jersey City, NJ from Day 1 (Client prefer local folks)

\n

Hybrid Schedule: 3 Onsite Days (Tue, Wed, Thur) & 2 Remote Days (Mon, Fri)

\n

Duration: 6+ months, extendable

\n

Direct client opportunity

\n

No mid layer / No Implementation partners are Involved

\n

Mode of Interview: 2 Rounds mostly virtual

\n

\n

Job Description:

\n

\n
• Mainframe IMS Application DBA / IMS DBA Analyst
\n
• The IMS Application DBA will manage and support IMS database environments in a high-availability enterprise environment.
\n
• 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.
\n

\n

\n

Mandatory requirements include:

\n

\n
• Minimum 7 years of DBA experience supporting IMS databases in a z/OS environment using Sysplexed Data Sharing.
\n
• Strong knowledge of Full Function, Fast Path, and HALDB databases
\n
• Experience with secondary indexing, logical relationships, sparsing routines using Assembler, replication, compression, and encryption.
\n
• Experience with database performance and tuning, monitoring, troubleshooting, physical database design and build, backup, and recovery.
\n
• Strong IBM z/OS experience
\n
• Hands-on experience as an IMS Application DBA supporting IMS DB.
\n
• Experience with IMS utilities and database maintenance activities.
\n
• Experience troubleshooting database abends, including Uxxx and S0Cxx errors.
\n
• Experience resolving data corruption and data integrity issues
\n
• Knowledge of JCL, TSO/ISPF, SDSF, and REXX
\n
• Experience with batch and online IMS environments, including IMS DB/DC.
\n
• Experience with IMS Database Administration Utilities and BMC utility/monitoring tools or equivalent.
\n
• Experience with IMS database types, including Full Function DB, Fast Path DB, and HALDB
\n
• Experience with database definition, allocation, dataset management, REORGs, and space management.
\n
• Knowledge of DBD, PSB, ACB libraries, and IMS Catalog
\n
• Experience with Load/Unload, Reorganization, Image Copy, and recovery utilities such as DFSURGL0 and DFSUICP0.
\n
• Experience performing Image Copy recovery and point-in-time recovery.
\n
• Strong database performance and tuning experience.
\n
• Willingness to work onsite three days per week.
\n

\n

\n

Preferred experience:

\n

\n
• Experience integrating IMS with DB2, CICS, MQ, and distributed systems.
\n
• Experience with OMEGAMON, MainView, or similar performance-monitoring tools.
\n
• Exposure to IMS modernization, APIs, or z/OS Connect
\n
• REXX or other scripting/automation experience
\n
• Experience with large-scale IMS database migrations or consolidation.
\n
• Experience with data replication or data integration solutions
\n
• Experience in regulatory or compliance-driven environments, including SOX or PCI
\n
• Experience with ISPW or ServiceNow
\n
• Experience with Visio
\n

\n

\n

Pay Range: $65/hr - $70/hr

\n

\n

The 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.