Nexlogica
Mainframe Systems Programmer/DBA
Location: Hybrid, Los Angeles, CA
Employment type: Full-time
Senior level: Mid-Senior level
Job function: Information Technology
Position Description A Mainframe Programmer is responsible for leading and/or supporting the most complex database upgrade projects, modifications, installations, testing, implementation, maintenance, and enhancements of new or existing system software products. The role plans, installs, configures, tests, implements, and manages core database products and software supporting the County’s database architecture and business needs. Core responsibilities include DB2, IMS, ADABAS, and other legacy systems management.
Skills Required The Mainframe Programmer/DBA manages databases such as hierarchical (IMS), relational (DB2), and file-based (ADABAS). Responsibilities include planning and upgrading databases, verifying database health, providing technical consulting, maintaining production systems, performance reviewing, evaluating new or fine-tuned DBMS software, consulting on database design, developing logical and physical designs, creating backups and recovery procedures, monitoring performance and space, reorganizing, replicating, compressing, and partitioning databases. Required technology skills: IBM Z/OS, IMS, DB2, ADABAS, SMP/E, JCL, IMS DB/DC, CICS, ACF2, Assembly/Cobol/Rexx, IBM File Manager, Delta/IMS, Natural/SuperNAT, Entirex, CA Spool, IMS & DB2 BMC Tools, N20/Trim.
Skills Preferred
Install, configure and support Oracle Enterprise Edition Database 19c as a backend for web applications and internal data warehousing on Linux.
Install and configure MySQL and PostgreSQL databases.
Install and support Microsoft SQL Server instances.
Configure and support Oracle gateways connecting SQL Server, MySQL, and PostgreSQL to Oracle.
Oracle Spatial implementation and support.
Build custom ETL utilities with Crons, SQLLoader and PL/SQL.
Provide DB administration services such as patch installation, cloning, backup and recovery, and script development (Unix shell scripting and PL/SQL).
Troubleshoot and resolve ETL jobs.
Experience Required Minimum seven (7) years of experience as a Systems Programmer/DBA, with at least three (3) years in a lead role.
Experience Preferred Minimum four (4) years of DB administration experience in Oracle/MySQL/PostgreSQL environments.
Education Required Bachelor’s degree in an IT-related or engineering field.
Notes Nexlogica reserves the right to contact only selected candidates.
#J-18808-Ljbffr
Employment type: Full-time
Senior level: Mid-Senior level
Job function: Information Technology
Position Description A Mainframe Programmer is responsible for leading and/or supporting the most complex database upgrade projects, modifications, installations, testing, implementation, maintenance, and enhancements of new or existing system software products. The role plans, installs, configures, tests, implements, and manages core database products and software supporting the County’s database architecture and business needs. Core responsibilities include DB2, IMS, ADABAS, and other legacy systems management.
Skills Required The Mainframe Programmer/DBA manages databases such as hierarchical (IMS), relational (DB2), and file-based (ADABAS). Responsibilities include planning and upgrading databases, verifying database health, providing technical consulting, maintaining production systems, performance reviewing, evaluating new or fine-tuned DBMS software, consulting on database design, developing logical and physical designs, creating backups and recovery procedures, monitoring performance and space, reorganizing, replicating, compressing, and partitioning databases. Required technology skills: IBM Z/OS, IMS, DB2, ADABAS, SMP/E, JCL, IMS DB/DC, CICS, ACF2, Assembly/Cobol/Rexx, IBM File Manager, Delta/IMS, Natural/SuperNAT, Entirex, CA Spool, IMS & DB2 BMC Tools, N20/Trim.
Skills Preferred
Install, configure and support Oracle Enterprise Edition Database 19c as a backend for web applications and internal data warehousing on Linux.
Install and configure MySQL and PostgreSQL databases.
Install and support Microsoft SQL Server instances.
Configure and support Oracle gateways connecting SQL Server, MySQL, and PostgreSQL to Oracle.
Oracle Spatial implementation and support.
Build custom ETL utilities with Crons, SQLLoader and PL/SQL.
Provide DB administration services such as patch installation, cloning, backup and recovery, and script development (Unix shell scripting and PL/SQL).
Troubleshoot and resolve ETL jobs.
Experience Required Minimum seven (7) years of experience as a Systems Programmer/DBA, with at least three (3) years in a lead role.
Experience Preferred Minimum four (4) years of DB administration experience in Oracle/MySQL/PostgreSQL environments.
Education Required Bachelor’s degree in an IT-related or engineering field.
Notes Nexlogica reserves the right to contact only selected candidates.
#J-18808-Ljbffr