SQL DBA • February-2019 to June-2025
Description: • Replicated database from Oracle11g to SQL Server 2019 (Snapshot replication and Transac-tional replication). • Created a Linked Server to Oracle11g from SQL Server. • Created Active Directory with Security group with Table level permissions. • Responsible for maintenance of all the SQL Server and Oracle servers. • Created maintenance plan for regular scheduled Transaction log backup, Fullbackup (Separately in remote server), Check database, Reorganize index, Rebuild Index, Update Statistics and Cleanup task. • Setup and maintain Replication for Production servers to provide high availability and monitor using Replication Monitor. • Setup Alerts, Notifications, Jobs, Job steps with automated response solution schedules. • Frequently Monitor Connections, Locks and Database Performance using Performance Dashboard. • Reviewed and optimized SQL queries, stored procedures, functions, Indexes, views and Triggers. • Setup and maintain Replication for Production servers to provide high availability and monitor using Replication Monitor. • Setup Alerts, Notifications, Jobs, Job steps with automated Response solution schedules. • Frequently Monitor Connections, Locks and Database Performance.