Resume

Sign in

Administrator Trainee

Location:
Mumbai, Maharashtra, India
Posted:
April 28, 2021

Contact this candidate

Resume:

SHWETA BALASAHEB YENDHE

Address: */* ******** ***** ****** Village,Ghatkopar(W) Mumbai NO-400084

Email ID: adl0qs@r.postjobfree.com Mobile No: 773-***-****

EXPERIENCE SUMMARY

MICROSOFT SQL SERVER ADMINISTRATOR

Role:

Independently handling Clients Site technically and operations wise in executing work related to database management.

Expertise In:

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.

Academic Details

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.

Work Experience

Organization: Clover Infotech Pvt. Ltd., Andheri, MIDC

Working as Trainee (3month) & MICROSOFT SQL SERVER ADMINISTRATOR DBA.

Responsibilities

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.

Import/Export Objects.

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..

Personal Details

DOB: 26th March 1995

Marriatial Status: Unmarried

Languages: English, Marathi, Hindi



Contact this candidate