Job No: 542183
Work Type: Full-time
Location: PHOENIX
Categories: Information Technology/Services
Department of Education The Arizona Department of Education is a service organization committed to raising academic outcomes and empowering parents.
Job Location:
Address: Information Technology Division
Phoenix, AZ 85007
Posting Details:
Salary: $85,000 - $90,000
Grade: 27
Closing Date: 07/15/26
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:
Assist and cross-train in the work of other database administrators
Review and recommend improvements to existing architecture
Tune performance, review, and recommend improvements to existing code
Meet with other IT staff to determine scope of system requirements related to data storage, retrieval, and performance
Design and code stored procedures and scripts to facilitate database administration (Powershell experience desired)
Develop database administration tools/utilities/operation procedures
Assist in developing purge/archive criteria and procedures for historical application data
Proactively solve complex problems
Review, evaluate, design, implement and maintain company database[s]
Implement and review appropriate security guidelines/mechanisms
Implement database migrations and changes
Management of Azure database virtual machines
Troubleshoot application key selection, creation of appropriate indexes, and query needs
Ensure that databases are operational and functioning properly
Perform database maintenance functions
Move, rebuild, or change database objects as required in production
Develop and test database migration procedures
Manager Power BI Configuration
Assist in interviewing and training new hires and provide guidance to Junior Developers when required
Manage SQL Server Always On configurations
Provide on-call support to correct database issues or assist with other processes that require off-hours support
Educate users and maintains database documentation
Establish database procedures and standards; assists in database design
Writing PowerShell scripting
Design, develop, and optimize stored procedures, functions, and queries
Implement indexing strategies for performance improvement
Build and maintain SSIS packages for ETL workflows
Other duties as assigned as related to the position
Knowledge, Skills & Abilities (KSAs):
Knowledge in:
General working knowledge of physical data models, technical architecture, system interfaces, etc.
Database Software: SQL Server 2000 - SQL Server 2022
Hardware installation and configuration (Azure)
SQL Server Clustering
Transact-SQL and stored procedure design
Database performance tuning and replication
Disaster recovery planning
Backup/recovery planning
SQL Server Always On groups
Power BI Configuration
Powershell scripting
A Bachelor's degree plus five or more years of experience in database administration, or equivalent experience to substitute for the degree, is required.
? 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:
Strong customer service skills
Excellent interpersonal, written and oral communication skills
Analysis and problem solving for complex information and data collection systems
Intermediate to advanced skill in using Microsoft Outlook, Word, and Excel
Demonstrated ability to:
Balance, prioritize and organize multiple tasks
Work collaboratively in teams and across organizations
Synthesize feedback and adjust plans accordingly
Build strong relationships inside and outside the organization
Develop and write technical documentation
Model and design relational databases
Install and support relational database management systems (RDMS)
Evaluate and test emerging technologies
Apply creative solutions to business problems to ensure business needs are most effective
Develop PowerShell scripts for automation and administrative tasks
Configure and support Power BI datasets, gateways, and refresh schedules
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: Driver's License Requirements. (https://publicstorage.dc4.pageuppeople.com/1045/ClientPublicFile/3601803f-02e5-4b70-b325-26c8ef309c1b.pdf)
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:
Affordable medical, dental, life, and short-term disability insurance plans
Top-ranked retirement and long-term disability plans
Ten paid holidays per year
Vacation time accrued at 4.00 hours bi-weekly for the first 3 years
Sick time accrued at 3.70 hours bi-weekly
Paid Parental Leave-Up to 12 weeks per year paid leave for newborn or newly-placed foster/adopted child (pilot program).
Deferred compensation plan
Wellness plans
Learn more about the Paid Parental Leave pilot program here (https://hr.az.gov/about/resources/family-leave-expansion) . For a complete list of benefits provided by The State of Arizona, please visit our benefits page (https://benefitoptions.az.gov/jobseekers)
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.
Contact Us:
The State of Arizona is an Equal Opportunity/Reasonable Accommodation Employer. Persons with a disability may request a reasonable accommodation such as a sign language interpreter or an alternative format by calling (602) 542-3186 or emailing Human.Resources@azed.gov. Requests should be made as early as possible to allow sufficient time to arrange the accommodation.
