THIS POSITION IS ONLY FOR CURRENT ARIZONA RESIDENTS
SOAZ-Req # 10154 - Phoenix, AZ - IT - AZED - Information Technology Division (IT) - Database Administrator (Hybrid)
Contract to hire position
Location: Phoenix, AZ 85007
Closing Date & Time: 3/9/26@ 2 PM
Required Skills
- Either PowerShell scripting or Power BI experience (need to have one or the other)
- Disaster recovery
- SQL Server
- Management of Azure database virtual machines
- Implement version control and DevOps practices for database objects
- Logical and physical database design
Preferred Skills
- Designing and writing stored procedures
- Design and implement ETL processes for data integration and transformation
- Develop and optimize complex SQL queries and stored procedures
- Implement indexing strategies for performance improvement
Job Description:
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 effectively
• Develop PowerShell scripts for automation and administrative tasks
• Configure and support Power BI datasets, gateways, and refresh schedules