AZED (IT) SQL Server DBA with Powershell or Power BI 10154 C TO H (Hybrid)

AZED - Req # 10154 - SQL Database Administrator with Powershell/Power BI(Hybrid)

contract to hire position - Local AZ candidtaes Only

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

• 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

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 Educations (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 databases

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