DB2 Database Administrator

Manage My Dream, LLC
Cincinnati, OH, US
Temporary

Job Description

Job Description

Job Title : DB2 Database Administrator

Location : Cincinnati, OH or Dallas / Austin, TX or Philadelphia, PA

Position Type : W2

Duration : 6+ months Contract

Job Description :

DB2 DBA (Database Administrator) experience typically involves managing and maintaining IBM 's DB2 database, which is used for both transactional and analytical workloads.

Key Responsibilities :

  • Installing and setting up DB2 database software on different platforms (e.g., Windows, UNIX, Linux). Configuring the database environment, including storage, memory, and security settings.
  • Database Design and Architecture : Designing databases and schemas to meet business requirements. Creating and managing tablespaces, tables, indexes, views, and constraints.

Planning database architecture for performance, scalability, and redundancy.

  • Monitoring and optimizing the performance of the DB2 databases, including tuning queries and indexing strategies. Analyzing execution plans and making adjustments to ensure the best performance.
  • Establishing backup and recovery strategies, including automated and manual backups. M Performing database recovery in case of data corruption or failure using tools like DB2 HADR (High Availability Disaster Recovery).
  • Managing user roles, privileges, and security policies. Ensuring compliance with data security standards like encryption, access control, and auditing.
  • Regularly monitoring and maintaining database health using DB2 tools. Running reorganization utilities, updating statistics, and managing tablespace growth.
  • Applying patches, fixes, and version upgrades as needed to ensure the system remains up to date and secure.
  • Setting up and managing replication between DB2 databases. Implementing high availability and disaster recovery solutions, including clustering and HADR setups.
  • Writing scripts for database monitoring, backups, automation of routine tasks, and scheduling jobs using tools like cron or DB2 native tools.
  • Resolving database-related issues such as connectivity problems, slow query performance, or system crashes. Working with support teams to troubleshoot and resolve critical incidents.
  • SQL Proficiency : Strong knowledge of SQL for creating, querying, and managing databases.
  • Experience with tools like DB2 Control Center, db2look, db2pd, and db2diag.
  • Expertise in performance tuning, including indexing, query optimization, and memory allocation.
  • Familiarity with DB2 backup utilities and disaster recovery protocols.
  • Ability to automate tasks using Shell scripting (on Linux / UNIX) or PowerShell (on Windows).
  • Understanding of OS-level administration on platforms such as AIX, Linux, or Windows.
  • Experience with DB2 HADR, replication, or clustering solutions.
  • Hands-on experience with database encryption, role-based access control, and compliance standards.

Typical Tools and Technologies :

  • IBM Data Studio : For DB2 database administration and performance monitoring.
  • DB2 HADR : For high availability and disaster recovery.
  • DB2 Optim Performance Manager : For monitoring and tuning DB2 databases.
  • IBM Guardium : For database security and auditing.

If you are interested on the above job details, then please respond back with the following details at the earliest possible :

  • Full name :
  • Current Location :
  • Work Authorization :
  • Availability :
  • Rate expected :
  • Best contact number and time :
  • Vacation Plans :
  • 8 hours ago
Related jobs
Manage My Dream, LLC
Cincinnati, Ohio

DB2 DBA (Database Administrator) experience typically involves managing and maintaining IBM's DB2 database, which is used for both transactional and analytical workloads. Experience with tools like DB2 Control Center, db2look, db2pd, and db2diag. Job Title: DB2 Database Administrator. DB2 Optim Perf...

Promoted
DMI (Digital Management, Inc.)
Cincinnati, Ohio

Database Administrator or Database Engineer, with hands-on experience managing complex databases for SaaS products. In this role, you will collaborate with cross-functional teams, including developers, data engineers, and system administrators, to ensure that our databases support product features a...

Promoted
Technogen International Company
Cincinnati, Ohio

Understanding the benefits of data warehousing, data architecture, data quality processes, data warehousing design and implementation, table structure, fact and dimension tables, logical and physical database design. Experience working on cloud migration methodologies and processes including tools l...

Promoted
Deloitte
Cincinnati, Ohio

Responsible for the day-to-day operations of and support for applications and systems to include: Microsoft Exchange servers, Microsoft Outlook, DNS, Active Directory and other applications as deployed by the Unified Communications team. Work with vendors to support Deloitte's email and Active Direc...

Belcan
Cincinnati, Ohio

A Tier L1 IT Systems Administrator job is currently available at Belcan in Evendale, OH 45215. ...

Cincinnati Children's Hospital Medical Center
Cincinnati, Ohio

Duties: Cincinnati Children's Hospital Medical Center in Cincinnati, Ohio seeks Architect-Data Engineer to focus on how to design, integrate, and manage complex data and analytic systems over their life cycles; use a combination of core software engineering principles and domain specific data and an...

InsideHigherEd
Cincinnati, Ohio

Enrollment Management's Student Financial Aid Office is searching for a Data Reporting Analyst who will report to the Director of Financial Aid position in the Student Financial Aid Office. Perform data extraction and analysis and process data and reporting requests as required. The SFA office is se...

Adams, Inc.
OH, US

By completing this form, you are indicating to us that you are interested in exploring this opportunity in greater depth: Applications Database Administrator OH ID67296. ...

FSA Federal
Cincinnati, Ohio

We currently have a vacancy for a Data Analyst. Accurately enters required data into one or more databases, documents, or spreadsheets. Experience with the Microsoft Office suite of applications (Excel, PowerPoint, Word) and other common software applications, to include databases, intermediate skil...

Highmark Health
OH, Working at Home, Ohio

In partnership with other business, platform, technology, and analytic teams across the enterprise, design, build and maintain well-engineered data solutions in a variety of environments, including traditional data warehouses, Big Data solutions, and cloud-oriented platforms. Align with security, da...