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).
