IMS / DB2 Database Engineer (L3 Support)

APN consulting Group

Bernards, NJ

Apply

JOB DETAILS

JOB TYPE

Contractor

SKILLS

AllFusion Endevor Change Manager, Amazon Web Services (AWS), Analysis Skills, Apache Kafka, Artificial Intelligence (AI), Business Solutions, Cloud Computing, Cobol Programming Language, Computer Security, Compuware File-aid, Consulting, Database Administration, Database Analysis, Database Extract Transform and Load (ETL), Database Programming, Database Technology, Debugging Skills, File Systems, High Availability, IBM DB2, IBM IMS Database, IBM Product Family, IBM Rexx Programming Language, IBM z-OS Operating System, IMS DB/DC, IP Multimedia System (IMS), Image Indexing, JCL (Job Control Language), Loading/Unloading, Mainframe Computer, Messaging Middleware, Network Administration/Management, On Call, Operational Support Systems (OSS), Oracle, PL/1 (Programming Language 1), Performance Analysis, Performance Tuning/Optimization, Problem Solving Skills, Process Improvement, QMF, SQL (Structured Query Language), ServiceNow, Software Upgrades, Statistics, Sterling Commerce CONNECT:Direct, System Integration (SI), Technical Recruiting, Telecommunications

LOCATION

Bernards, NJ

POSTED

30+ days ago

APN Consulting, Inc. is a progressive IT staffing and services company offering innovative business solutions to improve client business outcomes. We focus on high impact technology solutions in ServiceNow, Fullstack, Cloud & Data, and AI / ML. Due to our globally expanding service offerings we are seeking top-talent to join our teams and grow with us. Job title: IMS / DB2 Database Engineer (L3 Support) Location: Richardson, TX 75082 OR Baskin Ridge ,NJ ,Tampa FL •****Must have skills****** We need four Mainframe developer with skill set - Mainframe - PL/1, C370, Assembler, IMS, DB2, JCL ,DB Developer . Telcordia work experiences with prior Tirks + switches knowledge. IMS / DB2 Database Engineer (L3 Support) Need an experienced IMS and DB2 (Mainframe) database engineer with prior expertise supporting large telecom OSS applications running on IBM z/OS. The engineer will provide Tier 3 support for database-related code fixes, performance tuning, schema changes, bind/plan/ACB maintenance, and resolution of data-related issues in production. The engineer should be able to support Tier 1 and Tier 2 teams responsible for operational monitoring, ensuring that all database components remain available, optimized, and stable 24/7. This role supports multiple integrated systems that depend on DB2 and IMS databases for planning, dispatch, inventory, scheduling, and network operations. Responsibilities Provide Tier 3 support for DB2 and IMS database subsystems including: • Support database changes required for code fixes, enhancements, or vulnerability remediation • Analyze DB2 packages, plans, SQL performance, and buffer pool behavior • Support bind, rebind, package versioning, and collection maintenance • Modify DB2 tables, indexes, views, synonyms, and statistics as needed • Perform IMS database maintenance including ACBGEN, DBDGEN, PSBGEN • Review and deploy IMS database structural changes across TEST, PRE-RELEASE, and RELEASE • Assist in resolving production data issues involving record corruption, mismatched keys, or incorrect table loads • Debug SQL-related abends (SQLCODEs, SQLSTATEs) and IMS abends (U- or A-codes) • Review SAS or batch jobs for database access patterns impacting performance • Ensure database availability during nightly, weekly, and monthly batch cycles • Monitor space utilization, reorganize databases, and maintain high-performance availability Assist Tier 2 Support as needed by: • Responding to questions or failures involving DB2 or IMS batch jobs • Validating database connectivity for applications during upgrades or migrations • Providing routine maintenance such as RUNSTATS, REORG, image copies, and index rebuilds • Supporting refresh processes between environments (TEST, PREL, REL) • Supporting SQL and DLI/DBB calls used by application teams • Maintaining integration flows with external systems (NDM, MQ, TIRKS, WFA subsystems) Requirements • Minimum 5 years of hands-on experience with DB2 for z/OS (packages, plans, utilities, SQL tuning) • Minimum 7 years of experience with IMS (DB + DC), including DBD/PSB/ACB management • Strong understanding of IMS and DB2 utilities such as REORG, RUNSTATS, LOAD/UNLOAD, ICOPY, CHANGE ACCUM • Experience with SQL tuning, EXPLAIN, access path analysis, and performance monitoring • Familiarity with mainframe file systems (VSAM, GDGs, PDSEs) • Strong knowledge of the compilation flow between DB2 precompile, bind, load module, and execution • Experience supporting DB2 and IMS changes via Endevor or similar CM tools • Ability to participate on-call support for critical database escalations (as needed) Nice to Have • Experience with telecom OSS systems such as WFA-DO, WFA-DI, TIRKS, Ericsson/Telcordia applications • Experience with IBM tools: OMEGAMON, MainView, FileAid/DB2, IMS Explorer, QMF, Platinum tools • Experience handling database migrations (DB2 version upgrades, IMS version upgrades) • Experience debugging SAS/REXX/COBOL/PL1 programs that use DB2 or IMS • Experience integrating mainframe databases with distributed platforms (AWS, Oracle, Kafka, ETL tools) • Experience in a high availability 24/7 operational environment We are committed to fostering a diverse, inclusive, and equitable workplace where individuals from all backgrounds feel valued and empowered to contribute their unique perspectives. We strongly encourage applications from candidates of all genders, races, ethnicities, abilities, and experiences to join our team and help us build a culture of belonging.

About the Company

APN consulting Group

Resume Resources

Free Resume Templates Free Resume Builder