Sql Server Project Manager

HEMANT KORDE

**** ****** ***** ******: 609-***-****

Melbourne, Florida 32940 Home: 321-***-****

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

OVERVIEW

Certified Microsoft Professional (MCP) and certified Microsoft DBA (MCDBA) with several years of

IT experience in the corporate America including over 18 years in FORTUNE 500 corporations. Very

strong experience in both main frame and Windows based Database Administration, Project planning

and implementations, and as a project leader of both on site and off-shore project teams. Over 10 years

of experience working in the Database design and Analysis group as a project leader. Experienced in all

phases of production and application support areas of SQL Server 2000 and SQL Server 2005, including

production, development, and QA server administration, Developer support with TSQL tuning,

application performance tuning, server migration, cluster server, replications and ETL tools such as DTS

and SSIS packages.

Until February 28,2013 worked full time remotely from home as a consultant SQL Server DBA for a

company located in Fairfield New Jersey. Contract (since October 2011) was ended on March 1, 2013, As

a only DBA for this small but 24 X 7 financial processing company, responsible for maintaining two data

centers hosting several tests, QA and production servers and databases with over 1 TB data.

At present looking for a permanent or a consulting SQL Server DBA position near Melbourne Florida or

within a reasonable driving distance from home.

EDUCATION:

BS

CERTIFICATIONS:

Microsoft Certified Professional – MCP

Microsoft Certified DBA – MCDBA

VISA STATUS:

US Citizen

WORK SUMMARY

Complete database management of production, test, and QA servers by performing server level

•

performance, tuning, and improving production work load.

Performed important tables Index fragmentation analysis and fixed issues related to the

•

fragmentation.

Performed both side-by-side and in-place migrations of SQL Server 2000 to SQL Server 2005

•

production servers.

Installed clustered SQL Server 2005 in an Active/Passive mode to replace SQL Server 2000

•

production server.

Worked as a Project manager / Project coordinator and develop dot net applications using off-shore

•

developers and deployed finish projects at client’s location.

Set up and maintain Transactional and Snapshot replications between servers to provide production

•

level data integrity and failover strategy.

Used ETL tools such as writing DTS and SSIS packages to extract information from a back-end

•

VAX flat file source using CONNX.

Implemented various maintenance plans to perform timely full backups, differential backups, and

•

restores of production data bases.

Worked with application developers to code optimized TSQL stored procedures, user views, and

•

Triggers.

Wrote and tune several DTS packages to help efficient data migration between servers.

•

Worked as an application support and production support DBA for a credit card processing

•

company located in Fort Lauderdale, Florida with data base sizes of over 350 GB and total data over two

terra bytes.

Performed several critical performances tuning of long running stored procedures, index analysis,

•

server performance monitoring and server disk space monitoring, production implementations, query

profiling and carrying out other general DBA functions for both 2000 and 2005 servers..

Worked as an application support DBA, responsible for tuning stored procedures and monitoring

•

server performances of over 30 production servers containing several terabytes of data. Responsible for

monitoring and optimizing CPU utilization by query and index tuning procedures and resolving

replication related errors.

Involved in production implementation and all phases of production control and enhancements.

•

Conducted SQL Server 2000 and SQL Server 2005 courses for consultants of a New Jersey based

•

consulting company.

Installed new Instances, created databases, tables, triggers, and views for the developers. Provided

•

support to the developers during analysis, design, coding, and implementation of new applications.

Maintained user login, roles, and performed job scheduling using Enterprise Manager, SQL Server

•

WIZARDS, Query Analyzer, and SQL Server Agent.

Performed migration from SQL server 2000 to SQL Server 2005 using both side by side and in

•

place upgrade methods.

Over 15 years of solid experience as an ADABAS DBA in designing and developing large scale

•

high profile applications, creating and upgrading both production and test data bases, and supporting

backups and maintaining 24 X 7 production environments.

Performed total functional support of PREDICT data dictionary

•

TECHNICAL SKILLS:

Operating Systems: OS/390, WINDOWS 98/NT/2000, and XP

Databases: SQL Server 2000, SQL Server 2005, and ADABAS for main frame

Programming: T-SQL, COBOL, NATURAL and VB.

JCL/TP Monitors etc.: OS/JCL, COM-PLETE, MVS/VM, TSO, ISPF, VSS

Other Tools used: SQL Compare, SQL Server Profiler

EXPERIENCE:

2

Softgate Systems Inc. Fairfield, NJ

(10/2011 – Present)

At present working as a consulting DBA remotely from home in Florida. Still the only DBA providing

total server and application level support to the company responsible for below duties.

Softgate Systems Inc. Fairfield, NJ

(9/2008 – 10/2011)

Worked as a Sr. SQL Server DBA managing two data centers located in New Jersey and Cleveland.

