Sql Dba Resume 4c4t3c

SureshKumar SQL Database

Mobile: +91-9686703300

[email protected]

PROFESSIONAL SUMMARY:  4.2 Years of Experience in Installation, Configuration and istration of MS SQL Server 2008, 2005 and 2000 in production, test and development environments.  Experience in configuring and maintaining High Availability Features Like log shipping, Mirroring and Replication.  Experience in defining backups, restores and Disaster Recovery solutions  Ensuring the Data consistency in the database through DBCC Commands.  Experienced with Troubleshooting database issues, performance issues and blocking issues.  Proficiency in improve Performance using Execution Plan, Database Tuning Advisor.  Experience in Creating and Managing Databases and adding data files and log files to the Databases whenever it is required.  Experience creating s and s in the SQL server environment and granting permissions to the and s.  Experience in Creating scheduled Jobs, alerts and Maintenance plans.  Database scheduled backups and recovery.  Daily activities include monitoring Databases, checking error logs, Event logs, checking the log file size and free space in the data drives, connectivity of the databases.  Exposure to migrating SQL Server Databases.  Upgrade the databases to SQL Server 2000/2005 to 2008  Extensive experience in ing 24x7 production environment.  Excellent communication, interpersonal skills and highly motivated with strong commitment to quality and client service. PROFESSIONAL EXPERIENCE:



Currently working as a MSSQL Database for IBM, from July 2014 to till date.



Worked as a MSSQL Database for iGate, from Sep 2011 to June 2014.

EDUCATION: 

Master Of Computer Applications from Vinayaka University, TamilNadu

TECHNICAL EXPERTISE: Operating Systems

: Windows 2008, 2003 & 2000 Servers and XP.

Relational Databases

: SQL Server 2008R2, 2008, 2005, 2000.

Database Technologies

: SSMS, DTS, Perfmon, Profiler, Red gate.

Programming Languages Applications

: T-SQL : Microsoft Office.

PROJECT PROFILES: Project Project

#1 : Discover Financial Services

Client

: Discover Financial Services, US

Role

: SQL Server DBA

Team size

:6

Duration

: July 2014 to Present.

Synopsis: Discover Financial Services is a direct banking and payment services company with one of the most recognized brands in U.S financial services. The company has become one of the largest card issuers in the United States. The company operates the discover cards and offers personal and student loans online saving s and money market, Discover card was one of the earliest to offer 24/7 customer service and secure numbers for online purchases. Roles and Responsibilities:  Database istration for Development, Test and Production servers with MS SQL Server 2008R2, 2008, 2005 on windows 2008, 2003 Server.  MSSQL Server 2008, 2005 and installations, configuration and security settings for standalone servers.  Configuring and maintaining SQL Server high availability solutions that include Log shipping, mirroring and Replication.  Having knowledge on rebuilding master, msdb databases during crash situations.  Maintaining and Creating s, s and giving permission to them as per request.  Creating and Maintaining scheduled jobs and implementing automation for other tasks.  Experienced in using Red gate, third party tool for backup and restore of Databases.  Perform Full, Differential Backups and Transaction Log Backups, Restore them whenever necessary, creating back up strategies and scheduling them for automation.  Involved in troubleshooting, resolving data integrity and monitoring performance issues.  Handling blocking issues and troubleshooting accordingly.  Maintaining the database consistency with DBCC commands at regular intervals.  As per hardening measure, changing system and databases of default location.  Performing Shrink operation while having space issues based on the situation.  Creating and Managing Databases and adding data files and log files to the Databases whenever it is required.  Reorganize or Rebuild indexes and update statistics of a Database whenever it is required and improving the efficiency of a Database.  Upgrading the databases to SQL Server 2005 to 2008/2008R2  Restoring databases from one server to another.  Providing 24X7 s to all the production databases. Project

#2

Project

: Allied Health Claims

Client

: Allied Insurance, USA.

Role

: Associate SQL DBA

Team size

:8

Duration

: Sep 2011 to june 2014.

Synopsis:

Allied Insurance is one of the largest insurance companies in USA. It deals with different kinds of insurances and this project mainly deals with Health Insurance. It has an automated online system which maintains all policy details, Medical details of patient and claim details. The functionality of this project is covering the insurance coverage details of the patients and storing the details of the services rendered by physicians and patient claim payments, outstanding and paid-up amounts, adjustments, etc.

Roles and Responsibilities: 

Responsible for Managing Production, Development and Test Databases for 24x7.



Responsible for Backup and Recovery of Database.



Created Server s and Database Roles to define Security.

 istering SQL Server by Creating s with appropriate roles, monitoring the s, creation of groups, granting the privileges to s and groups. SQL Authentication.  Scheduled Full and Transactional log backups for the created and system databases in the production environment using the Database Maintenance Plans. 

Creating and Maintained Operators, Alerts, Notifications, Jobs, Job Steps and Schedules.

 Maintaining the database consistency using DBCC at regular intervals to minimize complexity. 

Resolving fragmentation issues.



Managing Permissions, and creating appropriate s, database s, roles.



Preparing daily reports like disk space report.



Responsible for task completion on a timely and accurate basis.



Resolving blocking and monitoring dead locks.



SQL server daily health check.