Install, maintain, and support SQL Server2016,2019,2022 servers
Maintain data integrity and security (manage roles, permission of database users).
Create and manage indexes, Manage database availability,
Perform SQL Server Migrations and SQL server upgrades, whenever required.
Manage production, QA, Stage and development database environments.
Installation and configuration of Log shipping, AlwaysON
Perform routine database administration activities like index management, transaction log management, update statistics, check database integrity etc.
Configuration of /Replication
Monitor and maintain database security and database software
Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
Responsible for maintaining database backups (full, differentials and transaction logs), verify and retain them for a specific period to meet retention policy as per our SLA.
Analyze database activities and performance, using various tools like SQL Server inbuilt tools as well as third-party tools, troubleshoot and track the nature and resolution of problems