Sql Server Database Administrator
Resume:
RESUME
Jerry Jacob
***********@*****.***
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 : ***********@*****.***
Mobile : 984*******
PanCard Number : APTPJ9595M
Contact this candidate