Nexlogica · 2 months ago
Mainframe Systems Programmer/DBA
California, United States
Full-time
Onsite
Senior Level
7+ years expNexlogica is seeking a Mainframe Systems Programmer/DBA to lead and support complex database upgrade projects and manage core database products. The role involves planning, installation, configuration, testing, and maintenance of database systems to meet business needs.
Cloud ComputingConsultingSoftwareWeb Design
Responsibilities
Leading and/or supporting the most complex database upgrade projects
Modification, installation, testing, implementation, maintenance and enhancements of new or existing system software products
Planning, installing, configuring, testing, implementing and managing core database products
Managing different types of databases, such as hierarchical (IMS), relational (DB2), and file-based (ADABAS)
Verifying the health of all the databases
Providing database administration technical consulting for application and operations teams for project planning/development
Maintenance on production database systems
Performing technical reviews for existing systems that utilize DBMS
Performing evaluations for selecting new or fine-tuning existing DBMS software
Consulting 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
Qualification
Required
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
Possession of a bachelor's degree in an IT-related or Engineering field
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; 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
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/19c, Oracle 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 Pump
Three (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 Plus, Oracle Data Integrator Studio, Oracle JDeveloper (JDEV), Oracle Database Performance Testing and Tuning (e.g., AWR, ADDM), Oracle Application Testing Suite (OATS) Test Manager
Two (2) years of experience working with two or more of the CI/CD Release Management, build, deployment, and source control tools: Jenkins, Apache Maven, Ant, Git, SonarQube
One (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
Company
Nexlogica
Nexlogica is a business navigator that offers digital enterprise transformation and management consulting services.
51-200 employees
Funding
Current Stage
Growth StageCompany data provided by crunchbase