Ms Sql Database Administrator
Note:Apply the candidates who are avialble for Sunday Virtual drive(22-Mar-26)
Role & responsibilities
1. Database Installation & Configuration
Install, configure, and upgrade MS SQL Server (2016/2019/2022) instances.
Install and manage environments (on Linux/Windows).
Configure instances, services, memory, I/O, and database parameter tuning.
2. Performance Tuning & Optimization
Analyze and tune slowrunning queries, indexes, and stored procedures.
Conduct performance analysis using SQL Profiler, Extended Events, Execution Plans.
For PostgreSQL: use pg_stat_statements, EXPLAIN, VACUUM, ANALYZE for optimization.
Resolve locking/blocking, deadlocks, waits, and highresource queries.
PostgreSQL
MS SQL Server
Configure & manage Full/Diff/Log backups, maintenance plans.
Perform DB restore during corruption, human error, or system failures.
Implement Always On Availability Groups, Failover Clustering, Log Shipping, Mirroring.
Security, Compliance & Patch Management
Implement user management, RBAC, encryption at rest & transit (SSL/TLS).
Apply patches, cumulative updates, PostgreSQL minor/major upgrades.
Ensure compliance with BFSI, ISO, PCIDSS, or internal audit requirements.
Monitor vulnerabilities and apply security hardening.
Provide 247 support for critical databases (oncall rotation).
Manage incidents, service requests, and change controls (ITIL).
Monitor using SQL Server Agent, pgAdmin, Grafana, Prometheus, or OEM-like tools.