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