Job Description
SQL Server Administration
Install, configure, and harden
Microsoft SQL Server
(2016/2017/2019/2022) in standalone and
Always On
(AGs) / cluster configurations.
Own
patching, service packs, cumulative updates
, and
in‑place/side‑by‑side upgrades
with rollback plans.
Implement and maintain
backup/restore strategies
(Full/Diff/Log),
log shipping
, and
DR
(site failover tests).
Manage
security
: logins, roles, permissions, encryption (TDE), auditing, and compliance (e.g., CIS benchmarks).
Performance management:
indexing strategies, query tuning (execution plans), statistics maintenance, I/O & memory tuning
, and
baseline + capacity planning
.
Migration to AWS
Lead
end‑to‑end migrations
from on‑prem SQL Server to AWS using
AWS DMS
and native tools (BA...
Install, configure, and harden
Microsoft SQL Server
(2016/2017/2019/2022) in standalone and
Always On
(AGs) / cluster configurations.
Own
patching, service packs, cumulative updates
, and
in‑place/side‑by‑side upgrades
with rollback plans.
Implement and maintain
backup/restore strategies
(Full/Diff/Log),
log shipping
, and
DR
(site failover tests).
Manage
security
: logins, roles, permissions, encryption (TDE), auditing, and compliance (e.g., CIS benchmarks).
Performance management:
indexing strategies, query tuning (execution plans), statistics maintenance, I/O & memory tuning
, and
baseline + capacity planning
.
Migration to AWS
Lead
end‑to‑end migrations
from on‑prem SQL Server to AWS using
AWS DMS
and native tools (BA...