Back to Jobs
Recently postedOther

DB2 Database Architect - PP copy and 3 professional references are mandatory

Bits & Bytes Technology SolutionsAlbany, NY🇺🇸United States

Why this role stands out

Take your career to the next level by joining a high-impact project at Bits & Bytes Technology Solutions, where you will leverage your senior-level expertise to optimize critical database infrastructure in a collaborative, professional environment. This hybrid role is perfect for a proactive, autonomous specialist who thrives on solving complex technical challenges and wants to make a tangible difference in state-level systems. Apply today to advance your skill set and contribute to the success of this vital data management initiative.

Quick overview

SeniorityMid Senior
Work modeHybrid
LocationAlbany, NY, United States
EncryptionBashGoogle CloudPerlPythonLinuxIAM

Job description

Bits & Bytes Technology Solutions is seeking a Senior Database Architect (Data Management Specialist) to support the New York State Department of Labor's Unemployment Insurance System — NYSDOL Data Warehouse / UISIM project support, in Albany, NY. The role administers DB2 databases on Red Hat Linux and supports the operational functions of the UI system.

Day-to-day: administer Db2 databases hosted on bare-metal Red Hat Enterprise Linux (RHEL); monitor Db2 performance metrics (CPU, memory, disk I/O, buffer pool hit ratios); deploy, maintain, and monitor Db2 monitoring utilities including IBM Data Management Console (DMC); develop scripts and tools to automate monitoring, maintenance, and administrative tasks; review overnight alerts, dashboards, and Db2 diagnostic logs daily to identify and resolve errors and incidents; run routine maintenance (RUNSTATS, REORGCHK, REORG); apply patches and upgrades per agency change management; monitor and validate backup and recovery processes; review Db2 security settings and user access, monitoring for unauthorized access attempts; document all administrative work and update knowledge base articles; respond to data management service requests; participate in daily stand-up meetings with State supervisory staff.

Mandatory Qualification: 60-84 months (Senior) — candidate is able to work independently, without assistance, and provides guidance to others. May have an advanced education. 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.

Requested Qualifications:
1. 72 months — DB2 Database Administration: administering DB2 databases on Linux environments, including installation, configuration, performance tuning, backup/recovery, and security management.
2. 84 months — Red Hat Linux proficiency: command-line administration, scripting, and system troubleshooting.
3. 84 months — Database performance tuning and optimization: query optimization, index management, buffer pool tuning, and workload management.
4. 84 months — High Availability and Disaster Recovery (HADR) for Db2: setting up, configuring, and managing Db2 HADR solutions.
5. 60 months — Google Cloud Platform (Google Cloud Platform): Compute Engine (bare metal), networking (VPCs, firewalls), storage (Persistent Disks), and IAM.
6. 60 months — Scripting and automation: Bash, Python, or Perl for automating database administration tasks, deployments, and monitoring.
7. 60 months — Troubleshooting and problem-solving: diagnosing and resolving complex issues across Db2, RHEL, and their interaction within the Google Cloud Platform environment.
8. 84 months — Backup and recovery strategies: full, incremental, and log backups, and point-in-time recoveries for Db2 databases.
9. 84 months — Monitoring and alerting: Dynatrace, IBM Data Management Console, or Google Cloud Platform native monitoring tools; configuring proactive alerts.
10. 84 months — Security best practices for Db2 databases and RHEL systems: user and group management, access control, encryption, and vulnerability management.

Required to Apply: Résumé; copy of candidate identification (Driver's License / / Visa and Passport if applicable); supporting documents for the qualifications above (certifications, degrees, etc.); PP copy + 3 professional references. Resource must sign a confidentiality agreement; NYS OER mandated training and UI confidentiality training required. Interview: webcasting (camera required).

Similar jobs