Professional Summary

• Over 8 years of experience in MS SQL SERVER 2012/2008 R2/2008/2005/2000 Database Development and Administration DBA in Windows environment.
• Experience in Installation, Configuration Maintenance of MS SQL Server 2008 R2/2008/2005/2000 Versions for standalone, windows clustered environments.
• Experience in Capacity planning, Performance Tuning, Disaster Recovery, troubleshooting, backup and restore procedures.
• Extensive experience on Upgrading and Migrating SQL Server Software to new versions applying service packs patches.
• Experience in Administration, Database Design, Performance Analysis, and Production Support for Large VLDB and Complex Databases up to 1.4 Terabytes and 200 Servers.
• Experience in implementing and managing Merge, Transactional and Snapshot Replication models.
• Implementation experience on Log shipping with SQL Server 2000/2005 and Database Mirroring with SQL Server 2005 and Clustering active active and active passive for high availability and disaster recovery procedures.
• Experience in configuring and managing Linked Server, Data transfer between SQL Server and other Databases such as Oracle 9i and 10g.
• Good knowledge in creating and managing user permissions, logins and setting up security according to business standards.
• Extensively worked on 32 bit and 64 bit clustered and standalone server environments.
• Experienced in Creating Databases, Tables, Views, Stored Procedures, Triggers, Functions and Indexes using T-SQL statements based on Functional Requirements considering System and Logical database design.
• Proficient in Performance Tuning, Query optimization using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor DTA , DMV's, DBCC commands and reading execution plans.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Good knowledge on using different system monitors object counters and various reporting tools for monitoring and Tuning MS SQL Server Performance.
• Experience on Data Transfer from and to SQL Server Databases using utilities / tools like SSIS, DTS, BCP, BULK INSERT etc.
• Experience on Migrating DTS packages to SSIS packages worked on building and deploying SSIS packages.
• Good experience in creating Jobs, SQL mail agent, partitions and scheduling DTS and SSIS, SSRS packages.
• Knowledge and worked on developing and deploying OLAP cubes through SSAS.
• Experience on installing and configuring SSRS on windows environment also know the process of generating different types of reports.
• 24 X 7 Production Database on Call Support.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Sr. SQL Server DBA

The TBC Corporation, headquartered in Palm Beach Gardens, Florida was a publicly traded corporation from 1983 to its purchase by the Sumitomo Corporation in 2005. During the corporation's short independent existence, it acquired a number of businesses related to automobile parts and tires.

Responsibilities:

Provided support to 75 database Servers. Support included Production, stage, QA and Development.

• Installed and configured SQL Server 2008R2 on stand-alone and active/active and active/passive clusters on windows 2008 environment.
• Installed and configured SQL Server 2012/2008R2.
• Experience in improving SQL Server Database performance using Index Tuning Wizard, SQL Profiler and execution plans.
• Created the disaster recovery plan for production server and development server.
• Support and develop multiple SQL Server Databases and ensure all the developed SQL Server components functions in the production environments.
• Created transactional and snapshot replication on different servers.
• Developed complex stored procedures T-SQL for front-end application and reports.
• Running DBCC checks and DMV commands to fixing data corruption in application databases.
• Involved in performance tuning issues by running Profiler Trace and analyzing the output.
• Managing SQL databases, Security, fine tuning of T-SQL queries.
• Created logins and users according to required server roles and database roles. And worked fixing orphan users.
• Monitor database environments, related jobs end procedures Database tuning optimization Write and maintain stored procedures Work with database tools and utilities for administration and development.
• Maintain Fail-Over and Back-up system through use of transaction logs and Snapshot and Transactional Replication.
• Configured and maintained Log Shipping and DB mirroring Environments for the projects.
• Capacity planning - properly sizes and organizes including archive logs calculate optimum disk space, memory, etc.
• Manage hardware configurations and considerations for SQL Server environment Recommend security of databases insure that policies are adhered to when they are approved and implemented.
• Triggers, jobs created views and encryption of Stored Procedure on SQL Server 2008 R2.
• Supported 24/7 for production servers using HP Service Manager 7 ticketing tool.

Environment: SQL Server 2008/2008R2 Enterprise Edition, Management Studio, Red Gate Backup and SQL Compare , HP service Manager 7, Activity monitor , SQL Profiler, SSIS, SSRS, Windows server 2008.

Confidential

Sr.SQL Server DBA

PricewaterhouseCoopers trading as PwC is a global professional services firm headquartered in London, United Kingdom. It is the world's largest professional services firm and the largest of the Big Four accountancy firms measured by 2011 revenues. PricewaterhouseCoopers has three main service lines. There are Assurance Services, Tax advisory, financial services. The project involves support for production server, monitoring and troubleshooting replication, clustering, scheduling the jobs, SSIS Packages, SQL Server 2008 R2 Integration Services, maintaining databases for optimum performance and backups and restores.

Responsibilities:

