PROFESSIONAL SUMMARY

• 9+ years of professional experience in Microsoft SQL SERVER Database Administration, Designing and implementing solutions using SQL 2016,2014, 2012, 2008R2, 2008, 2005 for Financial, Healthcare, Retail and Manufacturing Industries.
• Expertise in installation and configuration of MS SQL Server 2014, 2012, 2008, 2005 & 2000 in 32/64 bit environments.
• Good Experience in TSQL Development/Troubleshooting skills in Stored procs, views, functions, Cursors, triggers and Creating SQL objects like tables, Indexes, Constraints, rules etc.
• Expertise in Installing and configuring SQL Server 2012/2008/2005Active/Active and Active/Passive clusters on 32/64 bit Window Server 2003 and Window Server 2008;
• Expertise in Transact - SQL (DDL, DML, DCL) and in Design and Normalization of the database tables
• Experience in performing Migration and Upgrades from 2000 to 2005 and 2005 to 2008, 2012 and 2014. In-place upgrade process and as well as side-by-side upgrade process.
• Expertise in DR Solutions using Database Mirroring/Log shipping.
• Good experience in Implementing Always ONHADRusing SQL 2012/2014.
• Highly experienced in implementing Replication Models such as Transactional and Snapshot in SQL Server 2005/2008 and 2012 OLTP environments.
• Hands on experience in Installation of SQL Server 2014/2012/2008/2005/2000 Service packs and vulnerability fixes.
• Experience in implementing Table, Index partitioning.
• Expertise in handling huge databases ranging from GB’s to TB’s in size.
• Experience in Overall database design, such as creating normalized databases, authentication, query tuning, Analyzing and implementing indexes, creating stored procedures, functions, triggers and data types.
• Good Experience in Managing security through Windows/SQLlogins, Users, Roles, permissions, certificates, Credentials, Encryption schemes, Policy based management as per company’s policy.
• Expertise in debugging T SQL Statements, stored procedures, triggers, views etc. and Optimizing Code with help ofexecution plans.
• Experience in scheduling maintenance tasks like Index/Statistics Maintenance, Backups/Restores, DB integrity checks, Tracing long running/deadlock queries, Capacity planning, Monitoring and tuning Tempdb, Cleanup tasks, Patch and hotfix installations, Disaster recovery solution maintenance etc.
• Experience with Analysis Services (SSAS), Reporting Services (SSRS) and Integration Services (SSIS) administration and deployments.
• Experience in implementing PowerShell automations.
• Experience with Installations, Configuring reporting services, Develop/Debug SSRS reports and deploy the rdl’s.
• Experience in Designing, Building the Dimensions, cubes with star schema and snowflake schema, using native OLAP service Manager in Data Warehousing.

TECHNICAL SKILLS

Databases: MS SQL Server 2014/2012/2008/2005/2000.

SQL Server Tools: SQL Server Data Tools BI, Extended events, SQL Server Profiler, Visual Studio 2010/2012DTS, Database Tuning Advisor.:

Operating Systems: Windows NT, Win 2000, Windows 2012/2008/2003 Server.

Languages: C, C++, T-SQL, XML, HTML, PowerShell

Tools: Rapid SQL, Toad, SQL Lite Speed, IBM Maximo, BMC Remedy, Spotlight, Idera’sdiagnostic manager

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr. SQL Server DBA

Responsibilities:

