Database Warehouse Analyst jobs in Idaho

Description

DEDICATED TO STRENGTHENING THE HEALTH, SAFETY, AND INDEPENDENCE OF IDAHOANS

People Making a Difference!

***THIS ANNOUNCEMENT WILL BE OPEN UNTIL FILLED. APPLICANTS ARE ENCOURAGED TO APPLY AS SOON AS POSSIBLE TO BE CONSIDERED.

Join an agency which serves and supports the health and well-being of Idahoans. The IT Services Division has an opportunity for one Database Administrator to 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.

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.

BENEFITS:

BEST RETIREMENT AVAILABLE IN THE NATION

We have one of the Nation's best state retirement systems (PERSI) that offers a lifetime benefit.

OTHER EXCELLENT BENEFITS

• Excellent medical, dental and vision insurance- (full-time/30 hours per week) employee only coverage for PPO $65/month for medical and vision & $11.80/month for dental
• Generous vacation and sick leave accrual beginning as soon as you start
• 11 paid holidays a year
• Paid parental leave
• Multiple savings plans, optional 401K, and optional 457
• Basic life insurance for employee and family (employee covered at one times annual salary; spouse covered at $10,000; child covered at $5,000)
• Wellness programs
• Ongoing training opportunities
• An opportunity for student loan forgiveness
• And more!

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 five years of work experience.
• Experience with Performance Tuning and Optimization (PTO) of databases. Typically gained by five 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 by a minimum of two years work experience.
• Securing Data at Rest, Masking Data, patching SQL databases that run on Windows Servers. Typically gained by at a minimum of two years of work experience.
• 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.