Dieses Stellenangebot ist nicht mehr verfügbar
Über
$35.09 - $59.63 Hourly Location :
Salt Lake County, UT Job Type:
Full Time Remote Employment:
Flexible/Hybrid Job Number:
47899 Agency:
150 Department of Government Operations Unit:
2904 DGO DTS APPLICATION SUPPORT - CRC/LBR Opening Date:
02/06/2026 Closing Date:
2/12/2026 11:59 PM Mountain FLSA:
Non-Exempt Recruiter:
Liz Vander Linden - evander@utah.gov # of Openings:
1 Background Check:
You must successfully pass a criminal history check. Location:
This position is currently a hybrid of both in-office and telework days (two days a week, in office required at the Heber M. Wells Building (160 E 300 S SLC, UT). Please note, a position's eligibility for telework is established by agency management and is subject to change at their discretion at any time and for any reason. 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.
Job Description The Department of Technology Services (DTS) has a great opportunity for someone who totally enjoys DBA work and working with a great team! This position is for an Application Database Administrator (DBA) to support maintenance and development of the My License One (MLO) and My License 1 (ML1) applications for the Department of Commerce. The MLO environment runs on an Oracle database in an environment managed by the State of Utah. The vendor, developer of the MLO and ML1 environments owns the applications themselves. The DTS staff manage the administration of the applications. The environment is currently in flux, likely to end up on an AWS or Google Cloud Platform (GCP) within the upcoming months moving from its on premises Exadata environment. The state also has a DTS-side DBA who supports the physical and/or cloud environments for the day-to-day security, load balancing, backup and system management. This position is currently a hybrid of both in-office and telework days (two days a week, in office required at the Heber M. Wells Building (160 E 300 S SLC, UT). Please note, a position's eligibility for telework is established by agency management and is subject to change at their discretion at any time and for any reason. 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.09- $59.63 per hour IT Analyst I, $27.49 - $46.75 per hour 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. to view a summary of all the benefits we offer.
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.
Responsibilities
The database analyst working on the MLO and ML1 environments should ideally be able to:
Install, patch, maintain and monitor Oracle databases Create and maintain SQL and PL/SQL queries and shell scripts Monitor, and verify backups and perform ad-hoc backups Provide maintenance support for database systems. Data Extraction, transformation, and loading (ETL) Perform routine security and authentication measures Database tuning and troubleshooting Support reporting products as required by the Department of Commerce Mentoring The Department of Technical Services employs an agile development methodology. DTS team members are part of sprint teams following the methodology.
Responsibilities
Oversee daily operations with MLO and ML1 Coordinate with the vendor for application side issues Provide reports and reporting as requested by the business Support Department of Commerce projects as requested Develop and support the Commerce data warehouse Document all activities, processes or other work Gain a functional understanding of the professional licensing applications at a data structure, table, column and row level
Qualifications
Agile development methodology Data modeling Data design Able to create and maintain stored procedures Able to create and maintain complex PL-SQL queries Proficient with ETL functions, oversight and support Supplemental Information
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.
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
Applicants for this recruitment will be rated based on their answers to the supplemental questions listed below. It is imperative that information provided on the application and job profile are detailed and clearly outline your work experience & skills. Your profile must support and/or match answers to the supplemental questions. "See Resume" is not an acceptable answer for any question. Please acknowledge that you have read this statement.
Yes No
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
Do you currently reside in the state of Utah?
Yes No
04
This position is currently a hybrid of both in-office and telework days (two days a week, in office required at the Heber M. Wells Building (160 E 300 S SLC, UT). Please note, a position's eligibility for telework is established by agency management and is subject to change at their discretion at any time and for any reason. Are you willing to relocate if selected for this position?
Yes No
05
Rate your experience with Oracle database administration, including installation, configuration, and maintenance.
Zero: No knowledge or experience. Novice: Understands basic syntax and concepts. Intermediate: Can write functional code and troubleshoot common issues with minimal guidance. Advanced: Capable of independently completing projects and integrating related tools. Expert: Develops efficient, scalable solutions and mentors' others on best practices.
06
Please describe in detail your experience with Oracle database administration, including installation, configuration, and maintenance. 07
Rate you experience with SQL and PL/SQL, particularly in optimizing database performance and troubleshooting issues.
Zero: No knowledge or experience. Novice: Understands basic syntax and concepts. Intermediate: Can write functional code and troubleshoot common issues with minimal guidance. Advanced: Capable of independently completing projects and integrating related tools. Expert: Develops efficient, scalable solutions and mentors' others on best practices.
08
Please describe in detail your experience with SQL and PL/SQL, particularly in optimizing database performance and troubleshooting issues. 09
Rate your experience with database security best practices in an Oracle environment.
Zero: No knowledge or experience. Novice: Understands basic syntax and concepts. Intermediate: Can write functional code and troubleshoot common issues with minimal guidance. Advanced: Capable of independently completing projects and integrating related tools. Expert: Develops efficient, scalable solutions and mentors' others on best practices.
10
Please describe in detail your experience with database security best practices in an Oracle environment. 11
Rate your experience with Oracle backup and recovery strategies.
Zero: No knowledge or experience. Novice: Understands basic syntax and concepts. Intermediate: Can write functional code and troubleshoot common issues with minimal guidance. Advanced: Capable of independently completing projects and integrating related tools. Expert: Develops efficient, scalable solutions and mentors' others on best practices.
12
Please describe in detail how familiar your are with Oracle backup and recovery strategies, and what tools have you used for these tasks. 13
How do you stay updated on the latest Oracle technologies and database trends? 14
Rate your experience with overseeing ETL processes with applications and data warehouses.
Zero: No knowledge or experience. Novice: Understands basic syntax and concepts. Intermediate: Can write functional code and troubleshoot common issues with minimal guidance. Advanced: Capable of independently completing projects and integrating related tools. Expert: Develops efficient, scalable solutions and mentors' others on best practices.
15
Please describe in detail your experience overseeing ETL processes with applications and data warehouses. 16
Please indicate how you heard about this specific job posting.
State of Utah job site (www.governmentjobs.com/careers/utah) Referred by a Friend or Family Indeed Other External Job Board or Site LinkedIn 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.) Other (not listed above)
Required Question
Sprachkenntnisse
- English
Hinweis für Nutzer
Dieses Stellenangebot wurde von einem unserer Partner veröffentlicht. Sie können das Originalangebot einsehen hier.