Senior DB2 DBA - Linux, Performance & HA Expert

Trigyn Technologies Limited; City of Albany (NY); On-site; USD 110,000 - 140,000; Full time

Job summary

Trigyn Technologies, Inc. seeks a Db2 Database Administrator in Albany, NY to manage Db2 databases on Red Hat Linux. You will monitor performance, deploy monitoring utilities, and automate tasks with Bash/Python/Perl.

Responsibilities include backups, tuning, HADR, security, and daily incident resolution. Collaboration with cross-functional teams is essential. The role requires extensive Linux, Db2, and cloud experience, plus strong problem-solving and documentation skills.

Qualifications

• 72+ months of DB2 database administration on Linux environments (installation, configuration, performance tuning, backup/recovery, security).
• 84+ months Red Hat Linux proficiency (CLI, scripting, troubleshooting).
• 84+ months of database performance tuning and optimization experience.
• 84+ months of HADR for Db2 (setup, configuration, management).
• 60+ months of GCP experience for database deployments (Compute Engine, networking, storage, IAM).
• 60+ months of scripting/automation for admin tasks (Bash, Python, Perl).
• 60+ months of troubleshooting across Db2 and RHEL environments.
• 84+ months of backup and recovery strategy experience.
• 84+ months of monitoring/alerting (Dynatrace, DMC, or GCP monitoring).
• 84+ months of security best practices for Db2 and RHEL.

Responsibilities

• Administer Db2 databases on bare-metal Red Hat Enterprise Linux (RHEL).
• Monitor performance metrics: CPU, memory, disk I/O, buffer pool hit ratios.
• Deploy, maintain, and monitor Db2 monitoring utilities (IBM DMC).
• Develop scripts/tools to automate monitoring, maintenance, and admin tasks.
• Review alerts, dashboards, and Db2 logs to troubleshoot incidents.
• Perform RUNSTATS, REORGCHK, and REORG regularly.
• Apply patches and upgrades per change management procedures.
• Monitor and validate backups and recovery processes.

Skills

DB2 administration

Red Hat Linux

Scripting

Monitoring & alerting

Backup & recovery

Education

Advanced education

Tools

GCP

Dynatrace

Data Management Console

Bash

Python

Perl

Job description

Trigyn Technologies, Inc. seeks a Db2 Database Administrator in Albany, NY to manage Db2 databases on Red Hat Linux. You will monitor performance, deploy monitoring utilities, and automate tasks with Bash/Python/Perl.

Responsibilities include backups, tuning, HADR, security, and daily incident resolution. Collaboration with cross-functional teams is essential. The role requires extensive Linux, Db2, and cloud experience, plus strong problem-solving and documentation skills.