SUMMARY OF QUALIFICATIONS:

• MS SQL Server DBA with 5 years of IT experience in Database Administration, Design, Development, Installation and Support of MS SQL Server 2014/2012/2008 R2/2008/2005 in Production, Testing and Development Environments.
• 3+ Years experience in Data Migration from MS SQL server 2000/2005 to 2014/2012/2008 R2.
• 2+ Years experience in Implementing, Upgrading and Migrating to SQL Server 2012/2014.
• Implemented AlwaysOn availability groups and replicas for reporting, backup and performance
• Experience in implementing different types of Replication topologies including Snapshot and
• Transactional replication.
• Expert in Installing and configuring SQL Server Cluster in Active/Passive and Active/Active
• environments.
• Implemented Sync and Async MIRRORING in SQL Server 2012/2008 R2 and 2008 for DR
• Implemented Backup and Restore in SQL Server using Native SQL Backups
• worked on VMware and Virtual environments.
• Experience in Performance Tuning, Query Optimization, and Database Consistency Checks
• using DBCC Utilities and Linked Servers.
• Knowledgeable in Creating, Deploying, Scheduling solid ETL Packages in SSIS.
• Great knowledge on implementing Log Shipping and Data Mirroring Techniques.
• Experience in Software Development Life Cycle (SDLC) and configuring Alerts using SQL Mail.
• Expertise in planning and implementing MS SQL server Security and database Permissions.
• Well aware of SOX compliance, SQL Server change control management and Reporting
• Services.
• Worked on T - SQL writing and developing Database Objects, Triggers, stored procedures,
• Functions and Views.
• Knowledgeable in using extensive SQL Server DMVs for performance tuning and Monitoring
• I nvolved in writing SQL queries (Sub queries and Join conditions), T-SQL
• programming and Query Level Performance tuning
• Generated DDL scripts for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, Triggers, Packages, Stored procedures, roles and granting privileges
• Experienced in providing quality operational Support for Production Environments.
• Provided 24/7 database maintenance and Production support.

TECHNICAL SKILLS:

• MS SQL Server 2014/2012/2008 R2/2005 Oracle (9i, 10g), MYSQL, VMware, Hyper-V, Visual Source Safe, Team
• Foundation Server, Visual Studio, C#, .NET, JAVA, HTML, SSRS, Crystal Reports, Business Objects, Windows
• 2012/2008 R2/2003, UNIX, DTS, SSIS, Informatica, IDEARA Diagnostic Manager, Fog light, Red Gate, RMAN, Toad, SQL Profiler, Query Analyzer, SSIS, ERWIN,VERITAS NetBackup, Lite Speed, JDBC, TSM, and SharePoint, Clustering, Mirroring, Log Shipping, AlwaysOn

PROFESSIONAL WORK EXPERIENCE:

Billerica, MA

Senior SQL DBA

Responsibilities:

