What are the responsibilities and job description for the Sr SQL Server DBA --- F2F--C2H---Phoenix, AZ-Hybrid--LOCALS ONLY position at HUMAC INC.?
Sr SQL Server DBA --- F2F--C2H
Phoenix, AZ-Hybrid--LOCALS ONLY
This is a 4 month contract to hire a position.
Job Summary:
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
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
Sirisha N
Sr IT Analyst