Key Responsibilities Backup &amp; Maintenance -

<ul>
<li>Define and enforce backup/restore policies (full, diff, and log).</li>
</ul>

<ul>
<li>Run/automate maintenance plans: index rebuild/reorg, stats updates, DBCC CHECKDB. Perform restore tests and document RPO/RTO adherence. Jobs Monitoring Monitor SQL Server Agent jobs; triage and fix failures. Implement alerts and reporting (Agent, Database Mail, SCOM/Prometheus).</li>
</ul>

<ul>
<li>Optimize schedules and job concurrency. Daily Health Checks Review error logs, wait stats, blocking, deadlocks, long-running queries. Track resource utilization (CPU, memory, IO, tempdb) and instance uptime. Ensure config baselines (MAXDOP, Cost Threshold, memory settings).Storage Management Manage data/log/tempdb growth and autogrowth settings .Capacity planning and filegroup/file layout optimization.</li>
</ul>

<ul>
<li>C oordinate with infra for IOPS, latency, and backup storage needs.User &amp; Security Management Provision users/roles; enforce least privilege and RBAC. Manage credentials, linked servers, encryption (TDE, TLS) and auditing.</li>
</ul>

<ul>
<li>Support compliance (GDPR/PCI/SOX) and periodic access reviews. Fixing Job Failures Perform RCA, implement corrective/preventive actions. Standardize run-books and improve observability. Reduce MTTR with proactive checks and automation.</li>
</ul>

<ul>
<li>Enhancing Existing FunctionalityTune queries, indexes, and stored procedures. Optimize schema design, partitioning, and compression .Automate routine tasks with T-SQL/Power Shell.</li>
</ul>

<ul>
<li>Package Development &amp; Delivery (SSIS/ETL)Build and maintain SSIS packages and data pipelines. Version, test, and deploy across environments (Dev/UAT/Prod).Ensure robust logging, retry logic, and documentation.</li>
</ul>

Required Skills &amp; Experience 

<ul>
<li>4+ years administering Microsoft SQL Server (2016+), including Always On AGs, Log Shipping, and Replication. Strong T-SQL, performance tuning (execution plans, wait stats), and indexing strategies. Hands-on with SQL Server Agent, SSIS, Database Mail, and maintenance automation.</li>
</ul>

<ul>
<li>Security: RBAC, TDE, auditing, and compliance processes. Experience with monitoring tools (native DMVs, SCOM, SolarWinds, Redgate, or equivalent).</li>
</ul>

<ul>
<li>Familiarity in managing Azure SQL Database and Managed Instance (sizing, replication)/ Configure backups, PITR, and failover groups</li>
</ul>

Database Administrator

India

Key Responsibilities Backup &amp; Maintenance - Define and enforce backup/restore policies (full, diff, and log). Run/automate maintenance plans: index rebuild/reorg, stats updates, DBCC CHECKDB. Perform restore tests and document RPO/RTO adherence. Jobs Monitoring Monitor SQL Server Agent jobs; triage and fix failures. Implement alerts and reporting (Agent, Database Mail, SCOM/Prometheus). Optimize schedules and job concurrency. Daily Health Checks Review error logs, wait stats, blocking, deadlocks, long-running queries. Track resource utilization (CPU, memory, IO, tempdb) and instance uptime. Ensure config baselines (MAXDOP, Cost Threshold, memory settings).Storage Management Manage data/log/tempdb growth and autogrowth settings .Capacity planning and filegroup/file layout optimization. C oordinate with infra for IOPS, latency, and backup storage needs.User &amp; Security Management Provision users/roles; enforce least privilege and RBAC. Manage credentials, linked servers, encryption (TDE, TLS) and auditing. Support compliance (GDPR/PCI/SOX) and periodic access reviews. Fixing Job Failures Perform RCA, implement corrective/preventive actions. Standardize run-books and improve observability. Reduce MTTR with proactive checks and automation. Enhancing Existing FunctionalityTune queries, indexes, and stored procedures. Optimize schema design, partitioning, and compression .Automate routine tasks with T-SQL/Power Shell. Package Development &amp; Delivery (SSIS/ETL)Build and maintain SSIS packages and data pipelines. Version, test, and deploy across environments (Dev/UAT/Prod).Ensure robust logging, retry logic, and documentation. Required Skills &amp; Experience 4+ years administering Microsoft SQL Server (2016+), including Always On AGs, Log Shipping, and Replication. Strong T-SQL, performance tuning (execution plans, wait stats), and indexing strategies. Hands-on with SQL Server Agent, SSIS, Database Mail, and maintenance automation. Security: RBAC, TDE, auditing, and compliance processes. Experience with monitoring tools (native DMVs, SCOM, SolarWinds, Redgate, or equivalent). Familiarity in managing Azure SQL Database and Managed Instance (sizing, replication)/ Configure backups, PITR, and failover groups

Database Administrator · Mumbai

Job highlights

Skillset required

Job Description

Job Description for Database Administrator

More at WNS