VIDHYA M K

Email: adm0jd@r.postjobfree.com Phone: 91-882*******

Summary:

Over 5+ years of experience as SQL SERVER DBA handling administration activities

Good Knowledge and experience in SQL Server – Installations, configuring, administering, Maintenance Jobs, Patching,job monitoring, backup and restore strategies.

Experience on Log shipping, SQL clustering, Database Mirroring, Always On.

Good knowledge and experience in Data Warehousing environment as a SQL administrator.

Creative, unconventional, Quick learner, strong teamwork abilities.

Less than year experience in SQL Azure (IAAS and PAAS model) respectively.

Professional Experience:

Employment details:

July 2019 – Till Date: DXC Technology India Private Limited

Department Name: Deutsche Bank

Team size: 20

Roles:

Active member of SQL database administration team of size 20.

Daily backup monitoring and effective recovery on data loss.

Backup and restores based on customer requirement.

Upgrade from previous versions, Applying latest patch production environment.

Handling high severity issues like SQL Server down, database crash, application connection failure by working with various teams which includes network team, storage teams.

Provided SQL server training and knowledge transfer to freshers on day to day activity of DBA

Faced P1 issue and resolved successfully by continuously in call over hours.

Performance tuning on slow responses – Index check, rebuild and reorganize.

Connecting to Virtual Desktop via SDOD (Secure Desktop On Demand)

Ad-hoc backup and restore activity performed based on user requests.

Worked on Patching tool named BladeLogic from pre-requisites to deployment.

Perform patch activities, install service packs & security updates.

Having experience on Trivolli Data Protection (TDP) tool which has been used in critical servers.

Monitoring tool as Nimsoft which is widely used in our Banking Environment for all database server alerts.

Create maintenance plan and develop sql agent jobs for monitoring the performance related issues like blocking and deadlock.

Configuring high availability tasks like Mirroring, Always ON.. hands on.

Taken care of P3 critical calls during application outage

Involved in DR activity for critical data centers

Also solving user level issues like password issues, account locked, user creations, granting/revoking roles & privilege relates issues based on the security standards maintained for the banking infrastructure.

Worked in database level Migration activities

On call support during the weekend activities on production upgrade and maintenance.

Less than a year experience in SQL Azure (IAAS and PAAS)

Feb 2017 –June 2019 Ramco Systems.

Department Name: Customer Reporting Data warehouse Services.

Team size: 9

Roles:

Active member of SQL database administration team of size 9.

Provided support for Customer Reporting Data warehouse Infrastructure Servers.

Managing 100 SQL Server Instances in three different domains.

Incidents tickets, daily user requests, Change activities, quote management & Problem management using Remedy ticketing tool.

Performing DBCC check like Integrity and Optimization check on all databases in every weekend.

Daily backup monitoring and scheduling using Commvault backup tool and effective recovery on data loss.

Perform patch activities, install service packs & security updates.

Worked in Idera performance monitoring and management tool for managing performance related issues.

Also solving user level issues like password issues, account locked, user creations, granting/revoking roles & privilege relates issues based on the security standards maintained for the banking infrastructure.

Work with management and customers on various environment stabilizations activities like suppressing false alerts, setting threshold for disk space issues so that DBA can act proactively to avoid any database failures.

Automation of manual activities like Daily/Weekly backup report, Weekly Change Order reports, capacity reports etc.

Worked in Migration activities

Oct 2015 – Jan 2017 Ramco Systems.

Department Name: Internal System Technology Group (STG).

Roles:

Active member of SQL database administration team of size 6.

Was providing L1 support for Internal Infrastructure Servers.

Managing over 50 plus SQL server Instances.

Tickets and Daily user request using Remedy and HPSM (HP Service Manager).

Data and log files management – Restricting, adding new log\data files, creating new file group & moving the files between the file groups.

Involved in change activities involving Migrating standalone SQL Servers.

Co-ordination with various teams like Citrix, Wintel, Network teams in case of troubleshooting root cause for the issues.

On call support during the weekend activities on production upgrade and maintenance.

AWARDS & PRESENTATION:

Won DXC quarterly awards for best performance in overall DXC.

Received appreciation on Town hall for good team player and Performer.

Awarded as high flier of the month for best contribution in resolving the critical ticket which had hard disk failure and server disk space issue.

Awarded SPOT award for best performance in team.

TECHNICAL SKILLS:

Languages : SQL.

Database : SQL Server 2008, 2008 R2, 2012, 2014,2016.

Environment worked : International Banking Environment

Networking : Basics of computer networks.

Applications : SERVICE NOW

EDUCATION:

Secondary

82.45%

Jawahar Matriculation Higher Secondary School,Neyveli,TN.

Higher Secondary

86.25%

Jawahar Matriculation Higher Secondary School,Neyveli,TN.

B.E(ECE)

77%

VIETW, Tiruchengode, TN.

Strength:

I consider my complete unconventional thinking ability as a major strength. My Strength from a corporate perspective would be my quick grasping and smart working capacity. With aspire to face challenges, interest to learn new things mutually benefit me and the organization I work.

I, hereby confirm that the information given above is true to the best of my knowledge.

Date:

Place: (M.K.VIDHYA)

Contact this candidate