DB2 Database Administration

Ekloud Data Labs

United States

Remote

USD 120,000 - 180,000

Full time

2 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Ekloud Data Labs is seeking an experienced IBM Z DB2 DBA to manage and administer mainframe database systems, focusing on performance, security, and reliability. You will define the base definitions, structure, and documentation to support long-term success in a global enterprise.

You will lead upgrades, patching, backups, capacity planning, and collaborate with internal/external clients to meet service requirements and optimization goals.

Qualifications

  • Minimum of 5 years of experience in IBM Z DB2 DBA Support.
  • Strong knowledge of DDL/DML/DCL/SQL & JCL.
  • Experience with database backups, index rebuilding, reorgs and statistics gathering.
  • Ability to work customer hours (8 am - 5 pm US EST).
  • Providing on-call support on rotation.

Responsibilities

  • Optimize databases and ensure peak performance.
  • Configure, install and maintain DB2 DBMS; implement upgrades/patches.
  • Manage security: user access and policies to protect data.
  • Plan capacity and growth projections for scalability.
  • Coordinate DB project plans with cross-functional teams.
  • Develop robust backup and recovery plans and procedures.

Skills

IBM Z DB2 DBA
SQL
JCL
DB2 Performance Tuning
Backup and Recovery

Tools

BMC MainView
File-AID

Job description

Main skills : DB2 SMF, Omegamon
Job Description Summary:

Manages and administers the physical and technical aspects of database systems, including base definition, structure, documentation, long-range requirements, operational guidelines and protection. Responsibilities include, but are not limited to, installation and maintenance of the database system, installation of upgrades and patches, performance and capacity monitoring/management, and security compliance. Proposes and implements enhancements that will improve the performance and reliability of the system. Potential interaction with clients (internal or external) in order to understand and meet requirements for the delivery of services related to database products.

Job Description:

Your role : Bring your specialist knowledge and experience to a company managing 50% of the worlds MIPS and open up the opportunity to shape the very foundation of the technology that drives our world. You’ll be in good company amongst our global community of experts leading the future of mainframe modernization. Experts who share knowledge openly and collaborate freely.

In this role, you’ll manage and administer the backbone of our technological infrastructure. You'll be the architect of the system, shaping the base definition, structure, and documentation to ensure the long-term success of our business operations.

What you will do Maintain and Protect:
  • Optimize systems: Your expertise will be crucial in configuring, installing and maintaining database management systems, ensuring that our systems are always running at peak performance.
  • Set security protocols: You'll be responsible for managing user access and implementing policies and procedures to protect our valuable data from unauthorized access and external threats.
Strategize to Scale:
  • Plan ahead: You will conduct capacity planning and growth projections based on usage, ensuring that our system is always scalable to meet our business needs.
  • Make progress: You'll be a strategic partner, working closely with various teams to coordinate systematic database project plans that align with our organizational goals.
  • Generate ideas: You'll have the opportunity to propose and implement enhancements that will improve the performance and reliability of the system, enabling us to deliver world-class services to our customers.
Recover and Resolve:
  • Be ready to recover: Develop strong backup and recovery plans to ensure that our system is always protected in the event of a failure.
  • Support solutions: Use your technical acumen to support end users and application developers in solving complex problems related to our database systems.
Job Qualifications
Required skills and experience:

Minimum of 5 years of experience in IBM Z DB2 DBA Support, directly supporting the client with DB2 Table/Object builds, Conversions, Reorgs, maintain such objects across all Pre-Test, Non-Prod & Production environments.

Strong Knowledge working with DDL/DML/DCL/SQL & JCL.

Experience with performing routine maintenance tasks, such as database backups, index rebuilding, reorgs and statistics gathering.

Ability to work customer hours (8 am - 5 pm US EST)

Providing on-call support on rotation.

Skills:
Required Skills:

Admin Tool; BMC MainView; Database Design Concepts; Database Performance; Database Performance Tuning; Disaster Recovery (DR); File-AID; IBM DB2 Database Administration; Job Control Language (JCL); Relational Database Management; Structured Query Language (SQL) Development

Optional Skills:

Database & SQL; Database Design; Database Planning & Design; Data Integrity; Data Management; Data Modeling; Data Structures; Relational Database Management System (RDBMS); Structured Query Language (SQL)

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Mainframe DBA
Senior Mainframe DBA

System One, Inc. • Salt Lake City (UT)

On-site
USD 96,000 - 152,000
Mainframe Administrator
Mainframe Administrator

IPolarity LLC • Whippany (NJ)

Hybrid
USD 110,000 - 155,000
Mainframe DB2 Database Administrator
Mainframe DB2 Database Administrator

Veriipro • Midvale (UT)

On-site
USD 110,000 - 150,000
SQL Database Administrator
SQL Database Administrator

iSpace, Inc. • Marysville (OH)

On-site
USD 120,000 - 150,000
Senior Mainframe Developer
Senior Mainframe Developer

Ethereum Technologies LLC • Salt Lake City (UT)

On-site
USD 110,000 - 140,000
Senior Mainframe Developer
Senior Mainframe Developer

Valiant Technologies LLC • Salt Lake City (UT)

On-site
USD 110,000 - 170,000
Senior DB2 / z/OS Systems Programmer
Senior DB2 / z/OS Systems Programmer

Lancesoft • United States

On-site
USD 140,000 - 190,000
Mainframe DB2 Database Administrator - Hybrid
Mainframe DB2 Database Administrator - Hybrid

Global Payments • Atlanta (GA)

On-site
USD 110,000 - 150,000
Senior Mainframe Developer
Senior Mainframe Developer

Quantum Technologies LLC • Salt Lake City (UT)

On-site
USD 110,000 - 140,000
DB2 DBA
DB2 DBA

GuruSchools • Tallahassee (FL)

On-site
USD 124,000 - 179,000