SUMMARY

• Over 7 years of experience in Implementation, Administration and Support of MS SQL Server 2000/2005/2008/2008 R2 and 2012 in Development, Test, UAT and Production Environments.
• Installation and configuration of SQL server 2012/2008R 2/2008/2005/2000 with Banking, Health Care, Manufacturing and IT sectors.
• Specific hands on experience include administering large and complex Databases, Database Design.
• Entity relationship diagram (ERD) development/normalization and physical database schema design.
• Performed Log Shipping and implemented Transactional and Snapshot Replication as high availability techniques.
• Implemented both Active / Active Clustering and Active Passive Clustering as a disaster recovery solution.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Experience in Database of OLAP/OLTP and Mirroring as disaster recovery solution..
• Experience in supporting Very Large databases (more than 2 TB) and troubleshooting the problems.
• Experience with 2005 concepts like data partitioning, online indexing, DDL triggers, DMV, DMF, SSIS, SSRS and SSAS.
• Experience with T - SQL/ PL SQL in writing triggers, tables, user defined functions, views, indexes, and relational database models and data integrity
• Experience in migrating SQL Server 2000 to SQL Server 2005, SQL Server 2000 to SQL Server 2008R2, SQL Server 2005 to SQL Server 2008 and 2008 R2.
• Experience in configure server and client network protocols like SQL Server and SQL Extensions in SQL 2005 using configuration manager.
• Experience in extracting and transforming data using SSIS, DTS Import/Export Data, Bulk Insert, BCP and DTS Packages.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC utilities and Index Tuning Wizard.
• Intensive experience in monitoring database performance using SQL Profiler, and the DB’s percent log space for all database servers using SCOM and Windows Performance counters.
• Experience in maintaining the security for databases (creating logins for users, roles, and assigning permissions to them).
• Expert in performance tuning and handling blocking situation and dead lock situations in SQL and Oracle Data bases.
• Experience with backup and restore database or detach and attach database, clustering and replication.
• Good knowledge in developing several UNIX Shell Scripts, PL/SQL and SQL Scripts to automate the databases setup, monitoring and maintenance activities managed SQL*Loader, Export/Import.
• Used third party tools like spot light and fog light and Quest Litespeed for backing up large databases.
• Experience in working with Windows Server 2003 Enterprise Edition, Windows 2000 Advanced Server, Windows 2000 Server and Windows NT.
• Expertise and Interest include Administration, Development, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases and Experience in creating jobs, alerts and automating them.
• Good knowledge on SQL Server Reporting Services (SSRS), drill down, parameterized reports, and cascading reports deployed them on Report server from Report Manager.
• Excellent communication, analytical and inter personal skills and ability to learn new concepts and supported 24/7 on call in production and development environment.
• Ability to learn and adapt to new technology and concepts quickly and create a systematic approach in working towards developing business solutions that increase company’s efficiency, Productivity and profitability. Possess strong analytical, interpretation and problem solving skills.

TECHNICAL SKILLS

Operating Systems: Windows NT/ 2000/2003/2008/2008 R2/XP.

Languages: T-SQL, PL/SQL, C, C++, VB.net

Databases: SQL Server 7.0/2000/2005/2008 , 2008 R2, 2012Oracle 11g/10g/9i, 8i and MS Access.

SQL Server Tools: SSMS, Profiler, DTS ( Import & Export ), Query Analyzer, ETL, SSIS, SSRS.

DML Tools: Erwin, TOAD 8.6/9.0, SQL Compare 5.0/6.0/6.2Quest Litespeed 4.8/5.2/6.5, RMAN, Tivoli.

Bug Tracking Tools: Clear Quest, Quality Center, Vantive and Remedy.

PROFESSIONAL EXPERIENCE

Confidential, New York

Senior SQL Server DBA

Responsibilities:

• Principal responsibility is to implement, support, maintain, monitor & tune highly available and clustered database systems.
• Create and maintain databases after logical and physical database design. Create database objects including tables, triggers, views, stored procedures, indexes, defaults and rule.
• Set database access privileges for different users and user groups.
• Develop SSIS Packages to transform data from excel/Access file to SQL Server database.
• Involved in Capacity Planning and analyzed the Database Growth and plan for the Data Storage and Servers.
• Installed and configured Active/Active Cluster environment on Windows Server 2008 Infrastructure.
• Involved in bench mark testing on EMC SAN using SQL IO.
• Implemented Table Partition for RUMS Database and created useful indexes to improve the performance.
• Ran the SQL Server Profiler to troubleshoot the blocking issues on the RUMS DB.
• Performance tune Stored Procedures & long running queries by looking at query plans, IO Statistics, Joining Techniques and Outdated Statistics & Indexes.
• Extensively used Importing & Exporting Data (ETL) using BCP & BULK INSERT and SSIS when implementing the Table Partition.
• Customized the existing Log Shipping configuration and resolved the Restore T-Log Errors by using Perl Script and resolved the Network issues.
• Configure the Linked Servers with Heterogeneous Database Environments like Oracle, DB2, VSAM and Flat-Files.
• Developed the Intelligent Index Fragmentation Script on Production Servers to resolve Index Fragmentation issues automatically.
• Expert in sizing and utilizing the Temp database in an efficient way.
• Performed Root cause Analysis in case of Database shutdown and Sev-1 issues.
• Researched database applications to determine eligibility for server consolidation.
• Configured DB Mail, SQL Alerts, Operators, SQL Server Agent Maintenance jobs on the Production and Development Environments.
• Involved in Production Support on a 24*7 basis.

