Source description
About the role
You will manage and maintain Microsoft SQL Server environments across multiple versions and Azure platforms. Responsibilities Install, configure, and maintain SQL Server versions from 2012 through 2022 on x64bit operating systems. Execute database migrations, software upgrades, and the application of service packs and patches. Manage database maintenance including index rebuilds, integrity checks, and scheduled maintenance plans. Implement and manage high availability and disaster recovery solutions including Always On, replication, log shipping, mirroring, and clustering. Tune system performance by optimizing SQL queries and stored procedures using SQL Profiler and Database Engine Tuning Advisor. Required Skills 5-9 years of experience in Microsoft SQL Server Database Administration. Proficiency with SQL Server versions 2012, 2014, 2016, 2017, 2019, and 2022. Hands-on experience with Azure and SQL Server environments. Expertise in Backup, Restore, Recovery, and Linked Servers. Deep knowledge of Replication models including Snapshot, Transactional, and Merge. Experience implementing Always On availability groups in SQL Server 2016+. Skill in using SQL Management Studio, Enterprise Manager, and Query Analyzer. Ability to use DMVs, Resource Governor, and Windows Performance Monitor for tuning. Competency in performing DBCC and custom script execution. Strong technical troubleshooting and logical thinking skills. You will manage and maintain Microsoft SQL Server environments across multiple versions and Azure platforms. Responsibilities Install, configure, and maintain SQL Server versions from 2012 through 2022 on x64bit operating systems. Execute database migrations, software upgrades, and the application of service packs and patches. Manage database maintenance including index rebuilds, integrity checks, and scheduled maintenance plans. Implement and manage high availability and disaster recovery solutions including Always On, replication, log shipping, mirroring, and clustering. Tune system performance by optimizing SQL queries and stored procedures using SQL Profiler and Database Engine Tuning Advisor. Required Skills 5-9 years of experience in Microsoft SQL Server Database Administration. Proficiency with SQL Server versions 2012, 2014, 2016, 2017, 2019, and 2022. Hands-on experience with Azure and SQL Server environments. Expertise in Backup, Restore, Recovery, and Linked Servers. Deep knowledge of Replication models including Snapshot, Transactional, and Merge. Experience implementing Always On availability groups in SQL Server 2016+. Skill in using SQL Management Studio, Enterprise Manager, and Query Analyzer. Ability to use DMVs, Resource Governor, and Windows Performance Monitor for tuning. Competency in performing DBCC and custom script execution. Strong technical troubleshooting and logical thinking skills.
More at Logic Planet