Responsible for maintaining Production, QA, and test environments of the corporation, including

transactional and snapshot replications, disaster recovery plans, backups, complete support to the dot net

developers in-house and off-shore, performance monitoring and tuning, and migration to SQL Server 2005

projects. Heavily involved in writing several performance related stored procedures. SSIS Packages for

extracting data from backend Alpha system. Most of these DTS packages use third party software

CONNX to download data from a backend flat file processing system. Have completed project to installed

SQL Server 2005 in clustered environment and replace one of the most important but aging production

SQL Server 2000. Created and deployed several SSIS packages during migration of SQL Server 2000

databases. Saved IPP over $65K, proposed by outsourcing company in India, by completing in-house

migration of all servers, residing at three different data centers, from version 2000 to 2005. Also, IPP has

been saving over $48K per year, in consulting DBA fees, by discontinuing services of an outsourcing

company.

At present still working for the same employer as a consultant based in Florida after resigning from the

employment due to move to Melbourne, Florida.

.

ADP Virtual Edge, Newtown, PA

(3/2008 – 9/2008)

Worked as an Application Support DBA consultant in this fast growing and dynamic environment. This

newly acquired company has over 350 high profiled customers using 300 databases amounting to over 1

TB of data. Responsibilities included maintaining total development and QA environments including

weekly restores of all databases, supporting teams of developers situated in-house and in India,

performance tuning applications, reviewing ad hoc SQL scripts and Stored Procedures.

Satyam Computers, Paramus, NJ

(10/2006 – 3/2008)

Worked as Sr. consultant at one of the Satyam’s client located in northern New Jersey. Main

responsibilities included providing production and development support. IPP has production, QA, and the

development servers containing several small and large size databases including BizTalk databases. Some

of the work being done on a regular basis included writing DTS Packages, creating maintenance plan,

maintaining Transactional and Merge replications, backups, restores, query tuning, production data purge

and archive, application support such as table creation, file group management, writing stored procedures,

and Index tuning. Headed and completed migration project to move SQL Servers from IPP data center to

Cleveland.

Wild Card Systems, Fort Lauderdale, Florida

(01/2006 – 09/2006)

As a Database Administrator, was responsible for performance tuning related issues such as identifying

and troubleshooting long running stored procedures and queries. Also responsible for maintaining

production databases in optimum conditions by performing REINDEXING and updating stats on timely

manner, trouble shooting failed jobs, and fixing replication errors. Prepared and published a Performance

Tuning and coding standards document. Also, redesign and published easy to use database change request

form for the developers. Implemented Reindexing strategy to reindex and update statistics of high volume

tables within the databases using a stored procedure to cut down transaction log build up.

Lincoln Financial, Philadelphia

(3/2005 – 12/2005)

This was a SQL Server DBA consulting assignment at this Fortune 500 Company, located in Philadelphia.

Responsibilities included modification and writing several complex Sales Reporting Stored Procedures for

the management group of the technology team. The Stored Procedures generated report feed files for

analysis and strategy planning purposes. Responsibilities also included writing DTS packages, scheduling

and monitoring jobs, query tuning and performance analysis.

Teachers Insurance (TIAA-CREF)

(5/1985 – 12/2004)

Working as a Senior Database Administrator for this Fortune 500 Company located in the city of New

York, was responsible for working on several high profile projects with the developers such as production

server installations and initialization, analyzing and designing databases and tables for new projects.

.

Supported and maintained ADABAS test and production databases and assisted mainframe developers

during new product developments. Supported and implemented SQL Server 2000 to Oracle conversions

using Oracle Migration Work Bench. Resolved conversion related table, trigger and stored procedure

problems. Worked with programmers to find and implement best access methods for effective data

retrieval and updates. Responsible for maintaining data dictionary information such as DDM’s, user

profiles, and generating FDT’s for test and production file loads. Provide programming support to legacy

applications written in COBOL using ADASQL. Wrote several ADABAS direct call programs and batch

COBOL to NATURAL interface.

Citi Bank

(7/1983 – 5/1985)

Worked in the database group as a Sr. Officer and was responsible for providing total database

support to the application developers. Also responsible for maintaining production ADABAS

databases for 24 by 7 operations, upgrades, and new product evaluation and deployment.

Fisher Stevens

(7/1974 – 7/1983)

4

Worked in this Pharmaceutical company service provider as a Basic Assembler Language (BAL)

and COBOL programmer and was promoted to System Analyst position. Design and implemented

Physicians’ Practice Profile (PPP) system to provide drug companies reports on prescription

activities by territories. Also developed and .implemented GEOLINE system to allow drug

companies to realign their sales force based on doctors concentration and rating.

6

Contact this candidate