Senior Database Administrator

S R INTERNATIONAL INC•Phoenix, AZ

7d•Hybrid

About The Position

This is a 4-month contract-to-hire position for a Senior Database Administrator at the Arizona Department of Education. The role involves managing all aspects of the department's data, including database backup and recovery, logical and physical database design, disaster recovery, performance tuning, upgrades, and installation of SQL Server. The position also requires configuring and supporting Power BI datasets and gateways, designing and developing stored procedures, and optimizing SQL queries. Collaboration with application and BI teams, implementation of version control and DevOps practices, and occasional in-state travel are also part of the responsibilities. The role requires strong PowerShell scripting skills for job automation and offers a hybrid work environment with up to two days of remote work, contingent upon business needs, with the ability to work in-office up to five days per week as needed.

Requirements

Power BI experience
Disaster recovery
SQL Server
Management of Azure database virtual machines
Implement version control and DevOps practices for database objects
A Bachelor’s degree plus five or more years of experience in database administration, or equivalent experience to substitute for the degree, is required.
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
Demonstrated ability to work collaboratively in teams and across organizations
Demonstrated ability to synthesize feedback and adjust plans accordingly
Demonstrated ability to build strong relationships inside and outside the organization
Demonstrated ability to develop and write technical documentation
Demonstrated ability to model and design relational databases
Demonstrated ability to install and support relational database management systems (RDMS)
Demonstrated ability to evaluate and test emerging technologies
Demonstrated ability to apply creative solutions to business problems to ensure business needs are most effectively met
Demonstrated ability to develop PowerShell scripts for automation and administrative tasks
Demonstrated ability to configure and support Power BI datasets, gateways, and refresh schedules

Nice To Haves

Designing and writing stored procedures
Design and implement ETL processes for data integration and transformation
Develop and optimize complex SQL queries and stored procedures
PowerShell
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
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.

Responsibilities

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.
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.