Remote Jobs
IT Analyst III - Database Administrator
This job is now closed
Job Description
- Req#: 5007173
- 3 medical plan options. Choose a Traditional or High Deductible Health Plan. There is an Opt-Out Cash Benefit option for those that have other medical insurance coverage.
- 5 dental plan options, with an Opt-Out Cash Benefit option for those that have other dental insurance coverage.
- 4 vision plan options under EyeMed or OptiCare
- Employees who have any service credit with an employer covered by the Utah Retirement Systems prior to 7/1/2011 are in the Tier I Public Employees System.
- Employees hired on or after 7/1/2011 and who have never been in the URS retirement system have two options for retirement in the Tier II System.
- Tier 2 Hybrid Retirement System. Employer contributes an amount equal to 10% of your salary between both plans (pension and 401(k))
- Tier 2 Defined Contribution Plan. Employer contributes an amount equal to 10% of your salary to a 401(k) plan only.
- Employer contributions to your 401(k) are vested after four years.
- Annual leave and sick leave are accrued at 4 hours per pay period each (4 hours annual, 4 hours sick).
- Annual leave amounts increase with years of service.
- We have 12 paid holidays.
- 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.
- 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.
- 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).
- Employment contingent on passing a drug screening and a background check.
- Risks found in the typical office setting, which is adequately lighted, heated and ventilated, e.g., safe use of office equipment, avoiding trips and falls, observing fire regulations, etc.
- Typically, the employee may sit comfortably to perform the work; however, there may be some walking; standing; bending; carrying light items; driving an automobile, etc. Special physical demands are not required to perform the work.
- I acknowledge I have read and understand the above statement
- Less than 1 year
- 1 - 2 years
- 3 - 4 years
- 5+ years
- State of Utah job site (www.governmentjobs.com/careers/utah)
- Referred by a Friend or Family
- Indeed
- Other External Job Board or Site
- Social Media (Facebook, Twitter, etc.)
- DWS job website (www.jobs.utah.gov)
- Advertisement (Digital Ad, Billboard, Print, etc.)
- Professional Network (Association, Membership, Work Colleague)
- University Network (Handshake, School Job Board, Career Center, etc.)
- Contacted by a Recruiter
- Career or Job Fair
- Internship
- Interviewed for different position
- Internal communications (Agency/Division, etc.)
- Jobwise
- Other (not listed above)
Salary: $41.59 - $70.69 Hourly
Location : Salt Lake County, UT
Job Type: Full Time
Remote Employment: Flexible/Hybrid
Job Number: 45694
Agency: 150 Department of Government Operations
Unit: 2728 DGO DTS SQL
Opening Date: 07/16/2025
Closing Date: Continuous
FLSA: Exempt
Recruiter: Liz Vander Linden - evander@utah.gov - 801-957-7232
# of Openings: 1
Background Check: You must successfully pass a criminal history check.
Location: This position is currently a hybrid of both in-office (2 days a week required in office and any mandatory in office meetings) and remote work days (work must be performed in Utah). Please note, a position's eligibility for remote work is established by agency management and is subject to change at their discretion at any time and for any reason. The office is located at the Taylorsville State Office Builiding, 4315 S 2700 W, Taylorsville, UT. All remote work must be performed within the state.
Schedule Code: AT - Executive/Professional Employees of Technology Services - This is a career service exempt at will position.
Benefits: This position is eligible for a full benefits package. See benefits tab below for details.
EEO Statement: The State of Utah is committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity, or Veteran status. We also consider qualified applicants regardless of criminal histories, consistent with legal requirements. For accommodations, dial 711 or TTY: 800-346-4128.
Job Description
The Database Administrator manages and maintains database performance, security, and availability for executive branch agencies across various platforms (AWS, GCP, Azure, Exadata, standalone) using Oracle, SQL Server, PostgreSQL, Amazon Aurora, and Google BigQuery. Key responsibilities include database design and implementation, ongoing maintenance including upgrading, performance monitoring and optimization, backup/recovery, and security management.
This position is currently a hybrid of both in-office (2 days a week required in office and any mandatory in office meetings) and remote work days (work must be performed in Utah). Please note, a position's eligibility for remote work is established by agency management and is subject to change at their discretion at any time and for any reason. The office is located at the Taylorsville State Office Builiding, 4315 S 2700 W, Taylorsville, UT. All remote work must be performed within the state.
Why join our team?
We have great business partners who want to serve Utah citizens efficiently and effectively, while working within the guidance of their federal and state partners. This is an opportunity to make a difference for Utah citizens while being a pivotal part of an exciting IT team. You will receive great health and retirement benefits, such as, generous paid time off so you can spend more time with your family and have a positive work life balance.Click here to view a summary of all the benefits we offer.
Health Insurance - Public Employee Health Program (PEHP):
The Agency:
To learn more about The Division of Technology Services check us out Click here. The State's environment is a highly optimized blend of systems responsible for collecting, processing, and distributing millions of data elements every day. The provides support to, and enables other state agencies to fulfill their core missions.
Responsibilities
Responsibilities:
Qualifications
Required/Minimum Qualifications
Additional or Preferred Qualifications
Supplemental Information
Benefits:
The State of Utah offers eligible employees a variety of benefits including medical, dental, life and disability insurance, as well as a comprehensive leave program. Please click the following link for a detailed information page: To access a Total Compensation Calculator in Excel format click
FMLA General Notice:
(right click + open link in new tab)
(clic derecho + abrir en una pestaña nueva?)
01
ONLY APPLICANTS SELECTED FOR AN INTERVIEW WILL BE CONTACTED. As part of this application process, you must upload your resume into your application profile. Your answers to the questions on this application must be supported by your resume or work history. "See resume" or "see previous response" is not an acceptable response to any question. Please answer all questions fully. Failure to follow these terms may result in disqualification from further consideration for this position.
02
To ensure your potential employment with the Department of Government Operations does not violate the law (Utah Code 52-3-1), or agency policy; if you have any relatives employed with the Department of Government Operations, please list their name below and indicate your relationship. Please note that listing a relative will not automatically disqualify you from employment. If you have no relatives working for the Department of Government Operations, please enter "no relatives at DGO".
03
How many years of direct, hands-on experience do you have in database administration within a production environment?
04
Describe your experience setting up, configuring, and preparing database instances and infrastructure across various platforms (cloud and on-premise). Please provide examples of the specific platforms you have worked with.
05
Which database systems (e.g., Oracle, SQL Server, PostgreSQL, Amazon Aurora, Google BigQuery) do you have direct administration, maintenance, and support experience with in a production environment? Please rate your proficiency (e.g., expert, proficient, familiar) with each.
06
How do you proactively monitor database performance, and what strategies do you employ for tuning and optimization (e.g., query tuning, indexing)? Provide a specific example of a performance bottleneck you resolved and the steps you took.
07
Detail your experience managing database deployments and operations in public cloud environments (AWS, GCP, and/or Azure) and/or on-premise environments (Exadata, standalone servers).
08
Describe your experience with establishing, testing, and maintaining database backup and recovery protocols. What methodologies do you typically use to ensure data integrity and rapid restorability?
09
Do you have experience with database automation tools and scripting (e.g., Python, PowerShell, shell scripting) for routine tasks, deployments, or monitoring? If so, please provide examples.
10
Please indicate how you heard about this specific job posting.
Required QuestionAbout the company
The best remote jobs for you
Notice
Talentify is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.
Talentify provides reasonable accommodations to qualified applicants with disabilities, including disabled veterans. Request assistance at accessibility@talentify.io or 407-000-0000.
Federal law requires every new hire to complete Form I-9 and present proof of identity and U.S. work eligibility.
An Automated Employment Decision Tool (AEDT) will score your job-related skills and responses. Bias-audit & data-use details: www.talentify.io/bias-audit-report. NYC applicants may request an alternative process or accommodation at aedt@talentify.io or 407-000-0000.