OnBenchMark Logo

Vamsidhar

Technical Specialist
placeholder
Location Chennai
view-icon
Total Views40
availability
Shortlist0
back in time
Member since30+ Days ago
 back in time
Contact Details
phone call {{contact.cdata.phone}}
phone call {{contact.cdata.email}}
Candidate Information
  • User Experience
    Experience 9 Year
  • Cost
    Hourly Rate$10
  • availability
    AvailabilityImmediate
  • work from
    Work FromOffsite
  • check list
    CategoryInformation Technology & Services
  • back in time
    Last Active OnJuly 24, 2024
Key Skills
SQL Server
Education
2008-2011

(Computer Science)
Osmania University

Summary

Work Experience:

 

Project #1

Client                   :          World Bank

Role                 :       Team member

Duration            :       Jan 2016-Till Date

Environment      :       Windows 2016/2012/2008, MS-SQL Server 2022/

2019/2017/2016/2014/2012/2008R2/2005.

Responsibilities:

Ø Providing 24/7 On-Call support for critical production database.

Ø Installation, Configuration and Administration of SQL Server 2005/2008/2008R2/2012/2014/2016/2017/2019/2022.

Ø Working on Standard Database Maintenance tasks, Backups and Recovery Plans.

Ø Database Refreshes from Production to Stage and Development environments as per the requirement.

Ø Administration of SQL server by creating user Logins with appropriate roles, granting, and denying login privileges, monitor 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.

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

Ø Carrying out Installations and upgradations of SQL server Database engine and client tools through all the versions and administrating the same.

Ø Administrating replication, log shipping, Mirroring and Always-On 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.

Ø Creating Weekly and Monthly analysis reports for the Database Growth and Performance statistics

Ø Distribution of Knowledge within Team considering any new issue and document it for future usage if it surfaces back.

Ø Configuring DR strategies Replication, Mirroring, Always-on and Log Shipping.

 

Project #2

Client                   :          TSC

Role                 :       Team member

Duration            :       Sep 2014 - Dec 2014

Environment      :       Windows 2003/2000, MS-SQL Server 2012, 2008R2/2005.

 

Responsibilities:

Ø Installation, Configuration and Administration of SQL Server 2005/2008.

Ø Working on Standard Database Maintenance tasks, Backups and Recovery Plans.

Ø Database Refreshes from Production to Stage and Development environments as per the requirement.

Ø Administration of SQL server by creating user Logins with appropriate roles, granting, and denying login privileges, monitor 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.

Ø Knowledge on Administrating replication,

Ø Applying SQL Server patches and Service Packs during the maintenance window.

Ø Creating Weekly and Monthly analysis reports for the Database Growth and Performance statistics

Ø Distribution of Knowledge within Team considering any new issue and document it for future usage if it surfaces back.

Copyright© Cosette Network Private Limited All Rights Reserved
Submit Query
WhatsApp Icon