HBITS-08-15058-Database Architect-Senior

Knowledge Builders Inc; City of Albany (NY); On-site; USD 90,000 - 130,000; Full time

Job summary

Knowledge Builders Inc. seeks a skilled Data Management Specialist to support the NYSDOL Data Warehouse UISIM project, administering Db2 databases on Red Hat Linux.

The role requires strong database administration, performance tuning, security, and automation skills within a collaborative, cross-functional team environment. You will monitor, backup, and recover Db2 data, apply patches, implement HA/DR, and develop scripts to automate tasks, with daily stand-ups and artifact documentation.

Qualifications

• 72 months of DB2 database administration experience on Linux.
• 84 months of Red Hat Linux proficiency including CLI and scripting.
• 84 months of database performance tuning and optimization experience.
• 84 months of HADR for Db2 and data resilience experience.
• 60 months of GCP experience for DB deployments and IAM controls.
• 60 months of scripting and automation for DB tasks.
• 60 months of troubleshooting Db2 and RHEL in cloud/on-prem environments.
• 84 months of backup and recovery strategy experience.
• 84 months of monitoring and alerting using enterprise tools.
• 84 months of security best practices for Db2 and RHEL systems.

Responsibilities

• Administer Db2 databases on bare-metal RHEL environments.
• Monitor Db2 performance metrics and adjust configurations.
• Deploy and monitor Db2 utilities including DMC.
• Develop scripts to automate monitoring and maintenance tasks.
• Review alerts and logs to identify and resolve critical DB issues.
• Perform RUNSTATS, REORGCHK, and REORG regularly.
• Apply patches/upgrades per change management procedures.
• Verify backup and recovery processes and data integrity.
• Review security settings and user privileges; monitor for unauthorized access.
• Document changes and maintain knowledge base articles.

Skills

DB2 database administration

Red Hat Linux proficiency

Database performance tuning

High availability & disaster recovery

Scripting (Bash/Python/Perl)

Troubleshooting & problem-solving

Monitoring & alerting

Security best practices

Tools

Dynatrace

Data Management Console (DMC)

GCP monitoring tools

Job description

Project/Program:

NYSDOL Data Warehouse | UISIM project support.

Job Description

NYSDOL Data Warehouse | UISIM project support.

We are seeking a skilled Data Management Specialist to support the Department of Labor's (DOL) Unemployment Insurance System’s operational functions. This role involves administering DB2 databases on Red Hat Linux. The ideal candidate will possess technical expertise in these areas, problem-solving abilities, and the ability to collaborate effectively with cross-functional teams.

Day-to-day Tasks

Daily Responsibilities include but are not limited to:

• Perform administration of Db2 databases hosted on bare-metal Red Hat Enterprise Linux (RHEL) environments.
• Monitor Db2 database performance metrics, including CPU usage, memory usage, disk I/O, and buffer pool hit ratios.
• Deploy, maintain, and monitor Db2 monitoring utilities, including IBM Data Management Console (DMC).
• Develop scripts and tools to automate ongoing monitoring, maintenance, and administrative tasks for Db2.
• Review overnight alerts, monitoring dashboards, and Db2 diagnostic logs daily to identify, troubleshoot, and resolve critical database errors, warnings, and incidents.
• Perform routine database maintenance tasks, including running RUNSTATS, REORGCHK, and REORG.
• Apply database patches and upgrades in accordance with established agency change management procedures.
• Monitor and validate database backup and recovery processes to ensure data integrity.
• Review Db2 security settings and user access privileges, and monitor systems for unauthorized access attempts.
• Document all administrative work performed, including system changes, issues encountered, and resolutions, and update knowledge base articles as needed.
• Respond to service requests and emails related to data management tasks, and prioritize work based on urgency and business impact.
• Participate in daily stand-up meetings to provide progress updates and report roadblocks to State supervisory staff.

Mandatory Qualifications

Database Architect–

Determines database structural requirements by analyzing client operations, applications, and programming; reviews objectives with clients; evaluates current systems; provides database support by coding utilities, responding to user questions, and resolving problems.

Senior

60 - 84 months: Candidate is able to work independently, without assistance and provides guidance to others. May have an advanced education.

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.

We provide equal employment opportunity for all applicants and employees regardless of race, color, sex, gender identity, gender expression, religion, age, national origin, citizenship, disability, medical condition, family care status, marital status, domestic partner status, sexual orientation, genetic information, military/veteran status, or any other protected basis.