Mainframe Systems Programmer / DBA

Hybrid in Los Angeles, CA, US • Posted 5 hours ago • Updated 5 hours ago
Contract W2
Contract Corp To Corp
12 Months
Hybrid
$90 - $95/hr
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

Summary

HonorVet Technologies is a Service Disable Veteran-Owned IT staffing firm, ISO 9001 and ISO 27001 certified, working with federal agencies, state governments, and Fortune 500 enterprise clients across the US. What makes us different isn''t a tagline; it''s the way we work. We don''t forward resumes and hope for the best. We take the time to understand where a professional like you are headed and only reach out when we genuinely believe there''s a fit worth exploring.

Job Title: Mainframe Systems Programmer / DBA
Location: Los Angeles, CA 90020 (Onsite)
Duration: 12 months

Job Description:

Client is looking for a Mainframe Systems Programmer/DBA who will be 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 client’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:
  • Manage different types of databases, such as hierarchical (IMS), relational (DB2), and file-based (ADABAS)
  • Planning and upgrading the database environment on a client-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 purpose 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
  • Development and use of backup and recovery procedures for databases
  • Database capacity planning, 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.
 
Additional Skills Required:
  • Skills in assessing, planning and migrating DBs to Cloud Environment
  • Skills in transferring, validating and maintaining DBs in a Cloud environment
  • Skills in Installing, Configuring and Supporting Oracle Enterprise Edition Database 19c and 21c as a backend for both public facing web applications and internal data warehousing on Linux operating system.
  • Skills in Installing and configuring MySQL and PostgreSQL databases.
  • Skills in Installing and Supporting Microsoft SQL server instances.
  • knowledge in Configuring and supporting Oracle Application Express (APEX), Oracle gateways connecting SQL Server, MySQL and PostgreSQL server instances to the Oracle database.
  • knowledge in Oracle Spatial implementation and support.
  • Mastery in building custom extracts, transform and load (ETL) utilities with cron jobs and crontab, SQLLoader and PL/SQL.
  • Skills in Database Administration services such as patch install, cloning, backup and recovery of databases and script development (Windows Batch Script, Unix shell scripting and PL/SQL).
  • Skills in Troubleshooting and resolution of ETL Jobs.
 
Experience Required:
  • Minimum of 07 years of experience as a Systems Programming/ DBA, with at least three 03 years of that experience in a lead role.
 
Additional Experience Required:
  • 4+ years of DB Administration experience, specifically in an Oracle/MySQL/PostgreSQL/MS SQL Server environment.
  • 3+ years of experience in transferring, validating, and maintaining DBs in cloud environment.
 
Education Required:
  • Bachelor’s degree in IT-related or engineering field.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 90941473
  • Position Id: 26-21751
  • Posted 5 hours ago
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Hybrid in Downey, California

Today

Easy Apply

Contract, Third Party

$50 - $52

Seal Beach, California

Today

Contract

USD 60.00 - 73.00 per hour

Downey, California

Today

Easy Apply

Full-time, Part-time, Contract, Third Party

USD 53-56

Downey, California

9d ago

Easy Apply

Contract

Depends on Experience

Search all similar jobs