Database Administrator (IT Infrastructure Management)

Applies expert knowledge of the data management process to the support of Exchange data base management within the IT infrastructure portfolio. The tasks associated with this support may include, but are not limited to reviewing, evaluating, designing, implementing and maintaining corporate data bases, identifying data sources, constructing data decomposition and data flow diagrams, writing code for accessing and modifying data bases and constructing stored procedures. Responsible for ensuring IT compliance to security, audit policies, and procedures. Monitors and tunes data base systems to achieve optimum performance. Develops and maintains standard operating procedures and documentation, provides project leadership for the planning and execution of major data base projects, and provides guidance and advice to developers and users concerning data bases capabilities, software, hardware, and procedures. Ensures data integrity by evaluating, implementing, and managing appropriate software and hardware solutions. Defines disaster recovery requirements and plans and delivers a disaster recovery solution for the data base environment. Coordinates with Exchange business units, the project management office (PMO), outside entities and IT staff to confirm compliance and risk mitigation has been met. Serves as third level support by identifying, evaluating, and troubleshooting non-routine events and incidents associated with the data base management processes. Responds to telephone calls and email requests for data base management processes. Safeguards physical access to Exchange restricted data, processes and services.

Five years of experience in the administration of IMS and DB2 or oracle and SQL server databases and subsystems.

Or

Bachelor's degree in information technology and three years of experience in the administration of IMS, DB2, Oracle or SQL server databases and subsystems


Degree (one of):

BACHELORS DEGREE - Preferred

Major/Minor (one of):

INFORMATION TECHNOLOGY - Preferred

Work – Onsite (HQ – Dallas, Texas)

• Remote/Telework not authorized per Presidential Memorandum “Return to In Person Work”

• PCS Not Authorized/LSP Not Authorized

Technical (Preferred/Required Skills/Systems):

IMS Skills:

• IMS for z/OS DBA experience in large-scale enterprise environments.
• Expertise in system architecture, advanced troubleshooting, andinfrastructure planning.
• Advanced database engineering: HALDB partitioning, IMS Full FunctionDBs (HDAM, HISAM, HIDAM, GSAM).
• IMS SYSGEN proficiency (DBDGEN, PSBGEN, ACBGEN) and systemparameter management.
• Dynamic Resource Definition (DRD) for online resource changes.
• IMS TM expertise (Control/Dependent Regions, transaction queueoptimization).
• Performance tuning and diagnostics: buffer pools, locking, bottlenecks.
• IMS log, trace, and DBRC analysis; monitoring tools and vendor utilities.
• Disaster recovery: DBRC architecture, log/change accumulationmanagement.
• DR planning, testing, and execution (failover, point-in-time recovery).

DB2 Skills:

• Db2 for z/OS DBA experience in high-volume, mission-critical
• environments.
• Expertise in mainframe architecture, subsystem optimization, and advanced
• SQL tuning.
• Subsystem architecture: buffer pools, group buffer pools, storage tuning to
• reduce I/O.
• ZPARM configuration for performance, locking, and memory optimization.
• DDF configuration and security for distributed workloads.
• WLM alignment with Db2 performance and workload priorities.
• Performance tuning: access path analysis (EXPLAIN, Visual Explain), SQL
• optimization and rewrite.
• Monitoring and diagnostics using enterprise tools (e.g., Omegamon).
• High availability: Db2 Data Sharing (Parallel Sysplex) design and support.
• Utilities: REORG, RUNSTATS, LOAD, MODIFY, and third-party tooling.
• Backup and recovery: point-in-time recovery, FlashCopy, DR planning and
• testing.
• Security and governance: RCAC, Trusted Contexts, RACF integration.
• Schema evolution: non-disruptive changes in 24/7 production environments.

Analyze and resolve database performance issues, database capacity issues, replication/clone/restores, and other database issues.
Database design and new software compliance.
Interface with development staff, project management and senior management.
Data security.
Provide technical resource/training to lead junior staff.
Performs other duties as assigned.

24x7 work environment supporting Exchange operations, which requires either shift work, on call, and/or after hours project work and may include holidays, and weekends
IT environment is constantly changing demanding quick solutions and evolving skills
IT position located at HQ
IT position - there may be some TDY associated with this IT work