Noor Staffing Group

Mainframe DB2 Database Administrator

Noor Staffing Group  •  $140k - $155k/yr  •  Los Angeles, CA (Remote)  •  28 days ago
Apply
AI can make mistakes so check important info. Chat history is never stored.

Job Description

Position: DB2 Database Administrator

Salary: $140,000 - $155,000 DOE + great benefits

100% REMOTE

Direct Hire -not able to accommodate C2C or H1 VISA candidates at this time.

Well established IT firm is seeking an experienced Mainframe DB2 Administrator to support their largest enterprise client. You will work remote and will install, customize, upgrade, maintain, and tune up a massive DB2 database environment.

Responsibilities

  • Act as a Principal/Lead DBA for complex DB2 environments on both z/OS and Distributed (LUW -
  • Linux, Unix, Windows) platforms, providing senior-level guidance and mentorship.
  • DB2 database design, configuration, review, and administration.
  • Maintain and operate DB2 software, and tools.
  • Diagnose and resolve DB2 reason codes and SQL errors.
  • Design, implement, and manage DB2 Connect configurations to enable seamless communication between distributed applications and the mainframe DB2 subsystem.
  • Perform advanced, end-to-end performance tuning across application, database, and system levels, including detailed SQL query optimization and access path analysis (using tools like EXPLAIN).
  • Provide on-call break/fix database support and respond within the agreed SLA.
  • Support Disaster Recovery exercises.
  • Manage changes within standard control processes and mechanisms using ITIL/ITSM practices.
  • Produce clear technical documentation and conform to any audit requirements.

Qualifications

  • Must have 4 years of progressive experience as a mainframe DB2 DBA.
  • Extensive, demonstrable experience in the administration and architecture of DB2 for LUW (Linux, Unix, Windows) environments, complementing the z/OS experience..
  • Proven expertise in using DB2 performance monitoring and tuning tools (both IBM and third-
  • party) to manage buffer pools, I/O operations, locking mechanisms, and run time statistics.
  • Deep understanding of DB2 Data Sharing principles, setup, and maintenance for high availability and scalability.
  • Functional knowledge of DB2 internals, tools, and their usage.
  • Functional knowledge of database interfaces (connection/batch/CICS/DB2/MQ/distributed).
  • Functional knowledge of z/OS systems.
  • Operating system general knowledge for Windows/Unix/Linux.

#danieln

Noor Staffing Group

About Noor Staffing Group

Employing people across the United States in fields from healthcare to high-profile professional to light industrial, NSG encompasses all disciplines and regions to meet the challenging and sophisticated employment demands of our clients.

With a track record of staffing excellence, our recruiting team and support staff handle all projects with a commitment to quality service. We are a collaborative, innovative and customer-service oriented group of professionals. We continually build and establish relationships with top-tier organizations and industry-leading professionals nationwide.

NSG’s clients include elite professional services firms, Fortune 500 companies, local, federal and state agencies as well as small and mid-cap businesses. NSG is a minority owned supplier with 14 offices, 250 corporate staff and 4,000 contingent staff across 40 states. NSG is a part of the Noor Inc. family of companies and is committed to providing top-tier, unparalleled recruiting and staffing services.

The NSG team serves as career consultants to each of our candidates - they count on us to be their strategic career partner through every step of the process. We are fully invested in their success and our engagement goes beyond simply reviewing a resume. We recognize that a candidate's success depends on finding the right opportunity and we engage all of our resources to help them reach their potential.

Industry
HR & Recruiting
Company Size
501-1,000 employees
Headquarters
New York, NY
Year Founded
2005
Social Media