Logo
Pyramid Consulting, Inc

DB2 DBA on z/OS

Pyramid Consulting, Inc, Plano, Texas, us, 75086

Save Job

3 days ago Be among the first 25 applicants

Overview Immediate need for a talented

DB2 DBA on z/OS . This is a

14 months contract

opportunity with long-term potential and is located in

Plano, TX (Hybrid) . Please review the job description below and contact me ASAP if you are interested.

Job ID: 25-85196

Pay Range: $65 - $68/hour. Employee benefits include, but are not limited to, health insurance (medical, dental, vision), 401(k) plan, and paid sick leave (depending on work location).

Key Responsibilities

develop log scraping strategies to limit cpu, memory usage and staging space while log scraping.

Build Client dashboards to monitor the Db2 environment

Work with other DB2 teams in setting up log retention policies to cover for extended period of outages

Translation of business requirements into a physical model for implementation with a focus on a clear understanding of processing requirements (peak times, # trans etc), performance, availability, recoverability, and data access methods

Consulting with the application teams on both ACF2 and RACF managed database security to ensure appropriate access is provisioned for data access

Defining and implementing application specific backup and recovery strategies for the production environment.

Support of product upgrades related to DB2 replication providing a focal communication point for development teams as well as completing owned DBA remediation activities, executing internal verification processes, conducting assessments of new feature/function and providing recommendations for use.

Performance tuning support and recommendations for database calls, in cooperation with the application development team.

Monitoring and addressing items on exception reports to ensure a stable production environment

Support DBA production on call rotation including 24X7 SEV1 test support.

Conduct information sharing meetings with the application teams when requested.

Support of Self Identified Audits, Control assessments, Database Audits and SOX reviews, ensuring deliverables are complete and correct, and all milestone deliverables dates are met.

Key Requirements and Technology Experience

Position requires in-depth Mainframe DB2 DBA (DB2 on z/OS) knowledge with a focus on performance tuning.

Individual should have minimum of 7-9 years of DB2 DBA experience on z/OS at a single large financial institution.

Job stability is a key requirement.

experience with DB2 Utilities including Client and BMC

Working knowledge of BMC tools including change manager, catalog manager, Mainview, and SQL performance.

Solid understanding of DB2 recovery options

Broad understanding of ACF2 and RACF2 managed security for DB2 Access.

Working knowledge of Endevor

Working knowledge of ITSM Processes and tools including BMC Remedy

In depth understanding of Db2 zOS, JCL, COBOL, SQL Client Utilities and BMC Utilities.

Understanding of SMF data and reporting.

Our client is a leading

Banking Industry

and we are currently interviewing to fill this and other similar contract positions. If you are interested in this position, please apply online for immediate consideration.

Pyramid Consulting, Inc. provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

By applying to our jobs you agree to receive calls, AI-generated calls, text messages, or emails from Pyramid Consulting, Inc. and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy here.

Seniority level

Not Applicable

Employment type

Contract

Job function

Information Technology

Industries

Banking

Referrals increase your chances of interviewing at Pyramid Consulting, Inc by 2x

Get notified about new Database Administrator jobs in

Plano, TX .

Dallas, TX $135,000.00-$160,000.00 1 month ago

Database Administrator - Leading Hedge Fund - Dallas

Dallas, TX $89,301.33-$121,194.66 1 month ago

Dallas, TX $114,816.00-$165,845.33 1 month ago

Dallas, TX $130,000.00-$170,000.00 2 days ago

Dallas, TX $89,301.33-$114,816.00 1 month ago

Irving, TX $125,000.00-$140,000.00 3 days ago

Senior Discovery Database Administrator (DBA) (Top Secret Clearance Required)

Dallas, TX $182,700.00-$263,900.00 2 months ago

Richardson, TX $88,000.00-$144,000.00 2 weeks ago

Dallas, TX $130,000.00-$170,000.00 2 weeks ago

Discovery Database Administrator (DBA) (Top Secret Clearance Required)

Dallas, TX $142,100.00-$192,850.00 2 months ago

Richardson, TX $72,000.00-$119,000.00 2 weeks ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

#J-18808-Ljbffr