SQL DBA & BI, 5.6+ yrs Exp, Lead Consultant, India

SOURAV MUKHERJEE

Mobile: 096********

E-Mail: ******.********@*****.***

In pursuit of career enhancing assignments in the field of Software Solutions & DBA Support with an organization of repute.

PROFESSIONAL SNAPSHOT

A result oriented professional with over 5 years of rich experience in the field of Database Admin Support with further zeal to excel in IT sector as a Technical Delivery Database Support Executive.

Presently associated with Hitachi Consulting, Pune as Lead Consultant.

Completed B.Tech. (Computer Science) from Narula Institute of Technology. West Bengal University of Technology.

Successfully completed projects on ”SQL Server 2000 In-house Training on SQL Server DBA” & on OSIT –PPR” with Satyam Computer Services Ltd., Hyderabad, etc.

Technical proficiency in handling Microsoft SQL Server Database related issues both in Production and non Production Environments with expertise in doing rigorous troubleshooting on Database Backup, Restore, Replication, Log Shipping, Database Mirroring, installing SQL Server 2000,2005 and 2008 both in Standalone and Cluster Environments, etc.

Adroit in providing effective resolution to customer queries related to product and improving relationships with the customer by anticipating customer future requirements, thereby ensuring a positive customer experience.

Excellent communication & interpersonal skills with abilities in resolving complex software issues.

CAREER CONSPECTUS

Hitachi Consulting, Pune Jan ’11 – Till Date

Designation : Lead Consultant

Key Deliverables :

Working as a SQL Database Administrator in the Managed Services Team of strength 6.

