Database Architect - Senior

Provide a short description of the Position: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.

Provide a list of the day-to-day tasks to be performed by the Selected Candidate:• 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