DATABASE ADMINISTRATOR SENIOR

Job Summary :

Responsible for assisting with the management of all aspects of the Arizona Department of Education's (ADE) data including but not limited to :

• Database backup and recovery
• Logical and physical database design
• Designing and writing stored procedures
• Disaster recovery
• Database maintenance, connectivity, replication, performance and tuning, upgrades, naming conventions and standards
• Installation and configuration of database software (SQL Server)
• Diagnosing and correcting database operational problems
• Strong PowerShell scripting skills for jobs automation
• Configure and support Power BI datasets, gateways, and refresh schedules
• Design and develop stored procedures, functions, and triggers
• Develop and optimize complex SQL queries and stored procedures for reporting and analytics
• Design and implement ETL processes for data integration and transformation
• Collaborate with application and BI teams to support data-driven solutions
• Implement version control and DevOps practices for database objects
• Occasional in-state travel is required for this position

The Arizona Department of Education currently utilizes a hybrid work environment, with up to two days of remote work (contingent upon business needs). Candidates should apply with an ability and willingness to work in-office up to five days per week as business needs necessitate.

Job Duties :

Knowledge, Skills & Abilities (KSAs) :

Knowledge in :

Skills can be acquired by trouble shooting software and hardware issues in a generic computer environment. Logical prowess can be cultivated in basic mathematics training, puzzle solving, formal logic training.

Skills in :

Demonstrated ability to :

Selective Preference(s) :

N / A

Pre-Employment Requirements :

Offers are contingent upon successful completion of all background and reference checks, required documents and, if applicable, a post-offer medical / physical evaluation.

If this position requires driving or the use of a vehicle as an essential function of the job to conduct State business, then the following requirements apply :

All newly hired State employees are subject to and must successfully complete the Electronic Employment Eligibility Verification Program (E-Verify).

Benefits :

The State of Arizona provides an excellent comprehensive benefits package including :

Learn more about the Paid Parental Leave pilot program . For a complete list of benefits provided by The State of Arizona, please visit our

Retirement :

You will be required to participate in the Arizona State Retirement System (ASRS) upon your 27th week of employment, subject to waiting period. On or shortly after, your first day of employment you will be provided with enrollment instructions and effective date.