Ci CDP Architect

Position: Database Administrator

Location: Remote

Duration: 12+ Months

Rate: DOE

Job Description

The IBM DB2 Database Administrator is responsible for the installation, configuration, maintenance, optimization, and support of IBM DB2 databases across enterprise environments. This role ensures high availability, performance, security, and reliability of DB2 databases to support mission-critical applications. The DB2 DBA partners closely with application teams, infrastructure teams, and business stakeholders to deliver stable and scalable database solutions.

---

Key Responsibilities

1. Database Installation & Configuration

·          Install, configure, and upgrade IBM DB2 LUW or DB2 z/OS environments.

·          Create and manage DB2 instances, databases, buffer pools, and tablespaces.

·          Apply fix packs, patches, and firmware updates.

·          Configure high-availability environments (HADR, TSA, Pacemaker, Q-replication).

2. Database Administration & Maintenance

·          Perform routine maintenance tasks such as REORG, RUNSTATS, and backup management.

·          Monitor storage usage, tablespace health, and database growth.

·          Ensure proper log management and archival strategies.

·          Automate operational tasks using scripts and tools.

3. Performance Monitoring & Tuning

·          Monitor database performance, identify bottlenecks, and resolve slow-running queries.

·          Optimize SQL statements and access paths.

·          Tune database parameters, buffer pools, memory, and I/O configurations.

·          Perform workload analysis and recommend improvements.

4. Troubleshooting & Incident Management

·          Diagnose and resolve DB2 errors, lock issues, performance problems, and failures.

·          Review db2diag logs, snapshots, and system performance metrics.

·          Work with IBM Support to resolve critical incidents (PMRs).

---

Required Qualifications

·          Bachelor's degree in Computer Science, Information Systems, or related field.

·          5+ years of hands-on DB2 database administration (LUW or z/OS).

·          Strong knowledge of SQL, DB2 architecture, and database internals.

·          Experience with HADR, Q-replication, TSA, or clustering technologies.

·          Proficiency in performance tuning, capacity planning, and monitoring tools.

·          Strong analytical and troubleshooting skills.

Preferred Qualifications

·          Experience with cloud environments (AWS).

·          Experience with automation using shell scripts, Python, or Ansible.

·          Familiarity with CI/CD processes and DevOps concepts.

·          Knowledge of other databases (Oracle,).

·          IBM DB2 Certification (e.g., IBM Certified Database Administrator).