Database Architect

VSG Business Solutions•Albany, NY

About The Position

The Database Architect will administer and optimize Db2 databases in Red Hat Linux environments and support their deployment and operation on Google Cloud Platform. The role includes database installation and configuration, performance tuning, backup and recovery, security management, high availability and disaster recovery, automation, monitoring, and troubleshooting. The posting also requests a résumé, a copy of candidate identification, and documents referenced in the requested qualifications, such as certifications or degrees.

Requirements

72 months of experience administering Db2 databases on Linux environments.
84 months of experience with Red Hat Linux operating systems.
84 months of experience in database performance tuning and optimization.
84 months of experience with Db2 high availability and disaster recovery (HADR).
60 months of experience with GCP services relevant to database deployments, including Compute Engine, networking, storage, and IAM.
60 months of experience scripting and automating tasks using languages such as Bash, Python, or Perl.
60 months of experience troubleshooting Db2, RHEL, and related issues in GCP environments.
84 months of experience designing, implementing, and testing Db2 backup and recovery strategies.
84 months of experience with monitoring and alerting tools, such as Dynatrace, Data Management Console, or GCP native monitoring tools.
84 months of experience implementing security best practices for Db2 databases and RHEL systems.

Responsibilities

Administer Db2 databases on Linux, including installation, configuration, performance tuning, backup and recovery, and security management.
Administer Red Hat Linux systems, including command-line tasks, scripting, and troubleshooting.
Analyze and resolve Db2 performance bottlenecks through query optimization, index management, buffer pool tuning, and workload management.
Set up, configure, and manage Db2 HADR solutions.
Use GCP services relevant to database deployments, including Compute Engine, networking, storage, and IAM.
Automate database administration, deployments, and monitoring using scripting languages.
Diagnose and resolve issues involving Db2, RHEL, and their interaction in GCP environments.
Design, implement, and test Db2 backup and recovery strategies, including full, incremental, and log backups and point-in-time recovery.
Set up and use monitoring tools to track Db2 and RHEL health and performance and configure proactive alerts.
Implement security practices for Db2 and RHEL, including user and group management, access control, encryption, and vulnerability management.