IT Analyst III - Database Administrator

State of Utah Office of the Governor • West Jordan, UT

2d • $42 - $71 • Hybrid

About The Position

Are you a Database Administrator (DBA) looking for a meaningful career where your work directly supports public safety and critical government operations? The State of Utah Department of Government Operations, Division of Technology Services (DTS), is seeking an experienced Senior Database Administrator to support the Department of Corrections and other enterprise State systems.

This position will play a key role in modernizing enterprise database platforms, including leading strategic database migration initiatives from Informix to modern relational database technologies such as PostgreSQL hosted in AWS cloud environments.

The ideal candidate will possess strong experience administering enterprise SQL databases across Windows and Linux platforms, with expertise in database migration, performance optimization, cloud services, security, automation, and operational support for mission-critical applications.

This role is crucial in ensuring the State of Utah maintains secure, scalable, reliable, and high-performing database solutions capable of supporting current and future operational needs.

Requirements

• 5+ years of proven experience as a Database Administrator supporting enterprise relational database systems.
• Strong experience performing database migrations, upgrades, and modernization initiatives.
• Extensive knowledge of database design, administration, documentation, and SQL development.
• Experience administering enterprise SQL database platforms such as: PostgreSQL, BigQuery, Microsoft SQL Server, Other enterprise relational database systems and enterprise data warehouse technologies.
• Experience supporting databases in both on-premise and cloud-hosted environments.
• Strong understanding of: Database performance tuning, Query optimization, Backup and recovery strategies, Replication and high availability, Database security best practices.
• Experience with AWS database services including Amazon RDS and Aurora PostgreSQL.
• Experience with Windows and Linux server environments.
• Understanding of CI/CD pipelines and database deployment processes.
• Knowledge of database version control and change management practices.
• Ability to test and troubleshoot database and software issues using appropriate methodologies and techniques.
• Strong analytical, organizational, research, and problem-solving skills with exceptional attention to detail.
• Excellent written, verbal, interpersonal, and technical communication skills.
• Ability to create technical documentation, standards, and operational procedures.
• Ability to work effectively with technical teams, project stakeholders, and business users.
• Ability to deal with people in a manner that demonstrates professionalism, tact, sensitivity, and collaboration.

Nice To Haves

• 10+ years of proven experience as a Database Administrator supporting enterprise relational database systems.
• Experience with scripting and automation tools such as: PowerShell, Bash, Python.
• Familiarity with Infrastructure as Code (IaC) tools such as Terraform or CloudFormation.
• System administration experience is highly desirable.
• Relevant cloud, database, or PostgreSQL certifications are preferred.
• Experience supporting mission-critical or public sector environments is preferred.

Responsibilities

• Conduct assessments of existing database structures, integrations, dependencies, and data volumes.
• Design and implement scalable relational database architectures supporting enterprise applications and cloud modernization initiatives.
• Collaborate with infrastructure, application development, cloud engineering, cybersecurity, and business teams to ensure successful migrations and integrations.
• Administer, maintain, monitor, and optimize enterprise SQL databases hosted on Windows and Linux platforms.
• Administer and optimize PostgreSQL databases hosted in AWS cloud environments.
• Build, migrate, configure, and maintain databases supporting both on-premise and cloud-hosted systems.
• Monitor database health, storage utilization, system performance, replication, and availability.
• Provide ongoing database maintenance, support, troubleshooting, integrity validation, performance assessments, and operational enhancements.
• Analyze and optimize SQL queries, indexing strategies, and database configurations to improve performance and scalability.
• Support production deployments, upgrades, patches, releases, and change management activities.
• Coordinate database installations, upgrades, architecture changes, and issue resolution efforts with System Administrators and technical teams.
• Support cloud database technologies and modernization initiatives utilizing AWS services including: Amazon RDS, Aurora PostgreSQL, Amazon EC2, AWS Backup, AWS IAM, Amazon CloudWatch, Amazon S3.
• Develop and maintain automation processes, scripts, and database operational procedures.
• Support CI/CD pipeline integration and database deployment automation processes.
• Participate in Infrastructure as Code (IaC) and cloud automation initiatives.
• Design, implement, and enforce strong database security structures and access controls.
• Ensure the confidentiality, integrity, and availability of sensitive criminal justice and operational data.
• Implement database encryption, auditing, role-based security, and compliance best practices.
• Develop and maintain database backup, replication, disaster recovery, and continuity of operations plans.
• Support compliance with CJIS, State, and enterprise security standards.
• Participate in disaster recovery planning, testing, and operational readiness activities.
• Lead database design and development efforts based on business and technical requirements.
• Provide data modeling and database architecture support to development projects.
• Assist application developers with complex query development, tuning, and troubleshooting.
• Design, create, install, and manage automated databases, reporting processes, and scheduled report executions.
• Perform data validation to verify the integrity of data relationships, calculations, interfaces, and reporting outputs.
• Create and maintain technical documentation including: Database schemas, Data dictionaries, Operational procedures, System interfaces, Security structures.
• Interact with and support project managers, technical leads, developers, business analysts, and end users throughout analysis, design, testing, and implementation activities.
• Participate in architecture reviews and provide recommendations for scalable and reliable database solutions.
• Support production incident response, root cause analysis, and problem resolution activities.
• Accommodate work that may need to be performed during evenings, weekends, maintenance windows, or other after-hours operational periods.
• Perform other duties as assigned.

Benefits

• Job Stability: Enjoy the security and reliability of employment within a well-established organization.
• Career Growth: Develop valuable skills and gain opportunities for leadership within a large organization.
• Meaningful Work: Contribute to an important service that benefits the community and supports organizational goals.
• Supportive Work Environment: Be part of a team that values cooperation, strong work ethics, and mutual support.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed