Job Description
Our client, a leading public-sector organization, is seeking a Mainframe Systems Programmer / Mainframe ADABAS Administrator (DBA).
Apply today for consideration!
Job Title: Mainframe Systems Programmer / Mainframe ADABAS Administrator (DBA)
Location: Los Angeles, CA - Hybrid
Duration: 12 Months
Job Description:
#LI-GS3
#RTA
#RTA-ZR
PrideGlobal and it's affiliates offers eligible employee’s comprehensive healthcare coverage (medical, dental, and vision plans), supplemental coverage (accident insurance, critical illness insurance and hospital indemnity), 401(k)-retirement savings, life & disability insurance, an employee assistance program, legal support, pet insurance and employee discounts with preferred vendors.
Equal Employment Opportunity
PrideGlobal and it's affiliates are an equal opportunity employer. We do not discriminate on the basis of the race, religious creed, color, national origin, ancestry, physical disability, mental disability, reproductive health decision making, medical condition, genetic information, marital status, sex, gender, gender identity, gender expression, age, sexual orientation, veteran or military status, or any other characteristic protected by applicable federal, state, or local law.
Fair Chance Employment
PrideGlobal and it's affiliates are a Fair Chance employer. We consider all qualified applicants, including those with criminal histories, in a manner consistent with applicable state and local Fair Chance laws and ordinances, including, the California Fair Chance Act and all applicable local Fair Chance ordinances.
Accommodations
We are committed to providing reasonable accommodations to applicants and employees with disabilities. If you require a reasonable accommodation to participate in the application or interview process, or to perform the essential functions of this role, please contact us.
Only applicable for San Francisco Candidates: Under the San Francisco Lactation in the Workplace Ordinance, we will provide written notice of lactation accommodation rights, and this notice will automatically be given upon hiring, any inquiry of parental leave or lactation accommodation.
Only applicable for Kentucky positions: For this type of employment, state law requires a criminal record check as a condition of employment. This applies to direct care staff (Examples: RN, LPN, Nurse Aides, Therapists) referred to Kentucky nursing facilities, assisted living communities, or long-term care facilities, in accordance with KRS 216.793.
Apply today for consideration!
Job Title: Mainframe Systems Programmer / Mainframe ADABAS Administrator (DBA)
Location: Los Angeles, CA - Hybrid
Duration: 12 Months
Job Description:
- Lead and/or support complex database upgrades, modifications, installations, testing, implementations, maintenance, and enhancements.
- Plan, install, configure, test, implement, and manage core database and system software products supporting the organization's database architecture and business needs.
- Support and administer legacy database environments including DB2, IMS, and ADABAS/NATURAL.
- Manage IMS hierarchical databases, DB2 relational databases, and ADABAS file-based databases.
- Plan and perform database environment upgrades while monitoring overall database health and performance.
- Provide technical DBA consulting to application and operations teams for project planning and development.
- Perform maintenance and technical reviews on production database systems using ADABAS, DB2, and IMS.
- Evaluate, fine-tune, and recommend DBMS software and database solutions.
- Consult with development teams on database architecture, logical database design, and physical database design.
- Perform database capacity planning, performance monitoring, and space monitoring.
- Develop and maintain database backup and recovery procedures.
- Perform database reorganizations, replication, compression, and partitioning.
- Work with IBM z/OS, IMS, DB2, ADABAS, SMP/E, JCL, IMS DB/DC, CICS, and ACF2.
- Utilize Assembler, COBOL, REXX, IBM File Manager, DELTA/IMS, NATURAL/SUPERNAT, ENTIREX, CA SPOOL, IMS/DB2 BMC Tools, and N20/TRIM.
- Assess, plan, and execute database migrations to cloud environments.
- Transfer, validate, and maintain databases in cloud environments.
- Install, configure, and support Oracle Enterprise Edition 19c and 21c on Linux.
- Support Oracle databases serving public-facing web applications and internal data warehouses.
- Install and configure MySQL and PostgreSQL databases and support Microsoft SQL Server instances.
- Configure and support Oracle Application Express (APEX) and Oracle gateways connecting SQL Server, MySQL, and PostgreSQL environments.
- Implement and support Oracle Spatial.
- Build custom ETL utilities using Cron/Crontab, SQL*Loader, and PL/SQL.
- Perform DBA activities including patching, database cloning, backup/recovery, and script development.
- Develop scripts using Windows Batch, Unix Shell, and PL/SQL.
- Troubleshoot and resolve ETL job issues.
- Minimum 7 years of experience as a Systems Programmer / DBA.
- Minimum 3 years of experience in a lead role.
- 4+ years of DBA experience with Oracle, MySQL, PostgreSQL, and Microsoft SQL Server.
- 3+ years of experience transferring, validating, and maintaining databases in cloud environments.
- Strong experience with ADABAS/NATURAL, DB2, IMS, and IBM z/OS mainframe environments.
- Bachelor's degree in Information Technology, Computer Science, Engineering, or a related field.
#LI-GS3
#RTA
#RTA-ZR
PrideGlobal and it's affiliates offers eligible employee’s comprehensive healthcare coverage (medical, dental, and vision plans), supplemental coverage (accident insurance, critical illness insurance and hospital indemnity), 401(k)-retirement savings, life & disability insurance, an employee assistance program, legal support, pet insurance and employee discounts with preferred vendors.
Equal Employment Opportunity
PrideGlobal and it's affiliates are an equal opportunity employer. We do not discriminate on the basis of the race, religious creed, color, national origin, ancestry, physical disability, mental disability, reproductive health decision making, medical condition, genetic information, marital status, sex, gender, gender identity, gender expression, age, sexual orientation, veteran or military status, or any other characteristic protected by applicable federal, state, or local law.
Fair Chance Employment
PrideGlobal and it's affiliates are a Fair Chance employer. We consider all qualified applicants, including those with criminal histories, in a manner consistent with applicable state and local Fair Chance laws and ordinances, including, the California Fair Chance Act and all applicable local Fair Chance ordinances.
Accommodations
We are committed to providing reasonable accommodations to applicants and employees with disabilities. If you require a reasonable accommodation to participate in the application or interview process, or to perform the essential functions of this role, please contact us.
Only applicable for San Francisco Candidates: Under the San Francisco Lactation in the Workplace Ordinance, we will provide written notice of lactation accommodation rights, and this notice will automatically be given upon hiring, any inquiry of parental leave or lactation accommodation.
Only applicable for Kentucky positions: For this type of employment, state law requires a criminal record check as a condition of employment. This applies to direct care staff (Examples: RN, LPN, Nurse Aides, Therapists) referred to Kentucky nursing facilities, assisted living communities, or long-term care facilities, in accordance with KRS 216.793.
Numbers & Facts
| Location | Los Angeles90020, CA |
| Industry | Financial Services |
| Salary | $80–$90 Per Hour |
| Company Size | 100 to 499 employees |
| Year Founded | 1983 |
| Website | http://prideglobal.com |
About Company
Pride Global is a minority-owned integrated human capital solutions firm headquartered in New York with operating companies throughout the United States, Canada, India and Brazil. Pride Global companies focus on a diverse array of services including vendor management, payroll programs, business process optimization, and staffing for both direct hire and contingent labor.
Skills
- Adabasunmatched
- Capacity and Performance Managementunmatched
- Cloningunmatched
- Cloud Computingunmatched
- Cobol Programming Languageunmatched
- Computer Scienceunmatched
- Consultingunmatched
- Cron Job Schedulingunmatched
- Data Recoveryunmatched
- Data Warehousing Applicationsunmatched
- Database Administrationunmatched
- Database Architectureunmatched
- Database Backupunmatched
- Database Designunmatched
- Database Extract Transform and Load (ETL)unmatched
- Database Management Software/Systems (DBMS)unmatched
- Database Programmingunmatched
- Database Recoveryunmatched
- Database Replicationunmatched
- Database Technologyunmatched
- Environmental Monitoringunmatched
- File Managementunmatched
- IBM CICS (Customer Information Control System)unmatched
- IBM DB2unmatched
- IBM IMS Databaseunmatched
- IBM Mainframe Operating Systemunmatched
- IBM Rexx Programming Languageunmatched
- IBM z-OS Operating Systemunmatched
- IMS DB/DCunmatched
- IP Multimedia System (IMS)unmatched
- Identify Issuesunmatched
- Information Technology & Information Systemsunmatched
- Internet Applicationunmatched
- JCL (Job Control Language)unmatched
- Linux Operating Systemunmatched
- Mainframe Computerunmatched
- Microsoft SQL Serverunmatched
- Microsoft Windows Operating Systemunmatched
- MySQLunmatched
- Oracleunmatched
- Oracle Applicationsunmatched
- Oracle DBA (Database Administrator)unmatched
- Oracle Databaseunmatched
- Oracle Express Serverunmatched
- Oracle PL-SQLunmatched
- Oracle SQL*Loaderunmatched
- Performance Analysisunmatched
- PostgreSQLunmatched
- Problem Solving Skillsunmatched
- Product Supportunmatched
- Production Systemsunmatched
- Project Planningunmatched
- Relational Databases (RDBMS)unmatched
- Scripting (Scripting Languages)unmatched
- Server Supportunmatched
- Software Administrationunmatched
- Software Patchesunmatched
- Symmetric MultiProcessing (SMP) Computingunmatched
- Systems/Internals Programmingunmatched
- Technical Consultingunmatched
- Unix Operating Systemsunmatched
- Unix Shell Programmingunmatched
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.
Free resume templatesFree resume builder
Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.
Free resume builder