Database Administrator at University of Utah
Salt Lake City, UT 84112
About the Job
Database Administrator
Job Summary
Develops, implements, administers, and maintains policies and procedures for ensuring the security and integrity of the company database. Implements data models, database designs, data access and table maintenance codes. Resolves database performance and capacity issues, and replication and other distributed data issues.
Responsibilities
Technology is constantly evolving, and therefore our responsibilities also change based on evolving technical and business requirements. The following is not meant as a complete or exhaustive list of responsibilities, as we need to remain agile and flexible to changes.
Technical Role:· Ability to learn new technologies and facilitate knowledge sharing with team
Teamwork: · Willing and able to share work and collaborate with other team members
Documentation: · Develop & share documented Standard Operating Procedures (SOP)· Develop & share architecture diagrams and run-books
Automation: · Improve efficiently by automating repetitive tasks· Share automated scripts or programs with team
Monitoring: · Monitor systems and provide health status to team and management· Ensure databases are up/healthy and secure by monitoring systems and resolving issues as they arise, including performance tuning, etc.· Gather metrics and present reports or findings to management· Proactively monitor data storage capacity and project growth requirements
Security: · Develops, implements, administers, and maintains policies and procedures for ensuring the security and integrity of databases.· Develop and implement backup, restore, and database recovery plans· Manage DB User Access· Perform End-of-Life Support prevention upgrades, and apply patches to address vulnerabilities
Customer Service: · Work with customers and application teams to design database objects that meets business requirements and production standards. This requires obtaining application knowledge while working with architects, data modelers, and application developers, etc.· Maintain positive relationship with customers and translate business requirements into technical solutions· Work with customers on Software Development Life Cycle through multiple development, test, production and other environments· Monitor & resolve ticket queues to ensure high quality of customer service and meet SLA timelines.
Daily Work: · Expected to learn and become proficient in new database technologies that we administer, including Cloud platform technologies· Implement data models, database designs, data access and table maintenance codes.· Resolves database performance and capacity issues, and replication and other distributed data issues.· Ensures the performance of the databases by managing configuration and DB objects to work with application code from development to production.· Refresh production databases to Non-Prod environments as requested· Works on complex projects both on-premises and on the Cloud· Install, upgrade, and test complex database software· Works in multiple projects simultaneously which spans multiple applications releases· Troubleshoot issues as they arise in a timely manner· All other duties as assigned
Minimum Qualifications
Requires a bachelor’s degree in a related area or equivalency (one year of education can be substituted for two years of related work experience) and 2-4 years of experience in the field or in a related area.
Applicants must demonstrate the potential ability to perform the essential functions of the job as outlined in the position description.
Preferences
· Database Certifications (Oracle, SQL Server, MySQL)· Cloud Certifications (Comptia, AWS, Azure, GCP, OCI)· Programming and Automation Experience (Shell Scripting, PowerShell, Python, etc.)· Technical Academic Degree· Experience with PeopleSoft
Special Instructions
Requisition Number: PRN38764B
Full Time or Part Time? Full Time
Work Schedule Summary: Business Hours plus on-call rotation
Department: 01555 - UIT INFRASTRUCTURE & OPS
Location: Campus
Pay Rate Range: $80,000 - $114,900 DOE
Close Date:
Open Until Filled: Yes
To apply, visit https://utah.peopleadmin.com/postings/165857
jeid-81cb7c8f47f0734286a0c1b231b5e7e0