• Monitoring and Troubleshooting SQL Server Performance using Query Tuning, SQL Server Profiler, System Monitor, Database Engine Tuning Advisor, Dynamic Management Viewsand Functions and Resolving Blocking and Deadlocking Issues.
• Working on production Break fix issues which include performance, blocking and space related issues.
• Installation and configuration of SQL server 2014 and 2016
• Builds and Migrations from SQL Server 2008 to 2012 and 2014 on standalone and clusters.
• Implemented Always ON Availability groups
• DevelopedSQL Server Stored Procedures, Tuned SQL Queries( using Indexes and Execution Plan)
• DevelopedUser Defined Functions and created Views
• Created Triggers to maintain the Referential Integrity.
• Worked on Projects to provide DBA support for Building SQL Servers for new applications (begin to end support)
• Scheduling Jobs and Alerts using DB Mail.
• Using Foglight to monitor/Test the SQL Server Databases alerts.
• Implemented table and index partitioning.
• Configuring SSRS, Deploying and Migrating SSRS reports.
• Developed DR plans and automated failsafe backup remediation modules for accurate backup monitoring and reporting / Ad hoc reporting.
• Maintaining USER PERMISSIONS, LOGINS and SECURITY Issues. Monitoring Event Viewers, SQL Error logs and Log Files Viewer for S/W and H/W errors.
• Working with Maximo Change Request(Any changes in Production database need to Create Maximo Tickets this should be approved by Global DBA team after changes made in stage and development environment)
• Creating and scheduling maintenance routines.
• Configuring CLUSTERING, LOG-SHIPPING, MIRRORING, REPLICATION.
• Resolving all high availability Issues.
• Developing and deployment of packages using SSIS.
• Create and Modify of the database objects according to the requirement.
• Resolving Database Failures, Physical Server Failures and SQL Server Service Failures
• Scheduling and implementing patching activities i.e. Service packs and Cumulative upgrades as per baseline standards.
• Implemented backup and Recovery strategies.
• Involved in all ITIL process like Change management, Incident Management & Problem Management.

Environment: Windows2012/2008/2003/2000/NT4.0, VMware, MS-SQL Server 2014/2012/2008R2/2008/2005/2000, SSIS, SSRS, System Monitor / Performance Monitor, Foglight, Lite Speed, Maximo

Confidential, Atlanta, GA

SQL Database Administrator

Responsibilities:

• Installed and configured SQL Server 2012/2008R2 Enterprise/Standard edition in the production/DR/Test/Dev environment.
• Monitored the Daily Full Back-up and Transactional log backup jobs.
• Involved in the configuration and maintenance ACTIVE/PASSIVE Cluster Environments for the production servers
• Involved in Database and SQL Query Tuning to improve performance, identifying locking and blocking issues by utilizing DBCC commands, DMV’s and DMF’s for monitoring.
• Implemented and maintain database security (create and maintain users and roles, assign privileges).
• Perform general technical trouble shooting and give consultation to development teams.
• Identified issues related to poor performance of complex SQL queries by analyzing missing indexes and unused indexes.
• Implemented and monitoring Transactional replication in Test and production environment.
• Created new tables, written stored procedures, triggers for Application Developers and some user defined functions. Created SQL scripts for tuning and scheduling.
• Developed functions, views and triggers for automation
• Expert in performing multiple SSIS packages migration from SQL server 2005 to SQL server 2008R2.
• Analyzed values of performance monitor counters to identify potential disk, I/O subsystem issues.
• Actively involved in development of automated daily, weekly and monthly maintenance tasks such as backups, verifying database integrity and re-indexing.
• Troubleshoot and Resolved issued problems with the production server via the ticketing system BMC remedy.
• Monitoring the servers usingIdera Diagnostic Manager.
• Documented disaster recovery plans and participated disaster recovery drills.
• Provided dedicated supports for SQL Server production server 24/7 shifts.

Environment: Windows server 2003/2008/2008R2, MS SQL Server 2012/2008R2/2008/2005, Idera Diagnostic Manager, BMC remedy

Confidential, Princeton, NJ

MS-SQL DBA

Responsibilities:

