Mainframe DB2 Database Administrator

5 days ago

Los Angeles, CA, United States Noor Staffing Group Full time

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

Compensation:
$155,000 per year

  • Mainframe Developer

    3 days ago

    Los Angeles, CA, United States CData Software Full time

    6+ year of Mainframe Development Mainframe development and support, utilizing several of the following technologies: COBOL, JCL, CICS, DB2, VSAM, SQL, MQ, Xpeditor, Endevor or similar source control application.DB2, SQL, Oracle or similar databaseAgile delivery methodologiesExcellent verbal and written communication skills

  • Mainframe Developer

    4 days ago

    Los Angeles, CA, United States CData Software Full time

    6+ year of Mainframe Development Mainframe development and support, utilizing several of the following technologies: COBOL, JCL, CICS, DB2, VSAM, SQL, MQ, Xpeditor, Endevor or similar source control application.DB2, SQL, Oracle or similar databaseAgile delivery methodologiesExcellent verbal and written communication skills

  • Database Administrator

    2 weeks ago

    Los Angeles, CA, United States University of California Full time

    Description The Department of Anesthesiology and Perioperative Medicine is seeking a skilled Database Administrator / Lead SQL Developer to help drive the next stage of growth for our Perioperative Data Warehouse (PDW) and expanded perioperative analytics programs, including research and predictive analytics initiatives. The PDW is a custom SQL data...

  • Database Administrator

    5 days ago

    Los Angeles, CA, United States University of California Full time

    Description The Department of Anesthesiology and Perioperative Medicine is seeking a skilled Database Administrator / Lead SQL Developer to help drive the next stage of growth for our Perioperative Data Warehouse (PDW) and expanded perioperative analytics programs, including research and predictive analytics initiatives. The PDW is a custom SQL data...

  • Database Administrator

    1 week ago

    Los Angeles, CA, United States UCLA Health Full time

    Description The Department of Anesthesiology and Perioperative Medicine is seeking a skilled Database Administrator / Lead SQL Developer to help drive the next stage of growth for our Perioperative Data Warehouse (PDW) and expanded perioperative analytics programs, including research and predictive analytics initiatives. The PDW is a custom SQL data...

  • Database Administrator Team Lead

    1 week ago

    Los Angeles, CA, United States Westlake Services Full time

    Database Administrator Team Lead - Oracle, PostgreSQL and MySQLAt Westlake Financial Services, we believe that our PEOPLE are our most important asset. We embody PASSION in everything we do, and we hope that you will too. At Westlake Financial Services, the team lead is a crucial role in managing a team of database administrators and providing leadership on...

  • Database Administrator Team Lead

    2 days ago

    Los Angeles, CA, United States Westlake Services Full time

    Database Administrator Team Lead - Oracle, PostgreSQL and MySQLAt Westlake Financial Services, we believe that our PEOPLE are our most important asset. We embody PASSION in everything we do, and we hope that you will too. At Westlake Financial Services, the team lead is a crucial role in managing a team of database administrators and providing leadership on...

  • Database Administrator

    5 days ago

    Los Angeles, CA, United States Yeah! Global Full time

    About the job Database Administrator (DBA) - Los Angeles Note: This position does not offer any Visa sponsorship. We are only looking for applicants who are either local to Los Angeles, CA, or ready to relocate to the employers location.Job Summary:We are seeking an experienced Database Administrator to manage, optimize, and oversee our database systems,...

  • Manager, Database Administration

    5 days ago

    Los Angeles, CA, United States Wedbush Securities Full time

    Job Description Wedbush Securities is one of the largest securities firms and investment banks in the nation. We provide innovative financial solutions through our Wealth Management, Capital Markets, Futures and Advanced Clearing & Prime Services divisions. Headquartered in Los Angeles, California with over 100 offices and more than 80 correspondent offices,...

  • Principal Database Administrator, Healthcare *Virtual*

    3 days ago

    Los Angeles, CA, United States Providence Health & Service Full time

    Description Providence Health Plan caregivers are not simply valued - they're invaluable. Join our team at Providence Health Plan Partners and thrive in our culture of patient-focused, whole-person care built on understanding, commitment, and mutual respect. Your voice matters here, because we know that to inspire and retain the best people, we must empower...