Mainframe DBA

Position:Mainframe DB2 / IMS Administrator
Location: Wilmington, DE / Columbus, OH / New York, NY (Onsite)
Duration: Contract
Job ID: 173297

Job Overview:
We are seeking a highly skilled Database Management professional to architect advanced, strategic DBMS solutions and support the development and production of large-scale, complex distributed, midrange, and mainframe environments. The role involves developing and managing the execution of database implementation and upgrades, evaluating tools, performing database performance monitoring, and defining database standards, policies, and procedures. This position requires strong data modeling skills, data governance discipline, and proficiency in data modeling tools and operational/data warehouse design concepts.

Responsibilities:

• Administer, design, implement, and support highly available and scalable Mainframe DB2 & IMS database solutions.
• Implement data models, database designs, data access, and table maintenance codes.
• Maintain DB2/IMS Databases with High Availability features using Data Partitioning and Database replications.
• Resolve database performance issues, capacity issues, replication, and other data-related challenges.
• Collaborate with Information Architects and Database Designers to implement physical data models.
• Develop database performance monitoring processes and analyze data for optimization opportunities.
• Provide Level 2 on-call support for the 24/7 DB2/IMS database environment.
• Manage on-site backup and recovery processes.
• Plan and execute required database upgrades or migrations.
• Utilize database admin tools like CA Platinum, BMC, IBM Admin tools, Mainview, IBM Data Studio, and BMC Recovery management.

Qualifications:

• Formal training or certification in software engineering concepts with 5+ years of applied experience.
• Expertise in database design/development, integration, performance monitoring & tuning, systems re-engineering, and operations support.
• Proficiency in DB2 for z/OS and mainframe-related tools such as BMC, CA Platinum, SMPE, ISPF, SMS, and SMF.
• Experience with IMS Full Function/Fast Path database implementation, REXX programming, and MQ.
• Knowledge of IBM Replication CDC and QREP.
• Ability to create roadmaps, processes, best practices, standards, and strategies for continuous improvement, resiliency, and scalability.
• Experience with Atlassian tools like Jira and Confluence.
• Proven background in database engineering, automation, monitoring, performance engineering design, and implementations.
• Strong execution mindset to manage and track progress against transformation goals.
• Knowledge of industry-wide technology trends and best practices.
• Preferred: Experience providing 24x7 rotational support and familiarity with IDAA (Data Analytics Accelerators).

About PTR Global: PTR Global is a leading provider of information technology and workforce solutions. PTR Global has become one of the largest providers in its industry, with over 5000 professionals providing services across the U.S. and Canada. For more information visit www.ptrglobal.com

At PTR Global, we understand the importance of your privacy and security. We NEVER ASK job applicants to:

• Pay any fee to be considered for, submitted to, or selected for any opportunity.
• Purchase any product, service, or gift cards from us or for us as part of an application, interview, or selection process.
• Provide sensitive financial information such as credit card numbers or banking information. Successfully placed or hired candidates would only be asked for banking details after accepting an offer from us during our official onboarding processes as part of payroll setup.

Pay Range: $55 - $60

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, vision and 401K contributions as well as any other PTO, sick leave, and other benefits mandated by appliable state or localities where you reside or work.

If you receive a suspicious message, email, or phone call claiming to be from PTR Global do not respond or click on any links. Instead, contact us directly at +1 214-740-2424. To report any concerns, please email us at [email protected] #LI-HM1