PRAVALLIKA DEPATLA

Detail-oriented SQL Database Administrator with 2 years of experience in production support for SQL Server. Delivered on-call support for critical databases, emphasizing security management and performance optimization. Managed installation, migration, upgrades, as well as backup and disaster recovery processes, ensuring high availability and optimal database performance.

• Coty, Coty Sanford, SQL Server Database Administrator, 20, 10/01/23 to 09/30/24, Providing 24/7 On-Call support for critical production databases., Installation, Configuration and Administration of SQL Server 2012/2014/2016., Working on Standard Database Maintenance tasks, Backups and Recovery Plans., Database Refreshes from Production to Stage and Development environments as per the requirement., Performing SQL server daily health check and preparing a report based on it., Monitoring Disk Space of all the Servers and freeing up space as per SQL Server i.e. Older Backups, Unused Files etc., Scheduled and maintained routine Jobs, Alerts and Maintenance Plans., Managing backups on a daily basis and recovery (as per request)., Develop, implement and administer database policies and procedures and provide technical support and assistance to all database end-users., Ensuring the high availability of the Databases to the end users., Working as part of a team and providing 24x7 technical database support., Administration of SQL server by creating user Logins with appropriate roles, granting and denying login privileges, monitoring the user accounts, creation of groups, granting database and application roles to users and groups., Periodic checking of databases with DBCC command for maintaining data consistency and integrity and rebuilt indexes., Carrying out Installations and up gradations of SQL server Database engine and client tools through all the versions and administrating the same., Reviewing SQL Server and SQL Server Agent Error Logs., Knowledge on Administrating replication, log shipping and other high availability methodologies., Applying SQL Server patches and Service Packs during the maintenance window., Raising Change requests for any production change to be made and other defined requests for their respective purpose.
• National Grid, NATIONAL GRID- UK, SQL Server Database Administrator, 15, 06/01/22 to 08/31/23, Installation and patching the SQL Server 2008, 2008 R2, 2012, 2014, 2016, 2019., Working on Standard Database Maintenance tasks, Backups and Recovery Plans., Performing SQL server daily health check and preparing a report based on it., Monitoring Disk Space of all the Servers and freeing up space as per SQL Server i.e. Older Backups., Performing the new server configuration., Attending Crisis management calls whenever needed., Ensuring the high availability of the Databases to the end users., Constantly checking functionality of the environment and taking necessary action when an alert is thrown from alerting mechanism by taking a prompt action based on its severity and considering the resolution of the issues as most primitive tasks., Log shipping installation and maintenance., DB Mirroring Configuration and troubleshooting., Replication Configuration and troubleshooting., Cluster fail over and fail back activities., Migration and up gradation of servers and databases., Repetitive issue and analysis and proposals and resolutions., Performance Troubleshooting.