Mainframe Systems Programmer/Mainframe Database Administrator (DBA)

Downey, CA

12+ months

Required Skills:

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.

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.

This classification requires the possession of a bachelor's degree in an IT-related or engineering field.

Desired Skills:

Z/OS 2.4,HCD/IODEF , Z13S,Z15,SMP/E, ASSEMBLER, JCL, COBOL,ACF2,SYSPLEX coupling facility,, HMC (Processor Interface), OSA (Networking Interface), ICC (Integrated Console Controller), FICON (Fiber connectivity to peripheral devices),z/OS Open System and Unix Systems Services (USS) on the Mainframe. ,CLIST, REXX,, FICON switch configuration and definition in HCD, Server Time Protocol (STP) configuration.

15 Years of experience with Z/OS operating system upgrade, 10 Years of experience with Mainframe hardware upgrade projects. 6 Years of experience with HCD & HMC. 4 Years of experience with DB2 or IMS or IBM Tools installation. 2 Years of Experience with mainframe storage.

Additional Information: This is not Mainframe application developer role. This is strictly Z/OS System programmer role.

Regards

Sunil Damagalla

West Advanced Technologies, Inc

E: sunil.d@wati.com D: 279-666-5837