Senior Mainframe Database System Expert with DB2 and IMS Database

Job Title: Senior Mainframe Database System Expert with DB2 and IMS Database
Location: Charlotte, NC (Hybrid – 3 days onsite per week)
Employment Type: W2 Only
Experience Required: 10+ Years

Job Overview:

We are seeking a highly experienced Senior Mainframe Database System Expert with deep expertise in DB2 and IMS Database (IMS-DB) to join our client’s team in Charlotte, NC. The ideal candidate will have extensive experience in mainframe database administration, performance tuning, database design, and troubleshooting in large enterprise environments. This role requires strong technical expertise in z/OS environments, database optimization, and supporting mission-critical systems.

Key Responsibilities:

• Administer, maintain, and support DB2 and IMS databases on mainframe (z/OS) platforms.
• Perform database design, installation, configuration, and upgrades for DB2 and IMS environments.
• Monitor and optimize database performance, capacity planning, and storage management.
• Perform database backup, recovery, and disaster recovery planning.
• Analyze and resolve database performance issues, system failures, and data integrity problems.
• Work closely with application development teams to support database requirements and ensure optimal performance.
• Implement database security policies and access controls.
• Support production deployments, change management, and database migrations.
• Provide technical guidance and best practices for database architecture and management.
• Maintain documentation related to database configurations, procedures, and standards.

Required Skills & Qualifications:

• 10+ years of experience working with Mainframe databases (DB2 and IMS-DB).
• Strong experience with IBM z/OS mainframe environment.
• Hands-on expertise in DB2 administration, tuning, and troubleshooting.
• Deep knowledge of IMS database architecture and management.
• Experience with database backup and recovery tools.
• Strong understanding of database performance tuning and optimization techniques.
• Experience with JCL, TSO/ISPF, and mainframe utilities.
• Familiarity with database security, compliance, and governance.
• Strong analytical and problem-solving skills.
• Excellent communication and collaboration abilities.

Preferred Qualifications:

• Experience in large enterprise or banking/financial services environments.
• Knowledge of DB2 utilities and performance monitoring tools.
• Experience with database migration, modernization, or integration projects.
• Familiarity with DevOps practices in mainframe environments.

Work Model:

• Hybrid role – Candidates must be able to work 3 days per week from the Charlotte, NC office.