Sql Server Data

**** *** *** ****

City : Richmond

State : Virginia

Zip : 23228

Email : ********@**.***.***

Mobile : 804-***-****

GOUTAM GHOSHAL

PROFILE

Accomplished information Technology offering around 14 years of demonstrated career and a wide range of skill set roles and industry verticals in IT Industries

Highly experienced database architect with experience designing, implementing, and managing enterprise relational and dimensional solutions

Involved with Microsoft SQL Server architecture and administration since the initial versions using Microsoft tools to implement relational and dimensional database solutions

Highly skilled using ERwin to design and implement database solutions

Strong problem solving and technical skills coupled with confident decision making for enabling effective solutions.

Extensive experience with analysis, design, development, customizations and implementation of applications software development and Database Management.

Experience in leading teams. Handled multiple roles - Project Lead, Database Architect, Database Administrator, Application Developer, Web Developer.

Have been associated with Media and Telecom industry (Virgin Media, NTL), Consumer Product and Distribution Sector (McCain, Phillip Morris), Financial (Standard n Poor’s) Logistic, Accounts and Payroll.

Good communication skills, interpersonal skills, self-motivated, quick learner, team player.

Skill Set

Designed relational databases to support several of the company’s core database system

Design Physical, conceptual and logical data modeling, Data Architect.

Designed and implemented much of the current corporate data warehouse,datamart.

Implemented ETL processes to load data warehouses and copies of reporting databases

Set the standards for database design and implementation

Heavily employed Microsoft database tools including SQL Server 2000-2012 Relational Engine, Integration Services and Computer Associate’s ERwin data modeling tools and some experience with Analysis Services

Design Physical and logical data modeling,

Education:

Master of Computer Applications (MCA)

Professional Qualification :

Designing, Optimizing and Maintaining a Database Administrative Solution Using MS SQL Server 2008

Microsoft Certified IT Professional Database Administrator

Microsoft Certified IT Professional Database Developer

Microsoft Certifies Technology Specialist SQL Server 2005

Microsoft Certified Professional

Undergone Certificate Course in Oracle 9i Data Warehousing from SQL Star International Limited.

Undergone Certificate Course on Client Server Computing Architecture with Oracle 8.0 from Software Technology Group International Ltd. (STG).

(Exposures: Client server concepts, Conceptual & Physical Schema, Internal Components of Oracle 8.0 kernel, SQL*Plus, PL/SQL, Developer/2000).

Professional Experience

March 2007 – Till date, Senior System Engineer IBM India Pvt. Ltd. Kolkata, India

As a Senior System Engineer in IBM, representing as Database Administrator and Team Lead for Philip Morris USA. Deputed on Client location.

Project: Altria ( Philip Morris USA)

Project Name : Altria AMS (Onsite)

Client – Philip Morris USA

Database Administrator and project lead in Altria. Senior Advisor for several other internal projects.

Highly involved with Data Requirement Analysis, Data Modeling and Data Architecture.

Apart from core capabilities involved in the following responsibilities.

Logical and physical data modeling and final database design for OLTP internet business to business communications and information system .

Day-to-day DBA responsibilities for backups, uptime, performance & optimization of code developed by developers.

Day-to-day production management and automation of all necessary and helpful reporting and of care-and-feeding of mission critical databases and applications.

Providing support for more than 1020 database instances.

Working on tickets generated across all environments related to DB modeling, Design.

Applying patches and upgrading DB’s.

Implementing various database alerts.

Stringent monitoring and checking the log files, and Space management.

Monitoring DTS/SSIS jobs and troubleshooting DTS/SSIS job issues.

Creating SQL jobs / Maintenance Plan / Maintenance Clean up task .

Involved in designing jobs for Database management as well as backup and restore strategy.

Establish Quality Procedure for the team and continuously monitor and audit to ensure team meets quality goals.

Established standards for SQL installations, maintenance, tuning and coding

Environment: Microsoft Windows XP, Windows 2003, SQL Server 2000,SQL Server 2005 and SQL Server 2008, MS SQL Server SSIS,Analysis Services and Reporting Services, Crystal Reports, Internet Information Server 4.0 and 5.0. IBM ManageNow, IBM Maximo,

As a senior SQL Server Database Administrator worked for McCain Food and NTL Leah Virgin Media as DBA and Data Architect.

Project: McCain Foods AMS

Project Name : McCain Foods AMS (Offshore)

Client – McCain Food

Responsibility as a Database Administrator and Data Architect .Designed Logical and Physical data modeling for OLTP module for the business apart from following were my day to day activities:

Designed a Data Warehouse (SQL Server) to be fed from sixteen legacy systems.

Installed and manages several Data Servers and hundreds of databases.

Supported Several OLTP, Reporting and Business Intelligence applications on MS SqlServer. 2005,2008

Performed day-to-day support, performance tuning and optimization..

Optimized the data Base Architecture, All data access programs and the business functions. Did Extensive tuning for performance and stability. This resulted in increasing the trade volume processed by 100 percent, without increasing the program support staff or computer and network hardware.

Maintaining other DBA activities, stringent monitoring and checking the log files, and Space management.

Monitoring SSIS jobs and troubleshooting SSIS job issues.

Creating SQL jobs / Maintenance Plan / Maintenance Clean up task .

