CodeForce
Main frame / Midrange Database Admin
CodeForce, Los Angeles, California, United States, 90079
Position 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:
Three (3) years of experience within the last five (5) years designing, developing, testing and deploying software applications utilizing two or more of the Oracle Fusion Middleware (FWM) 12c / 11g products in the area of database access, objects, and data integration (ETL/ET-T):Oracle Data Integrator (ODI)Oracle Golden Gate (OGG, Veridata) 1.c Materialized view (MV), Procedural language / structured query language (PL / SQL)Oracle B2B for Electronic Data Interchange (B2B-EDI)Three (3) years of experience within the last five (5) years designing, developing, testing, and deploying software applications utilizing two or more of the following Oracle Database products in the areas of database processing (OLTP, OLAP), data modeling, database options, architecture and operations:Oracle Database (e.g. DB 12c/11g or greater, ExaData Cloud Service)Oracle Database options (e.g. ASO, ACO, SGO, DMS, partitioning, DB In-Memory, Multi-tenant)Oracle Real Application Clusters (RAC) 2.d Oracle Active Data Guard (ADG/DG), Recovery Manager (RMAN), Data PumpThree (3) years of experience withing the last five (5) years troubleshooting software application deployment and configuration issues, utilizing the Oracle Enterprise Manager (OEM Cloud Control) with database management packs. Familiar with Oracle WebLogic Server (WLS), Oracle Database High Availability (HA) and Disaster Recovery (DR) concept.Three (3) years of experience within the last five (5) years utilizing three (3) or more of the development, testing, and product backlog/defect management tools:Oracle SQL Developer (with Data Modeler)Oracle GoldenGate StudioOracle Data Integration StudioOracle Application Testing Suite (OATS)Oracle Database Performance Testing and Tuning (e.g. AWR, ADDM)Soap.UIJIRA 5 Three (3) years of experience working with two (2) or more of the Release Management, Continuous Integration (CI), build, and source controls tools:Jenkins 5.b Apache Maven, Ant 5.c Apache ArchivaGITSonarQubeThree (3) years of experience acting as a technical lead of a software development team, working in an Agile SDLC collaborative environment. Familiar with Test Driven Development (TDD) & Dev Ops Principals.Three (3) years of experience designing, developing, testing and deploying software applications utilizing one or more of the Oracle Fusion Middleware (FMW) 12c / 11g products in the areas of application integration:Oracle Service-Oriented Architecture Suite (SOA, EDA / END)Oracle Service Bus (OSB)Three (3) years experience with installing and configuring Oracle products on Oracle Linux (OL) platform and/or Red Hat Enterprise Linux (RHEL) platforms,Three (3) years experience familiar with Oracle cloud infrastructure and technology concepts (IaaS, PaaS, SaaS).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:
Three (3) years of working experience within the last five (5) years designing, developing, testing, and administrating software applications utilizing three or more of the Oracle Database products in the areas of database processing, data modeling, architecture and operations:Oracle Database 12c/19cOracle ExaData Cloud Service (ExaCS) or Oracle Database Service (DBCS)Oracle Autonomous Data Warehouse (ADW)Oracle Database options (e.g. ASO, ACO, DB In-Memory, Multi-Tenant)Oracle Real Application Clusters (RAC)Oracle Active Data Guard (ADG), Recovery Manager (RMAN), Data PumpThree (3) years of working experience within the last five (5) years designing, developing, testing, and deploying software applications utilizing two or more of the midrange Oracle Fusion Middleware (FMW) 12c products in the areas of database backend and data integration (ETL/EL-T) development:Oracle Data Integrator (ODI)Oracle Application Express (APEX)Oracle DB Materialized View (MV), Procedural Language/Structured Query Language (PL/SQL)Three (3) years of working experience within the last five (5) years designing, developing, testing, and deploying software applications utilizing SQL or PL/SQL programming to extract, transform, and load data in between the mainframe, SQL Server data warehouse, and Oracle database environments.Three (3) years of experience within the last five (5) years troubleshooting software application deployment and configuration issues, utilizing the Oracle Enterprise Manager (OEM) with database management packs. Familiar with Oracle WebLogic Server (WLS), Oracle Database High Availability (HA) and Disaster Recovery (DR) concepts.Three (3) years of working experience within the last five (5) years utilizing three or more of the development, testing, and defect management tools:Oracle SQL Developer (with Data Modeler)Oracle SQL PlusOracle Data Integrator StudioOracle JDeveloper (JDEV)Oracle Database Performance Testing and Tuning (e.g., AWR, ADDM)Oracle Application Testing Suite (OATS) Test ManagerTwo (2) years of experience working with two or more of the CI/CD Release Management, build, deployment, and source control tools:JenkinsApache Maven, AntGitSonarQubeOne (1) year of working experience acting as a technical lead of a software development team, working in an Agile SDLC collaborative environment. Familiar with Test Driven Development (TDD) & DevOps principles.Experience with installing and configuring Oracle products on Oracle Linux platform and/or Red Hat Enterprise Linux platform.Familiar with Oracle Cloud Infrastructure (OCI) and on-premises Mainframe/Windows/Linux environments.
Education Required:
This classification requires the possession of a bachelor's degree in an IT-related or engineering field.
Education Preferred:
Software and IT systems administration skills spanning Main Frame, Mid Range and Linux platforms.
Additional Information:
Live Scan 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:
Three (3) years of experience within the last five (5) years designing, developing, testing and deploying software applications utilizing two or more of the Oracle Fusion Middleware (FWM) 12c / 11g products in the area of database access, objects, and data integration (ETL/ET-T):Oracle Data Integrator (ODI)Oracle Golden Gate (OGG, Veridata) 1.c Materialized view (MV), Procedural language / structured query language (PL / SQL)Oracle B2B for Electronic Data Interchange (B2B-EDI)Three (3) years of experience within the last five (5) years designing, developing, testing, and deploying software applications utilizing two or more of the following Oracle Database products in the areas of database processing (OLTP, OLAP), data modeling, database options, architecture and operations:Oracle Database (e.g. DB 12c/11g or greater, ExaData Cloud Service)Oracle Database options (e.g. ASO, ACO, SGO, DMS, partitioning, DB In-Memory, Multi-tenant)Oracle Real Application Clusters (RAC) 2.d Oracle Active Data Guard (ADG/DG), Recovery Manager (RMAN), Data PumpThree (3) years of experience withing the last five (5) years troubleshooting software application deployment and configuration issues, utilizing the Oracle Enterprise Manager (OEM Cloud Control) with database management packs. Familiar with Oracle WebLogic Server (WLS), Oracle Database High Availability (HA) and Disaster Recovery (DR) concept.Three (3) years of experience within the last five (5) years utilizing three (3) or more of the development, testing, and product backlog/defect management tools:Oracle SQL Developer (with Data Modeler)Oracle GoldenGate StudioOracle Data Integration StudioOracle Application Testing Suite (OATS)Oracle Database Performance Testing and Tuning (e.g. AWR, ADDM)Soap.UIJIRA 5 Three (3) years of experience working with two (2) or more of the Release Management, Continuous Integration (CI), build, and source controls tools:Jenkins 5.b Apache Maven, Ant 5.c Apache ArchivaGITSonarQubeThree (3) years of experience acting as a technical lead of a software development team, working in an Agile SDLC collaborative environment. Familiar with Test Driven Development (TDD) & Dev Ops Principals.Three (3) years of experience designing, developing, testing and deploying software applications utilizing one or more of the Oracle Fusion Middleware (FMW) 12c / 11g products in the areas of application integration:Oracle Service-Oriented Architecture Suite (SOA, EDA / END)Oracle Service Bus (OSB)Three (3) years experience with installing and configuring Oracle products on Oracle Linux (OL) platform and/or Red Hat Enterprise Linux (RHEL) platforms,Three (3) years experience familiar with Oracle cloud infrastructure and technology concepts (IaaS, PaaS, SaaS).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:
Three (3) years of working experience within the last five (5) years designing, developing, testing, and administrating software applications utilizing three or more of the Oracle Database products in the areas of database processing, data modeling, architecture and operations:Oracle Database 12c/19cOracle ExaData Cloud Service (ExaCS) or Oracle Database Service (DBCS)Oracle Autonomous Data Warehouse (ADW)Oracle Database options (e.g. ASO, ACO, DB In-Memory, Multi-Tenant)Oracle Real Application Clusters (RAC)Oracle Active Data Guard (ADG), Recovery Manager (RMAN), Data PumpThree (3) years of working experience within the last five (5) years designing, developing, testing, and deploying software applications utilizing two or more of the midrange Oracle Fusion Middleware (FMW) 12c products in the areas of database backend and data integration (ETL/EL-T) development:Oracle Data Integrator (ODI)Oracle Application Express (APEX)Oracle DB Materialized View (MV), Procedural Language/Structured Query Language (PL/SQL)Three (3) years of working experience within the last five (5) years designing, developing, testing, and deploying software applications utilizing SQL or PL/SQL programming to extract, transform, and load data in between the mainframe, SQL Server data warehouse, and Oracle database environments.Three (3) years of experience within the last five (5) years troubleshooting software application deployment and configuration issues, utilizing the Oracle Enterprise Manager (OEM) with database management packs. Familiar with Oracle WebLogic Server (WLS), Oracle Database High Availability (HA) and Disaster Recovery (DR) concepts.Three (3) years of working experience within the last five (5) years utilizing three or more of the development, testing, and defect management tools:Oracle SQL Developer (with Data Modeler)Oracle SQL PlusOracle Data Integrator StudioOracle JDeveloper (JDEV)Oracle Database Performance Testing and Tuning (e.g., AWR, ADDM)Oracle Application Testing Suite (OATS) Test ManagerTwo (2) years of experience working with two or more of the CI/CD Release Management, build, deployment, and source control tools:JenkinsApache Maven, AntGitSonarQubeOne (1) year of working experience acting as a technical lead of a software development team, working in an Agile SDLC collaborative environment. Familiar with Test Driven Development (TDD) & DevOps principles.Experience with installing and configuring Oracle products on Oracle Linux platform and/or Red Hat Enterprise Linux platform.Familiar with Oracle Cloud Infrastructure (OCI) and on-premises Mainframe/Windows/Linux environments.
Education Required:
This classification requires the possession of a bachelor's degree in an IT-related or engineering field.
Education Preferred:
Software and IT systems administration skills spanning Main Frame, Mid Range and Linux platforms.
Additional Information:
Live Scan Required.