MS SQL DBA – for Atlanta (GA) – Hybrid

Job Description

Job Summary

The Sr. SQL Database Administrator is responsible for managing, optimizing, and ensuring the availability of SQL Server databases within the enterprise. This role is critical in maintaining data integrity, supporting business operations, and enabling data-driven decision-making by ensuring high-performance and secure database environments. This role involves overseeing database installation, configuration, optimization, troubleshooting, backup, and recovery while ensuring security and compliance. The Sr. DBA will collaborate with software development teams, IT infrastructure teams, and business stakeholders to support upgrades, new requirements, and system enhancements.

Responsibilities –

Database Management:

Install, configure, and maintain SQL Server databases across multiple environments, including Microsoft Azure SQL Cloud Databases.
Design and implement database schemas, tables, indexes, and views based on application requirements, specifically with Infor SyteLine V9.00.30 and Infor SyteLine V10.x.
Monitor database performance and implement tuning techniques for high availability and optimal efficiency, leveraging third-party tools for automation.
Develop and maintain disaster recovery and backup strategies to ensure data integrity and availability.
Manage SQL Server instances to ensure proper configuration and compliance with security policies.

Performance Tuning and Optimization:

Proactively monitor and optimize database performance, including CPU, memory, disk usage, and query efficiency.
Analyze execution plans and recommend indexing, partitioning, and other optimization techniques.
Identify and resolve SQL Server performance bottlenecks to maintain consistently high-performance environments

Backup & Recovery:

Design and maintain comprehensive backup strategies for all SQL databases.
Conduct regular backups and test restoration procedures to ensure business continuity.
Implement high-availability solutions such as Always On Availability Groups, clustering, and replication.
Develop and test disaster recovery plans to minimize downtime.

Security & Compliance:

Implement database security best practices, ensuring appropriate user permissions.
Monitor compliance with data protection policies, industry standards, and auditing requirements.
Collaborate with the security team to identify, respond to, and remediate vulnerabilities.

Capacity Planning & Scaling:

Perform database capacity planning and resource allocation.
Scale databases to meet business growth needs while ensuring minimal downtime.
Optimize storage usage across on-premises and cloud environments.

Troubleshooting & Issue Resolution:

Identify, diagnose, and resolve database-related issues, including performance degradation, locking/blocking, and system failures.
Provide on-call support for critical database incidents, ensuring rapid response times and adherence to an established escalation process to minimize downtime and data loss.

Collaboration & Documentation

Work closely with software development teams to support application deployments, new features, and database migrations.
Offer expertise on SQL coding best practices, query optimization, and database design.
Lead or participate in complex database projects, ensuring deadlines and quality standards are met.
Maintain detailed documentation for database architecture, configurations, maintenance procedures, and troubleshooting guidelines, ensuring compliance with regulatory requirements and industry standards for audits.

Miscellaneous Responsibilities:

Support and train other team members.
Other duties as assigned.

Required Expertise

Knowledge, Skills, and Abilities –

Bachelor’s degree in computer science, software engineering, or equivalent experience strongly preferred.
Minimum of 5+ years of experience as a SQL Database Administrator, with 3+ years in a senior or lead role.
Expertise in SQL Server 2012 or newer, with deep knowledge of database architecture, design, and optimization.
Strong proficiency in performance tuning, indexing, and query optimization.
Experience with high-availability solutions, including Always On Availability Groups, SQL Server Clustering, and Database Mirroring, following industry best practices and leveraging tools such as SQL Server Management Studio (SSMS) and PowerShell for automation and monitoring.
Solid understanding of database security, backup, and recovery strategies.
Familiarity with cloud platforms such as AWS, Azure, or Google Cloud for database management.
Experience with automation tools (e.g., PowerShell, SQLCMD) for routine maintenance tasks.
Experience with Quest Foglight is required.

Desired Technical Skills:

Certifications such as Microsoft Certified: Azure Database Administrator Associate or Microsoft Certified: SQL Server Database Administrator.
Experience with Infor SyteLine V9.00.30 or V10.x as an ERP platform.
Familiarity with NoSQL databases or other RDBMS like PostgreSQL, MySQL, or Oracle.
Experience with Cohesity DataProtect a plus.

General Competencies:

Basic understanding of manufacturing and accounting principles.
Experience with helpdesk and ticketing systems is desirable.

Communication and Analytical Skills:

Exceptional written and verbal communication skills, including cross-functional collaboration.
Must be detail-oriented with strong analytical and critical thinking skills, able to meet deadlines consistently.