z/OS DB2 DBA

Arete Technologies, Inc.; Little Rock (AR); On-site; USD 80,000 - 100,000; Full time

Job summary

A leading IT consulting firm in Little Rock, Arkansas, is looking for a Z/OS DB2 DBA responsible for maintaining and tuning z/OS DB2 databases. This role requires ensuring 24/7 database availability and support, along with implementing best practices in database management. Qualified candidates should have a Bachelor's degree in Computer Science and at least 3 years of z/OS DB2 DBA experience. This position offers an opportunity to work in a dynamic environment with a focus on performance enhancement and database optimization.

Qualifications

• In-depth z/OS DB2 Database Administration (V9) experience (3+ years).
• Solid experience with VSAM files, JCL, and TSO.
• Database Administration experience with DB2 UDB on LUW and SQL Server is preferred.

Responsibilities

• Database administration, implementation, and maintenance tasks.
• Ensure the 24/7 availability and performance of the databases.
• Optimize hardware/system resources allocated to the databases.

Skills

z/OS DB2 Database Administration

VSAM files

JCL

TSO

DBA certifications

SQL Server

DB2 UDB on LUW

CA tools

REX

Education

Bachelor’s Degree in Computer Science or related technical field

Job description

Arete Technologies, Inc. offers set of innovative Consulting and Outsourcing services, bridging the gap between requirements and outputs of various dexterous and facile companies worldwide. The thrust of providing global deliverables with focus on providing paramount and unsurpassed services combined with cost saving solutions to the clients.

We understand the business requirements in the present day corporate scenario and aspire to provide world-class services enabling the organization to burgeon and flourish while keeping the work-life balance intact. The Global delivery mechanism followed at Arete Technologies, Inc. saddles proficient schemes and unconventional channels to provide one-stop solutions for all your workforce needs.

our Team is an exquisite amalgamation of vast experiences of over 30 years in IT Consulting and Staffing industry. Connoisseurs in the field of staff augmentation for IT, we operate on 24 by 7 model with an aim of providing affordable and adept professionals with an assurance of satisfaction for both Consultants and Clients.

We are pre-eminent service providers in the field of staff augmentation, IT Consultancy, Software development, Web Development providing unexcelled services and focusing on both the employers and employees.

Job Description

Description: The Z/OS DB2 DBA will be primarily responsible for the maintenance, enhancement and performance tuning of z/OS DB2 databases as well as VSAM files, JCL, and TSO. The DBA will also work as part of a team to provide DB2 DBMS subsystem management.

In addition, this person will be required to provide after hours support, 24 x 7 on a rotating basis.

While z/OS support will be the primary responsibility of the Database Administrator, providing maintenance, enhancement and operational support to additional DBMSs like DB2 UDB and SQL Server will be required.

Qualifications

• Bachelor’s Degree in Computer Science or related technical field
• In-depth z/OS DB2 Database Administration (V9) experience (3+ years).
• Solid experience with VSAM files, JCL, and TSO.
• DBA certifications a plus.
• Database Administration experience with DB2 UDB on LUW, SQL Server , CA tools and REX will be a plus.

Responsibilities

• Database administration, implementation, and maintenance tasks including but not limited to:
  • Enforcing database naming/creation/deletion standards in the Test and Production environments
  • Establish, oversee, and optimize all database maintenance (i.e. update statistics, etc) and backup processes
  • Enforce and implement appropriate security measures
• Ensure the 24/7 availability and performance of the databases that support our systems, including "on-call" responsibilities
• Optimize the hardware/system resources allocated to the databases for high availability & minimum downtime
• Provide assistance to developers in DBMS performance tuning, best practices and problem resolution.
• Resolve database performance issues, database capacity issues, and other data issues
• Manage backup and recovery of databases
• Prepare, maintain and execute disaster recovery plans