DB2 Database Administrator

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 :
5 days ago