SUMMARY

• SQL DBA with over nine years of experience in SQL Server administration, implementation, support and security.
• Hands - on experience in supporting SQL Servers 2005/2008/2008 R2/2012/2012R2/2014/2016 and 2017 in investment banking, media, market research, and education industries.
• Offers solid track record based on professionalism, thoroughness, and dedication.
• Able to work both independently and as a team player.
• Excellent communication, presentation and interpersonal skills.
• Database Administrator with nine plus years of experience in managing, maintaining and securing MS SQL Server in Dev, QA and Production including VIRTUAL and PHYSICAL environments.
• SME in Installation and Configuration of SQL Server, Backup and Restore including Disaster Recovery, Performance Tuning, Query Optimization and Database Security.
• Strong experience in Upgrade and Migration of SQL Server from 2005/2008/2012/2014 to SQL Server 2008, 2012, 2014 and 2016. Database decommissioning.
• Involved in Data migration on AWS and supporting RDS console.
• Experience in moving/copying data in different location and convert data from flat file, Oracle to SQL.
• Supported OLAP and OLTP databases including Star, Snowflake and Fact Constellation schemas on DW.
• Created, supported and maintained SQL jobs and Backup Strategy by Scheduling Maintenance Plan Jobs. Also created Automated Jobs running from windows server using power shell script.
• Experience in installing and managing Active/Active and Active/Passive Failover Cluster environment.
• Hands on experience and knowledge on various High Availability SQL Server solutions/technologies, including Log Shipping, Mirroring, Replication and AlwaysON AG.
• Proficient in configuring, monitoring and managing several Replication Topologies.
• Strong knowledge on setting up and troubleshooting Database Mirroring including Auto Failover.
• Experience in configuring and setting up AlwaysOn High Availability Groups including monitoring and troubleshooting.
• Strong hands on T-SQL, DMVs, DBCC commands and Trace Flags, including creating and maintaining Databases, Tables, Views, Stored Procedures, Functions, Triggers, cursors and Indexes.
• Agile in Creating and Maintaining ETL routines as well as assisting with reporting needs.
• Experience in developing and deploying complex SSIS and SSRS Packages.
• Monitor and Troubleshoot Servers and databases by using Standard Reports, Activity Monitor, Profiler/Tuning Advisor to find and resolve various bottlenecks such as Blocks/Locks/Dead Locks and Long /Slow running Queries. Also used tracing mechanism Extended Events.
• Hands on experience dealing with Execution Plan for query optimization and missing Indexes for better performance. Also implemented TDE encryption.
• Experience in responsibly securing SQL Server, User Management, Access Provisioning, Assigning Permissions and Roles (Server and Database level).
• Proficient in Using Performance Monitor (perfmon) dealing with various counters.
• Hands on experience of Microsoft SharePoint 2007/2010 and SharePoint server 2013.
• Extended experience in working independently as well as in team-oriented environments.
• Supporting and maintaining Very Large Databases.
• Experienced in working as a Team Lead in terms of leading and coordinating team’s responsibilities.

TECHNICAL SKILLS

Languages: T-SQL, PL/SQL, HTML, VB, .NET, C#, C++, and Java

ETL Tools: SSIS and Remedy MDM.

Data Model: Darwin 2.0, Erwin, and SSAS.

Reporting Tools: SSRS, Cognos, and Business Objects XI.

Backup Software: Data Domain Boost, Lite speed, Red gate, SQLBackup.

RDBMS & Tools: SQL Server 2005/2008/2008 R2, 2012/R2, 2014 and 2016, MS Access 2003/2007/2010 , Oracle 11g, MySQL 5.5

Operating System: Windows 95/98/XP/Vista, 7, 8.1 and 10, MS-DOSWindows NT/ 2000/2003/2008 and 2008R2/2012/R2 servers and UNIX.

Third Party Tools: Fog Light, Red Gate and Idera, MOM, SCCM.

