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, SQL Server 2005, SQL Server 2008R2 and SQL Server 2012 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.

At present looking for a SQL Server DBA contract position in a reputed organization to provide over 10 years of SQL Server DBA experience and over 26 years of IT experience in corporate America..

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.
• Performed migration from SQL server 2000 to SQL Server 2005 using both side by side and in place upgrade methods.
• Maintained user login, roles, and performed job scheduling using Enterprise Manager, SQL Server WIZARDS, Query Analyzer, and SQL Server Agent.
• 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.
• 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, SQL Server 2008 R2,
• SQL Server 2012 and ADABAS
• Programming: T-SQL, COBOL, NATURAL and VB.
• Other Tools used: SQL Compare, SQL Server Profiler

EXPERIENCE:

GE Transportation

• This was a short term contract position during which worked for GE's Australian Railways client to develop RailEdge Archival System. This system
• Archive daily transactions from production databases in the archival databases which were used for reporting. Two sites containing production databases were mirrored. Project required developing several scripts, stored procedures using TSQL.

Emergency Communication Network

Confidential

• Worked for this severe weather warning, community notification company as a DBA. Company databases carry millions of records containing spatial geographic data. Fixed several slow running
• Running Stored Procedures as quick response time was the critical need of company business model.
• Also, downgraded SQL Server 2012 instance to SQL Server 2008 R2 for product development. Developed plans for setting up Replications, data encryptions for servers located in three locations. Implemented Backup/Restore maintenance plans for databases which could not be replicated. Resolved several programming issues faced by the developers on a daily basis. Had to resign from the company after moving to New Jersey for family reasons

Softgate Systems

Confidential

For a year and half, worked as a consulting DBA remotely from home in confidential to provide production and development support. Mainly responsible for supporting every area of the SQL Server as it was done while employed by the company.

Softgate Systems

Confidential

Worked as a Sr. SQL Server DBA managing two data centers located in confidential. 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. Written and modified several SSIS packages to facilitate data transfers between servers. Performed complete ETL administration and support.

ADP Virtual Edge

Confidential

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

Confidential

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

Confidential

• 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

Confidential

• 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

Confidential

• 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.