Sql ServerDBA

Location:

Bengaluru, KA, India

Posted:

March 24, 2018

Contact this candidate

Resume:

Santhosh Kumar SD

G***, Vintage Elite B block,

Visheshvarya Nagar, Vijayabank Layout

Bengaluru - 560076

E-mail:- *****************@*****.***

Mobile:-+91-900*******

Professional Experience:

9+ Years of overall experience with 8+ years of SQL DBA experience and 1 years of Application Support team Experience.

Experience Summary:

1.Role: Supervising Associate

Company: EY Global Delivery Services

Duration: 24th Oct 2016 – Till date

2.Role: IT Specialist

Company: HP Enterprise Solutions

Duration: 12th Nov 2014 – 14th Oct 2016

3.Role: Lead Engineer

Company: iGATE Global solutions

Duration: 06th Jan 2014 – 7th Nov 2014

4.Role: Senior System Engineer

Company: Infosys Limited

Duration: 07th July 2008 – 06th December 2013

Project worked in:

EY Global Delivery Services

Client

EY Global Delivery Services

Role

Level III support – Domain Team, DBA- SQL

Team Size

Duration

24th Oct 2016 – Till date

Tools & Databases

SQL Server 2016/2014/2012/2008R2, SQL Azure PaaS and IaaS, Service now, Veritas Net backup client, Configuration Management, SharePoint support

Responsibilities:

Experienced in managing dedicated applications on own with multiple environment like SQL server 2012/2014/2016 and Azure PaaS and IaaS

Experienced as Primary /dedicated DBA for more than 100+ applications on EY environment.

Experienced on Managing entire Application cycle, enhancement planning, Data issues,

Performance issue and decommission activities

Experienced in Planning, Testing and Execution on DR activity.

Migration experience on MSSQL Server 2008R2/2012/2014/2016 and On-Prem to Azure environment.

Managing and configuration exposure on High availability in SQL server which includes SQL Cluster (Active-Active, Active-Passive) and Log shipping, Replication, AG – Always ON under On-Premises servers

Experience in Database administration activities for DB Security (creating logins, users, roles, and assigning permission to them), database files management and backup/restore and verification of Critical production daily backup status.

Configuration Management - Handling end to end ownership on Configuration items in the dedicated environment.

Change Management- Implementing Change requests in production environment and verification of all CAB approved CRs are driven for implementation and involvement in CAB meetings.

Driven end to end project (New installation and Environment upgrade) activity right from Planning, Architecture suggestion on requirement and drive it to successful completion.

HP Enterprise Solutions

Client

BMS - Bristol-Myers Squibb, Global

Role

Level III support & Configuration/ESM Lead, DBA- SQL

Team Size

Duration

Nov 2014 – Oct 2016

Tools & Databases

SQL Server 2012/2008R2/2008/2005/2000, Profiler, Management Studio/Enterprise Manager, Query Analyzer,Ticketing,Change & CMDB tool – Vitalize(Client based)

Responsibilities:

Experience in Patching and Services packs activity on both Production & Non-Production environment.

Experience in Disaster Recovery Planning, Execution and Testing on DR environment.

Migration experience on MSSQL Server 2000/2005/2008/2008R2/2012.

Managing and configuration exposure on High availability in SQL server which includes SQL Cluster (Active-Active, Active-Passive) and Log shipping.

Configuration Lead - Handling end to end ownership on Configuration items in the environment.

ESM (Enterprise security Management) Lead: Ensure Access level are provided as per the Client process and procedures at SQL server and Database level.

Change Management- Implementing Change requests in production environment and verification of all CAB approved CRs are driven for implementation.

Driven end to end project (New installation and Environment upgrade) activity right from client meeting and proposal, suggestion on requirement and drive it to successful completion.

Strong experience in mentoring team members and writing documentation.

IGate Global Solutions

Client

GE,USA

Role

Migration Resource, DBA- SQL

Team Size

Duration

Feb 2014 – Apr 2014

Tools & Databases

SQL 2000/2005/2008R2

Responsibilities:

Involved as Migration resource for migration of 12 Legacy 2000 SQL servers to 2005 Servers and 30 SQL Servers from 2005 environment to 2008R2.

Infosys Limited

Client

UL, USA

Role

Team Member, DBA- SQL

Team Size

Duration

Sep 2013 – Nov 2013

Tools & Software

SQL 2008/2012, DB Artesian and Change Management Tools(CHART)

Responsibilities:

