Divya Arulprakash

Installed SQL Server 2019,2016,2012,2005 and 2008 R2 in development, test, and production environment

Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012.

Maintained server and database security including database encryption (TDE) Installed and Configured SQL Server Reporting Services (SSRS) Monitored performance and if required tuning TSQL queries, Stored procedures. Basics on Writing T-SQL and Stored-Procedures Working experience in Database Backup, Restore and Point-in-Time Recovery Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification Developed Different Maintenance Plans for database monitoring Customized support for Client’s Applications and provided client will won the responsibility of creating and maintaining database objects and structures such as tables, indexes, views, triggers, Functions, Procedures. Managed different types of Indexes , Constraints Setup Jobs, Maintenance plans for backups, Rebuilding indexes, check server health, alert, notifications Configured and Maintained Replications, Log Shipping, and Mirroring for High Availability. Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor(DTA). Rebuilding / Monitoring the indexes at regular intervals for better performance. Backup and Restoration of Databases using RedGate Backup and SQL native methods Manual, on Demand and setup jobs for Database Backup, and design backup strategy Monitor Server Activity, Error Log, space usage and solving problem as needed Working individually, as a member of a team, and deploy the source codes through AGILE process

Developed stored procedures, functions and complex packages extensively using PL/SQL and fine-tuned SQL to optimize performance. Wrote SQL/T-SQL queries, Stored-Procedures, functions, and Triggers. Checking the general health of the servers and the databases. Monitored the server’s status, database file growths, disk space alerts etc. Monitored Space estimation for database objects. Experience working in Active/Passive, Active/Active cluster environment. Scheduled Alerts and Jobs Using SQL Server Agent (Automation). Implemented SQL logins, roles, and authentication modes as part of security policies.