Phoenix, AZ - IT - AZED - Information Technology Division (IT) - Database Administrator - Senior Database Administrator

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. Knowledge, Skills & Abilities (KSAs): Knowledge in: " General working knowledge of physical data models, technical architecture, system interfaces, etc.

This is a 4 month contract to hire position. All candidates must be eligible to convert to an FTE. The State is unable to sponsor any visas. In office 2-3 days onsite first week then once a month or as needed. Local to Phoenix only.

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 effectively
" Develop PowerShell scripts for automation and administrative tasks
" Configure and support Power BI datasets, gateways, and refresh schedules