Database Query Tools: Query Analyzer, SQL Profiler, SSMS and Enterprise Manager.

PROFESSIONAL EXPERIENCE

Confidential, Johnston, RI

Apps Support and Database Security DBA

Responsibilities:

• Installation and configuration of MS SQL Server 2008R2, 2012, 2014, 2016 and 2017on Windows server 2003, 2008R2, 2012R2 and 2016, also applied service packs and security patches on those Servers.
• Proactively monitoring and analyzing database servers in upper and lower regions including SIT, DEV, QA and PROD.
• Finding, troubleshooting and recommending server and database level bottlenecks such as Memory, CPU, I/O and blocking, locks and deadlocks issues.
• Performance tuning and query optimization, monitoring the performance of the servers and databases.
• Using third party tool Fog Light and Diagnostic Manager (Idera) to monitor workloads and analyze various performance bottlenecks including slow/long running queries. Also used execution plan to find query cost and other related issues.
• Responsible for a large scale of database migration from SQL server 2008R2/2012 to 2012 R2 /2014 and 2016.
• Work with application support and development team to Create, Maintain and Troubleshoot stored procedures, views, functions, triggers and indexes.
• Involved in database and log backups and restoration, planning backup strategies, and scheduling to automate those jobs.
• Check for data validity and integrity in regular basis, also validate the disk space proactively including monitoring data and log file growth.
• Automated Reorganize/Rebuild Index jobs to run in regular intervals for better performance.
• Using third party tool DD Boost, ensuring all the databases are backed up on the regular basis.
• Involved with infrastructure team to create Logical & Physical Design of the databases and capacity planning. Also used data modeling tool Erwin.
• Responsible for configuring and maintaining Transactional, Snapshot and Peer to Peer replication.
• Involve in Change/Incident Management Process using ITSM and Service Now tool to notify requests and open new requests including implementation and code deployment. Involved in database decommissioning.
• Find and improve database performance issues using DMVs, Activity Monitor, SQL Profiler, Traces, Execution plan and Engine Tuning Advisor. Also used Extended Event mechanism.
• As a Team Lead manage and lead offshore and onsite DBA team. Also, setup and host weekly apps DBA meeting.
• Currently additionally assigned to IAM and database security team to oversee and provision various incidents and ITSS requests.

Confidential, Beachwood, OH

SQL Server DBA Consultant

Responsibilities:

• Installed 2008/2012 and 2014 on Windows server 2012 and Windows Server 2012 R2 and also applied service packs and security fixes on this MS SQL Servers.
• Set up AlwaysOn Availability Groups (AG) with 4 Replicas and manage them.
• Provided dedicated production support for SQL Server problem resolution and server outages on call basis.
• Installed and configured SQL server Failover cluster for both active\passive and active\active in multiple nodes.
• Was Responsible for database migration from SQL server 2008/2012 to SQL 2012R2 and 2014.
• Responsible for Planning, Creating and Troubleshooting database, tables, views, stored procedures, functions, triggers and indexes.
• Involved in backup and restoration, planning backup strategies, and scheduling.
• Check for data validity and integrity in regular basis, also validate the disk space proactively.
• Tracking fragmentation level and did reorganize/rebuild the Indexes to increase performance.
• Verified backups and checked error logs on the server and troubleshoot any failures or alert, and open trouble tickets if necessary, to work with concerned group from other DL.
• Involved in creating Logical & Physical Database Design using data model tool Erwin.
• Responsible for configuring and maintaining Transactional, Snapshot and Peer to Peer replication in production environments.
• Involve in Change Management/Incident Management Process and using Remedy tool notify requests and open new requests and update all records in work history.
• Using third party tool Red Gate, ensuring all the databases are backing up on the regular basis and then restoring this database on requests.
• Involve in improving database performance using SQL Profiler, Trace Flags, Execution plan and Engine Tuning Advisor. Also use Extended Event mechanism.
• Working with installation, configuration and creation of SSIS packages.

