USA Jobs
IT Database Admin Analyst III - ITS
USA Jobs - Boise, Idaho, United States, 83701
Work at USA Jobs
Overview
- View job
Overview
IT Database Admin Analyst III
Information Technology Services (ITS) currently has an opening for an IT Database Administration Analyst III (DBA III) position in our Chinden office in Boise. The selected individual must possess an in-depth knowledge of how to install and manage large, complex database management systems to ensure the security, quality, and integrity of data resources. Work will be performed in a MS SQL Server and MySQL environment supporting the missions of State of Idaho agencies and citizen digital services. Example of duties: Installs and configures new database server environments Monitors and maintains the availability of databases across numerous servers Manages permissions and access of data across various State agencies Plans and coordinates database migration efforts as environmental requirements and support scopes change over time Designs, implements, reviews and updates stored procedures and functions as required to facilitate state-wide database maintenance efforts Uses SQL tracing to identify root-cause of process breaks Writes SQL scripts to fulfill maintenance needs as they arise Designs, implements, or reconfigures ETL processes as agency needs change Coordinates with development and hosting teams to implement new enterprise-level systems and services Database performance tuning and database storage forecasting Minimum Qualifications: Experience installing, administering and monitoring production databases and database servers Experience training and mentoring staff throughout the organization on the effective and secure use of data Experience monitoring and tuning the performance of databases, queries and indexes Experience developing procedures and controls to ensure database security, integrity and availability Experience resolving complex database problems Experience in database resource planning Special Consideration for: Experience managing Microsoft SQL Server Experience managing MySQL environments Experience creating and managing SSIS packages Experience designing, deploying and managing SSRS reports Experience setting up or maintaining SQL failover cluster environments Experience managing Windows servers in a virtual environment Experience creating and maintaining Azure Data Factory (ADF) workflows and instances 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. 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.
Information Technology Services (ITS) currently has an opening for an IT Database Administration Analyst III (DBA III) position in our Chinden office in Boise. The selected individual must possess an in-depth knowledge of how to install and manage large, complex database management systems to ensure the security, quality, and integrity of data resources. Work will be performed in a MS SQL Server and MySQL environment supporting the missions of State of Idaho agencies and citizen digital services. Example of duties: Installs and configures new database server environments Monitors and maintains the availability of databases across numerous servers Manages permissions and access of data across various State agencies Plans and coordinates database migration efforts as environmental requirements and support scopes change over time Designs, implements, reviews and updates stored procedures and functions as required to facilitate state-wide database maintenance efforts Uses SQL tracing to identify root-cause of process breaks Writes SQL scripts to fulfill maintenance needs as they arise Designs, implements, or reconfigures ETL processes as agency needs change Coordinates with development and hosting teams to implement new enterprise-level systems and services Database performance tuning and database storage forecasting Minimum Qualifications: Experience installing, administering and monitoring production databases and database servers Experience training and mentoring staff throughout the organization on the effective and secure use of data Experience monitoring and tuning the performance of databases, queries and indexes Experience developing procedures and controls to ensure database security, integrity and availability Experience resolving complex database problems Experience in database resource planning Special Consideration for: Experience managing Microsoft SQL Server Experience managing MySQL environments Experience creating and managing SSIS packages Experience designing, deploying and managing SSRS reports Experience setting up or maintaining SQL failover cluster environments Experience managing Windows servers in a virtual environment Experience creating and maintaining Azure Data Factory (ADF) workflows and instances 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. 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.