SQL Server DBA – Hybrid (Contract‑to‑Hire) | Power BI & Azure

vTech Solution; Phoenix (AZ); Hybrid; USD 90,000 - 130,000; Full time

Job summary

The Arizona Department of Education's Information Technology Division seeks a Database Administrator to oversee SQL Server environments, design databases, implement backup/recovery, performance tuning, and disaster recovery. The role involves PowerShell automation and configuring Power BI workspaces, datasets, and refresh schedules, with in-state travel.

This contract-to-hire position requires in-person work primarily in Phoenix, AZ, with hybrid options.

Qualifications

• Bachelor's degree or equivalent in database administration.
• Extensive experience with SQL Server versions 2000 through 2022.
• Proficiency in Transact-SQL, stored procedures, and performance tuning.
• Experience with Azure database virtual machines and disaster recovery planning.
• Strong PowerShell scripting skills for automation.

Responsibilities

• Manage database backup, recovery, and disaster recovery planning.
• Design and maintain logical and physical database structures.
• Develop and optimize stored procedures, functions, triggers, and complex SQL queries.
• Install, configure, and upgrade SQL Server database software.
• Monitor and tune database performance and troubleshoot operational issues.
• Automate database administration tasks using PowerShell scripting.
• Configure and support Power BI datasets, gateways, and refresh schedules.
• Design and implement ETL processes and build SSIS packages for data integration.
• Collaborate with IT staff to define system requirements related to data storage and retrieval.
• Review and improve existing database architecture and code.
• Manage Azure database virtual machines and SQL Server Always On configurations.
• Develop and maintain database migration and version control procedures.
• Provide on-call support for database issues and assist with off-hours processes.
• Assist in interviewing, training new hires, and mentoring junior developers.
• Document database procedures, standards, and educate users.
• Perform database maintenance, including purging and archiving historical data.
• Implement and enforce database security guidelines and mechanisms.
• Occasionally travel within the state as required.

Skills

Communication skills

Customer service

Team collaboration

Mentoring juniors

Education

Bachelor's degree in database administration

Tools

SQL Server

Azure SQL Database VMs

PowerShell

Power BI

SSIS

SQL Server Clustering

Always On Availability Groups

Job description

The Arizona Department of Education's Information Technology Division seeks a Database Administrator to oversee SQL Server environments, design databases, implement backup/recovery, performance tuning, and disaster recovery. The role involves PowerShell automation and configuring Power BI workspaces, datasets, and refresh schedules, with in-state travel.

This contract-to-hire position requires in-person work primarily in Phoenix, AZ, with hybrid options.