Key ResponsibilitiesInstall, configure, and maintain IMS database environments (IMS DB)Support and manage different IMS database types: Full Function DB, Fast Path DB, HALDB (High Availability Large Databases)Perform database administration activities: Database definition, allocation, and dataset management; REORGs and space management to maintain performanceManage IMS control structures: DBD, PSB, ACB libraries, and IMS CatalogExecute and support IMS utilities: Load / Unload, Reorganization, Image Copy, Recovery utilities (e.g., DFSURGL0, DFSUICP0)Monitor database performance and resolve issues: Access path inefficiencies, Space constraints, Application-related data issues, Abends and data inconsistenciesCollaborate with: Application development teams (DL/I access, database design); IMS System Programmers (performance and tuning); Operations teams (batch and online processing)Participates in design, development and implementation of complex Databases or maintenance and support of the infrastructure supporting IMS databases, often using new technologies and emerging methodologiesManages multiple, moderately complex projects and may direct activities of a team related to special initiatives or operations. Routine accountability is for technical knowledge and capabilities as a team member or as an individual contributorDesign technical solution to match business application requirementsCreate process flow charts and related procedural documentationPerform database recovery of all types (Image Copy recovery, PIT recovery)Provide independent application development supportExperience with Performance and TuningRequired Skills & QualificationsMinimum 7 years of DBA experience supporting IMS databases in a z/OS environment using Sysplexed Data Sharing. Must have knowledge of Full Function, Fast Path and HALDB databases using Secondary Indexing, Logical Relationships, Sparsing Routines (Assembler), Replication, Compression, Encryption. Database performance and tuning, Database monitoring and troubleshooting, Physical database design and build, Backup and recoveryStrong experience with IBM z/OS environmentHands-on experience as IMS Application DBA (IMS DB)Experience with IMS utilities and DB maintenance activitiesExperience troubleshooting: Database abends (Uxxx, S0Cxx), Data corruption or integrity issuesFamiliarity with: JCL, TSO/ISPF, SDSF, REXX; Batch and online IMS environments (IMS DB/DC); IMS Database Administration Utilities, BMC utility and monitoring tools or equivalentPreferred QualificationsExperience integrating IMS with: DB2, CICS, MQ, and distributed systemsExperience with performance tools (e.g., OMEGAMON, MainView)Exposure to IMS modernization (APIs, z/OS Connect)Knowledge of scripting/automation (REXX)Experience in large-scale IMS database migrations or consolidationExposure to data replication or data integration solutionsExperience in regulatory/compliance-driven environments (SOX, PCI, etc.)Management procedures and/or tools (ISPW, Service Now).
Experience with VISIO a plus