Database Admin

Hi,

Hope you are doing well

My name is Deepak Yadav and I'm a Recruiter at Prisa Consulting Solutions LLC. Our records show that you are an experienced IT professional with Senior DB2 Database Administrator. This experience is relevant to one of my current openings.

Job Title: Senior DB2 Database Administrator

Location: Harrisburg, PA. Hybrid (02- 03 days onsite)

Position: Contract Position

(Hybrid Telework Monday, Tuesday & Friday; Onsite Wednesday & Thursday at The Keystone Building, 400 N St., Harrisburg, PA 17120)
Duration: Through 6/30/2026 (with potential extension through 6/30/2027)
Interview Process: Initial virtual (Microsoft Teams), followed by onsite in-person

• 
  We are seeking an experienced Senior DB2 Database Administrator (DBA) with 10+ years of DB2 experience to support high-availability enterprise systems in a complex z/OS environment. The ideal candidate will have extensive expertise in database design, performance tuning, high transaction environments, and 24x7 production support, along with strong collaboration and problem-solving skills.
  • Design, develop, and maintain DB2 database applications for high availability and maximum performance.
  • Provide production and test database support in a complex enterprise environment.
  • Perform SQL code reviews, database performance monitoring, and application-level tuning.
  • Implement and enforce DB2 security standards.
  • Collaborate with DB2 systems programming staff to manage DSNZPARM settings.
  • Create, manage, and support DB2 Stored Procedures, Triggers, and Referential Integrity.
  • Manage service requests, create change requests, and provide 24x7 on-call support.
  • Configure and support DB2 Connect access for users and distributed systems.
  • Partner with cross-functional teams on technical solutions and project schedules.
  • Develop and implement backup, recovery, and disaster recovery strategies.
  • Support data modeling (logical and physical) and participate in data warehouse design.
  Required Skills & Experience
  • 10+ years of experience with DB2 on z/OS in a production, high-transaction environment.
  • Expertise in:
    • DB2 12 for z/OS (or higher)
    • High availability (24x7) techniques and large data stores
    • DB2 utilities setup and execution (V10 or higher)
    • DB2 performance and tuning at the database and SQL level
    • Complex SQL coding and tuning
    • Data modeling (logical and physical design)
    • Data warehouse design and OLAP query solutions
  • Experience with DB2 attachments/interfaces: DRDA, DB2 Connect.
  • Hands-on expertise with DB2 Tools:
    • IBM Data Studio, DB2 Admin Tool, DB2 Automation Tool, DB2 Explain, DB2 Query Monitor
    • IBM OPTIM Workload Query Tuner, IBM File Manager, Tivoli OMEGAMON, QMF
  • Strong Mainframe (z/OS) skills: TSO/ISPF, JCL, DFSORT/ICETOOL, REXX, and z/OS utilities.
  Desired Skills
  • Strong problem-solving and analytical skills.
  • Ability to organize and prioritize multiple projects.
  • Excellent written and verbal communication.
  • DB2 V9/V10 Certification preferred.
  • Experience with:
    • IMS Databases and IMS Utilities (IBM, BMC, NEON, etc.)
    • ETL tools (InfoSphere, Informatica, etc.).
  Education & Certification
  • Bachelor s degree in Computer Science, Information Systems, or related field (or equivalent experience).
  • DB2 Certification highly preferred.
  
  Desired Minimum years of Exprience as per Skills

  Excellent knowledge of DB2 z/OS Database Support, including but not limited to the following-

  Required

  10

  Years

  High availability 24x7 designs and techniques

  Required

  10

  Years

  DB2 V10 utilities setup and execution

  Required

  10

  Years

  Data Modeling expertise logical and physical design

  Required

  10

  Years

  Data Warehouse design with an understanding of OLAP design and query solutions

  Required

  10

  Years

  DB2 tools skill set will include, but not limited to the following: QMF & IBM (Data Studio, OPTIM Workload Query Tuner, File Manager, Tivoli OMEGAMON)

  Required

  10

  Years

  z/OS Mainframe skills, but not limited to the following: TSO & ISPF, JCL, DFSORT &/or ICETOOL, REXX, z/OS Utilities

  Required

  10

  Years

  Ability to organize and prioritize workflow and projects

  Desired

  DB2 V9 or V10 Certification preferred

  Desired

  IMS Database Utilities (IBM, BMC, NEON, etc.)

  Desired

• ETL tools experience (InfoShere, Informatica, etc.)

• IMS Database experience

  Desired

• Excellent written and oral communication skills

  Desired

• Problem solving and analytical skills

  Desired

• DB2 tools skill set will include, but not limited to the following: IBM DB2 (Administration Tool, Automation Tool, Explain, Query Monitor)

  Required

  10

  Years

• DB2 attachments/interfaces include DRDA, DB2 Connect

  Required

  10

  Years

• Complex SQL coding / tuning

  Required

  10

  Years

• DB2 performance and tuning

  Required

  10

  Years

• Managing large data stores

  Required

  10

  Years

• z/OS DB2 12 for zOS or higher in a production environment with high transaction rates

  Required

  10

  Years

• 10+ years DB2 experience

  Required

  10

  Years

• Key Responsibilities
• Job Description