SUMMARY

• Over 8+ years of IT experience on Database Administration and development with MS SQL Server technology 2008/2005/2000 , MS SQL Server 2008 (R2).
• Extensive experience on database administration, advanced data recovery, data corruption, extended SQL Server internals and SQL Server Memory concepts
• Extensive experience in installation, Upgrades (In place Upgrade and side - by-side) and configuration of MS SQL Server 2008 R2, 2005, and 2000 versions on both Standalone and Cluster Environments.
• Experienced in investigating and applying necessary SQL Server database Service packs, Hot fixes and Security Patches.
• Experience in Database Backup, Recovery and Disaster Recovery procedures (Log shipping, Mirroring, Clustering and Replication).
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
• In-depth knowledge of T-SQL (DDL, DML, and DCL).
• Experience in implementing different types of Replication Models like Snapshot, Merge and transactional.
• Maintained Database Authentication Modes, Creation of Users, Configuring Permissions and assigning roles to users.
• Experience in extracting and transforming transactional information using DTS Import/Export wizard, BCP (Bulk Copy Program) DTS (Data Transformation Services) and SSIS Packages from SQL Server.
• Using Performance Monitor/Profiler to solve Blocking, Dead Locks/Long running queries.
• Worked closely with management, applications development staff, and users on database solutions to business problems.
• Defined and administered database standards, controls, procedures and documented the same
• Provided after hours and 24/7 Database Maintenance and Production Support.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS

RDBMS: MS SQL SERVER 7.0/ 2000/20 R2/2012, Analysis Server 2000/2005, Ms Access 2000/2005.

Databases Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS), Database Engine Tuning Advisor(DTA), Enterprise Manager, Query Analyzer, SQL Profiler, Data Transformation Services, Upgrade Wizard, Replication, Jobs and task creating and scheduling, MS Visio, Crystal Reports 10.0, SQL reporting, SSIS, SSAS

Programming Languages: SQL, TSQL, XML,, VB 6.0, Perl, HTML, XML.

Web Tools: MS-Front Page, Internet Information Server(IIS),FTP,TCP/IP,LAN,MS-Outlook Express

Operating Systems: Windows 95/98/2000/2003/ XP/NT 4.0, Linux, Novell Netware, MS-DOS.

Utility Tools: MS Office, MS Project, Clear Quest, Visual Source Safe 6.0, Rational Clear Case.

ETL Tools: SSIS(SQL Server Integration Services), DTS(Data Transformation Services), Import Export Data, Bulk Copy Program (BCP)

PROFESSIONAL EXPERIENCE

Confidential, Framingham, MA

SQL Server DBA

Responsibilities:

• Installed, upgraded and configured SQL Server 2008r2 for several applications.
• Backup and restore the databases from old environment to new environment.
• Identified and categorized the problems in existing database in SQL server 2005 and SQL 2000 using Upgrade Advisor.
• Experience in Database Mirroring, Database Snapshot and Isolation Levels.
• Migration of databases from SQL 2008 to SQL 2012.
• Ensure the compatibility level changes and perform database checkup routines to ensure consistency and integrity is preserved.
• Deploy SSIS packages in various environments Development/test/Stage/production.
• Capture performance baselines for old and new environments using perfmon.
• Daily periodically monitored performance using both System Monitor and Profiler.
• Periodically (daily, weekly, or monthly) performed a database reorganization on all the indexes on all the tables in all databases to rebuild the Indexes so that the data is no longer logically fragmented.
• Reconfigured Log Shipping and Database Mail after migration.
• Ensured security logins and database access permissions.
• Created and scheduling maintenance jobs in new environment.
• Created Notification and alerts for jobs failure.
• Applying service packs for old and new environments according to the Enterprise Architecture standards
• Implemented and maintained Transaction replication, Mirroring for high availability.
• Ran DBCC CHECKDB on all the databases to verify database integrity after migrating.
• Planned the backup and recovery for Publisher and Distribution servers.
• Involved in various stages like system Analysis, design, and development
• Provided 24/7 Production on call Support.
• Worked on incidents like slow running queries, blocking.

Environment: MS SQL Server 2000/2005/2008 , Business Intelligence - MS SQL ServerIntegrated Services (SSIS) and MS SQL Server Reporting Services (SSRS),SQL Agent, SQL Profiler, Database Tuning Advisor, Database Mail, T- SQL,Windows2003/2008 server.

