Job Description
Please review this document prior to submitting your candidate :
Position - Sr Mainframe Systems Programmer / DBA
Location - Downey, CA, 90242
Please do not submit Mainframe Application developer or Team Leads or Just DBA Profiles. This position is strictly Mainframe Systems programmer role with DBA Skills.
Description
- A Mainframe Systems Programmer / DBA is responsible for leading and / or supporting the most complex database upgrade projects, modification, installation, testing, implementation, maintenance and enhancements of new or existing system software products.
- This classification must plan, install, configure, test, implement and manage core database products, software products in support of the County's database architecture and business needs.
- Special organizational or functional industry position titles for Systems Programmer / DBA include, but are not limited to, DB2 Systems Programmer / DBA, IMS Systems Programmer / DBA and ADABAS / NATURAL Systems Programmer / DBA.
Skills Required
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.Skills Preferred
DB2,ADABAS and MQ Systems programming skills , Mainframe DBA Skills, SMP / E.
Experience Required
This classification must have a minimum of seven (7) years of experience as a Systems Programming / DBA, with at least three (3) years of that experience in a lead role.
Experience Preferred
7 Years of Experience in ADABAS / NATURAL systems programming.12 Yeas of Experience in DB2 Systems programming.5 Years of experience in ADABAS / DB2 / MQ Database Administration.5 Years of experience in BMC DB2 Admin tools.Education Required
This classification requires the possession of a bachelor's degree in an IT-related or engineering field.