SQL Server DBA --- F2F

Humac, Inc.

Phoenix, AZ, United States

6 days ago

Apply on www.dice.com

Prepare application

Role details

Contract type

Temporary to permanent

Employment type

Full-time (> 32 hours)

Experience level

Expert

Working hours

Regular working hours

Job source

www.dice.com

Tech stack

Microsoft Word Microsoft Excel Microsoft Azure Microsoft Outlook Cluster Analysis Databases Data Integration Extract Transform Load (ETL) DevOps Disaster Recovery Microsoft SQL Server SQL Azure

+15 more

Performance Tuning Windows PowerShell Power BI SQL Stored Procedures Technical Data Management Systems Transact-SQL Virtual Machines Freeform SQL Database Optimization Software Troubleshooting Data Analytics Physical Data Models SQL Server Management Studio (SSMS) Database Backup Software Version Control

Job description

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

Requirements

Knowledge, Skills & Abilities (KSAs): 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 troubleshooting software and hardware issues in a generic computer environment. Logical prowess can be cultivated in basic mathematics training, puzzle solving, and 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

Required Skills

Power BI experience

Disaster recovery

SQL Server

Management of Azure database virtual machines

Implement version control and DevOps practices for database objects