Utah Retirement Systems

  • Microsoft SQL DBA

    Location US-UT-Salt Lake City
    Posted Date 21 hours ago(11/20/2018 10:30 AM)
    Job ID
    Information Technology
    Minimum Starting Wage
    USD $79,941.89/Yr.
  • About The Company

    Utah Retirement Systems (URS) provides benefits for state and other Utah public employees.  It has two divisions.  The Retirement Office administers pension and retirement savings plans.  PEHP specializes in medical, dental, life, and other benefits.

    Job Description


    Incumbent is heavily involved in the decisions related to systems administration including evaluating feasibility and possible impact on organizational units.  Plans and implements projects as a team leader.  Performs a variety of full performance level professional and complex technical duties as needed to maintain day to day  computer system operations. Duties are divided into four primary areas of emphasis:  project management, systems programming, database administration and systems administration.


    Duties and Responsibilities:

    1. Manages and coordinates activities of assigned projects. Develops and implements a project plan, delegates project assignments and monitors and evaluates project work flow to assure compliance with project plan.
    2. Resolves complex technical issues.
    3. Evaluates team member performance.
    4. Manages critical enterprise security systems for resource security related to internal and external systems and data.
    5. Directs computer operations on systems related tasks.
    6. Schedules system maintenance tasks and directs and approves problem resolutions.
    7. Develops and provides user coordination and training, coordinates user involvement in project plan, provides useable documentation.
    8. Performs complex systems programming for the Midrange and Server operating systems and all associated program products.
    9. Maintains systems software integrity; develops and maintains backup and recovery procedures to assure system protection in the event of hardware/software failure. Assures privacy and security for systems software.  Measures hardware and software performance and statistics.    
    10. Analyzes and modifies software parameters to interface with related software products.
    11. Performs troubleshooting related to software problems. Assesses systems software conditions and determines appropriate action as needed to complete timely repairs and minimize costly down time of the system; tests procedural changes and implements as needed to expedite return to service and operational status of the system. 
    12. Communicates system failure information to vendor then implements and coordinates resolution with vendor and computer operations staff.
    13. Coordinates a variety of hardware and software platforms to maintain connectivity.
    14. Writes and maintains complex special purpose systems software such as user exits and programming tools.
    15. Performs capacity planning on all hardware and software products running in our data centers, makes recommendations for future upgrades.
    16. Identifies IT infrastructure needs for the organization.
    17. Create procedures and processes for software support.
    18. Performs, plans, or manages the installation, maintenance and tuning of systems software, hardware, and database management systems, performs file conversions, integrity and security assurance tests, acceptance tests, etc.
    19. Maintains database integrity; develops and maintains backup and recovery procedures to assure database file protection in the event of hardware/software failure. Assures privacy and security for database software. Measures database usage and performance.
    20. Effectively uses vendor supplied database utilities for data base change requests. Communicates changes in content and structure of database to effected users 
    21. Provides definition and maintenance of user profile and login scripts, directory, subdirectory and file security.
    22. Installs, maintains and supports technical and end-user applications.
    23. Writes implementation plans for all software installs, policies on how to use software, and technical communications to inform users about system software changes and enhancements.
    24. Records all system tasks, tips and techniques, and problem description and resolution in our problem/change management system.
    25. Analyzes, implements and maintains our disaster recovery strategy for software supported.
    26. Plans, directs, and maintains the primary data center infrastructure.
    27. Maintains the Disaster Recovery infrastructure.
    28. Maintains strict confidentiality.
    29. Performs other related duties as required.

    Required Experience

    Education and Experience

    Bachelor Degree in data processing, computer science, engineering or other related field; and seven (7) years of progressively responsible computer systems administration; or an equivalent combination of education and experience.


    Specific experience in data base management, hardware and software systems design and programming preferred.


    CISCO certification, Microsoft certifications, Vmware certifications, HP/Unix certifications preferred.


    Knowledge, Skills, and Abilities

    This list contains knowledge, skills, and abilities that are typically associated with the job. It is not all-inclusive and may vary from position to position:


    Required technical skills include the working knowledge and ability of:

    • Database management.
    • System design concepts.
    • LAN concepts.
    • Programming processes and languages.
    • Information system management concepts.
    • Hardware configurations and capabilities.
    • Differences between batch vs. on‑line systems.
    • Operating system fundamentals.
    • Telecommunication concepts.
    • Data communication concepts.
    • Communication protocols.
    • DNS.
    • Mail systems.
    • SQL.
    • VMware, HP/Unix, Window Server OS, Linux.
    • Security Principles.
    • Virtual Networking.
    • Data switching.
    • Connectivity between multiple computing platforms.
    • Multiple hardware platforms and operating systems, including performance metrics.
    • Function in an environment employing multiple software products understanding the influence and effect each product may or may not have on other software running simultaneously in the system.
    • Analyze a variety of IT issues and problems and make recommendations.
    • Quickly and accurately diagnose and resolve system software problems.


    Must possess excellent communication skills:

    • Requires a thorough knowledge of Project management.
    • Methods and standards for project control.
    • Documentation procedures.
    • Technical writing.
    • Communicate with, organize, and lead a project team.
    • Draft technical reports, documents and agreements.
    • Communicate effectively verbally and in writing.
    • Ability to follow written and verbal instructions.
    • Establish and maintain effective working relationships with professionals, vendors, department heads, co‑workers and the public.
    • Present technical ideas, concepts and procedures to end users and top management.


    Required mathematical skills include working knowledge of:

    • Ability to apply concepts of basic algebra and geometry.
    • Binary and hexadecimal number systems.
    • Metric system.


    Must have the ability to:

    • Follow written and verbal instructions.
    • Prioritize work.
    • Perform within deadlines.
    • Work well in a team environment as well as independently.
    • Multi-task by handling a variety of duties in a timely and efficient manner.
    • Follow through with assignments.
    • Deal effectively with stress caused by workload and time deadlines.

    The incumbent must always demonstrate judgment, high integrity, and personal values consistent with the values of URS.


    Work Environment

    Incumbent performs in a typical office setting with appropriate climate controls. Tasks require a variety of physical activities which do not generally involve muscular strain, but do require activities related to walking, standing, stooping, sitting, reaching, talking, hearing and seeing. Requires occasional lifting of up to 20 lbs. Common eye, hand, finger dexterity required to perform essential functions. 



    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed