Sql Server Service

NAME: CHETAN KUMAR

E-MAIL:***************@*****.***

PHONE:+91-990*******

Experience Summary:

IT professional with around 5 year’s hands-on experience in managing large-scale databases in production support environment on windows platform. A database administrator with a proven track record of technical skills, who has the ability to work on multiple highly visible projects, is a creative problem solver, and has an aptitude for learning.

SQL DBA Summary:

•Having 4.6 years of production and development experience in MS SQL Server (2000, 2005, 2008R2 and 2012) on Windows (2003, 2008, and 2012) environment.

•Experience in Installation, configuration Microsoft SQL Server 2000, 2005 and 2008R2 with latest service packs.

•Hands on experience in SQL Server version Upgrade, Data migration, performing database refresh and scheme refresh.

•Having Experience in database Backup\restore, Attach\Detach & import export methods. Implementing the backup plans and configuring Database Maintenance Plan.

•Designed SQL Server instance-level, database-level and object-level security policies.

•Performance tuning: database tuning and query tuning.

•Configuring and managing High-availability solutions Mirroring and Log Shipping.

•Worked on the data synchronization solution replication.

•Having experience on large size production Databases.

•Having experience in creating and maintaining BI (SSRS & SSIS) packages.

•Used BCP utility to publish table output to text files.

•Scheduling SQL Server Agent Jobs, configuring database mail, alerts and operators.

•Hands on experience in T-SQL, Creating the Database and Configure triggers, views and stored procedures. Creating and managing schema objects such as tables, views, cursors, indexes.

•Experience in using DBCC Commands and DMV Commands

•Experience in automating Administrative tasks by writing custom scripts.

•Analyzing Error Logs and take appropriate action to resolve any issues.

•Hands on experience Installing, configuring and administering MS SQL server Failover Clustering.

•Experience in capacity planning and database configurations recommendations based on applications criticality.

•Provide 24x7 DBA production support, work with DBA team for production on call support rotation. Resolve Database related trouble tickets assigned to the DBA group.

•Good analytical and troubleshooting and problem solving skills, Ability to work under stress with extensive working hours

•Customer Support Orientation.

Employment Details:

Company Name

Emp type

Job location

Designation

Duration

ITC InfoTech Pvt Ltd

Permanent

Bangalore, India

IT Consultant

Feb 2013 -Till Date

EF Information System Pvt Ltd

Permanent

Bangalore, India

SQL Administrator Database/Developer

Feb 2012- Feb 2013

Relyon Softech Pvt Ltd

Permanent

Bangalore, India

Implementation Engineer

Jul 2010- Feb 2012

Technical Certifications:

•Programming Languages : T-SQL, SQL

•Database : SQL Server 2005,2008, 2008 R2, and 2012,

MS Access, Oracle

•Operating System : Windows XP/7,Windows Server 2003, 2008 and

2008 R2

•ETL Tool : BIDS For SSIS,SSRS

Educational Qualifications:

•B.E (Electronics and Communication Engineering) :-

•From M.S ENGINEERING COLLEGE, Bangalore, Karnataka-India, 2009

•(Affiliated to Visvesvaraya Technological University-Belgaum India)

Professional Experience:

Current Project:

Project & Client : Misys

Role : SQL Server DBA

Duration : Feb2013 - Till Date.

Environment :SQLServer2000/2005/2008/R2/2012,Windows2003/08/R2/2012

Scope: Misys is at the forefront of the financial software industry, providing the broadest portfolio of banking, treasury, trading and risk solutions available on the market. Misys deliver sophisticated solutions to the most difficult challenges, but never forget the need to resolve the smaller issues on which the day to day running of the business depends. This 'macro to micro' approach is why 1800 companies in 120 countries trust Misys to provide their banking, treasury and capital markets systems.

Roles and Responsibilities:

•Creation of user databases and ensuring file group creations and also ideally placing files in appropriate locations

•Performing the database up gradations from lower version to higher versions and database refreshes form production to development.

•Configuring SQL Server instance-level, database-level and object-level security policies.

•Monitoring performance using both System Monitor and Profiler tool

•Capturing and tuning the long running query's using Ignite 8 monitor tool.

•Created Database Maintenance Plans for Index Defrag, checking database integrity, rebuilding indexes, Reorganize Index and updating statistics.

•Performing Disaster Recovery (DR) test on a Quarterly basis i.e., using VM ware concepts(Lun)

•Administrating the SSIS package and SSRS reports.

•Resolve ticket’s that are raises on Footprint Help Desk.

•Performed failover clustering whenever necessary.

•Developed SQL installation standards, automated install process

•Handling incident management calls