Migration SQL SharePoint Server from SQL 2008 Enterprise to SQL 2008 Developer Edition.

Migration SQL SharePoint Server from SQL 2012 Enterprise to SQL 2012 Developer Edition.

Handling Backup, Restore and Refresh activity and verification of Critical production daily backup status.

Access Management - Users & logins

Change Management- Implementing Change requests in production environment and verification of all CAB approved CRs are driven for implementation.

Infosys Limited

Client

SCI, USA

Role

Team Member, DBA- SQL

Team Size

Duration

Nov 2009 – Aug 2013

Tools & Software

SQL 2005/2008, DB Artesian, SQL diagnostic manager and Change Management Tools(CHART)

Responsibilities:

SQL server 2005, 2008 and 2012 installations and Uninstallation.

Handling Backup, Restore and Refresh activity and verification of Critical production daily backup status.

Access Management - Users & logins

Change Management- Implementing Change requests in production environment and verification of all CAB approved CRs are driven for implementation.

Incident Management - Troubleshoot on failures, Alerts, Jobs and Open Incident tickets if necessary to work with technicians.

Exposure on SQL clusters Environment

Understanding and Setting up Knowledge on Replication, Log shipping and DB Mirroring.

Performing Weekly\Monthly\Quarterly activities like Server health checks and Month End Activity.

Performance Monitoring and Tuning.

Documenting major changes in the Client SQL Servers environment.

Infosys Limited

Client

SCI, USA

Role

Team Lead, Production Operations (Application Support Team)

Team Size

Duration

Oct 2008 – Oct 2009

Tools & Software

AS400 Rumba tool, SkyBot Scheduler, Heat Ticketing Tool, Data Stage director, IBM Web Sphere and BizTalk Server

Responsibility:

Managed Client Sales Application by taking it offline and Running prewritten scripts during outage window (Batch Processing) to update each day transactions.

Handling files management in and out with Client side transactions during their daily business hours.

Supporting Data warehouse team in tracking and monitoring their loads. Managing BizTalk Application jobs.

Additional PROFILE:

Infosys Limited

Clients

SCI, BESCOM, Telstra Global, BELGACOM and POYRY

Role

Process Consultant

Tools &Software

Microsoft Project 2003,2007 & 2010, IPM+ and AMS(Internal)

Responsibility:

Anchor from Production side for all Quality and ITIL Process related work within my Unit/DM Portfolio and Account level BCMS Anchor.

Managed many projects to sustain the CMMI Level and driven all my DM portfolio projects successfully during ITIL ISO 20K Audit across various DC locations. Participated as ISO 20K Audi tee for 3 times in my Career for the projects.

Setting up Process Environment for newly kicked in project with reference to SOW from Client Aligning with ITIL Process.

I have been member of Managed Services team and worked for few projects RFPs and Environment setup.

Certifications:

1.70-432 - TS: Microsoft SQL Server 2008 Implementation and Maintenance

2.70-450 - PRO: Designing, Optimizing and Maintaining a Database Administrative solution Using Microsoft SQL Server 2008

3.ITIL – Foundation

4.70-533 - Implementing Microsoft Azure Infrastructure Solutions

Education:

S.S.L.C (2001) from Grace Matriculation Higher Sec School (Ranipet, Vellore) With 68%.

HSC (2003) from Grace Matriculation Higher Sec School (Ranipet, Vellore) with 73%.

B.C.A (2008) from S.S.S College (Arcot, Vellore) with 73%.

Technical Skills:

Operating Systems

Windows 2003/2008, XP, Vista and 7

Domain

Windows 2003 Server, Microsoft SQL Server

Database Worked On

2012/2008R2/2008/2005/2000

PROFESSIONAL STATISTICS:

Hard working and innovative

Quick learner with ‘Can do’ attitude.

Good technical & Process knowledge with practical exposure.

Capability to work in teams and take up responsibilities

Good interpersonal and communication skills in dealing with International clients.

PERSONAL STATISTICS:

Name

Santhosh Kumar SD

Date of birth

21st March 1986

Sex

Male

Nationality

Passport No

Indian

G7163098

Hobbies

Driving, Riding, listening to music

Email-ID

mailto:*****************@*****.*** *****************@*****.***

Languages Known

English and Tamil

DECLARATION

I hereby declare that the above written particulars are true to the best of my knowledge and belief.

SANTHOSH KUMAR SD

PLACE: - Bangalore

Contact this candidate