RAUSHAN RAJ

E-mail: adl0v1@r.postjobfree.com Mobile:- +91-735*******

CAREER OBJECTIVE

To work for an organization in which I can enhance my learning’s, acquire new skills and contribute effectively towards the fulfillment of the company’s goals.

PROFESSIONAL SUMMARY

4.4 years of IT experience in SQL Server Database Administration and Implementation in Production, Development, QA, and Test environments in Retails and Global Investment Project.

Experience in installing and configuration and maintenance of SQL Server 2008R2, 2012, 2014, 2016 and 2017

Experience in applying latest service pack and CU update in SQL server 2012\2014\2016\2017.

Verifying and resolving the SQL server blockings and deadlocks.

Experience in side-by-side migration and upgrade process from 2008\2008R2 to 2012\2014\2016\2017.

Hands on experience in DBA activities like SQL Server Maintenance, Disk Space management, Security Issues, Database Backup and Recovery

Handling Incident tickets, high priority and low priority tickets.

Experience in Net Backup Client Tool for scheduling Backup and Restore.

Good experience in Configuration of SSRS & Deploying SSIS packages.

Experience in creating Logins, Users, Roles and assigning permission as per client requirement.

Experience to fixing the SQL failed jobs.

Hands on experience shrinking the Log file and temp db.

Configured Database mail and creating linked server between SQL server instances.

Hands on experience import & export one-database tables to another database as per user requirement.

Hands on experience on creating maintenance plan and worked on index fragmentation to tune the database.

Experience in Log shipping, Database mirroring and Always on configuration and fixed the issue related to log shipping.

Configured Active/Active and Active/Passive clustering for failover and Hands on experience in troubleshooting on failover cluster.

Experience to perform Always on restore and failover activity.

Involved in defining a trace, specifying trace events, selecting data columns and managing traces for databases using SQL Profiler.

Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries and deadlocks and Application server slow issues.

Experience in new project transition KT.

Experience in creating technical documentation and change management process.

Provided 24*7 Production support for the database services and application issue.

Got Award “Pat on back” from client side .

TECHNICAL SKILLS

Databases : MS SQL Server 2008/2008R2/2012/2014/2016/2017

Operating Systems : Windows 2003/2008/2012 R2/2016 Servers

Highly Availability : Database Mirroring, Log Shipping, Clustering and Always On .

Backup Tool : Netbackup7.6

Ticketing Tool : Ipcenter,ITSM, Zabbiz, GLPI, Nagios .

Cloud : Azure 104

EDUCATION PROFILE

Bachelor of Technology from Ghanashyam Hemalata Institute of Technology and Management, Puri with aggregate of 68.8% .

WORK EXPERIENCE

Working as SQL Database Administrator in CGI from 30th Nov 2016 to till now . CURRENT PROJECT

Project name : Russell Investment

Role : Database Administrator (Production Support)

Team Size : 8

Environment : SQL Server 2008, 2008 R2, 2012, 2014, 2016 and 2017

Description : US based finance domain project, we are supporting and troubleshooting 24*7 for production support as prime DBA .

ROLES AS A DBA

Installation & Configuration of SQL Server 2008/2008 R2/2012/2014/2016/2017.

Performing Upgradation/Migration from SQL Server 2008/2008R2 to 2012/2014/2016.

Applying SQL Server Service Packs and CU on SQL Server 2008/2008R2/2012/2014/2016.

Creating Maintenance plan & Scheduling jobs, Alerts in SQL server.

Responsible for all tickets like Incident/Change/service request.

Daily monitoring health check of servers and drive space.

Executing scripts on specified database and provide output based on customer request.

Verifying and resolving the SQL Server Blocking, Disk Space & SQL Agent Job failure issues.

Performing DB Refresh from Production to Test / Development as per business request.

Resolving the SQL Event related to SQL services, disk space, tempdb, log space, CPU and memory.

Hands on experience on creating maintenance plan and worked on index fragmentation to tune the Database.

Hands on experience in High availability Database Mirroring and Clustering.

Performing Configuration of SSRS and deploying SSIS Packages

Troubleshoot query performance issue

Providing weekend On-Call support as a Primary\Secondary on rotation basis.

Provided 24*7 Production support for the database services and application issue.

# PROJECT

Project name : TALK TALK

Role : Database Administrator (Production Support) Team Size : 6

Environment : SQL Server 2005, 2008, 2008 R2, 2012, 2014 & 2016 Description : TalkTalk was a UK based Telecom Industry, we are working as prime DBA team for production environment 24*7 .

ROLES AS A DBA

Installation & Configuration of SQL Server 2008/2008 R2/2012/2014/2016 on Local System and Remote System.

Performing Upgradation/Migration from SQL Server 2008/2008R2 to 2012/2014/2016

Applying SQL Server Service Packs and CU on SQL Server 2008/2008R2/2012/2014/2016.

Creating Maintenance plan & Scheduling jobs in SQL server.

Performed Database backups and restore through tools like Net Backup Tool and Backup Exec.

Hands on experience in creating linked server SQL to SQL & SQL to oracle.

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

Hands on experience in backup and restore databases as per client requirements and troubleshooting orphaned users

Import-export tables from one server to another sever

Hands on experience shrinking the Log file and temp db.

Resolving the SQL Event related to SQL services, disk space, tempdb, log space, CPU and memory.

Hands-on experience in resolving blocking, deadlocks and performance issues like CPU and Memory issue.

Hands on experience on creating maintenance plan and worked on index fragmentation to tune the database.

Working in log shipping configuration and fixed the issue related to log shipping.

Working in always on configuration and performed always on restore activity and failover. DECLARATION

I hereby declare that the above-mentioned information is correct up to my knowledge and I bear the responsibility for the correctness of the above-mentioned particulars. Place: Bangalore Raushan Raj .

Contact this candidate