•On-Call responsibilities for Production database systems

•Working in rotational shifts and also providing on call support on weekends.

•Managed team of two DBA’s

•Creating requests and follow-up with various teams globally to complete the request on time

•Daily Monitoring SQL Server instance:

•Verify the appropriate services are running

•Check the Windows NT Event Viewer for error messages.

•Check for adequate disk space for growing database files and log files.

•Record disk free space for trending report

•Report any discrepancies found.

•Ensure network connectivity to the SQL Server

•Check SQL Server jobs (look for failures).

•Check the SQL Server logs for error messages.

•Verify the SQL Server transaction log backups were successful.

•Verify the full database backups were successful.

•Report any discrepancies found.

•Collect index fragmentation information

•Preparation of weekly report

EF Information System Pvt Ltd, Bangalore (Feb 2012 – Feb 2013)

Project Name : Elektra

Client : Education First Clients (Hult international school,

EF (Education First)

Duration : FEB 2012 to FEB 2013

Role : SQL Server DBA L2 Role

Description

Elektra is an Application which is used by the clients, there are two types of application one WPF (Windows Presentation Foundation) and other one is Web UI.

Education First is a list of all the client list supported by EF Information System Pvt Ltd, the list includes vast covered clients and normal priority clients. Some of the vastly covered clients are Hult international school, EF (Education Frist). We handle shared services for all these clients and their databases and the applications that EF Information System uses in collaboration with these respective clients.

We ensure that we support all the applications and the database servers and their availability is an important factor for data loads and feeds for the clients.

Job Profile

•Creating logins and assigning proper permissions to the created logins, mapping logins to the database and granting appropriate permissions

•Involved in Installing SQL Server and its service packs, and also client installations as required

•Creating Stored Procedures, Functions and Views

•Writing TSQL Queries

•Fixing the data issue in the application

•Data migration at object level from one server to another

•Monitoring free space of database

•Checking the status of backup, troubleshooting the failed backups and restoration of databases

•Monitoring SQL server performance using profiler to find performance and deadlocks

•Creating Indexes on tables to improve the performance as per Dev/App team request

•Recovering the databases from backup in disaster situations

•Monitoring the servers using third party tool like Ignite8,RedGate and SQL Monitor

•Monitoring/Maintaining HA options being used in servers Log Shipping, Clustering and Mirroring

•Performing SQL server daily health check and preparing a report based on it

•Experienced in Database Backup, Restore and Disaster Recovery procedures

•Scheduled and maintain routine Jobs, Alerts and Maintenance Plans

•Applying Service Packs and Security patches for the Servers as released

•Monitoring the Logs for successful execution of all the specified jobs

•Managing Backups on a daily basis and Recovery as per request

•Reviewing SQL Server and SQL Server Agent Error Logs

•Implemented and Maintaining Log shipping High Availability option, Replication

•Performing Disaster Recovery (DR) test on a Quarterly basis

•Work as part of a team and provide 24x7 supports when required

Relyon Softech Pvt Ltd, Bangalore (Feb 2010 – Feb 2011)

Project Name : Cenduit Client Pool

Client : Cenduit Clients (Novartis, Biocon, Astellas Pharma etc)

Duration : JUL 2010 to FEB 2011

Role : SQL Server DBA

Description

Cenduit Client Pool is a list of all the client list supported by Cenduit India service Pvt Ltd, the list includes vast covered clients and normal priority clients. Some of the vastly covered clients are Novartis, Biocon, and Astellas Pharma. We handle shared services for all these clients and their databases and the applications that Cenduit uses in collaboration with these respective clients.

Job Profile

•Creation of user databases as per request from client

•Creating logins and assigning proper permissions to the created logins, mapping logins to the database and granting appropriate permissions

•Involved in Installing SQL Server and its service packs

•Ensuring documentation is constantly updated without any miss

•Fixing orphaned users through stored procedures

•Monitoring the servers using third party tool like Ignite8 and RedGate

•Performing new instance installations as per build sheet

•Scheduled and maintain routine Jobs, Alerts and Maintenance Plans

•Managing Backups on a daily basis and Recovery as per request

•Reviewing SQL Server and SQL Server Agent Error Logs

•Maintaining instance/database-specific documentation and ensuring it is Up-to-date

Personal details:

Name as in Passport: Chetan Kumar

Permanent Address:

#1-4-155/204

Jyothi Colony,

Manthralayam Road,

Raichur – 584104

Karnataka

Date of Birth : 12-11-1987

Marital Status : Single

Nationality : Indian

Passport Number : J0787341/21-06-2020

Place: Bangalore

(Chetan Kumar)

Contact this candidate