DB2 Database Administrator – GCP

Maagsoft Inc.; City of Albany (NY); On-site; USD 120,000 - 180,000; Full time

Job summary

Maagsoft Inc. seeks a seasoned DB2 Database Administrator for a State of NY project based in Albany, NY.

The role focuses on administering Db2 databases on Linux, implementing high availability and disaster recovery, optimizing performance, and ensuring security across the stack, including GCP integration. The ideal candidate brings extensive DB2 expertise, Red Hat Linux skills, and strong scripting abilities to maintain robust backup, monitoring, and optimization practices in a complex

Qualifications

• 72 months of experience DB2 DBA on Linux including install, config, performance tuning, backup/recovery, and security management.
• 84 months of experience Red Hat Linux proficiency across CLI, scripting, and troubleshooting.
• 84 months of experience as DB2 performance tuning and optimization, including index and workload management.
• 84 months of experience with HADR for Db2 to ensure business continuity and data resilience.
• 60 months of experience in Google Cloud Platform (GCP) services relevant to database deployments.
• 60 months of scripting (Bash/Python/Perl) for automating DBA tasks.
• 60 months of troubleshooting and problem-solving across Db2, RHEL, and GCP interactions.
• 84 months of experience with backup and recovery strategies for Db2 databases.
• 84 months of experience in monitoring and alerting for Db2 and RHEL systems.
• 84 months of experience implementing security best practices for Db2 and RHEL.

Skills

DB2 DBA

Red Hat Linux

Performance Tuning

HADR

GCP

Scripting

Troubleshooting

Backup & Recovery

Monitoring & Alerts

Security Best Practices

Tools

Dynatrace

Data Management Console

GCP Monitoring Tools

Linux Command Line

Job description

Position Job Title: DB2 Database Administrator GCP
Job ID (Task ID): HBITS-08-15058
Location: Albany, NY
Experience : 15 + Years
Client :State of NY

Requested Qualifications;

• 72 Months of experience DB2 Database Administration Expertise: Experience in administering DB2 databases on Linux environments, including installation, configuration, performance tuning, backup/recovery, and security management
• 84 Months of experience Red Hat Linux Proficiency: Experience in Red Hat Linux operating systems, including command-line administration, scripting, and system troubleshooting.
• 84 Months of experience Database Performance Tuning and Optimization Expertise: Analyze and resolve performance bottlenecks in Db2 databases, including query optimization, index management, buffer pool tuning, and workload management.
• 84 Months of experience High Availability and Disaster Recovery (HADR) for Db2:Experience in setting up, configuring, and managing Db2 HADR solutions to ensure business continuity and data resilience.
• 60 months of experience Google Cloud Platform (GCP) Expertise: Experience with GCP services relevant to database deployments, such as Compute Engine (for bare metal instances), networking (VPCs, firewalls), storage (Persistent Disks), and IAM for access control.
• 60 months of experience Scripting and Automation: Experience in scripting languages such as Bash, Python, or Perl for automating routine database administration tasks, deployments, and monitoring.
• 60 months of experience Troubleshooting and Problem-Solving: Analytical and problem-solving skills to quickly diagnose and resolve complex issues related to Db2, RHEL, and their interaction within the GCP environment.
• 84 Months of experience Backup and Recovery Strategies: Experience in designing, implementing, and testing robust backup and recovery strategies for Db2 databases, including full, incremental, and log backups, and performing point-in-time recoveries.
• 84 Months of experience Monitoring and Alerting: Experience with setting up and utilizing monitoring tools (e.g., Dynatrace, Data Management Console, or GCP's native monitoring tools) to track Db2 and RHEL system health, performance, and to configure proactive alerts.
• 84 Months of experience Security Best Practices: Experience in implementation of security best practices for both Db2 databases and RHEL systems, including user and group management, access control, encryption, and vulnerability management.

Required Documentation;

• Resume
• Copy of Candidate Identification (i.e., Driver s License/Green Card/Visa and Passport if applicable)
• Any documents referenced in the above Requested Qualifications (i.e., professional certifications, degrees, etc.)