Involved in designing jobs for Database management as well as backup and restore strategy.

Environment: Microsoft Windows XP, Windows 2000,2003, SQL Server 2005,SQL Server 2008, MS SQL Server SSIS,Analysis Services and Reporting Servises, Crystal Reports, Internet Information Server 4.0 and 5.0. ErWin

Project: Virgin Media Leah Internet System

Project Name : NTL Leah Virgin Media (Offshore and Onsite)

Client - Virgin Media

Performed a role of Senior Database Administrator and Data modeler.

Primarily involved in Data Architect, Conceptual Data Modeling, Enterprise Data Modeling designing Physical and logical Data modeling and then final database of various new modules and applications. Performed Extensive Data Analysis & Modeling. Apart from following were my day-to-day responsibilities.

Database Performance Tuning, and Disaster Recovery

Setting up Base lining and Capacity Planning

SQL Server Hardware sizing and bottleneck tuning

Auditing SQL Server Security

Data Transfer / Transformation

Plan, Design and Scheduled Database Maintenance & Administrative Tasks

Configuring Replication / Data Synchronization

Installing & Configuring SQL Server Analysis Services on clustered environment

Memory Management for SQL Server Analysis Services

Cube Deployment using BIDS, deployment wizard, XLMA Script

OLAP / CUBE database (s) synchronization

Database Backup Restore Strategy design and Implementations for OLAP Databases

Logging, Monitoring, and Optimizing an Analysis Services Solution

Backing Up and Restoring an Analysis Services Database (OLAP)

Installing and Configuring Integration Services on Clustered Environment for High Availability

Troubleshooting and Optimizing SSIS package performance

Deployed and Scheduled DTS SSIS Packages

Environment: Microsoft Windows XP, Windows 2000, SQL Server 2005,SQL Server 2005 Internet Information Server 4.0.

October 2005 – February 2007,Database Administrator ELECOM SOFTWARE PVT LTD, Kolkata, India

As a Senior SQL Server DBA, Involved in building physical and logical data model design Enterprise Data Warehouse Design, Operational Datastore and Datamart Design.

Responsibilities included typical DBA activities, Management of DBA group, Performance Measurement, Tuning & Optimization and the following day to day activities.

Performed Business Requirement Analysis, Data Analysis and Modeling.

Performed Several Server installations, upgrades, maintenance, day-to-day operation, and optimization and tuning.

Collaboration in the design of databases emphasizing performance, integrity and usability

Taking care of backup/Storage management through out the organization.

Creation and maintenance of highly available, secure, and reliable production database environment

Creating, maintaining and monitoring scheduled applications and events

Developing, implementing and maintaining scheduled production extract-transform-load processes within and across database environments

Supporting and, when possible, participating in the development of all applications leveraging the databases including both desktop applications and web applications.

Developing data analysis and reporting for business users. Working directly with the business to gather and interpret requirements, test and certify results, and deploy solutions

Responsible for evaluating new software/Hardware/Tools & Technology and providing recommendations to the Head of IT regarding its role and potential benefits to the firm.

Involved in migration of SQL SERVER 2000 databases to SQL SERVER 2005 databases.

Work with Business Analyst in translating business requirements into Functional Requirements Document and to Detailed Design Documents

Coordinate and communicate tasks with developers

Established standards for SQL installations, maintenance, tuning and coding

Ensure that development is performed as per requirements

Work with QA to create test scripts and scenarios for enhancements and customizations to the core product

Environment: Microsoft Windows XP, Windows 2000, SQL Server 2000,SQL Server 2005, MS SQL Server 2005- SSIS,Analysis Services and Reporting Services, Crystal Reports, Internet Information Server 4.0 and 5.0

March 2005 – October 2005, Database Administrator DEBENO INDIA INFOTECH PVT LTD, Kolkata, India

DEBONO is a Product Development and Outsourcing company, Here I worked for a Client: STANDARD & POOR’S

As a Database Administrator, I was involved in Upgrading, and configuration of SQL Server database software, MS SQL Server Installation.

Managed acquisition of Bond market data, created models and global indices for Mutual, pension and sovereign funds benchmark their performances.

Responsibilities included day-to-day DBA activities (SQLServers), Management of DBA group, Performance Measurement, Tuning & Optimization for throughput and response time,

Database creation, configuration, optimization and migration, Database re-engineering,

Backup, Recovery and Disaster Planning,

Database performance monitoring, troubleshooting,

Database related documentation.

Environment: Windows2000, SQL Server 7, SQL Server 2000, Crystal Reports.

April 2003 – February 2005, Database Administrator ZODIAC EXPRESS PVT LTD, Kolkata, India

Performed multiple role a Senior Programmer and Database Administrator and tech lead, Performed typical DBA role and involved in designing Data-warehouse and datamart.

Led small team (8 SQL developers).

Tech lead role on development of interfaces to trading (front-office) logistic and financial systems.

Designed and implemented application architecture. Logical and Physical Database design for front end application. User and subject matter expert interfacing. Infrastructure design and documentation.

Environment: Windows2000, SQL Server 7,SQL Server 2000, Crystal Reports. Visual Basic 6,

References: Available upon request

(Signature)

Goutam Ghoshal.

Contact this candidate