Dutech’s Job

MS Azure Infrastructure Specialist & SQL Server DBA

Austin,TX

DatePosted : 3/26/2024 7:16:55 AM

JobNumber : DTS101765725
JobType : Contract
Skills: Network support for Azure, MS SQL Server 2016, SQL queries, database, logical, and physical design
Job Description

 

  1. CANDIDATE SKILLS AND QUALIFICATIONS

 

Minimum Requirements:
Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will be displayed to customers but may not be chosen for this opportunity.

Years

Required/Preferred

Experience

7

Required

Network support for Azure, Application performance / health monitoring, Azure Capacity planning, Azure VPN Configuration / troubleshooting, Azure VM maintenance and troubleshooting, Azure OS security patching and software updates

7

Required

Azure automation management and improvements, IAM (Azure access management, and AD group Management) , AD Administration

7

Required

Experience performing Database Administration functions for MS SQL Server 2016 and later

7

Required

Understanding of complex SQL queries

7

Required

Experience in database, logical, and physical design

7

Required

Experience with PowerShell scripting on MS Windows

7

Required

Experience performing database backup, restore and recovery

7

Required

Experience with each of the following: Configuring and maintaining database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security, while minimizing false alarms

7

Required

Experience with each of the following: Troubleshooting and resolving database problems, Data modeling techniques to ensure consistency across teams and to meet integration and performance expectations

7

Required

Experience with each of the following: Performance tuning and optimization at the physical server level (e.g., table and index partitioning), the database level (e.g., database settings and options), and query tuning

7

Required

Experience with: Installation and configuration of SQL Server including AlwaysON, and as well as other forms of replication, Expertise in Failover clustering, SAN replication, and other High Availability (HA) and Disaster Recovery (DR) technologies

7

Required

Experience with: Working with SQL Server Integration Services, SQL Server Reporting Services and Power BI

5

Required

Experience with Salesforce Systems

5

Required

Administration, building and deployment of agency MS Windows application server software

4

Required

Bachelor’s degree from an accredited four-year college or university, with major coursework in Computer Science, Information Systems or a related field. Education and experience may substitute for each other on a year for year basis.

5

Preferred

Experience in multi-dimensional data models that are an extension of Star schema - where dimension tables are broken down into subdimension tables

5

Preferred

Knowledge of MuleSoft (version 4)

5

Preferred

Experience with Informatica Power Exchange Change Data Capture (CDC)

5

Preferred

Experience integrating SQL Server with Azure Active Directory

5

Preferred

Experience working with Microsoft DevOps (previously called Team Foundation Server (TFS))

5

Preferred

Experience with Data Lakes; SnowFlake; or other Data Warehouse platforms

5

Preferred

Working knowledge in one or more technology areas: Cloud technol-ogies, Cloud Storage, Cloud Networking, IaaS, PaaS, Observability, IAM, Infrastructure as Cloud (IaC),

1

Preferred

Certification is a plus: Azure Database Administrator; Certified Microsoft Database Administrator; MCTS; MCITP; MVP

 

 

SHARE THIS JOB

;