SQL Data base Administrator

TechSpace Solutions - Atlanta, GA

Full-time

Atlanta, GA

Professional, Scientific, and Technical Services

About the position

The SQL Database Administrator is responsible for managing and operating Microsoft SQL Server database instances, optimizing configurations, performing backups and restores, and developing automation scripts. This role requires strong communication skills and the ability to work independently while providing excellent customer service. The administrator will also be involved in researching technical solutions and sharing knowledge within the team.

Responsibilities

• Manage and operate Microsoft SQL Server database instances.
• Optimize configuration settings for performance.
• Perform database backups and restores.
• Develop and run optimization tasks.
• Compose automation scripts for repetitive tasks.
• Research viable technical and non-technical solutions.
• Share knowledge with the team and stakeholders.
• Leverage internal networks as a skilled specialist.

Requirements

• Bachelor's degree in computer or information sciences or similar field preferred.
• Experience in managing SQL Server databases.
• Proficiency in T-SQL programming.
• Knowledge of third form normalization design principles and indexing best practices.
• Experience with SQL Server versions 2012-2019.

Nice-to-haves

• Solid MS SQL Server DBA experience.
• Strong database design skills.
• Expertise in SQL statement tuning.
• Experience with native transactional data replication.
• Experience in configuring Always-On Availability Groups.
• Experience with deploying and managing cloud database services (AWS/Azure preferred).
• Experience with cloud automation deployment (e.g., Terraform for SQL RDS).
• Good understanding of networking concepts in cloud (VPCs, Subnets, Security Groups, etc).
• Strong PowerShell and/or Python scripting capabilities.
• Familiarity with Oracle Database technology (versions 11g, 12c, 18c, and 19c).
• Familiarity with Datadog as a monitoring and analytics tool.
• Familiarity with MySQL and PostgreSQL.