IT Analyst II - AWS Oracle Database Administrator
Apply NowCompany: State of Utah
Location: Salt Lake City, UT 84118
Description:
Salary: $34.23 - $49.00 Hourly
Location : Salt Lake County, UT
Job Type: Full Time
Remote Employment: Flexible/Hybrid
Job Number: 44447
Agency: 150 Department of Government Operations
Unit: 2912 DGO DTS APPLICATION SUPPORT - DWS
Opening Date: 03/06/2025
Closing Date: 3/16/2025 11:59 PM Mountain
FLSA: Non-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 Utah Department of Workforce Services, 140 E 300 S, Salt Lake City, 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 Utah State Department of Government Operations (DGO), Division of Technology Services (DTS), seeks an AWS Oracle Database Administrator to manage and optimize our cloud-based database infrastructure. Oracle databases are the primary focus; however, you will also have opportunities to work with other platforms-such as PostgreSQL, Aurora, MySQL, and MSSQL-as part of our diverse technology ecosystem.
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 Utah Department of Workforce Services, 140 E 300 S, Salt Lake City, UT. All remote work must be performed within the state.
Salary range for this position is $34.23 - $58.18, budgeted range for this position is $34.23 - $49.00.
Why join our team?
The State of Utah is a forward-thinking technology company managing complex database environments in the cloud. We support a diverse range of database architectures and are looking for a motivated Database Administrator (DBA) to join our team. This is a great opportunity for individuals looking to expand their expertise while working in a collaborative environment. 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.
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
Key Responsibilities:
Qualifications
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 pestaa 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
Please indicate how you heard about this specific job posting.
Required Question
Location : Salt Lake County, UT
Job Type: Full Time
Remote Employment: Flexible/Hybrid
Job Number: 44447
Agency: 150 Department of Government Operations
Unit: 2912 DGO DTS APPLICATION SUPPORT - DWS
Opening Date: 03/06/2025
Closing Date: 3/16/2025 11:59 PM Mountain
FLSA: Non-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 Utah Department of Workforce Services, 140 E 300 S, Salt Lake City, 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 Utah State Department of Government Operations (DGO), Division of Technology Services (DTS), seeks an AWS Oracle Database Administrator to manage and optimize our cloud-based database infrastructure. Oracle databases are the primary focus; however, you will also have opportunities to work with other platforms-such as PostgreSQL, Aurora, MySQL, and MSSQL-as part of our diverse technology ecosystem.
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 Utah Department of Workforce Services, 140 E 300 S, Salt Lake City, UT. All remote work must be performed within the state.
Salary range for this position is $34.23 - $58.18, budgeted range for this position is $34.23 - $49.00.
Why join our team?
The State of Utah is a forward-thinking technology company managing complex database environments in the cloud. We support a diverse range of database architectures and are looking for a motivated Database Administrator (DBA) to join our team. This is a great opportunity for individuals looking to expand their expertise while working in a collaborative environment. 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.
Health Insurance - Public Employee Health Program (PEHP):
- 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.
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
Key Responsibilities:
- Database Administration: Perform core DBA tasks including database installation, configuration, patching, upgrades, performance tuning, backup and recovery, security management, and user management for Oracle databases on AWS RDS.
- AWS Cloud Management: Manage and monitor AWS RDS instances, including provisioning, scaling, security groups, VPC configurations, and other related AWS services. Understand and implement AWS best practices for database deployments.
- Performance Tuning and Optimization: Proactively monitor database performance, identify bottlenecks, and implement performance tuning strategies to optimize database efficiency and responsiveness. Utilize performance monitoring tools and techniques.
- High Availability and Disaster Recovery: Design, implement, and test high availability and disaster recovery solutions for Oracle RDS databases, including multi-AZ deployments, read replicas, and backup/restore procedures.
- Security Management: Implement and enforce security best practices to protect sensitive data, including access control, encryption, auditing, and vulnerability management. Ensure compliance with relevant security standards.
- Automation: 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.
- Monitoring and Alerting: Configure and maintain database monitoring and alerting systems to proactively identify and address potential issues. Respond to alerts and incidents in a timely manner.
- Collaboration: Work closely with development teams, system administrators, and other stakeholders to support application deployments and database-related initiatives.
- Documentation: Maintain accurate and up-to-date documentation for database configurations, procedures, and troubleshooting steps.
- Problem Solving: 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.
- Capacity Planning: Participate in capacity planning activities to ensure that database resources are adequate to support future growth.
- Continuous Learning: Stay up-to-date with the latest Oracle database technologies, AWS services, and best practices for cloud-based database management.
Qualifications
Qualifications:
- Proven experience with Oracle databases in AWS environments (RDS, EC2, or other cloud-hosted solutions).
- A strong understanding of database concepts with solid troubleshooting and performance tuning skills.
- Experience with scripting languages (e.g., Python, Bash) and AWS automation tools (e.g., CloudFormation, Terraform) is a plus
- 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.
- 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.
- Hands-on experience with AWS RDS, including instance management, security groups, VPC configurations, and other related services.
- Knowledge of high availability and disaster recovery solutions for Oracle databases.
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 pestaa 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.
- I acknowledge I have read and understand the above statement
02
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
- 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)
Required Question