Confidential, New York, NY

Senior SQL Server DBA

Responsibilities:

• Providing 24x7 dedicated production support for SQL Server problem resolution and server outages.
• Installed and configured MS SQL Server 2008, 2008R2, 2012 and 2012R2 on Windows Server 2003 and 2008R2 also applied service packs and security fixes on this MS SQL Servers.
• Responsible for a large scale of database migration from SQL server 2008 to SQL server 2012 and 2012R2.
• Responsible for Creating and Managing Stored Procedures, Views, Triggers and Indexes.
• Involved in database Backup and Restore, Planning backup strategies, and Scheduling.
• Backing up master & system databases and restoring them when necessary.
• Rebuilding/Reorganize the Indexes at regular intervals and Update Statistics for better performance.
• Verified backups and checked Error Logs and troubleshoot any failures or alert, and opened tickets if necessary, to work with various personnel.
• Responsible for Installing, configuring and maintaining SQL Fail over cluster for two production environments.
• Involved in creating Logical & Physical Database Design and Deployment.
• Responsible for configuring and maintaining Snapshot, Transactional and Merge replication.
• Using third party tool Red Gate, ensuring all the databases are backed up on the regular basis and then restoring these databases on requests.
• Involved in improving database performance by using Standard Reports, SQL Profiler, Trace Flags, Execution plan and Engine Tuning Wizards.
• Using third party tool Idera, monitor all the servers and their jobs in a single Management Console.
• Working with installation, configuration and creation of SSIS and creating report using SSRS.
• Responsible for securing SQL Server, user management, and taking care of permissions and roles. Scheduling Jobs and Alerts using SQL Server Agent. Involved in Problem Solving and Conflict Resolutions.

Confidential, Valley View, Ohio

Production Server DBA

Responsibilities:

• Responsible for Installing and configuring SQL Server 2005, 2008 and 2008 R2 on Windows 2003 and 2008 servers.
• Worked with SQL DBA team and SQL Developers to optimize the SQL queries and stored procedures.
• Created user roles, managed security, built reports and deployed them to production.
• Provided 24 X 7 dedicated supports to hundred and eight Production, development and clustered servers.
• Extensively used BCP and BULK INSERT to import and export data from flat files, Excel and MS Access to MS SQL Server databases.
• Created standard operation procedures (SOP) for initial database shell creations for specific customer package builds.
• Developed the metrics and trending processes for SQL database sizing and growth.
• Daily monitoring of two-node active-passive SQL cluster in a host environment.
• Applied service packs and security fixes for all SQL Servers, and provided database administration support.
• Involved in upgrading from SQL Server 2000 to SQL Server 2005 and from SQL Server 2005 to SQL Server 2008.
• Performed the database backups for production, test and development environments.
• Created the backup and restore strategy for the all three environments.
• Worked with the database optimization, Performance tuning and index tuning for optimization of queries.

Confidential, Boston, MA

SQL Server DBA

Responsibilities:

• 24* 7 Critical production supports for hundred and ten SQL Servers out of which 75 were mission critical production support.
• Created database maintenance plan for SQL Server backups, optimization, integrity check and transaction log backups.
• Created checklists for proper install of SQL Server, applied service packs and security fix.
• Involved in validating SQL Servers, which was installed on validated environments.
• Configured and maintained transactional and Snapshot replication for 3 environments.
• Worked with SQL Disaster Recovery processes and documented those processes.
• Worked with capacity planning, database sizing and monitoring.
• Created databases, tables, indexes, stored procedures and triggers.
• Involved in creating DTS Packages to import and export operations in and out of SQL Servers.
• Improved SQL Server performance using the Windows performance monitor.
• Worked on user administration and responsible for upgrading project from SQL Server 2000 and 2005 to SQL server 2008.
• Applied monthly patches and hot fixes
• Worked with application team to test the successful upgrade.
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules.
• Created the Standards for SQL Server environment.