SQL Database Administrator

SQL Database Administrator

[Atlanta, GA, 30334] |   2023-05-31 15:55:36

Apply Now

Share Job 

Job Code : 2023-MY3TECH0310

SQL Database Administrator

Atlanta GA 30334 (Hybrid)

12 months Contract with possibility to extension

Under broad supervision, designs and secures computer databases to store, track, and maintain a large volume of critical business information. Develops database models and coordinates projects.

Conduct the following for Azure SQL/Azure SQL MI/SQL on Azure VM, On Prem SQL Server, SSRS, SSIS, Azure Synapse and other related products as applicable and necessary

•     As a SQL DBA, you’ll need to have hands-on experience with databases. Create databases with efficient structures. Maintain high standards of data quality and integrity.

•     Understand issues related to network performance and security.

•     Experience in software development using Microsoft SQL Server 2019, Azure SQL, T-SQL and T-SQL language (queries, views, procedures), SQL Server database design, stored procedure design and implementation.

•     Experience coding stored procedures (using T-SQL). Proven analytical problem solving and debugging skills.

•     Knowledge of Data Warehousing models

•     Working knowledge of Azure services

•     Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, etc.

•     Experience with performance tuning, query optimization, using Performance Monitor, SQL.

•     Profiler and other related monitoring and troubleshooting tools. Knowledge of standard concepts, practices and procedures related to database management.

•     Knowledge of capacity planning and infrastructure provisioning.

•     Design and create database objects for SaaS web applications

•     Analyze and tune existing queries and schema

•     Provide database expertise to teams of software developers

•     Perform database administration tasks for production and non-production databases as needed

•     Create and update documentation on database objects

Required:

•     Bachelors or Masters in relevant field.

•     Strong written and verbal communication skills in English

•     Real experience with Microsoft SQL Server in Azure Cloud Environment

Preferred Skills:

•     Knowledge of indexes, index management, and statistics.

•     Experience in troubleshooting and resolving database problems.

•     Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.

•     Experience with backups, restores and recovery models.

•     Experience with data migration or ETL.

•     Experience with cloud platforms, especially Azure.

•     Experience with cloud-based databases, especially Azure SQL.

SQL Server DBA

Required

8

Years

Microsoft SQL Server in a Azure Cloud Environment

Required

5

Years

Performance Tuning and Optimization (PTO)

Required

3

Years

Data Migration

Required

5

Years

Azure SQL, SQL, T-SQL

Required

5

Years

SQL Database back-up, recovery and documentation

Required

5

Years

Microsoft PowerShell

Required

3

Years

Capacity planning and Infrastructure provisioning