University of Utah
Database Administrator Sr
University of Utah, Salt Lake City, Utah, United States, 84193
Flexible primarily normal business hours with occasional nights and weekends, with on-call weekly rotation every 5-6 weeks.VP Area : VP Area PresidentDepartment : [Department]Location : [Location Campus]City : Salt Lake City, UTType of Recruitment : External PostingPay Rate Range : $74,000 - $109,000Close Date : Open Until FilledJob Summary : UETN provides network and IT solutions for educational institutions (Higher Education, K12, Libraries, Zoo, Aquarium, and other sites) throughout Utah. This position is integral in providing systems and services to all UETN stakeholders.
We are looking for a Senior Database & Systems Administrator. You’ll be joining a team that is responsible for managing storage, server, and virtual hosting infrastructures.
Senior Database & System Administrator responsibilities include traditional database administration; monitoring system performance; and configuring software and hardware. To be successful in this role, you should have excellent troubleshooting skills and hands-on experience with various database platforms and operating systems. Activities include but are not limited to the following:Develops, implements, administers, and maintains policies and procedures ensuring the security and integrity of the UETN’s databases.Implements data models, database designs, data access, and table maintenance.Resolves database performance, capacity, replication, and other distributed data issues.Works with the applications team to design database objects that meet business requirements and production standards. This requires obtaining application knowledge while working with architects, data modelers, and application developers.Ensures the performance of the databases and application code from development to production.Installs and migrates object changes through multiple test environments and production.Works on complex projects with software design engineers.Develops and implements database recovery plans and procedures.Installs, upgrades, and tests database software.Works on multiple projects simultaneously which span multiple application releases.Maintains database and systems servers to current patch levels and works with developers to ensure compatibility with the application code base.Maintains systems that support application development and data analysis.Serves as System Administrator for database and web-tier application servers.Responsibilities :Serves as Database Administrator for UETN Enterprise Operations Support.Maintain and administer PostgreSQL and MSSQL Database servers for applications supporting users on multiple remote campus sites.Manage a PostgreSQL cluster with streaming replication using Pgpool-II.Administer and configure Apache, Tomcat, and various other application platforms.Maintain and support software development tools, Bitbucket, Jenkins, and SonarQube.Monitor services for functionality and end-user accessibility.Maintain existing software versions, updates, and patches to maintain current levels.Plan, organize, and implement necessary technology to meet institutional needs.Assist UETN technical staff to develop and implement standard backup and recovery procedures and contribute to a complete disaster recovery plan.Work with other institutional and UETN Enterprise Application Support staff to resolve issues efficiently.Respond to computer support help requests and resolve hardware and software problems in a timely and amicable manner.Document methods and resources used to resolve issues.Set up and configure new servers and services as needed.Assist in project-based system administration tasks.Minimum Qualifications : Require 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 at least 5 years of experience in database administration or in a related area. Familiar with a variety of the field’s concepts, practices, and procedures. Relies on extensive experience and judgment to plan and accomplish goals.
Applicants must demonstrate the potential ability to perform the essential functions of the job as outlined in the position description.Preferences :Experience with PostgreSQL, Pgpool-II, and MSSQL.Experience with Ubuntu Linux, Ansible, and Bash Scripting.Experience with Atlassian products (Jira, Confluence, Bitbucket, etc.).Ability to learn and adapt to changes in industry technologies and platforms.Demonstrated problem solver.Experience with identity access management tools and concepts, RBAC, ABAC, and PBAC.Additional Information : UETN is a business unit of the University of Utah responsible for the state’s education and telehealth IT infrastructure and associated services including KUEN public television.
About the University of Utah : Located in Salt Lake City, the U is the flagship institution of the State of Utah’s system of higher education, home to arts and museum venues and a member of the Pac-12 Conference. Skiing and snowboarding opportunities are a short distance from campus, and opportunities to pursue activities from biking to hiking to fishing abound. Salt Lake City is home to the Utah Symphony and Opera, Ballet West, professional sports teams, and a wide range of other cultural and recreational activities.The University is a participating employer with Utah Retirement Systems (“URS”). Eligible new hires with prior URS service may elect to enroll in URS if they make the election before they become eligible for retirement (usually the first day of work). Contact Human Resources at (801) 581-7447 for information. Individuals who previously retired and are receiving monthly retirement benefits from URS are subject to URS’ post-retirement rules and restrictions.This position may require the successful completion of a criminal background check and/or drug screen.The University of Utah values candidates who have experience working in settings with students and patients from all backgrounds and possess a strong commitment to improving access to higher education and quality healthcare for historically underrepresented students and patients.All qualified individuals are strongly encouraged to apply. Veterans’ preference is extended to qualified applicants, upon request and consistent with University policy and Utah state law. Upon request, reasonable accommodations in the application process will be provided to individuals with disabilities.The University of Utah is an Affirmative Action/Equal Opportunity employer and does not discriminate based upon race, ethnicity, color, religion, national origin, age, disability, sex, sexual orientation, gender, gender identity, gender expression, pregnancy, pregnancy-related conditions, genetic information, or protected veteran’s status.To request a reasonable accommodation for a disability or if you or someone you know has experienced discrimination or sexual misconduct including sexual harassment, you may contact the Director/Title IX Coordinator in the Office of Equal Opportunity and Affirmative Action (OEO/AA). More information, including the Director/Title IX Coordinator’s office address, electronic mail address, and telephone number can be located at:
https://www.utah.edu/nondiscrimination/Posting Specific Questions
Required fields are indicated with an asterisk (*).* Do you have a related Bachelor's degree or equivalency? (2 years related work experience may be substituted for 1 year of education)
YesNo
* How many years of database administration or related experience do you have?
Less than 5 years5 years or more, but less than 8 years8 years or more, but less than 12 years12 years or more, but less than 15 years15 years or more
* How did you hear about this position?
University of Utah Web PageInternet: search engine, online job board, etc.University of Utah employee referralCareer Services/Campus Job FairCommunity/Government AgencyOther/Unknown
* How did you hear about this position? Please specify the name of the job board, community, education, government agency, search engine, etc. used to find out about this position. (Open Ended Question)
Required Documents :ResumeCover LetterList of ReferencesOptional Documents :
Appropriate discharge document (such as a DD-214 – Member Copy 4) – Veteran Only – Call 801.581.2169Addendum to the University of Utah - Veteran Only - Call 801.581.2169 after submissionUniversity Human Resource Management250 East 200 South, Suite 125 Salt Lake City, UT 84111Contact us: (801) 581-2169 By Email: employment@utah.edu
#J-18808-Ljbffr
We are looking for a Senior Database & Systems Administrator. You’ll be joining a team that is responsible for managing storage, server, and virtual hosting infrastructures.
Senior Database & System Administrator responsibilities include traditional database administration; monitoring system performance; and configuring software and hardware. To be successful in this role, you should have excellent troubleshooting skills and hands-on experience with various database platforms and operating systems. Activities include but are not limited to the following:Develops, implements, administers, and maintains policies and procedures ensuring the security and integrity of the UETN’s databases.Implements data models, database designs, data access, and table maintenance.Resolves database performance, capacity, replication, and other distributed data issues.Works with the applications team to design database objects that meet business requirements and production standards. This requires obtaining application knowledge while working with architects, data modelers, and application developers.Ensures the performance of the databases and application code from development to production.Installs and migrates object changes through multiple test environments and production.Works on complex projects with software design engineers.Develops and implements database recovery plans and procedures.Installs, upgrades, and tests database software.Works on multiple projects simultaneously which span multiple application releases.Maintains database and systems servers to current patch levels and works with developers to ensure compatibility with the application code base.Maintains systems that support application development and data analysis.Serves as System Administrator for database and web-tier application servers.Responsibilities :Serves as Database Administrator for UETN Enterprise Operations Support.Maintain and administer PostgreSQL and MSSQL Database servers for applications supporting users on multiple remote campus sites.Manage a PostgreSQL cluster with streaming replication using Pgpool-II.Administer and configure Apache, Tomcat, and various other application platforms.Maintain and support software development tools, Bitbucket, Jenkins, and SonarQube.Monitor services for functionality and end-user accessibility.Maintain existing software versions, updates, and patches to maintain current levels.Plan, organize, and implement necessary technology to meet institutional needs.Assist UETN technical staff to develop and implement standard backup and recovery procedures and contribute to a complete disaster recovery plan.Work with other institutional and UETN Enterprise Application Support staff to resolve issues efficiently.Respond to computer support help requests and resolve hardware and software problems in a timely and amicable manner.Document methods and resources used to resolve issues.Set up and configure new servers and services as needed.Assist in project-based system administration tasks.Minimum Qualifications : Require 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 at least 5 years of experience in database administration or in a related area. Familiar with a variety of the field’s concepts, practices, and procedures. Relies on extensive experience and judgment to plan and accomplish goals.
Applicants must demonstrate the potential ability to perform the essential functions of the job as outlined in the position description.Preferences :Experience with PostgreSQL, Pgpool-II, and MSSQL.Experience with Ubuntu Linux, Ansible, and Bash Scripting.Experience with Atlassian products (Jira, Confluence, Bitbucket, etc.).Ability to learn and adapt to changes in industry technologies and platforms.Demonstrated problem solver.Experience with identity access management tools and concepts, RBAC, ABAC, and PBAC.Additional Information : UETN is a business unit of the University of Utah responsible for the state’s education and telehealth IT infrastructure and associated services including KUEN public television.
About the University of Utah : Located in Salt Lake City, the U is the flagship institution of the State of Utah’s system of higher education, home to arts and museum venues and a member of the Pac-12 Conference. Skiing and snowboarding opportunities are a short distance from campus, and opportunities to pursue activities from biking to hiking to fishing abound. Salt Lake City is home to the Utah Symphony and Opera, Ballet West, professional sports teams, and a wide range of other cultural and recreational activities.The University is a participating employer with Utah Retirement Systems (“URS”). Eligible new hires with prior URS service may elect to enroll in URS if they make the election before they become eligible for retirement (usually the first day of work). Contact Human Resources at (801) 581-7447 for information. Individuals who previously retired and are receiving monthly retirement benefits from URS are subject to URS’ post-retirement rules and restrictions.This position may require the successful completion of a criminal background check and/or drug screen.The University of Utah values candidates who have experience working in settings with students and patients from all backgrounds and possess a strong commitment to improving access to higher education and quality healthcare for historically underrepresented students and patients.All qualified individuals are strongly encouraged to apply. Veterans’ preference is extended to qualified applicants, upon request and consistent with University policy and Utah state law. Upon request, reasonable accommodations in the application process will be provided to individuals with disabilities.The University of Utah is an Affirmative Action/Equal Opportunity employer and does not discriminate based upon race, ethnicity, color, religion, national origin, age, disability, sex, sexual orientation, gender, gender identity, gender expression, pregnancy, pregnancy-related conditions, genetic information, or protected veteran’s status.To request a reasonable accommodation for a disability or if you or someone you know has experienced discrimination or sexual misconduct including sexual harassment, you may contact the Director/Title IX Coordinator in the Office of Equal Opportunity and Affirmative Action (OEO/AA). More information, including the Director/Title IX Coordinator’s office address, electronic mail address, and telephone number can be located at:
https://www.utah.edu/nondiscrimination/Posting Specific Questions
Required fields are indicated with an asterisk (*).* Do you have a related Bachelor's degree or equivalency? (2 years related work experience may be substituted for 1 year of education)
YesNo
* How many years of database administration or related experience do you have?
Less than 5 years5 years or more, but less than 8 years8 years or more, but less than 12 years12 years or more, but less than 15 years15 years or more
* How did you hear about this position?
University of Utah Web PageInternet: search engine, online job board, etc.University of Utah employee referralCareer Services/Campus Job FairCommunity/Government AgencyOther/Unknown
* How did you hear about this position? Please specify the name of the job board, community, education, government agency, search engine, etc. used to find out about this position. (Open Ended Question)
Required Documents :ResumeCover LetterList of ReferencesOptional Documents :
Appropriate discharge document (such as a DD-214 – Member Copy 4) – Veteran Only – Call 801.581.2169Addendum to the University of Utah - Veteran Only - Call 801.581.2169 after submissionUniversity Human Resource Management250 East 200 South, Suite 125 Salt Lake City, UT 84111Contact us: (801) 581-2169 By Email: employment@utah.edu
#J-18808-Ljbffr