• Production support for SQL server environment giving 24/7 environment.
• Configured and maintained database mirroring and Log shipping for high availability.
• Implemented different types of Replication Models like Snapshot, Transactional and Merge.
• Extensively worked on Dynamic Management Views (DMV s).
• Migrated SQL Server 2008/2008 R2 to SQL Server
• 2012/2014.
• Set up and prioritized scheduled database backups (full, differential and transaction log) for security and disk space management.
• Auditing existing operational database setup (maintenance plans, data file layout, etc.) and provide action plans for any recommended improvements.Establishing best practices for 
• Applied SQL Server service packs and Cumulative updates based on the errors and flaws that are found in the application.
• Managed Microsoft Active\Active and Active\Passive Clustered SQL Server 2005, 2008 and
• 2012 environments.
• Managed the use of disk space, memory and connections.
• Performed DBCC utilities and fixed data corruption in application databases.
• Worked on monitoring and tuning of SQL scripts. Created upgrade scripts for production database and supported it.
• Created and managed schema objects such as tables, views, indexes, procedures, triggers &
• maintained Referential Integrity.
• Performed Server & Application fine-tuning & troubleshooting.
• Monitored MS SQL Server performance and network issues.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Worked on Data Partitioning and Snapshot Isolation in SQL Server 2005.
• Used Data Transformation Services (DTS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, created packages for different data loading operations for application.
• Provoked and revoked user access to developers and other team members for high security data.
• Helped Development Team in deploying and testing the application, which uses SQL Server as a database.

Environment: MS SQL Server 2008/2008 R2, 2012, 2014, SharePoint, Clustering, Mirroring, Log Shipping, AlwaysOn

 Raleigh, NC

Senior SQL SERVER DBA

Responsibilities:

• Production support for SQL server environment in Physical and Virtual Environments.
• Installation and configuration of SQL Server 201 4/2012 and 2008 R2.
• Installed, configured and managed Oracle databases.
• Performed upgrade and Migration of lower version SQL Servers to SQL 2014/2012
• Installed/Configured SQL Server 2014/2012 AlwaysON availability groups for high availability.
• Configured and maintained database mirroring on 2012 and 2008 for Disaster Recovery.
• Implemented different types of Replication Models like Snapshot and Transactional.
• Extensively worked on Dynamic Management Views (DMV).
• Patched servers with latest SQL Server service packs and Cumulative updates.
• Managed Microsoft Active\Active, Active\Passive, and Clustered SQL Server 2000, 2005 and
• 2008/R2 environments.
• Installed and Implemented Async and Sync Mirroring / Log Shipping for Disaster Recovery.
• Worked on EMC and EqualLogic SAN boxes, configured RAID 1, 0 and 5.
• Worked on monitoring and tuning of SQL scripts. Created upgrade scripts for production database and supported it.
• Performed Server, Application fine - tuning and troubleshooting.
• Monitored MS SQL Server performance and network issues.
• Developed, deployed and monitored SSIS Package tools of SQL Server to populate data from various data sources. Created packages for different data loading operations for applications including upgrading DTS to SSIS.
• Monitored Databases for lock escalation, dead Lock, resource utilization by sessions, package caching, buffer pool hit-ratios, and captured long running SQL/runaway queries.
• Maintained Log Shipping, Mirroring and SRDF for Disaster Recovery.
• Scheduled backups for databases and Transaction logs. Performed restoration operations and suggested backup strategies.
• Controlled user access rights and managed data security.
• Involved in trouble shooting, Performance Tuning, Query Tuning, Index Tuning using DMVs, Wizards and SQL Profiler.
• Maintained multiple SQL Server instances with maximum availability.

Environment: MS SQL Server 2005/2008/2008 R2/2012/2014, Windows 2003/2008R2/2012, TSQL, RED GATE, AlwaysON, Mirroring, Clustering and Log Shipping

Confidential

BRIDGEWATER, NJ

SQL SERVER DBA

Responsibilities:

• Daily responsibilities include administration and monitoring of Database servers.
• Fine - tuned and Monitored SQL Servers in Web based and Transaction intensive environments. Implemented Active/Passive, Active/Active SQL Server Cluster servers.
• Used Activity monitor and SQL Profiler to monitor the server performance, debug T-SQL
• and slow running queries.
• Created Users and Roles, and managed security and permission of database
• Involved in Migration from SQL 2000 to SQL 2005 /2008 R2.
• Implemented and Monitored Transactional Replication in SQL Server 2005
• Tuning database and SQL statements for optimal performance.
• Created SQL Server Jobs to automate the running of routine tasks such as backups, restores.
• Monitored Databases for lock escalation, dead Lock, and Captured long running SQL/runaway queries.
• Maintained log shipping for disaster recovery.
• Scheduled the backups for Databases and Transaction logs. Performed restoration operations.
• Suggested backup strategies.
• Transferred logins and passwords between instances of SQL Server 2005.
• Monitoring the event logs and Server error logs for troubleshooting purposes.
• Created various maintenance plans for the regular databases maintenance jobs in the
• SQL server.
• Mentored by and under the guidance of Sr. DBA to quickly and efficiently resolve issues