Mphasis, an HP Company, Pune Aug ’10-Jan`11

Designation : Principal Infrastructure Engineer

Key Deliverables :

Working as a SQL Database Administrator and doing the task of a technical team member and managing a SQL project of strength 3.

Wipro Technologies, Bangalore Oct ’09- Aug ‘10

Designation : Database Administrator

Key Deliverables :

Worked as a SQL Database Administrator and had experience in troubleshooting Database related issues in both Production and Non Production environment.

Looking after database / system backup and recovery, hardware sizing (CPU, memory, disk space), database replication (snapshot, synchronous) using database specific tools as well as third-party tools application and database level security modelling.

Handling activities like database server performance tuning and optimization, troubleshooting, query performance tuning and disk space management.

Preparing application design, software requirements specifications (SRS) documents and logic designs.

Mahindra Satyam, Hyderabad Nov ’06- Oct ‘09

Designation : Software Engineer

Key Deliverables : Worked as a SQL Database Support Analyst and had exposure to work as an Application DBA as well.

SCHOLASTICS

2006 B.Tech. (Computer Science) from Narula Institute of Technology. West Bengal University of Technology.

Secured 8.33 DGPA.

2001 XII from Ariadaha Kalachand High School, W.B.C.H.S.E. Secured 66.6%.

1999 X from Ariadaha Kalachand High School, W.B.C.H.S.E. Secured 83.6%.

CERTIFICATIONS

Pursuing Distance Learning MBA Program from Sikkim Manipal University. Completed First Year.

Successfully cleared four Microsoft Certification Papers (MCP)

Microsoft Certified Professional

Transcript Id: 865304

Access Code: 25648168

Website: https://mcp.microsoft.com/authenticate/validatemcp.aspx

MCP Certifications

Installation & configuring, SQL Server 200*-***-***, Secured 87%.

Designing & implementing, SQL Server 200*-***-***. Secured 96%.

Developing & Implementing, Windows-Based Applications with Visual Basic.NET and Visual Studio.NET070-306. Secured90%

Upgrade: MCDBA Skills to MCITP Database Administrator by Using Microsoft SQL Server 2005. 070-447.Secured78.2%

ITIL Certification

Candidate No: SR7091904

Registration No: TDASYD52C9

Website: http://www.itil-officialsite.com/ITILEISCRSquery.asp

ITIL V3 Foundation Examination (by EXIN). Series 101, Secured 87%.

ACCOLADES/ ACHIEVEMENTS

Holds distinction of appearing twice in the State Chess Tournament.

Bagged 3rd position Javelin Throwing & Long Jump in the Zonal Inter School Athletic Competition.

Attended various EXTEMPO during school and College days, Passed Junior Diploma (Part-II) in Fine-Arts.

Received certificate of merit NIIT All India Aptitude 2005.

Received recognition as the Champion in the school annual sports events.

Awarded "Feather in my Cap" for the best performance in the project in Wipro Technologies.

Service Delivery Excellence Award in Microsoft BGCOE project in Satyam Computer Services.

Actively provide solutions to the SQL Server community in Microsoft public newsgroups and other popular SQL Server mailing lists, E.g, MSSQLTips.com, SQLServerCentral.com

PERSONAL VITAE

Date of Birth : 5TH January 1983

Linguistics : English, Bengali & Hindi.

Present Address : Flat No “O”-02, Ground Floor, Koyana, Sahakari Sanstha, Srinagari Society, Near Amanora Park, Opposite Swagath Macchi, House, 17 Nalis, Hadapsar, Pune – 411028

Permanent Address : 18/3/16, Kumud Ghoshal Road, Ariadaha, “Falguni”, Kolkata-700 057.

Passport No : G0093466

Validity : 12/01/2007 to 11/01/2017

URL : www.freewebs.com/sourav_tech

ANNEXURE

Project -1

Title : SQL Server 2000 In-house Training on SQL Server DBA

Client : Satyam Computer Services Ltd.

Role : Software Engineer Trainee

Organization : Satyam Computer Services Ltd.

Location : Bahadurpally, STC , Hyderabad.

Duration : 3 Months (Nov 06, 2006 – Feb 10, 2007)

Team Size : 3

Synopsis : Backup and Recovery of Databases.

As a part of training creating and maintaining sample databases was performed in SQL Server 2000, taking Backup and Recover the databases in different situations and performed Database and Server administrative activities like monitoring the SQL Jobs.

Resposibilities:

• Installing SQL Server 2000 software in different systems(default and named instances).

• Managing SQL Server 2000 server instances, client-server connectivity.

• Assigning Permissions to users (Windows Authentication and SQL Authentication).

• Creation of databases, tablespaces.

• Monitoring database growth and control plan.

• Taking backup and Recovery of the database and restoring the databases. Analysis of locks, isolation levels and checking the indexes.

Project -2

Title : OSIT –PPR (Operations IT – Product Pricing & Release)

Client : Microsoft Corporation

Role : Production Support Analyst

Duration : 02/08/07– 16/10/2009.

Environment: SQL Server 2005, Windows XP, Windows server 2003 Enterprise Edtn.

Team Size : 18

Synopsis

Providing

• Support to 24 X 5 Days.

• Access to the users by running backend scripts

Identifying the issues with the help of running SQL Server queries in the backend database. Checking the locking, blocking and deadlocking by running appropriate queries and taking proper steps to handle it.

Running the SQL Server Profiler to identify the issues related to the application. Also checking the server event logs (Web servers) and checking the Error Logs (Backend servers) to identify the issues.

Monitoring and managing both the front end (webserver) and backend server (SQL Server), changing password to the service accounts in every 60 days intervals, applying security patches.

Monitoring & Configuring

o Replication and troubleshooting the issues.

o The Batch Jobs which runs on scheduled timings.

o Working on the Sharepoint tool to handle the customer issues

Hands on experience in Logshipping.

Working with IIS 6.0, checking NLB, doing drainstopping activities and performing initial trouble shooting issues related to Clustering like failover, failure reason analysis.

Creating Bugs/DCR (Data Change Requests) to resolve any issues to the tool using VSTF(Visual Studio Team Foundation) and Microsoft Product Studio.

Sending Notifications/ Alerts to the Customers using the tool Commbuilder (Microsoft Internal Tool).

Dropping Patches to the Production Environment in Monthly Production Patch Cycle or Out Of cycle.

Working as a PSA (Project Support Analyst) during the Quarterly Releases Phases.

The pitfalls in the previous versions on demand of the customers

Creating KB Articles and Posting in Primus.

Giving presentation to the team and also providing internal training.

Dedicated to handle issues related to – 5 servers. If not able to troubleshoot, escalating it to different team.

Installing Hotfixes in production servers.

Taking backups and restoring the databases.

Server related performance tuning – e,g, checking CPU status, I/O, Memory etc.

Project -3

Title : Database Services SQL (ANZ Bank)

Client : ANZ(Australia New Zealand Banking Corp.)

Role : SQL Server DBA

Organization : Wipro Technologies

Duration : 23/11/2009 – Till Date.

Environment : SQL Server 2000, 2005, Windows server 2003 Enterprise Edition

Tools Used : SQL Litespeed, Red Gate SQL Backup, Rock solid tool to monitor the jobs and alerts, Fog light tool (from quest software) to monitor the performance of the servers, AHD (Advanced Home Desktop) tool for monitoring tickets, DAMWare (to connect to servers), etc.

Team Size : 10

Synopsis

Giving support to all the ANZ Bank production (500+ servers) and non Production servers (300+). All the ANZ banking applications are connecting to the servers to get

the data.

Responsibilities

Maintaining more than 350+ Production servers in different domains and 300+ Dev and Test Servers.

Installing, configuring, administering and securing clients' production servers.

Taking the backup and restoring the databases and implementing disaster recovery plans for production servers.

Capacity planning (space management).

Handling disk space issues.

Implementing and administering database replication between SQL Server databases

Troubleshooting performance issues. Monitoring blocking, deadlocking, locking and taking preventive action once that occurs.

Configuring logshipping.

Creating weekly jobs for period maintenance.

Handling cluster related issues.

Installing hotfixes to the production and non production servers and changing the password of the service accounts.

Providing weekend oncall support from home using the escalation mobile.

Using the AHD (Advanced Helpdesk) tool by Computer Associates to create the tickets.

Using the automated tools: SQL Litespeed(for backup/restore), Rocksolid tool(for diskspace usage, backup/restore job failure issues, CPU and other server health checks, Cluster Heart bit check, etc..)

Project -4

Title : Kraft Foods Corp

Client : Kraft Foods Corp

Role : SQL Server DBA

Organization : MphasiS, an HP Company

Duration : Aug, 2010 – Jan, 2011

Environment : SQL Server 2000, 2005, 2008 and Windows server 2000 and 2003 Enterprise Edition

Tools Used : DW (Digital Workflow), DBArtisian Tool (To connect to SQL Servers in a single window to manage it appropriately) and TSM (Tivoli Storage Management)

Team Size : 16

Synopsis

Giving support to all the Kraft Foods Production and Non Production SQL Servers.

Working as a Project DBA to build all the SQL Servers and also to work as a Oncall DBA to support production failure issues on a rotational basis.

Responsibilities

Maintaining more than 350+ Production servers in different domains and 300+ Dev and Test Servers.

Providing SQL Database Admin Support to more than 1000+ Database SQL Servers.

Working on backup, restore issues, installing SQL Servers to both Production and Non Production Environments and also in Cluster Servers, Configuring Replication, DB-Mirroring, Logshipping, In place Migration and also Side By Side Database Migration, Capacity Planning.

Project -5

Title : Managed Services

Client : Shared Clients - JLT Group Ltd., Southern Railways, Peel Ports, British Airways, Mitchell and Butlers (MAB), PepsiCo, Whitbread, Dalkia, GSI, Idea Schools, Lombard

Role : SQL Server DBA (Lead Consultant)

Organization : Hitachi Consulting

Duration : Jan, 2011– Till date

Environment : SQL Server 2000, 2005, 2008 and Windows server 2000 and 2003 Enterprise Edition

Tools Used : Service Desk Ticketing Tool, Ground Work tool by IBM to monitor all alerts and jobs, PAL (Performance Analysis Log) to analyze the performance monitor, LiteSpeed.

Team Size : 7

Responsibilities

Installed SQL Server 2008 R2 in Production SQL Server (Both in Cluster and also in Standalone system).

Successfully completed the migration of SQL Server, BizTalk and sharepoint databases from SQL 2005 to SQL2008.

Successfully migrated SSRS reports from SQL 2005 to SQL 2008 R2.

Creating and maintaining various databases on development and also in Production environment and provided 24 X 7 support.

Involved with performance tuning of queries, optimization of procedures and codes and SQL server auditing to have a better system performance.

Configured Synchronous and Asynchronous Database Mirroring between SQL 2008 R2 Prod and DR servers.

Configured Log shipping from Production to DR server.

Configured replication and providing support fix based on the issues encountered due to replication.

Good hands on experience working with Windows Cluster and resolving the issues.

Writing complex T-SQL statements and stored procedures and Cursors based on the requirement of the user.

Applying SQL Server patches and cumulative updates to the servers.

Contact this candidate