IT Database Admin Analyst II - ITS

Description

Information Technology Services - ITS

State of Idaho Opportunity

Summary:

Information Technology Services is a team of dedicated professionals providing core technology and cybersecurity services to agencies statewide, enabling state employees to serve Idaho's citizens.

Information Technology Services (ITS) currently has an opening for a Database Administration Analyst II in Boise. This position provides database administration support to a diverse customer base representing numerous State agencies. This position will provide direct customer support in database maintenance, management and administration functions to include troubleshooting, disaster recovery, problem resolution, database design and development, and management and development of SQL scripts and Stored Procedures

The selected individual must possess an in-depth knowledge of Microsoft SQL Server and MySQL database support within a large enterprise environment and should also possess excellent time management skills with the ability to maintain multiple priorities.

Please note: The successful candidates will be required to pass multiple, comprehensive fingerprint-based background checks specific to the agencies ITS supports.

Example of Duties

• Provides daily support for multiple enterprise database platforms, primarily utilizing Microsoft SQL Server and MySQL, including the design, development, upgrades, troubleshooting, SQL scripting development, Stored Procedure development, backup and recovery and other database management, development and administrative functions;
• Develops a variety of reports;
• Participates in on-call rotation for afterhours support;
• Provides remote and on-site support to a wide variety of customers and supported systems as needed;
• Works closely with software developers in support of application development, software enhancements and systems integration activities as needed;
• Interprets and implements database changes and enhancements from user requirements;
• Monitors and optimizes database performance;
• Monitors, manages and tests backup, restore and database functions.

Minimum Qualifications

• Good knowledge of relational database principles and data normalization.

  Typically gained by obtaining an associate's degree or certification related to relational database concepts and data normalization OR at least one (1) year of full-time work experience (including combination of work experience and internships) regularly working with and supporting relational databases as part of your primary job responsibilities.

• Good knowledge of Structured Query Language (SQL).

  Typically gained by current certification related to Structured Query Language (SQL) design or administration AND at least one (1) year of full-time work experience (including combination of work experience and internships) writing, testing, and utilizing SQL as part of your primary job responsibilities OR at least two (2) years of full-time work experience (including combination of work experience and internships) writing, testing, and utilizing SQL as part of your primary job responsibilities.

• Experience installing, administering, and monitoring production databases and database servers.

  Typically gained through at least one (1) year of full-time work experience (including combination of work experience and internships) installing, administering and monitoring production databases and database servers as part of your primary job responsibilities.

• Experience technically interacting directly with clients to analyze customer needs.

  Typically gained by at least one (1) year of full-time work experience (including combination of work experience and internships) interacting with clients to analyze customer needs as part of your primary job responsibilities. 

Applications will be accepted through 4:59 PM MST on the posting end date. 

Benefits:

The State of Idaho offers a robust total compensation package, including medical, vision, and dental insurance; PERSI retirement benefits; paid sick, vacation, and parental leave; and 11 paid holidays per year. For additional information related to benefits and/or State programs, please visit https://dhr.idaho.gov/StateEmployees/Benefits.html.

EEO/ADA/Veteran:

The State of Idaho is committed to providing equal employment opportunities and prohibit discrimination against qualified individuals based on their status as protected veterans or individuals with disabilities and prohibit discrimination against all individuals based on their race, color, religion, political affiliation or belief, sex, national origin, genetics, or any other status protected under applicable federal, state, or local laws.

The State of Idaho is committed to access and reasonable accommodations for individuals with disabilities, auxiliary aids and services are available upon request. If you require an accommodation at any step in our recruitment process, you are encouraged to contact (208) 334-2263 (TTY/TTD: 711), or email [email protected].

Preference may be given to veterans who qualify under state and federal laws and regulations.