IT Analyst II - Database Administrator

Full 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.

Click here 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.

Requirements

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

Additional 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.