Confidential, NY

SQL Server DBA/Oracle DBA

Responsibilities:

• Provide 24/7 support to the Web applications like hCue, Arrow, CTA,AEF, Decision Wizard.
• Review and deploy Code across various Environments like production and release paths.
• Installed and configured SQL Server 2008 on the Cluster.
• Installed SQL Server 2012 in the Development environment.
• Restoring the databases from production to various environments using FTP.
• Migrating the databases from old environment SQL Server 2005 to SQL Server 2008R2.
• Loading Data from Oracle to SQL Server using SSIS packages.
• Executed Data migrations from oracle to SQL Server using SQL Server Migration Assistant for Oracle(SSMA).
• Restoring the databases form Production to other environments using Robocopy.
• Implemented & maintained Clustering in Win 2003/2008R2 Servers.
• Taking performance report using Performance Ware House.
• Documented design approaches and proactively engaged in developing company coding standards
• Daily periodically monitored performance using both System Monitor and Profiler.
• Periodically (daily, weekly, or monthly) performed a database reorganization on all the indexes on all the tables in all databases to rebuild the Indexes so that the data is no longer logically fragmented.
• Ensured security logins and database access permissions.
• Creating, scheduling and monitoring maintenance jobs in new environment.

Environment: MS SQL Server 2000/2005/2008 /R2, Business Intelligence - MS SQL ServerIntegrated Services (SSIS) and MS SQL Server Reporting Services (SSRS), SQL Profiler, Database Tuning Advisor, Database Mail, T- SQL,Windows2003/2008 server.

Confidential

Sr. SQL Server DBA

Responsibilities:

• Installed, upgraded and configured SQL Server 2008 that resembles the production configuration.
• Detached database from Sql server 2008 and attached to Sql Server 2008 using SSMS.
• Backup and restore the databases from old environment to new environment.
• Identified and categorized the problems in existing database in SQL server 2005 using Upgrade Advisor.
• Executed Data migrations from one database structure to another Using SSIS Review and Migrated Stored Procedure.
• Experience in Database Mirroring, Database Snapshot and Isolation Levels.
• Implemented & maintained Clustering in Win 2000/2003 and Replication in SQL 2005/2008.
• Ensure the compatibility level changes and perform database checkup routines to ensure consistency and integrity is preserved.
• Daily periodically monitored performance using both System Monitor and Profiler.
• Periodically (daily, weekly, or monthly) performed a database reorganization on all the indexes on all the tables in all databases to rebuild the Indexes so that the data is no longer logically fragmented.
• Reconfigured Log Shipping and Database Mail after migration.
• Ensured security logins and database access permissions.
• OLTP experience like Analysis Services (SSAS), Reporting Services (SSRS) and Integration Services (SSIS) to manage data ware house environment.
• Created and scheduling maintenance jobs in new environment.
• Created Notification and alerts for replication jobs failure.
• Involved in supporting client Data Center from locations.
• Wrote and edited stored procedures, functions and triggers required for sql agent jobs.
• Ran DBCC CHECKDB on all the databases to verify database integrity.
• Planned the backup and recovery for Publisher and Distribution servers.
• Monitored, optimized and Performance Tuning of Regression Servers using Performance monitor, SQL Profilers, Activity Monitor.
• Ensured distributed server side processing and data consolidation for client application using Service Broker.

Environment: MS SQL Server 2000/2005/2008 , Business Intelligence - MS SQL ServerIntegrated Services (SSIS) and MS SQL Server Reporting Services (SSRS),SQL Agent, SQL Profiler, Database Tuning Advisor, Database Mail, T- SQL,Windows2003/2008 server.

Confidential, Baltimore, MD

Sr SQL Server DBA

Responsibilities:

