Hi,
Please find my direct client job requirement for your consideration.
Title: SQL DBA {Exp. 8+ yrs.}
Location: Atlanta, GA {Hybrid}
Duration: 12 Months
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.
** The client is allowing telecommuting. HOWEVER, candidates will be REQUIRED TO BE ON-SITE with short notice. **
** The selected candidate MUST come on-site Day 1 for Orientation and to pick up Equipment **
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.
Required / Desired Skills:
| | Skill | Required / Desired | Amount | of Experience |
| 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 | Required | 5 | Years |