The Mainframe Systems Programmer/DBA for Legacy Systems manages different types of databases, such as hierarchical (IMS), relational (DB2), and file-based (ADABAS), and is responsible for planning and upgrading the database environments on a County-established basis;
verifying the health of all the databases; database administration technical consulting for application and operations teams for the purpose of project planning/development; maintenance on production database systems; performance of technical reviews for existing systems that utilize one of the following database management systems (DBMS): ADABAS, DB2 or IMS;
performance of evaluations for the purposes of selecting new or fine-tuning existing DBMS software; consultation with project development teams to provide recommendations on database design;
development of logical and physical database designs; creation of overviews of logical database designs;
creation of physical databases; database capacity planning; development and use of backup and recovery procedures for databases; database performance monitoring; database space monitoring;
database reorganizations; database replication; database compression and database partitioning.

Mainframe Developer

About this role