Description
You will manage daily database administration tasks and maintain SQL Server stability in Alpharetta, GA.
Responsibilities
- Perform day-to-day database administration using deep knowledge of SQL Server internals.
- Troubleshoot performance issues and provide technical recommendations to application development teams.
- Manage high-priority P1/P2 outages and resolve concurrency issues or deadlocks.
- Optimize queries and performance using monitoring and troubleshooting tools.
- Support additional technologies including Delphix, HVR, and RTDS.
Required Skills
- 5+ years of experience in MSSQL database administration.
- Deep knowledge of SQL Server internals including indexing, partitioning, file stream, Always-On, replication, and mirroring.
- Proficiency in T-SQL, query execution plans, and query optimization.
- Experience with Performance Monitor, SQL Profiler, and related monitoring tools.
- Strong automation skills using PowerShell.
- Ability to handle critical production outages.
- Any Graduate degree.
Preferred Skills
- Experience administering Azure SQL databases.
- MSSQL DBA Certification.
- Automation experience with tools beyond PowerShell.