Database Administrator III

Pyramid-Consulting,-Inc.; Plano (TX); On-site; USD 83,000 - 92,000; Full time

Benefits offered by this job

Health insurance

401(k) plan

Paid sick leave

Job summary

Pyramid Consulting, Inc. has an immediate opening for a Database Administrator III located onsite in Plano, TX and Jersey City, NJ. This 6+ month contract offers long-term potential and requires strong DB2 for z/OS experience and on-call support.

The role focuses on performance tuning, log management, security (RACF/ACF2), and DR testing, with opportunities to collaborate across DB2 teams and application groups. Competitive pay and benefits apply.

Qualifications

• 5+ years of experience with DB2 for z/OS and replication products (Qrep, SQLrep, CDC).
• Experience in software installation, version upgrades, and disaster recovery testing.
• Participation in a 24x7 on-call rotation and off-hours support.
• Strong communication skills, both written and oral.
• Working knowledge of RACF, TCP/IP, and network certificates.
• Familiarity with CICS, IMS, MQ and related mainframe subsystems.

Responsibilities

• Develop log scraping strategies to limit CPU, memory, and staging space.
• Build client dashboards to monitor the DB2 environment.
• Collaborate with DB2 teams to establish log retention policies.
• Translate business requirements into physical data models with performance focus.
• Define and implement application-specific backup and recovery strategies.
• Provide performance tuning recommendations with development teams.
• Monitor exception reports to ensure a stable production environment.
• Participate in DBA on-call rotation including Sev1 support.
• Support audits and control assessments, ensuring timely deliverables.

Skills

Communication skills

Analytical & debugging

REXX programming

SQL

JIRA

TCP/IP networking

RACF security awareness

Tools

DB2 for z/OS

DB2 replication tools (Qrep, SQLrep, CDC)

BMC for DB2 Tools

z/OS Connect

ADABAS/Natural

Job description

Immediate need for a talented Database Administrator III. This is a 06+months contract opportunity with long-term potential and is located in Plano and Jersey City, TX(Onsite). Please review the job description below and contact me ASAP if you are interested.

Job ID:26-26853

Pay Range: $60/hr - $67/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.
• Build client dashboards to monitor the DB2 environment.
• Collaborate with DB2 teams to establish log retention policies.
• Translate business requirements into physical models, focusing on performance and data access methods.
• Consult with application teams on ACF2 and RACF managed database security.
• Define and implement application-specific backup and recovery strategies.
• Support product upgrades related to DB2 replication and conduct assessments of new features.
• Provide performance tuning recommendations in cooperation with application development teams.
• Monitor exception reports to ensure a stable production environment.
• Participate in DBA production on-call rotation, including 24X7 SEV1 support.
• Conduct information-sharing meetings with application teams as needed.
• Support audits and control assessments, ensuring deliverables are complete and on time.

Key Requirements and Technology Experience

• 5+ years of experience with Client DB2 for z/OS and Replication products (Qrep, SQLrep, CDC).
• Experience in software installation, version upgrades, and disaster recovery testing.
• Participation in a 24x7 on-call rotation and off-hours support.
• Strong communication skills, both written and oral.
• Good analytical and debugging skills.
• Experience with BMC for DB2 Tools, Client z/OS Connect, Software AG ADABAS, and Natural products.
• Programming experience with REXX.
• Working knowledge of SQL, JIRA, SMP/E, RACF, TCP/IP, and network certificates.
• Familiarity with other Mainframe subsystems (CICS, IMS, MQ).

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.