• Built and extracted different reports using SSRS.
• Deployed database changes using IBM Rational Tool to all environments.
• Provided Secondary Support to IIS Web Servers.
• Used different monitoring tools like MOM, HP Openview, DB Artisan and Performance Manager Tools for monitoring server health.
• Implemented new T-SQL features added in SQL Server 2005.
• Designed and Extracted the DDL changes from the data modeling tools for databases.
• Developed and configured databases including objects, stored procedures, triggers and cursors.
• Worked on Performance Tuning and Optimizing Queries by analyzing Execution Plans and Re-designing Indexes.
• Imported and exported data from heterogeneous sources using various techniques like BCP and DTS
• Created maintenance plans to perform Index De- Fragmentation, Re-Indexing update the Index statistics.
• Developed SSIS packages to transform data between various data sources.
• Worked on deploying and migrating DTS Packages and SSIS packages.
• Involved in Capacity Planning and adding new storage space as needed
• Configured linked servers to run distributed queries between SQL Server and other data sources using ODBC, OLE DB Drivers.
• Managed Security by creating login/groups and assigning appropriate permissions
• Provided support to 50 database Servers. Support included Production, QA and Development
• Designed and Implemented regular backup, maintenance jobs and recovery procedures.
• Worked on designing and implementing the SQL Server behind the Firewall which sits out of domain.
• Created Snapshot and Transactional Replication for SQL Server 2000 and 2005.
• Configured and Implemented Log shipping, DB Mirroring and Clustering for high availability of data.
• Upgraded database servers from SQL 2005 to SQL 2008.
• Migrated several databases to SQL Server 2005/2008 from 2000/2005on stand-alone and cluster environments.
• Installed and configured SQL Server 2008R2/2005 on stand-alone and active/passive clustering on windows 2003 environment.
• Gained knowledge on installing the Sybase and Perl files for monitoring and audit purpose.
• Gathered user requirements from users and managers to better understand the business logic and developed required documentation.
• Worked as on-call DBA for 24x7 production support along with other team members.

Environment: SQL Server 2008/2008R2 Enterprise Edition, Enterprise Manager, Management Studio, Windows 2003 2008 Server, DTS, SSIS, SSAS,SSRS,SQL Query Analyzer, Power Designer, DB Artisan, IBM Rational Tool, Secure CRT, Remedy Tool Pac 2000 ,HP Openview, HP Performance Manager, SQL 2005 Performance Dashboard.

Confidential

Sr.SQL Server DBA

Clarity Public Retirement Administration Package is a framework that contains reusable software components that can be utilized to automate common functions within public retirement systems, including enrollment, benefit payments, benefit estimates, customer services and service credit purchases. In this project my role was assigned as a Database Administrator for support and maintenance of the application databases. Has been part of upgrade and migration project team.

Responsibilities:

• Working as a Production DBA with 50 Production MS SQL Servers and 100 Dev-Test SQL Servers and 1000 Databases.
• SQL Server 2005/2000 Production Database Administration.
• Installed and configured SQL Server 2005/2008R2.
• Worked on call support 24/7 and solved many Incident Tickets.
• Hands on experience in Performance issues and troubleshooting database issues.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies.
• Migrated DTS packages from Legacy system to SQL SERVER 2005.
• Created and Maintained jobs, alerts and Maintenance plans.
• Worked in Active passive and Active active cluster environment.
• Worked in Huge Transactional, Merge Replication environment.
• Extensively worked to implement Database mirroring, configured Principal, witness and mirror using the SQL SERVER 2005.
• Worked to implement Asynchronous mode for Database mirroring in Staging Environment.
• Used Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
• Used Online Indexing and online Restoring in SQL 2005.
• Created a new Reporting server in SQL SERVER 2005 environment which is being tested.
• Tested on Test environment with new stored procedures developed by Developers and applied on Production through Change management.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services SSRS .
• Configured and maintained Database Mirroring and CTE.
• Implemented new topics like CLR integration on Development server.
• Maintained the database consistency with DBCC at regular intervals.
• Maximum performance and uptime in production environment.
• To set up SQL Server configuration settings to resolve various resource allocation memory issues for SQL Server databases and to setup ideal memory, min/max server options.
• Created Documentation for steps need to be taken while upgrading the SQL server 2005 to SQL server 2008.

Environment: SQL Server 2005/2008, Windows 2003, QNXT, Care Advance, Biz Talk, Crystal Reports, SSRS, SSIS , Visual Basic, .NET, ADP Pay Roll.

Confidential

Sr.SQL Server DBA/SSIS Developer

The Norfolk southern Railway is a Class I railroad in the United States, owned by Norfolk Southern Corporation. The railroad is a major transporter of domestic and export coal in the eastern half of the country. Norfolk Southern Corporation is one of the nation's premier transportation companies. Its Norfolk Southern railway subsidiary operates approximately 20.000 route miles in 22 states and the District of Columbia, serves every major container port in the eastern united States, and provides efficient connections to other rail carries

Responsibilities:

• Designed ETL packages dealing with different data sources SQL Server, Flat Files, and XMLs etc and loaded the data into target data sources by performing different kinds of transformations using SSIS.
• Migration of DTS packages to the SSIS on SQL Server 2005.
• Scheduled Backups of databases and recovered them periodically to verify integrity of Backups.
• Worked on Migration from SQL Server 2000 to 2005.
• Installed SQL Server 2000/2005 on Stand Alone and Clustered Environments on Windows 2000/2003
• Worked in evaluating various high availability technologies such as Log Shipping, Clustering and Database Mirroring.
• Restricted developer access to production database servers by creating different users and logins on different databases.
• Re-architected numerous existing databases for increased performance and scalability
• Wrote complex T-SQL Scripts for generating reports.
• Generated reports using SSRS.
• Designed and developed OLAP Cubes using Analysis Services.
• Worked on OLAP and OLTP.
• Interacted with development and testing team and Configured Linked Servers.
• Involved in Importing and exporting of Databases using various techniques like BCP, DTS.

Environment: SQL Server 2000/2005 Enterprise Edition, Enterprise Manager, Management Studio, T-SQL,Windows 2000 2003 Server, DTS, SSIS, SSAS,SSRS ,SQL Query Analyzer.