IDOC - IT Database Admin Analyst III

Description

State of Idaho Opportunity

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

Summary:

The Idaho Department of Correction (IDOC) is seeking an IT Database Administration Analyst III, who can perform a full range of hands-on functions in the design, analysis, installation, maintenance, and security of database systems. This position requires experience with SQL Server and operational relationships with databases and applications. The location of the position is within the Information Technology department of IDOC located at the Central Office in Boise, Idaho. THIS IS NOT A REMOTE POSITION.

Primary responsibilities of the position include analyzing data needs throughout the agency and planning solutions to securely provide needed data through various channels. Incumbents interface with customers, developers, and network engineers to establish, administer and secure databases and database servers. Solutions utilize a variety of data management products to ensure consistent, secure, and meaningful availability of data. 

Responsibilities:

1. Database installation, performance tuning, monitoring, and database storage forecasting. 
2. Research opportunities to improve database technology standards and identify best practices. 
3. Ensure effective management of assigned databases and associated applications to provide uninterrupted availability of information to users. 
4. Design and implement procedures and controls necessary to protect information system data. 
5. Provide guidance and direction both within IT and among users for the effective and secure use of organizational data. 

Minimum Qualifications: 

1. Experience installing, administering, and monitoring production databases and database servers. Typically gained by a minimum of one year of full-time work experience where installing, administering, and monitoring production databases and database servers was part of your primary job functions. 
2. Experience monitoring and tuning the performance of databases, queries, and indexes. Typically gained by a minimum of one year of full-time work experience where you regularly monitored and tuned the performance of databases, queries, and indexes as part of your primary responsibilities. 
3. Experience developing procedures and controls to ensure database security. Typically gained by a minimum of one year of full-time work experience where you developed procedures and controls to ensure database security, integrity, and availability. 
4. Experience resolving complex database problems. Typically gained by a minimum of two years of full-time work experience where you resolved complex database problems as part of your primary job functions OR at least one year of full-time work experience where you resolved various level-three database escalation tickets as your primary job responsibility. 
5. Experience training and mentoring staff throughout the organization on the effective and secure use of data. Typically gained by a minimum of one year of full-time work experience where training and mentoring staff throughout the organization on the effective and secure use of data was part of your primary job responsibilities. 
6. Experience planning database resources. Typically gained by a minimum of one year of full-time work experience where database resource planning was part of your primary job responsibilities. 

Desirable Qualifications:

1. Experience installing, developing, and maintaining SQL Server databases. 
2. Solid understanding of Always on Availability Groups. 
3. Experience creating and scheduling SSIS packages. 
4. Expertise in creating stored procedures. 
5. Excellent problem-solving and analytical skills. 

Hiring Information:

• This is not a remote position. 
• IDOC requires a background investigation. In addition, federal law prohibits individuals who have previously been convicted of a felony from working in the IT department of any state agency. 
• You must be eligible to work in the US; IDOC cannot sponsor work visa candidates. 

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.