DB2 DBA

Modis

Plano (TX)

Hybrid

USD 91,000 - 94,000

Full time

8 hours ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Medical insurance
Dental insurance
Vision insurance
401K plan
Paid time off

Job summary

Akkodis seeks an experienced DB2 DBA (z/OS) for a contract role in Plano, TX or Jersey City, NJ. Hybrid work requires three on-site days weekly. The ideal candidate has deep DB2 experience in financial services and a strong tuning background.

The role involves log analytics, Splunk dashboards, security management with ACF2/RACF, and backup/recovery planning. On-call duties and SOX/compliance support are included.

Qualifications

  • In-depth DB2 on z/OS knowledge with strong performance tuning.
  • 7–9 years of DB2 DBA experience at a large financial institution.
  • Experience with DB2 Utilities (IBM & BMC).
  • Familiar with BMC tools: Change Manager, Catalog Manager, MainView, SQL tools.
  • Understanding of DB2 recovery options and security (ACF2/RACF).
  • Knowledge of Endevor and ITSM (Remedy).
  • Proficiency with DB2 z/OS, JCL, COBOL, SQL, IBM/BMC Utilities.
  • Knowledge of SMF data, Splunk, and Python.

Responsibilities

  • Develop log scraping strategies to optimize resource use.
  • Build Splunk dashboards to monitor DB2 environments.
  • Coordinate log retention policies across teams.
  • Translate requirements into a physical data model with performance focus.
  • Ensure DB2 access security via ACF2/RACF for applications.
  • Define backup/recovery strategies for production DB2.
  • Support DB2 replication upgrades and feature adoption.
  • Provide performance tuning for database calls with dev teams.
  • Monitor exception reports for production stability.
  • Participate in 24x7 on-call rotation for Sev-1 support.
  • Share information with application teams as required.
  • Support SOX/compliance audits and related deliverables.

Skills

Mainframe DB2
Performance tuning
z/OS
DB2 recovery options
ACF2 RACF security
Endevor
ITSM Remedy
Splunk
Python
JCL
COBOL
SQL

Tools

IBM Utilities
BMC Utilities
Change Manager
Catalog Manager
MainView
SQL Performance tools
Remedy
Endevor
Splunk

Job description

Akkodis is seeking DB2 DBA for a Contract job with a client in Plano TX or Jersey City, NJ - Hybrid (3 days on site in a Week). Ideally looking for applicants with a solid background in the financial services industry.

Pay: $66-68/hour – All Inclusive;

The rate may be negotiable based on experience, education, geographic location, and other factors.

Key Responsibilities:
  • Develop log scraping strategies to limit CPU, memory usage, and staging space while log scraping.
  • Build Splunk dashboards to monitor the DB2 environment.
  • Work with other DB2 teams in setting up log retention policies to cover extended periods of outages.
  • Translate business requirements into a physical model for implementation with a focus on processing requirements, performance, availability, recoverability, and data access methods.
  • Consult with application teams on both ACF2 and RACF managed database security to ensure appropriate access is provisioned for data access.
  • Define and implement application-specific backup and recovery strategies for the production environment.
  • Support product upgrades related to DB2 replication by coordinating with development teams, completing DBA remediation activities, executing verification processes, assessing new features/functions, and recommending adoption strategies.
  • Provide performance tuning support and recommendations for database calls in collaboration with application development teams.
  • Monitor and address exception reports to ensure a stable production environment.
  • Participate in DBA production on-call rotation, including 24x7 SEV1 test support.
  • Conduct information-sharing meetings with application teams as required.
  • Support Self-Identified Audits, Control Assessments, Database Audits, and SOX reviews, ensuring all deliverables are accurate and completed within established timelines.
Required Skills & Experience
  • In-depth Mainframe DB2 DBA (DB2 on z/OS) knowledge with a strong focus on performance tuning.
  • Minimum 7-9 years of DB2 DBA experience on z/OS at a single large financial institution.
  • Strong job stability background.
  • Experience with DB2 Utilities, including IBM and BMC utilities.
  • Working knowledge of BMC tools including Change Manager, Catalog Manager, MainView, and SQL Performance tools.
  • Solid understanding of DB2 recovery options.
  • Broad understanding of ACF2 and RACF-managed security for DB2 access.
  • Working knowledge of Endevor.
  • Working knowledge of ITSM processes and tools, including BMC Remedy.
  • In-depth understanding of DB2 z/OS, JCL, COBOL, SQL, IBM Utilities, and BMC Utilities.
  • Understanding of SMF data and reporting.
  • Knowledge of Splunk and Python.
Equal Opportunity Employer/Veterans/Disabled

Benefit offerings available for our associates include medical, dental, vision, life insurance, short-term disability, additional voluntary benefits, an EAP program, commuter benefits, and a 401K plan. Our benefit offerings provide employees the flexibility to choose the type of coverage that meets their individual needs. In addition, our associates may be eligible for paid leave including Paid Sick Leave or any other paid leave required by Federal, State, or local law, as well as Holiday pay where applicable. Disclaimer: These benefit offerings do not apply to client-recruited jobs and jobs that are direct hires to a client.

To read our Candidate Privacy Information Statement, which explains how we will use your information, please visit https://www.modis.com/privacy-policy

The Company will consider qualified applicants with arrest and conviction records in accordance with federal, state, and local laws and/or security clearance requirements, including, as applicable:

The California Fair Chance Act

Los Angeles City Fair Chance Ordinance

Los Angeles County Fair Chance Ordinance for Employers

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

DB2 Database Administrator
DB2 Database Administrator

Modis • Plano (TX)

Hybrid
USD 83,000 - 90,000
Db2 for z/OS Database Administrator
Db2 for z/OS Database Administrator

Matlen Silver • Plano (TX)

On-site
USD 69,000 - 73,000
Database Administrator
Database Administrator

Randstad USA • Plano (TX)

On-site
USD 59,000 - 72,000
Mainframe DB2 DBA
Mainframe DB2 DBA

Alliance of Professionals & Consultants, Inc. • Chandler (AZ)

Hybrid
USD 72,000 - 79,000
Senior DB2 DBA (z/OS) - Performance & Security, Hybrid
Senior DB2 DBA (z/OS) - Performance & Security, Hybrid

Modis • Plano (TX)

Hybrid
USD 91,000 - 94,000
Medical insurance
Dental insurance
Vision insurance
+2
DB2 DBA/Admin
DB2 DBA/Admin

Saxon Global • Milwaukee (WI)

On-site
USD 80,000 - 100,000
Senior DB2 Database Administrator (z/OS) - Jersey City, NJ
Senior DB2 Database Administrator (z/OS) - Jersey City, NJ

OM Housing • Jersey City (NJ)

On-site
USD 120,000 - 180,000
Excellent benefits package
Bonus opportunities
DB2 Admin
DB2 Admin

Robotic Process Automation LLC • Woodland (CA)

Remote
USD 105,000 - 121,000
Db2 Mainframe DBA
Db2 Mainframe DBA

Compunnel Inc. • Dallas (TX)

Hybrid
USD 89,301 - 121,194
DB2 Z/OS SYSTEMS PROGRAMMER
DB2 Z/OS SYSTEMS PROGRAMMER

Pyramid Consulting, Inc • Chandler (AZ)

Hybrid
USD 89,544 - 93,676
Health insurance
401(k) plan
Paid sick leave