Job description

Description DEDICATED TO STRENGTHENING THE HEALTH, SAFETY, AND INDEPENDENCE OF IDAHOANS • THIS ANNOUNCEMENT WILL BE OPEN UNTIL FILLED. APPLICANTS ARE ENCOURAGED TO APPLY AS SOON AS POSSIBLE TO BE CONSIDERED. The Idaho Department of Health and Welfare, IT Services Division has an opportunity for one IT Database Administrator Analyst IIIto join the Applications Development Team. This position provides an opportunity to serve the citizens of Idaho. We seek candidates who have excellent interpersonal and teamwork skills, a positive attitude with the skills to move forward in the ever changing world of Technology. The State of Idaho allows for Work/Life balance, and flex schedules including a hybrid (remote and on-site) option. This position is located in downtownBoise. If you have previously applied for IT Database Analyst Ill and wish to be considered for this vacancy, you must reapply under this announcement. Previous scores will not be used. This announcement may be used to fill future vacancies. If relocating to Idaho, the Department of Health & Welfare does not reimburse the cost of relocating. The department does not sponsor anyone with a work visa. This position may be eligible for telework after successful completion of probation and necessary training. Approval to telecommute is not guaranteed and subject to termination at any time. Benefits BEST RETIREMENT AVAILABLE IN THE NATION We have one of theNation's best state retirement systems(PERSI)that offers alifetime benefit. Other Excellent Benefits • 11paid holidays • Generous vacation and sick leaveaccrual beginning as soon as you start • Paid parental leave • Medical, dental, vision insurance - incredible rates!(full-time/30+ hours per week) • PERSI Choice 401(k) • Deferred compensation plan • Life insurance • Short and long-term disability insurance • Student Loan Forgiveness • Wellness programs • Employee Assistance Program (EAP) • Flexible Spending Accounts (FSA) • Wide variety of training opportunities • Some positions offer flexible hours and/or telecommuting Example Of Duties • Design and install large, complex database management systems; ensure the security, quality, and integrity of data resources; perform related work. • Research opportunities to improve database technology standards and identify best practices. • Ensure effective management of assigned databases and associated applications to provide uninterrupted availability of information to users. • Design and implement procedures and controls necessary to protect information system data. • Provide guidance and direction both within IT and among users for the effective and secure use of organizational data. Includes database performance tuning and database storage forecasting. • Provide on-call support to production databases outside normal work hours, on a rotating basis with other team members Minimum Qualifications You must possess all the minimum qualifications below to pass the exam for this position. Please make sure your resume or work history supports your meeting the minimum qualifications for this position. Failure to do this may disqualify you from being considered for this position.It is highly recommended to attach a one-page cover letter to your application to demonstrate how you meet the requirements below. • 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. • 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. • Experience developing procedures and controls to ensure database security, integrity and availability.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. • 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. • 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. • Experience in database resource planning.Typically gained by a minimum of one year of full-time work experience where database resource planning was part of your primary job responsibilities. Below is preferred experience. It is not required for the position but applicants with this experience may receive consideration over other applicants. • Experience as a SQL Server DBA in a Windows Server Environment.Typically gained by 5 years of work experience. • Experience with Performance Tuning and Optimization (PTO) of databases.Typically gained by 5 years of work experience. • Backups, Restores, recovery models including High Availability (HA) and Disaster Recovery (DR) options for SQL Server in a clustered environment.Typically gained through a minimum of 2 years work experience. • Securing Data at Rest, Masking Data, patching SQL databases that run on Windows Servers.Typically gained by at a minimum of 2 years work experience. • Please provide any experience in administration in the following SQL areas: SQL Server Reporting Services (SSRS), SQL Server Integrated Services (SSIS), Data Warehousing and Azure SQL Database.Typically gained by a minimum of 2 years experience Learn About a Career With DHW • PLEASE NOTE: application assistance is not available after the business hours listed below, on the weekends, or on holidays and you must apply before 4:59 pm on the closing date. When applying, use CHROME as your browser to avoid complications. If You Have Questions, Please Contact Us At Email is the quickest way to get an answer to your questions. (answered Monday through Friday during business hours MST) EMAIL:dhwjobs@dhw.idaho.gov PHONE:(208) 334-0681 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 ada.coordinator@dhr.idaho.gov. Preference may be given to veterans who qualify under state and federal laws and regulations.

Requirements