• Providing 24/7 On-Call supports for critical production databases.
• Install, configure, administer, secure and maintain SQL Server 2000,2005,2008 and 2012 instances and databases
• Refreshes from Production backup to Stage and Development environments
• Troubleshooting performance issues with Native SQL Profiler, Perfmon and other third party tools.
• Proactively monitoring space and minimizing space issues.
• Design and implementation of standards across all the SQL Servers.
• Implementing and administering database replication.
• Configure and Monitoring log shipping and planning for Disaster recovery.
• Managing SQL Server on a cluster and experience in installing service packs.
• Managing Database security by providing the appropriate permissions to the users.
• Preparing Capacity planning for the large databases.
• Ensuring the SQL Server to be with the Microsoft and companies security compliance.
• Performed Patching, upgrading and other maintenance activities on SQL Servers by planning downtime.
• Supported high available technologies like Clustering and Database mirroring and resolved critical issues.
• Resolving connectivity and ad-hoc user issues.
• Monitoring replication and resolving related issues.
• Experience on performance tuning and query tuning.
• Worked on Creating logins and providing Permissions to user.
• Worked on Stored Procedures, Modifying Tables, Views, Indexes,User-defined Functionsand writing T-SQL code.
• Used DBCC Commands for to improve the performance and integrity of the database.
• Created linked server from SQL environment to other environments like oracle environment.
• Performed Backup and recovery& Automation of Backups using maintenance plans.

Environment: Windows 2003/2008 server, MS SQL Server 2000/2005/2008 R2, MS Access, T-SQL, MSExcel, lite speed.

Confidential, Philadelphia, PA

SQL DBA

Responsibilities:

• Managing of database objects like Tables, views, indexes.
• Created views for easier implementation on web pages, and wrote triggers on those views to provide efficient data manipulation.
• Backing up entire user’s database and scheduling backup process.
• Successfully resolved deadlock issues by creating traces on objects using SQL Server Profiler.
• Worked on Server Native tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Responsible for migration of databases from one version to other versions and applying patches
• Performed daily support, troubleshooting, monitoring, and optimization and tuning of server and SQL server environments across entire system.
• Configured Transactional Replication (Creating Distribution Databases, updating Publishers, creating & managing Publications, managing Replication monitors) and troubleshoot replication issues.
• Assign permission to users, roles, and object. Administrate security for server’s logins with Windows and SQL Accounts.
• Troubleshooting, Debugging and Performance Optimization for SQL Server Database and Application Related issues.
• Configure and manage database maintenance plans for update statistics, database integrity check, backup operations and Indexing updates.
• Implement the New features like Table and Index Partitioning for Larger Tables in SQL Server 2008 for achieving performance enhancement.
• Performed transformations and data flow tasks using VB scripts.
• Worked with Application development using Visual Basic.
• Created logical and physical design of new database to fit new business requirements and implemented new design into SQL Server 2005.
• Used DDL and DML to writing triggers, developed stored procedure, functions, views and triggers.

Environment: SQL Server 2000/2005/2008, T-SQL, Windows Server 2000/2003, Visual Studio 2008, TFS HTML 4.0.

Confidential

Database Administrator

Responsibilities:

• Responsible for handling the Production & Staging Environment.
• Taking care of the Backups and Restoration Tasks of databases in 8-9 TB’s with multiple files and file groups
• Maintaining/ConfiguringClustering, Replication, Logs Shipping & Mirroring, Maintenance Plan.
• Preparing documents forDisaster Recovery and perform disaster recovery exercise once in a Year.
• Performance tuneStored Procedures, Triggers, Functions& long running queries by looking Confidential query plans, IO Statistics,Joining Techniques, and Outdated Statistics & Indexes.
• Perform Capacity Planning & utilization
• Preparing the schedule for the maintenance job of various events.
• Ensuring theautomationof monitoring MS-SQL Server.
• Assisting the Programmers foroptimizing SQL queries.
• Database refreshin test environment with the production database backup
• Coordinating service packupdates on SQL DB Servers on test and production environments
• Monitoring health of the databaseserver and checking error log or event log for database errors.
• Managing new database objectsincluding tables, indexes, SQL queries, & stored procedures for data manipulation.
• Drafting documentsfor Jobs, Replication, Server Capacity, Database Size, etc.
• Performing theroot cause analysisof production issues.
• Performing Weekly Maintenance of SQL Servers

Environment: MS SQL Server 2008/2005/2000, Windows Server 2003/2000, MS Office, SCOM.