Contract Teradata Database Administrator Jobs in California

Job Summary:
Suncap Technology is seeking a Senior Mainframe Systems Programmer/DBA to lead complex database upgrade projects and manage core database products. The role involves planning, installing, and maintaining database environments to support the County's database architecture.
Responsibilities:
• 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.
• 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.
Qualifications:
Required:
• A minimum of seven (7) years of experience as a Systems Programming/ DBA
• At least three (3) years of that experience in a lead role
• Possession of a bachelor's degree in an IT-related or engineering field
• The Mainframe Systems Programmer/DBA for Legacy Systems manages different types of databases, such as hierarchical (IMS), relational (DB2), and file-based (ADABAS)
• 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
• 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
Preferred:
• DB2, ADABAS and MQ Systems programming skills
• Mainframe DBA Skills
• SMP/E
• 7 Years of Experience in ADABAS/NATURAL systems programming
• 12 Years 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
Company:
Suncap Technology is a staffing firm that provides recruiting and financial staffing services. Founded in , the company is headquartered in Davie, USA, with a team of 51-200 employees. The company is currently Growth Stage.