Database and Systems Administrator Sr - Salt Lake City, United States - University of Utah

    University of Utah
    University of Utah Salt Lake City, United States

    Found in: One Red Cent US C2 - 1 week ago

    Default job background
    Description
    Database and Systems Administrator Sr.

    Job 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 to 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.
    Special Instructions


    Requisition Number:
    PRN38269B

    Full Time or Part Time? Full Time

    Work Schedule Summary:
    Flexible primarily normal Business hours with occasional nights and weekends, with On-call weekly rotation every 5-6 weeks.

    Department:
    KUEN/Utah Education Network


    Location:
    Campus

    Pay Rate Range:
    $74,000 - $109,000

    Close Date:

    Open Until Filled:
    Yes

    To apply, visit

    jeid-b7963121c18ea14cace85a6d9d84e58e