Source description
About the role
As an MS SQL Server Database Administrator, your role will be crucial in administering, maintaining, and supporting MS SQL Server databases across development and production environments. You will be responsible for performing backups, restores, and managing recovery models. Additionally, you will conduct performance tuning and optimization (PTO) using native monitoring tools and implement high availability (HA) and disaster recovery (DR) solutions. Your tasks will also include configuring and maintaining database servers and processes to ensure system health, availability, and security. You will play a key role in approving developers' change requests for database objects and assisting them in performance tuning and query optimization. Independently troubleshooting and resolving database issues in real-time will be part of your responsibilities. Furthermore, you will automate routine processes, monitor database jobs, and track/document changes. Collaboration with teams to manage database transitions across multiple product lifecycle stages will also be essential. Key Responsibilities: - Administer, maintain, and support MS SQL Server databases - Perform backups, restores, and manage recovery models - Conduct performance tuning and optimization using native monitoring tools - Implement and manage high availability and disaster recovery solutions - Configure and maintain database servers and processes - Approve developers' change requests for database objects - Assist developers in performance tuning and query optimization - Independently troubleshoot and resolve database issues - Automate routine processes, monitor database jobs, and track/document changes - Collaborate with teams to manage database transitions across multiple product lifecycle stages Qualifications Required: - Minimum 3+ years of experience as an MS SQL Server DBA - Strong knowledge of SQL queries, stored procedures, indexes, and query plans - Proficiency in backup/restore strategies and recovery models - Solid understanding of HA/DR setups and replication techniques - Experience working in Windows Server environments - Familiarity with performance monitoring tools and techniques - Ability to work independently and resolve issues quickly and effectively - Excellent communication and collaboration skills As an MS SQL Server Database Administrator, your role will be crucial in administering, maintaining, and supporting MS SQL Server databases across development and production environments. You will be responsible for performing backups, restores, and managing recovery models. Additionally, you will conduct performance tuning and optimization (PTO) using native monitoring tools and implement high availability (HA) and disaster recovery (DR) solutions. Your tasks will also include configuring and maintaining database servers and processes to ensure system health, availability, and security. You will play a key role in approving developers' change requests for database objects and assisting them in performance tuning and query optimization. Independently troubleshooting and resolving database issues in real-time will be part of your responsibilities. Furthermore, you will automate routine processes, monitor database jobs, and track/document changes. Collaboration with teams to manage database transitions across multiple product lifecycle stages will also be essential. Key Responsibilities: - Administer, maintain, and support MS SQL Server databases - Perform backups, restores, and manage recovery models - Conduct performance tuning and optimization using native monitoring tools - Implement and manage high availability and disaster recovery solutions - Configure and maintain database servers and processes - Approve developers' change requests for database objects - Assist developers in performance tuning and query optimization - Independently troubleshoot and resolve database issues - Automate routine processes, monitor database jobs, and track/document changes - Collaborate with teams to manage database transitions across multiple product lifecycle stages Qualifications Required: - Minimum 3+ years of experience as an MS SQL Server DBA - Strong knowledge of SQL queries, stored procedures, indexes, and query plans - Proficiency in backup/restore strategies and recovery models - Solid understanding of HA/DR setups and replication techniques - Experience working in Windows Server environments - Familiarity with performance monitoring tools and techniques - Ability to work independently and resolve issues quickly and effectively - Excellent communication and collaboration skills
More at Atlanta Systems