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