SUMMARY:

• Extensive over SEVEN years experience in Database administration, database design and database development work with SQL Server 2000, 2005, 2008, 2008 R2 and 2012.
• Database administration for multi - terabyte databases including T-SQL coding, stored procedures, backup/recovery, high availability and over SEVEN years’ experience in IT.
• Years of Experience in SQL standards in writing stored procedures, Views, SQL functions.
• Years of Experience in Developing SQL scripts for maintaining administration tasks.
• Years of experience in T-SQL Programming skills, Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor, Diagnostic Manager, and DBCC Commands.
• Experience in application database debugging and troubleshooting, including security & access controls.
• Hands on experience on SQL Data Collector, Change Data Capture on SQL Server 2008 R2.
• Experience deploying databases in Web-based applications and multi-tiered architectures.
• Worked on Linked and Remote Servers to run distributed queries between SQL server and other data sources like excel using ODBC, OLE DB.
• Experience in creating scheduling Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.
• Maintained database response times in 24X7 Production environments, proactively generated performance reports. Automating most of the DBA Tasks and monitoring stats.
• Hands on experience in backup and restoration of databases, automating Administration, Security Maintenance, and troubleshooting client-server applications.
• Knowledge in Database Analysis/Design/Normalization/Manipulation processes using SQL Server.
• Hands on experience in Troubleshooting database issues.
• Strong experience in performing database consistency checks and planning and scheduling Recovery.

TECHNICAL SKILLS:

Software Tools: SSIS2005/2008, Protocol Visio2000,Erwin 7.2,Microsoft Office, Microsoft Front Page, Visual Studio Business Objects, IBM Lotus Sametime 7.5.1.

Languages: TSQL, PL/SQL, COBOL, C, C++, Java.

Programming Languages: TSQL, PL/SQL, .Net, VB ++, C, C++.

Reporting Tools: Crystal Report 10/11/2008, Business Object BI 4.0.

PROFESSIONAL EXPERIENCE:

Confidential, Parsippany, NJ

Responsibilities:

• Installation, administration, and configuration of SQL Server 2008R2/2012.
• Maintenance and applying services pack and hot fix of 2005/2008/2000 R2/2012 in Production and development.
• Managed DEV, UAT and PRODUCTION 50+ clustered SQL Servers from 400 GB servers to a 3 terabyte of Databases.
• Responsible for disaster recovery planning for SQL Servers 2008 R2 Cluster Servers ACTIVE- ACTIVE using Logshipping and for SQL Server 2012 using Transaction replication .
• Implementing CR (Change Request) and CA (Change Amendments) requested by users. Ensured 24x7 support of all corporate databases.
• Performing Root Causal Analysis (RCA) of incidents and adhering to SLA standards.
• Hands on Experience on SQL Lite Speed - created Log Shipping, Backup, Restore and Maintenance Jobs. Hands on Experience on SQL DM for managing and monitoring all Servers health. Administration and troubleshooting of active/active SQL 4 and 2 node cluster.
• Worked extensive on SSIS for data migration from SQL server to Oracle.
• Design, deploy and unit testing of SSIS package in ETL environment.
• Managing SQL databases, Security creating roles, assigning roles and privileges to user.
• Worked with OS for planning and setup of hardware and software resources
• Extensively used SQL PROFILER and QUERY TUNING Wizard to troubleshoot problems and queries
• Upgraded server from MS SQL Server 2005 to MS SQL Server 2008.
• Installed, Created Oracle databases.
• Created and migrated Partition Tables in Oracle Production RAM Backup.
• Schema/Table Backup and restore from Production to UAT/DEV. Day to Day support for Oracle databases including identifying Blocked session, unlocking/reset user pwd.
• Applying scripts to UAT and then to Production. Managing table spaces on DEV/UAT and PROD.
• Setting Oracle Cluster environment Variables.

Environment: MS SQL Server 2005/2008, T-SQL, DTS, Replication, MS Access, Windows 2008 server, Windows NT 4.0, SSIS.

Confidential, Ridgefield Park, New Jersey

Responsibilities:

