Apply on Employer Site

NEOGOV · 5 months ago

IT Analyst III - Database Administrator

Salt Lake County, UT

Full-time

Hybrid

Mid Level

$41.59/hr - $70.69/hr

NEOGOV is a division of the State of Utah's Department of Government Operations, focusing on technology services. The Database Administrator will manage and maintain database performance, security, and availability for executive branch agencies across various platforms, ensuring robust database solutions and operations.

GovTechHuman ResourcesInformation TechnologySoftware

No H1B

Security Clearance Required

Responsibilities

Set up, configure, and prepare database instances and infrastructure across various platforms (cloud and on-premise) to support externally developed database designs

Administer, maintain, and support a diverse range of databases such as Oracle, SQL Server, PostgreSQL, Amazon Aurora, and Google BigQuery

Monitor database performance proactively and implement tuning and optimization strategies (e.g., query tuning, indexing) to ensure smooth operation

Manage database deployments and operations across various cloud platforms (AWS, GCP, Azure) and on-premise environments (Exadata, standalone servers)

Establish, test, and maintain robust backup and recovery protocols to safeguard data integrity and ensure rapid restorability

Implement and enforce comprehensive database security measures, including managing user permissions, access controls, and data encryption

Troubleshoot and resolve database-related issues and performance bottlenecks to maintain system stability and availability

Collaborate with executive branch customer agencies to understand their data needs and translate them into effective database solutions

Ensure the high availability and reliability of critical database systems to support continuous agency operations

Stay current with emerging database technologies and best practices, particularly within cloud environments, to recommend and implement improvements

Exposure to DevOps methodologies and CI/CD pipelines

Qualification

Database AdministrationCloud Database ServicesSQL ProficiencyDatabase Security ManagementPerformance MonitoringBackupRecoveryDatabase Automation ToolsAnalytical SkillsProblem-Solving SkillsTeam Collaboration

Required

Direct, hands-on experience in database administration within a production environment

Solid understanding and practical experience in database administration of cloud-native database services, like Amazon Aurora and/or Google BigQuery

Demonstrated expertise with preferably two distinct relational database systems (e.g., Oracle, SQL Server, PostgreSQL)

Proven experience managing and optimizing databases in public cloud environments (AWS, GCP, and/or Azure)

Proficiency in SQL for querying, manipulating data, and analyzing query performance

Strong working knowledge of database backup, recovery, and disaster recovery methodologies

Experience implementing and maintaining database security measures, including user management, permissions, and encryption

Demonstrated ability to perform database performance monitoring, tuning, and troubleshooting to resolve bottlenecks

Excellent analytical and problem-solving skills with the ability to work independently or with a team and communicate technical solutions effectively

Preferred

Bachelor's degree or equivalent experience in Computer Science, Information Technology, or a related field, or equivalent practical experience

Active Associate-level or higher cloud certification (e.g., AWS Certified Database - Specialty, Azure Database Administrator Associate, Google Cloud Professional Cloud Database Engineer)

Experience with database automation tools and scripting (e.g., Python, PowerShell, shell scripting) for routine tasks, deployments, or monitoring

Familiarity with Data Warehousing concepts and ETL processes, particularly in cloud environments

Working knowledge of Exadata or other high-performance on-premise database appliances

Experience in cloud cost management and optimization strategies related to database services (e.g., reserved instances, savings plans)