IT Analyst II - Database Administrator (DBA)

State of Utah•Salt Lake City, UT

1d•Hybrid

About The Position

We are seeking a Database Administrator to manage and optimize our cloud-based database infrastructure. You will also have opportunities to work on a variety of platforms— such as Oracle, PostgreSQL, Aurora, MySQL, MSSQL, and NoSQL( MongoDB, DynamoDB) —as part of our diverse technology ecosystem. This job may be filled at either of the levels listed below. (Rate as listed or in accordance with DHRM Rules for current state employees.) IT Analyst II, $35.97 - $61.12 per hour IT Analyst I, $28.18 - $47.92 per hour

Requirements

Proven experience with databases in AWS environments (RDS, EC2, or other cloud-hosted solutions).
A strong understanding of database concepts with solid troubleshooting and performance tuning skills.
Demonstrated ability to review and debug code written by others.
Familiarity with database security best practices and compliance requirements.
Ability to work both independently and as part of a collaborative, cross-functional team.
Willingness to learn new technologies and adapt to evolving database environments.

Nice To Haves

Experience with scripting languages (e.g., Python, Bash) and AWS automation tools (e.g., CloudFormation, Terraform) is a plus
Exposure to other database platforms is appreciated but not required.
Hands-on experience with AWS RDS, including instance management, security groups, VPC configurations, and other related services.
Experience with database migration projects.
Exposure to DevOps methodologies and CI/CD pipelines.
AWS Certifications (e.g., AWS Certified Database Specialty) are a plus.
Knowledge of high availability and disaster recovery solutions for database platforms.

Responsibilities

Perform core DBA tasks including database installation, configuration, patching, upgrades, performance tuning, backup and recovery, security management, and user management.
Manage and monitor AWS RDS instances or EC2, including provisioning, scaling, security groups, VPC configurations, and other related AWS services. Understand and implement AWS best practices for database deployments.
Proactively monitor database performance, identify bottlenecks, and implement performance tuning strategies to optimize database efficiency and responsiveness. Utilize performance monitoring tools and techniques.
Design, implement, and test high availability and disaster recovery solutions for database platforms, including multi-AZ deployments, read replicas, and backup/restore procedures.
Implement and enforce security best practices to protect sensitive data, including access control, encryption, auditing, and vulnerability management. Ensure compliance with relevant security standards.
Automate routine DBA tasks using scripting languages (e.g., Python, Bash) and AWS automation tools (e.g., CloudFormation, Terraform) to improve efficiency and reduce manual effort.
Configure and maintain database monitoring and alerting systems to proactively identify and address potential issues. Respond to alerts and incidents in a timely manner.
Work closely with development teams, system administrators, and other stakeholders to support application deployments and database-related initiatives.
Maintain accurate and up-to-date documentation for database configurations, procedures, and troubleshooting steps.
Troubleshoot and resolve database-related issues, including performance problems, connectivity issues, and data corruption. Review and debug code written by others across all platforms used by the DBA team.
Participate in capacity planning activities to ensure that database resources are adequate to support future growth.
Stay up-to-date with the latest database platforms, AWS services, and best practices for cloud-based database management.