What are the responsibilities and job description for the Mainframe Systems Programmer/DBA position at Jobs via Dice?
Dice is the leading career destination for tech experts at every stage of their careers. Our client, Fint Solutions Inc, is seeking the following. Apply via Dice today!
- 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.
- The following technology skill sets are required to perform in this classification. IBM: Z/OS, IMS, DB2, ADABAS, SMP/E, JCL, IMS DB/DC, CICS, ACF2, ASSEMBLER/COBOL/REXX, IBM FILE MANAGER, DELTA/IMS, NATURAL/ SUPERNAT, ENTIREX, CA SPOOL, IMS & DB2 BMC Tools, N20/TRIM.