• IT Database Administrator is responsible for administration of database platforms including monitoring, installation, configuration, debugging, administration, backup, recovery, troubleshooting, SQL tuning, and maintenance of database technologies. • IT database administrator is responsible for database design, deploying database objects and ensuring data integrity is maintained and secured. • IT Database administrator is also responsible to design and build high availability solutions to ensure stable and efficient operation of database technology solutions • Performs installation, monitoring, testing, configuration, migration, maintenance, tuning, and troubleshooting of assigned database technology, as well as designing database deployments for high availability. Ensure database versions are current and deploys patches as required. Also assists with determining migration and upgrade impacts and diagnosing/resolving technology/application errors. • Develop and implement controls required by CMS and other mandates/audit requirements. • Automate database functions by programming/scripting as required. Assists with researching, designing, implementing, and testing of database technology solutions, and work with users and IT partners to understand requirements for a physical database design. • Participate in Disaster Recovery planning and exercises. Proactively monitors and reports performance and utilization and adjust database configuration as appropriate. • Resolves database alerts and performs remediation activities, manages problem or escalated tickets and tasks and out of cycle requests from systems/application owners. Provides input into processes and procedures related to database administration. • Collaborates with IT and business area partners on work groups and initiatives. Performs On-Call activities as needed for the environment and database technologies

• Provide day-to-day operational support for mission-critical SQL database environments supporting state agency legacy systems. • Monitor database health, performance, availability, and capacity. • Perform routine maintenance, patching, backups, restores, and disaster recovery support. • Troubleshoot and resolve database-related issues in coordination with application and infrastructure teams. • Ensure database environments meet established service levels and operational requirements. • Support current-state assessments by documenting existing database architectures, configurations, and data flows. • Inventory databases, schemas, jobs, integrations, and dependencies across legacy systems. • Identify technical debt, performance constraints, risks, and operational challenges within the database environment. • Provide subject matter expertise related to legacy system data structures and usage patterns. • Contribute database-related input to modernization planning and future-state discussions. • Support analysis of database migration, modernization, or replacement options. • Assist in defining database-related technical requirements, assumptions, and constraints for future-state solutions. • Provide operational insights to ensure future designs are supportable, secure, and maintainable.

• Monitor database performance and implement tuning strategies. • Ensure data integrity, backups, and disaster recovery readiness. • Collaborate with development teams on schema design, query optimization, and data modeling (OLTP/OLAP). • Support database security and access controls in compliance with DoD standards. • Maintain documentation and change control procedures. • Lead database upgrades and migrations. • Automate routine tasks (backups, patching, user provisioning) with versioned scripting and CI/CD. • Participate in on-call rotation, incident response, root-cause analysis, and capacity planning. • Integrate monitoring and alerting.

• Responsibility for planning, operating and further developing our database landscape with a focus on PostgreSQL and Oracle. • Ensuring high performance, availability and security as well as extensive automation. • Administration, configuration and upgrades of PostgreSQL and Oracle databases, including backup & recovery. • Performance analysis and optimization (e.g., execution plans, indexing, bloat & lock management, wait events). • Design and operation of high-availability and replication solutions (PostgreSQL: Streaming Replication/Patroni; Oracle: Data Guard/HAS). • Patching, security measures (e.g., TDE, hardening, auditing) and conducting recovery tests. • Monitoring, capacity and storage management, as well as SLA and health reporting. • Automation using Shell/Python/Ansible and creation of reliable documentation (runbooks, playbooks, post-mortems).