Environment: MSSQL 2005/2008, T-SQL, Windows 2003/2008, Erwin, MS-Access, Terminal Services, MS Visio, Office 2003.

Confidential, NJ

Senior SQL Server DBA

Responsibilities:

• Involved in Migration from SQL Server 2000 to SQL Server 2005
• Involved in requirements gathering, analysis, design, development, change management, deployment and user training.
• Involved in general Database Administration, Query Performance tuning, and validated some of the existing schema.
• Monitored and modified Performance using execution plans and Index tuning.
• Rebuilding the indexes at regular intervals for better performance.
• To setup, implement, and maintain industry standards in database management.
• Integrated SQL traces with Performance Monitor to have better graphical analysis to find system bottlenecks. Used Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers and Dead Locks.
• Trouble shooting SQL Server 2008, 2005 and 2000 Database connectivity issues from the web applications.
• Actively involved in data warehousing of the XML onto SQL SERVER 2005.
• Created Transactional Replication, Pull Subscription and defined editions to transfer data from branch to head office and vice versa.
• Created Indexes and involved in Performance tuning.
• Created simple Reports using SSRS, Proclarity.
• Developed and designed DTS package/application for importing the data from word and update.
• Involved in Creation of Dimensions using Star and Snow Flake Schema
• Created and integrated user defined functions and stored procedures for reporting purposes.
• Designed and deployed various complex reports.
• Created and generated reports to display data.

Environment: SQL Server 2005, MS Excel 2003, MS Access 2003, SQL Query Analyzer, SSRS, Windows 2003

Confidential, Cedar Rapids, IA

SQL Server DBA

Responsibilities:

• Coordinated with SAN Team and involved in Capacity Planning and Storage allocation for Test, Dev, Stage and Prod environments.
• Created DTS packages to migrate Schema, Data and Logins across the servers.
• Setup the maintenance jobs in all Servers schedule to run at various times.
• Created Logins, users & roles and involved in Day to Day User Maintenance.
• Involved in setting up Transactional Replication and Monitor& Support Replication issues.
• Extensive usage of DTS export/Import, BCP & BULK INSERT utilities for data Migrations involving multimillion records tables.
• Involved in resolving the Locking & Blocking Issues by setting Trace Flags like T1204 and T1205.
• Created Linked Servers between SQL Servers and other Heterogeneous environment (VANTAGE-ONE® & Oracle 9.0).
• Analyze the Database Growth and plan for the data storage and servers.
• Installed and configured SQL Server 2000 service packs and hot fixes.
• Resolved the SQL Server 2005 upgrade hurdles and successfully Migrated SQL 2000 DTS packages to SSIS using Upgrade advisor and Package Migration wizard
• Configured and implemented Mirroring and Snapshot for SQL Server 2005
• Investigated and resolved any database corruption, performance related issues with minimal and maximum reliability.
• Installed, configured and implemented Transactional and Snapshot Replication.
• Created the Backup and Restore Strategy to production, development and test environments.
• Installed and configured Log Shipping for production servers.
• Approach to Migration that includes detach the existing databases and copy it through network and attach in SQL Server 2005.
• Involved in customer support and provide support for application in Warehouse with pcAnywhere.
• Review SQL Server error log and event log for any messages related to the migration.
• Linking SQL Server 2005 with SQL Server 2000 and Migrating DTS packages to SSIS, Scheduled Jobs and Maintenance Plans.
• Worked with developers to tune the SQL queries and stored procedures.
• Periodically checked all databases with DBCC commands for maintaining data consistency and integrity.
• Installation and configuration of MS SQL Reporting Services.
• Created OLAP cubes using Analysis Services, configured the security roles to the OLAP environment and Optimized the Data ware housing environment
• Involved in Production Support on a 24*7 basis.

Environment: MS SQL Server 2000/2005, T-SQL, Windows 2000/2003, VANTAGE-ONE®, Oracle 9.0, MS- Access 2003, SQL Compare 6.0, ERwin, Symantec PCAnyware 11.0, Rational Rose.

Confidential

Jr. SQL Server DBA

Responsibilities:

• Installation and configuration of SQL Server 2000 on Window 2000/NT OS.
• Managing of database objects like Tables, views, stored procedures, indexes etc.
• Developed DTS Packages to transfer the data between SQL Server database and files.
• Implementing Backups and restoring when necessary.
• Used BCP utility to publish table output to text files.
• Creation and management of Database maintenance plan for various database consistency checks.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Managing of users including creation/alteration, grant of system/db roles and permission on various database objects.
• Develop documentation that sufficiently describes technical deliverable as required for internal controls so that the maintenance responsibility can be passed on to production support team.

Environment: SQL Server 2000, Enterprise Manager, Windows 2000, SQL Profiler, DTS,T-SQL, BCP, Replication.