SHWETA BALASAHEB YENDHE
Address: */* ******** ***** ****** Village,Ghatkopar(W) Mumbai NO-400084
Email ID: email@example.com Mobile No: 773-***-****
MICROSOFT SQL SERVER ADMINISTRATOR
Independently handling Clients Site technically and operations wise in executing work related to database management.
Knowledge of SQL Server 2005, 2008\R2 & 2012.
Implementation and monitoring of Logshipping
Database Performance Tuning using performance monitor and profiler
Creation of logins and database users.
Creation of new databases, tables & other objects.
Migrating SQL Server databases to new versions.
Backups and restoration of databases.
Maintaining documentation for the site.
Monitoring of DR Solutions like Log Shipping, DB Mirroring & Replication.
Configure Alerts using database mail.
Documentation Report/Review – Site Documents, System Study, Backup Policy, Security Policy, Patch Management Document, Activity Report, Incident Report, Monthly Service Report etc.
BE in Information Technology from K C College Of Engineering Management Studies And Research, Thane.
Engineering Diploma in Information Technology From Navjeevan education society's polytechnic, Bhandup.
Organization: Clover Infotech Pvt. Ltd., Andheri, MIDC
Working as Trainee (3month) & MICROSOFT SQL SERVER ADMINISTRATOR DBA.
Provide 24*7 Production support as well on call support for SQL Server Databases.
Handling Multiple servers and Databases average sizes of DB’s are 250 GB To 650 GB.
For High Availability using logshipping, mirroring and Active /Passive cluster.
Monitoring the databases as per the daily schedule tasks to check the Health of Databases using DBCC Commands.
Configured Log Shipping & Mirroring.
Monitoring and troubleshooting log shipping issues & Mirroring issues.
Installation and configuration of MS SQL Server.
Configure SQL parameters as per hardware configuration of the Server.
Use Import/ Export Wizard to transfer data from Production databases.
Linked server creation from SQL to SQL & SQL to Oracle databases.
Configured various alerts and Database Mails.
Performed Log shipping DR drill activities.
Creation of Maintenance jobs which runs re-indexing & updates statistics on critical databases.
Upgradation of Service packs on SQL server production servers
Ensure latest SQL patches to be applied on live server after proper testing in UAT.
Consolidation of SQL servers.
Formulate Daily, Weekly & Monthly reports.
Configuration of DML auditing on SQL servers.
Analyzing & resolving the performance related issues on SQL servers.
Backup & Restoration.
Database deployment on UAT & PROD servers.
Monitoring jobs like backup, restore check the Error Log for daily running batch jobs.
Using Net Backup for scheduling Backup and Recovery jobs.
Identifying slow running Queries.
Check disk space utilization.
Reorganization of data and index pages and Fragmentation of indexes using Sql.
Monitor & Creating daily Checklist For Multiple Server For Multiple Client such as Cholamandalam, Bajaj, Polycab, Proconnect, ABFL Glenmark etc..
DOB: 26th March 1995
Marriatial Status: Unmarried
Languages: English, Marathi, Hindi