• Handled up to 2 TB Size databases with clustered and replication environment.
• Regular Database backing up and implementing tests on that backup and generating reports.
• Relocation of Databases from one server to another server using attach and detach database.
• Extensively worked on Dynamic Management Views (DMV’s) to get the information about executed T- SQL statements.
• Successfully installed SQL servers 2008 on cluster server.
• Migrated SQL Server 2005 database to MS SQL Server 2008
• Used Idera SQL safe backup which provides a high-performance backup and recovery solution.
• Worked on Data Partitioning and Snapshot Isolation in SQL Server 2008.
• Creation and maintenance of Users security permissions and Migration the entire database objects from one Server to another Server and database to another database.
• Rebuild the indexes at regular intervals for better performance.
• Generated various monthly reports with the help of SSRS 2008.
• Implementation of Immediate Transactional Replication to reduce the workload on servers.
• Worked on building queries, stored procedures that meet business needs.
• Tested and implemented Database Replication solution for Production critical application.
• Use replication stored procedures to create scripts to automate the transaction replication once databases are refreshed.
• Creating logins, groups, users, roles, database devices, databases, mirroring devices, checking for database consistency, fixing DBCC errors, monitoring error logs, database space allocations, transaction log space allocations, fine tuning SQL performance.
• Implemented log shipping between two instances of server using Database.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Successfully implemented Database Mirroring in SQL Server 2008.
• Monitored the server usingidera tools.
• Done general technical trouble shooting and give consultation to development teams.

Environment: MS SQL Server 2008/2005, Enterprise Edition, Business Intelligence Development Studio(BIDS) - SQLServerIntegrated Services (SSIS), DTS, SQL Agent, SQL Profiler, Database Tuning Advisor, Database Mail, Notification Services, T- SQL, Windows 2003 server, Idera Sql safe backup.

Confidential, Memphis, TN

SQL Server DBA

Responsibilities:

• Problem identification, troubleshooting, resolution, and index tuning databases.
• Worked on a package Migration wizard in SQL Server 2005 to migrate DTS Packages to SSIS, SSIS Package Configuration, passing variables dynamically and used SSIS Logging.
• Implemented Two Node Active/Passive Failover Clustering.
• Experience in implementing different types of Replication Models like Snapshot and Transactional. Good Knowledge of Merge Replication.
• Successfully implemented Database Mirroring in SQL Server 2005.
• Taking Database full Backup, Transaction log backup & differential backup in daily Routine.
• Developed and implemented Disaster Recovery Plan and Procedures.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, Mirroring, database integrity verification, indexing and statistics updates.
• Managed the use of disk space, memory, processor and connection.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Diagnosed and tuned the server optimal performance using SQL Server 2005’s Dynamic Management Views (DMV), Profiler and Index Tuning Wizards.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation.
• Reduced systems downtime risk through automatic offsite backup and recovery over network.

Environment: MS SQL Server 2005/2000,T- SQL, SQL Query Analyzer, SQL server Agent, DTS, Windows server 2003

Confidential, Columbus, OH

SQL Server DBA

Responsibilities:

• Configured and Installed SQL Server 2005.
• Developed, modified and optimized complex stored procedures, triggers and user defined functions.
• Tested to optimize the Stored Procedures and Triggers to be used in production.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Maintained the database consistency with DBCC at regular intervals.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Used ETL packages to move logins and jobs from one server to another server.
• Monitored SQL server performance using profiler to find performance and dead locks.
• Developed and deployed ETL packages using SSIS and Converted DTS packages into SQL Server 2005 Integration Services.
• Maintained the use of disk space, memory, processor and connection.
• Implemented regular database backup and recovery tests.

Environment: MS SQL Server 2000, Windows Server 2000, SQL Agent, SQL Profiler, DTS, T-SQL.

Confidential

SQL Server DBA

Responsibilities:

• Involved in requirement gathering, analysis, design, development, change management, deployment and user
• Installed and configured SQL Server 2000 successfully
• Login and user management: Adding logins, roles, groups to the Window NT and MS SQL Server and maintaining proper security procedure.
• Scheduling Jobs and Alerting using SQL Server Agent
• Created a Baseline for migrating from SQL Server 2000 to SQL Server 2005
• Written stored Procedures, Functions and Database Triggers
• Database creation; database tuning, performance planning, backup planning and database administration.
• Implemented Log Shipping
• Proactive and Reactive tuning of databases in every stage of the project
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery
• Creation/Modified complex stored procedures which are used for various reports
• Created/Maintained clustered/non clustered Indexes for fast and efficient reporting process
• Configured SNAPSHOT Replication using Snapshot agent. (Creating Distribution Databases, creating & managing Publications, managing Replication monitors).
• Wrote DTS scripts for data transfer
• Involved in System testing
• Used Performance Monitor and SQL Profiler to queries and enhance the performance of database servers.
• Monitored Performance during Beta - Testing phase of the application.

Environment: ASP.NET, T-SQL, XML, Web Services, SQL Server 2000, JavaScript.