• Installed new SQL Server 2000 and later migrated to SQL Server 2005 and then migrated to SQL Server 2008.
• Managed 25+ clustered SQL Servers, from 20 GB servers to a 1 terabyte of SAP BW Warehouse. Responsible for disaster recovery planning for SQL Servers.
• Ensured 24 hour x 7 day a week support of all corporate databases.
• Implemented database clustering for constant availability of sales force automation and product outing. Rewrote and tuned long-running SQL queries to cut execution time, ease database load and improve scalability.
• Hands on Experience on SQL Safe Idera - created Log Shipping, Backup and Restore Jobs.
• Hands on Experience on SQL DM for managing and monitoring all Servers health.
• Experience on HP LoadRunner including installing and Managing/Working closely with testing team to perform Performance and Stress testing using HP Load Runner.
• Experience handling Web Servers Used SQL DM and Window perform tools to check the servers.
• Trained Developers how to write better queries using .Net and SQL and optimize the applications.
• Worked extensive on SSIS for data conversion and for day to day activities.
• Implemented and worked extensively on Crystal Repots 11 and Crystal reports 2008, Business Objects BI 4.0 and SSRS for creating reports.
• Managed 2 Reporting projects each having 2 team members. Extensive use of Erwin 7.2. Worked with network team for planning and setup of hardware and software resources.
• Creating maintenance plan for consistency checks, maintaining indexes and statistics, performing fine Tuning of Database Application.
• Analyzed Performance using Performance monitor in order to identify the bottleneck such as CPU, memory, IO, paging and SQL Server and also bottleneck of SQL Server such as buffer cache hit, memory, transaction, procedure cache, paging etc.

Environment: MS SQL Server 2005/2008, T-SQL, DTS, Replication, MS Access, Windows 2008 server, Windows NT 4.0,SSIS,Msoffice 2003

Confidential

Responsibilities:

• Responsibilities include daily maintenance review, SQL optimization, disaster recovery planning and testing and custom software database installation support.
• Working as a team member with other DBA's to ensure 24 hour x 7 day a week support of all corporate databases.
• Extensive experience in full SLDC including requirements definition, prototyping, proof of concept, design, interface implementation and testing.
• Project requires detailed analysis of business requirement and building comprehensive Data models, Creating Logical Data Model and Physical Data Model using Erwin 7.2 Data Modeler Tool and creating scripts in .Net.
• Created scripts used in application in .Net and SQL.
• Analyzed and optimized MS SQL Server production databases.
• Implemented log shipping on servers. Used SSIS for data integration level of building validations.
• Created Tables, Views, triggers and Stored Procedures.
• Effectively used DBCC commands, SQL Profiler, Trace Analysis and Execution plans as part of troubleshooting and performance tuning.
• T-SQL programming for writing stored procedures, user-defined functions, Triggers, Cursors, Views, Joins, set up and management of linked servers to Non-SQL Server Databases.
• Set up test and production for new applications and deployed SQL server applications to production, backup and recovered them.
• Evaluated the Database Performance of Index tuning with using DTA to resolve Performance issues.
• Setup and configured SQL Server for other business functions. Index Data Management determine Defragmentation level; whether to Update Statistics or Rebuild Indexes.

Environment: MS SQL Server 2005/2008, T-SQL,MS Access, Windows 2008 server, Windows NT 4.0, SSIS, MS Office 2003, QUERY ANALYZER.

Confidential

Responsibilities:

• Creating the users, user groups and maintaining the access permissions for the HR, Admission and School Officials.
• Worked on DTS packages for transferring data from various data sources like Oracle, MS Access, Excel, *.txt file.
• Experience database backup and recovery procedures for Database servers.
• Supporting Customer Service requests by writing queries, creating table and adding new columns as needed to meet the requirements.
• Extensive experience in full SDLC including requirements definition, prototyping, proof of concept, design, interface implementation and testing.
• Coordinated physical changes and performance monitoring of two replicated production servers, two development servers and one reporting server, all Microsoft SQL Server 2000.
• Originally worked as intern from as an entry level programmer and later promoted up through the ranks to the Database Administrator.
• Created the backup schedule for production, test and development servers.
• Worked with developers to do the database schema changes and database restore requests.
• Involved in Migration of Production Database Servers from SQL Server 2000 to SQL Server 2005.
• Involved in Performance Tuning on Production, Staging and Test Servers.
• Upgraded most of SQL Server 2000 to SQL Server 2005.
• Involved with upgrade of databases from in a Clustered environment.
• Worked on SQL Server 2005 with latest Service Packs.
• Involved in Performance Tuning on Production, QA and Staging servers of the current project.
• Involved in Monitoring Performance of different production servers.
• Expertise in Security Issues such as creation and granting permissions on various Objects.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes.

Environment: MS SQL Server 2005/2008, T-SQL,MS Access, Windows 2008 server, Windows NT 4.0, QUERY ANALYZER.