Z/OS DB2 DBA

360 IT Professionals; Little Rock (AR); On-site; USD 80,000 - 110,000; Full time

Job summary

A software development company based in the United States seeks a Z/OS DB2 Database Administrator. Ideal candidates will have over 3 years of experience in z/OS DB2 Database Administration, alongside knowledge in VSAM files, JCL, and TSO. Responsibilities include enforcing database standards, ensuring system availability, and assisting developers in performance tuning. A Bachelor's degree in Computer Science or a related field is required. This role supports vital databases with 24/7 on-call responsibilities.

Qualifications

• 3+ years of in-depth z/OS DB2 Database Administration experience.
• Solid experience with VSAM files, JCL, and TSO.
• Experience with DB2 UDB on LUW and SQL Server is a plus.

Responsibilities

• Enforce database naming/creation/deletion standards in environments.
• Optimize all database maintenance and backup processes.
• Ensure 24/7 availability and performance of databases.
• Assist developers in DBMS performance tuning and problem resolution.
• Manage backup and recovery of databases.

Skills

z/OS DB2 Database Administration

VSAM files

JCL

TSO

DBA certifications

DB2 UDB

SQL Server

CA tools

REX

Education

Bachelor’s Degree in Computer Science or related technical field

Job description

360 IT Professionals is a Software Development Company based in Fremont, California that offers complete technology services in Mobile development, Web development, Cloud computing and IT staffing. Merging Information Technology skills in all its services and operations, the company caters to its globally positioned clients by providing dynamic feasible IT solutions. 360 IT Professionals work along with its clients to deliver high-performance results, based exclusively on the one of a kind requirement.

Our services are vast and we produce software and web products. We specialize in Mobile development, i.e. iPhone and Android apps. We use Objective-C and Swift programming languages to create native applications for iPhone, whereas we use Android Code to develop native applications for Android devices. To create applications that work on cross-platforms, we use a number of frameworks such as Titanium, PhoneGap and Jquery mobile.

Furthermore, we build web products and offer services such as web designing, layouts, responsive designing, graphic designing, web application development using frameworks based on model view controller architecture and content management system. Our services also extend to the domain of Cloud Computing, where we provide Salesforce CRM to effectively manage one’s business and ease out all the operations by giving an easy platform. Apart from this, we also provide IT Staffing services that can help your organization to a great extent as you can hire highly skilled personnel’s through us.

We make sure that we deliver performance-driven products that are optimally developed as per your organization’s needs. Take a shot at us for your IT requirements and experience a radical change.

Job 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

• 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
• Monitor databases for errors and perform problem determination when necessary