Sign upLog in
Database Jobs in Richardson, TX

IMS / DB2 Database Engineer (L3 Support)

APN consulting Group

Richardson, Texas

Apply
JOB DETAILS
JOB TYPE
Full-time
SKILLS
AllFusion Endevor Change Manager, Amazon Web Services (AWS), Analysis Skills, Apache Kafka, Application Integration, Artificial Intelligence (AI), Business Solutions, Cloud Computing, Cobol Programming Language, Computer Security, Compuware File-aid, Consulting, Database Administration, 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 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
Richardson, Texas
POSTED
1 day ago
IMS / DB2 Database Engineer (L3 Support)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.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.Job DescriptionIMS / 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 remediationAnalyze DB2 packages, plans, SQL performance, and buffer pool behaviorSupport bind, rebind, package versioning, and collection maintenanceModify DB2 tables, indexes, views, synonyms, and statistics as neededPerform IMS database maintenance including ACBGEN, DBDGEN, PSBGENReview and deploy IMS database structural changes across TEST, PRE-RELEASE, and RELEASEAssist in resolving production data issues involving record corruption, mismatched keys, or incorrect table loadsDebug SQL-related abends (SQLCODEs, SQLSTATEs) and IMS abends (U- or A-codes)Review SAS or batch jobs for database access patterns impacting performanceEnsure database availability during nightly, weekly, and monthly batch cyclesMonitor space utilization, reorganize databases, and maintain high-performance availabilityAssist Tier 2 Support as needed by:Responding to questions or failures involving DB2 or IMS batch jobsValidating database connectivity for applications during upgrades or migrationsProviding routine maintenance such as RUNSTATS, REORG, image copies, and index rebuildsSupporting refresh processes between environments (TEST, PREL, REL)Supporting SQL and DLI/DBB calls used by application teamsMaintaining 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 managementStrong understanding of IMS and DB2 utilities such as REORG, RUNSTATS, LOAD/UNLOAD, ICOPY, CHANGE ACCUMExperience with SQL tuning, EXPLAIN, access path analysis, and performance monitoringFamiliarity with mainframe file systems (VSAM, GDGs, PDSEs)Strong knowledge of the compilation flow between DB2 precompile, bind, load module, and executionExperience supporting DB2 and IMS changes via Endevor or similar CM toolsAbility 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 applicationsExperience with IBM tools: OMEGAMON, MainView, FileAid/DB2, IMS Explorer, QMF, Platinum toolsExperience handling database migrations (DB2 version upgrades, IMS version upgrades)Experience debugging SAS/REXX/COBOL/PL1 programs that use DB2 or IMSExperience integrating mainframe databases with distributed platforms (AWS, Oracle, Kafka, ETL tools)Experience in a high availability 24/7 operational environmentWe 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

A

APN consulting Group

Resume Resources

Free Resume TemplatesFree Resume Builder

Similar Job Searches

Database Administrator Jobs in Richardson, TXRemote IT JobsEntry Level IT Jobs