RESUME

Jerry Jacob

acscwe@r.postjobfree.com

Phone: (M) +91-984*******

Career Profile

Around 4.5+ years of experience in Database Administration in SQL Server for production support( 24/7)

Good in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.

Administering SQL Server High Availability.

Good in Database backup and recovery models.

Worked on Database migration activity

Hands on experience on high availability like Replication, Database mirroring, Log shipping and clustering

Strong technical background along with the ability to perform business analysis and write effective documentation

Experience in supporting and troubleshooting the problems & provide trainings

Certification

Microsoft Certified Technology Specialist, SQL Server 2008 Implementation and

Maintenance

Professional Experience

Title : Database Administrator

Company : TATA CONSULTANCY SERVICES, Chennai

Client : NIELSEN

Duration : June 2014 – Till dated

Environment : Production Support (24/7)

Responsibilities:

Installation, configuring, backup & restore, tuning for SQL Server 2005,2008,2012,2014 (Standalone & Cluster) in DEV, QA & Production Server on Production Support 24/7

SPOC for all the North American servers and new integration.

Performed daily tasks,outages (Migration, patching & hot fixes)

Patching and Hot fix activity performed for SQL 2005 & SQL 2008R2,SQL2012,SQL2014

To ensure trouble free access to SQL Server databases 24 hours a day for all 3000+ instances across Globe data centre for NIELSEN

Configuring and troubleshooting high availability in Replication, Database mirroring, Clustering, HA-2012

Participate in taking technical session on SQL SERVER.

Database Administrator, Database Development.

Restoring of the table from Lite speed

Designed and implemented comprehensive Backup plan.

Recovering the databases from backup.

Rebuilding the indexes at regular intervals for better performance

Installation, Configuration of Database in local server and remote server (Dev, QA & Production Server)

Monitoring and Supporting Servicing Team during Live Auction

Application testing and Database testing before & after deployment along with the application team.

Managing Users, privileges and roles for database.

Deployment of SSIS Packages.

Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.

Deploying new code base release to UAT and Production Environments.

Rebuilding the indexes at regular intervals for better performance.

Solving the request raised by user support.

Participate in implementation of new releases into production.

Automated messaging services on server failures, for task completion and success

Export or Import data from other data sources like flat files using Import/Export through SSIS.

Installed & deployment using SQL Server 2008,2012,2014 Reporting Services

Title : Database Administrator

Company : HCL Technologies, Chennai

Client : Pentair

Duration : Dec 2010 – May 2014

Environment : Production Support (24/7)

Responsibilities:

Installation, configuring, backup & restore, tuning for SQL Server 2005,2008 (Standalone & Cluster) in DEV, QA,RTE & Production Server on Production Support 24/7

Performed daily tasks,outages (Migration, patching & hot fixes)

Patching and Hot fix activity performed for SQL 2005 & SQL 2008R2

To ensure trouble free access to SQL Server databases 24 hours a day for all 60+ instances across Globe data centre for Pentair

Configuring and troubleshooting high availability in Replication, Database mirroring, Clustering

Provide Knowledge transfer regarding Technical and process oriented to Fresher or new employee joining team.

Participate in taking technical session on SQL SERVER.

Database Administrator, Database Development.

Designed and implemented comprehensive Backup plan.

Recovering the databases from backup.

Rebuilding the indexes at regular intervals for better performance

Installation, Configuration of Database in local server and remote server (Dev, QA & Production Server)

Monitoring and Supporting Servicing Team during Live Auction

Data migration [Ms sqlserver 2000/2005], tuning SQL queries & worked on complete database documentation for databases

Application testing and Database testing before & after deployment includes local server,, remote servers and for other Clients.

Managing Users, privileges and roles for database.

Deployment of SSIS Packages.

Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.

Deploying new code base release to UAT and Production Environments.

Rebuilding the indexes at regular intervals for better performance.

Solving the request raised by user support.

Participate in implementation of new releases into production.

Automated messaging services on server failures, for task completion and success

Preparing Billing reports for Marketing & Sales team

Export or Import data from other data sources like flat files using Import/Export through SSIS.

Installed & deployment using SQL Server 2008 Reporting Services

Automated messaging services on server failures, for task completion and success

Recovering the databases from backup.

Achievements in Pentair

Best Team player 2012-2013

Achievements in Nielsen

Most valued person 2015-2016

Education

Qualification

Pass %

University

B.E EEE

73 %

Anna University

12th STD

84%

Kumaran Asan Memorial

10th STD

78.6%

Asan Memorial Higher secondary board

Strengths :

Have known to work and provide the best even under intense work pressure.

Very good in adapting to new environment and work very well with teams as well as individual.

Personal Information

Name : Jerry Jacob

Current location : Chennai, Tamil Nadu

Communication Address : Plot no-6, Samy Street

Sundarvizhi avenue extn

Rajakilpakkam

Chennai-73

Gender : Male

Language : English, Tamil, Malayalam, French

Marital Status : Single

Nationality : Indian

Email : acscwe@r.postjobfree.com

Mobile : 984*******

PanCard Number : APTPJ9595M

Contact this candidate