Broadcom Datacom/DB Database Administrator

Perform day-to-day administration, monitoring, performance tuning, and troubleshooting of CA Datacom/DB Multi-User Facility (MUF) and databases in a 247 production environment

Apply and validate Broadcom recommended service (maintenance) via SMP/E, including planning and executing quarterly recommended service upgrades

Manage Datacom/DB structures (areas, tables, indexes, SQL access, Multi-Dataset Tables, partitioning, compression, etc.)

Perform database recoveries using Datacom forward recovery, backward recovery (Dynamic Backward Recovery), and spill/archive management

Support Datacom/DB SQL access including plan management, dynamic plan selection, and optimization for both native Datacom applications and SQL-based reporting tools

Work closely with application development teams on database design, DDL changes, and impact analysis

Maintain Datacom/DB security via internal security and/or integration with RACF/Top Secret/ACF2

Manage Datacom/DB logging (LXX, RXX, PXX), checkpoint processing, and MUF startup/shutdown procedures

Participate in disaster recovery planning and testing for Datacom environments

Automate repetitive tasks using REXX, Datacom utilities (DBUTLTY), or other tools

Provide on-call support (rotational) for production incidents