SUMMARY:

• 8 years of experience in Database Administration and Development for Very large and complex databases in SQL Server 2016/2014/2012/2008 R 2/ 2008/2005/2000
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Expertise in installation of MS SQL Server 2016/2014/2012/2008 R 2/ 2008/2005/2000 and updating with latest Service Packs, Hot fixes and Security Patches.
• Implemented and monitored different types of High Availability & Disaster Recovery scenarios like Always - on Availability Groups, Replication models (Snapshot, transactional, Merge, Peer-Peer), Log Shipping, Database Mirroring and Clustering (Active-Active and Active-Passive)
• Hands on experience with SQL Server 2012 Always-On High Availability Groups.
• Implemented In place and Side by Side Migration of MS SQL Server of different Versions.
• Experience working in both OLTP and OLAP (Data Ware Housing) environments.
• Experience in performing database regular Backups and Restoring on requirement and proficient with Database Recovery models
• Experience in identifying the I/O and memory bottle necks, blocking and deadlocks caused by complex queries using SQL Server Activity monitor/profiler, Dynamic Management Views (DMV) and handling them by implementing better Query Execution plans
• Experience in configuring Registered Servers, Linked Servers, and Multi Server Administration.
• Experience in Query Optimization, Database Consistency Checks using DBCC Utilities and analyzing the execution plan and index management for better Query Optimization.
• Written Complex Stored procedures as well as analyzing and debugging existing complex stored procedures, suggested creating Clustered and Non-Clustered indexes on tables.
• Implementation ofSQLLogins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Exquisite skills in Creating and scheduling jobs, alerts and operators withSQL Server Agent,handling native Backup/Recovery of databases, Database Maintenance Planning.
• Experience in analyzing and resolving Locks, Dead Locks and handling the Isolation Level and Concurrency Effects.
• Performed Database Integrity Checks, Database Maintenance plans, updated Database Statistics and performed Re-indexing, Rebuilding the indexes, online indexing at regular intervals for better performance.
• Worked extensively on Clustering and server consolidation. Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Checking the threshold values and baselines and monitoring in Perfmon and SCOM.
• Good atSQLServer features likeSQLAudit, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE)
• Experience in data partitioning to improve the performance of large table to reduce contention and improve availability of data.
• Used third party Quest tools like spot light and fog light for backing up large databases.
• Configuring TEMP DB on files and file groups and capacity planning of databases.
• Experience in implementing features of SQL Server 2008 like Policy Based Management, Backup Compression Techniques.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services
• Querying the databases using the Power-shell scripts.
• Monitoring Event Viewer,SQLError logs and Log File Viewer for Software and hardware related errors.
• Experience in Normalization, Database design, Performance Analysis and Production Support for very large (VLDB) and Complex Databases
• In-depth knowledge of T-SQL(DDL, DML, and DCL)
• Excellent backend skills in creatingSQLobjects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions
• Deployed and Debugged SSIS packages for import, export and bulk insert data with transformations from various data sources
• Experience in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Experienced in SSRS dashboard, table, chart report designing and deploying on Share point / SQL server.
• Experience in creating various type of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.
• Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Experience working in a team-oriented, collaborative environment. Demonstrated ability to successfully manage, lead, and inspire a team of technical professionals.
• Handled numerous Change Management requests on production servers and Supported 24X7 Production on Call.

TECHNICAL SKILLS:

Operating Systems: Windows10/8/7/Vista/XP/2000/NT, Server2012/2008R2/2003, Exchange 2003, Linux, UNIX.

Databases: MS SQL Server 2016/2014/2012/2008 R2/2005/2000, MYSQL, Oracle, MS Office Access 97/2000/2003

ETL Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Data Integrator, Data transformation services (DTS), SSDT

Database tools: SQL profiler, Data Collector Tool, SQL Query Analyzer, Index Analyzer, SQL Server Management Studio

Data Modeling Tools: Erwin, MS Visio

Data Mining Tools: WEKA, Orange

Languages: T-SQL, C/C++, C#, java script, java, Visual Studio, HTML, XML, CSS, Go, R,PL/SQL

Applications: Microsoft Office Suite, Adobe Photoshop, Acrobat Reader/Writer.

PROFESSIONAL EXPERIENCE:

Confidential, Detroit, MI

Sr. SQL Server DBA

Responsibilities:

• Involved in Administration, Database Design, Performance Analysis, and 24X7 Production Support for Large (VLDB) and Complex Databases.
• Managed over 250 SQL Servers 2016/2014/2012/2008 R2/2008/2005 including Production and Test servers.
• Installed and configured SQL Server (Standard and Enterprise editions) in clustered and non-clustered environments.
• Performed database migration fromSQL2008 toSQL2012 and managed orphaned users.
• Involved in implementation of Always-On Availability Group as a High Availability solution on SQL Server 2014/ 2012.
• Worked on configuring high availability like Clustering (Active-Active, Active-Passive), log shipping, Database mirroring and transactional replication.
• Worked on resolving clustering, Database mirroring and transactional replication issues
• Implemented and managed Database Cluster Failover as per client requirement Active/Passive & executed of any upgrade such as Service Pack, Hot fixes in Active/Passive clustering.
• Responsible for ensuring that company's databases are performing optimally through performance tuning, including: storage balancing, re-indexing, aggregation, partitioning, migration and maintenance plans.
• Upgraded SQL Server /2008 R2 databases to SQL Server 2014/2012 databases using side by side migration techniques.
• Tested and implemented Backup to multiple files for faster and smaller SQL Server files.
• Managed Security using SQL Logins, Roles and Security Modes for various users.
• Extensively worked on Dynamic Management Views (DMV’s) and Dynamic Management Functions (DMF’s).
• Responsible for Monitoring and TroubleshootingSQLJobs, Scheduled Tasks, Disk spaces, error logs and making recommendations for performance improvement in hosted databases which involved index creation, index removal, file group modifications, and scheduling jobs to rebuild/reorganize indexes and update statistics.
• Refresh non-prod environments with production.
• Extensively worked with SQL Profiler, Execution Plan, Extended Events, PerfMon, Data-Collector Tool and DBCC Commands.
• Resolved Locks and Deadlocks by using DMVs, table hints and Activity Monitor to improve the performance.
• Configured Database mail, linked servers, Transparent Data Encryption (TDE) and Auditing
• Created/altered/modified and tuned T-SQL Stored Procedures, Complex Queries, views, tables, and functions on OLTP and OLAP environments like Data warehouse and reporting.
• Designed and developed SSIS packages using different control flow tasks, Transformations and dataflow tasks.
• Created, deployed and managed reports using SQL Server Reporting Services (SSRS)
• Documented procedures\processes and Trouble-shooting guides for various issues.
• Supported 24 X 7 Production On call.

Environment: SQL Server 2016/2014/2012/2008 R2, Windows Server 2012/2008R2/03 server, SCOM, PL/SQL, SQL Profiler, Data Collector Tool, Perfmon, T-SQL, SSIS, SSRS, MS- Excel

Confidential, Charlotte, NC

SQL Server DBA

Responsibilities:

• Installation and configuration of SQL Server 2012/2008R2, applying service packs in both Cluster and stand-alone environments
• Implemented new SQL Server 2012 technique Always on Availability Groups (HADR) for High Availability.
• Configured Replication (Transactional replication)
• Configured and maintained Log shipping more than hundred production databases
• Configured and maintained Mirroring (High performance)
• Created Logins and managed database objects like Tables, views, stored procedures, indexes
• Experience in upgradingSQLServer software to new versions and applying Service packs and hot fixes and Unattended Installations
• Created Jobs, Alerts using SQL Server agent, monitoring and troubleshooting the jobs
• Implemented Backups and restored when necessary
• Monitored database health and tuned accordingly
• Experience in checking Actual and estimated execution plans to find out performance issues for long running quires and find out how SQL Server optimizer is behaving while the query is running in terms of (Nested loop, Hash and Merge Join).
• Experience in checking each operator property compare that with SQL Server query to find what columns are needed to be indexed to get the better performance.
• Involved in Index Maintenance Index tuning, Rebuild & Reorganizing Indexes according to Index fragmentation
• Optimization of T-SQL procedures, resolving the blocking, deadlocks, Client/Server Connectivity, Database Consistency Checks using DBCC Utilities
• Implemented Data partitioning for large tables in SQL Server 2012/2008/2005 to increase performance
• Configured and managed database maintenance plans for update statistics, database integrity check and backup and restore operations
• Experience in migration and maintenance of data using various utilities like DTS, SSIS, Import and Export, Attach/Detach Data Migration tools
• Used Windows Performance monitor to monitor CPU & Memory usage at windows level
• Created Operators and Configured Database Mail
• Trouble shooting Problems by using SQL server profiler. Very Pro actively identifying the problems before user complaints
• Developed SSIS Packages to transfer the data between production and development environments
• Develop documentation that sufficiently describes technical deliverable as required for internal controls so that the maintenance responsibility can be passed on to production support team
• Supported 24 X 7 Production On call.

Environment: SQL Server 2012/2008/2008 R2/2005, T-SQL, Windows Server 2012/ 2008 R2/2000, PERL, Report Builder, SSIS, SSRS.

Confidential, Baltimore, Maryland

SQL Server DBA

Responsibilities:

• Deployed and Administrated SQL 2008/2005/2000 Enterprise servers on production environment.
• Setting up disaster recovery solutions using Log shipping, Mirroring, Always On in windows clustering environments for High Availability.
• Applying service packs, hot fixes and cumulative updates.
• Implemented side - by-side migration and in-place upgrade of MSSQLServer
• Worked in Active/Passive and Active/Active cluster environment.
• Configured and managedSQLServer snapshot, transactional and merge replication
• Exported or Imported data from other data sources using Import/Export and SSIS
• Performed database migration using Backup-restore, Attach and detach methods.
• Analyze long running queries and tune to optimize application & system performance. implemented T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE), Data Partitioning, Snapshot Isolation
• Configured SQL Servers with appropriate settings to resolve various resource allocation & memory issues
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels
• Configured Email notifications through SMTP to get Alerts and diagnose the performance counters.
• Involved in analyzing and understanding execution plan and fixing query to execute with low cost using joins like merge, nested loops, hash join etc. depending on scenarios.
• Reorganizing or Rebuilding Indexes based on the Index fragmentation.
• Experience working with Active Directory
• Extensively worked on DBCC commands and Dynamic Management Objects.
• Involved in development of automated daily, weekly and monthly system maintenance tasks such as database backup, integrity and replication and indexing
• Used DMV for monitoring the performance of the server.
• Reorganize/Rebuilding the indexes at regular intervals for better performance.
• Performed data transformation from various data sources toSQLServer using SSIS, Import/Export, Bulk insert and BCP utilities.
• Involved in Creating SSIS packages to integrate the data coming from various data sources
• Created Reports through Reporting server (SSRS) accordingly the business requirement.
• Documented Trouble-shooting guide for various issues.
• Exposure in Data modeling tools such as Erwin, Microsoft Visio.

Environment: T-SQL, MS SQL SERVER 2012/2008R2/2005/2000, Windows Server NT/2003/2008R2/2012, SSIS, SSRS, SSMS, SQL Profiler.

Confidential

SQL Server DBA

Responsibilities:

• Install SQL server 2008R2/2005 servers on Physical/virtual servers and apply Service packs where needed.
• Involved in fine Tuning Performance and Query optimization of the Database as required by the application
• MigratedSQLserver 2000 databases intoSQLserver 2008/2000 databases by In-place upgrade process and also used upgrade advisor tool in up-gradation.
• IntegratedSQLserver profiler traces with Performance monitor to have better graphical analysis to find system bottlenecks.
• Created Stored Procedures, Triggers, Views and Functions for the Application.
• Extensively worked on Dynamic Management Views (DMV's) and Dynamic ManagementFunctions (DMF's).
• Created Views to facilitate easy user interface implementation, and Triggers on them to facilitate consistency Data entry into the database.
• Filtered unnecessary data using complex T-SQL statements, implemented various Constraints and Triggers for data consistency.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Maintaining the database consistency with DBCC at regular intervals. Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Implemented and maintained Database mirroring as a Disaster Recovery Solution.
• Used Data Partitioning, Snapshot Isolation inSQLServer 2005
• Generated reports from Jobs, Alerts,SQLMail Agent and scheduling DTS and SSIS, SSRS Packages
• Designed and implemented comprehensive Backup plan and disaster recovery model
• Worked extensively in Query Analyzer and Profiler for tuning queries using variable for characteristics and query costs
• Used log shipping for synchronization of database
• Managed Security using SQL Logins, Roles and Authentication Modes for various categories of users.
• Setup and maintained Linked Servers.
• Expert in data transformation services like SSIS, DTS, BCP and Bulk Insert.
• Provided back-end support for functional testing and performance testing.

Environment: T-SQL, MS SQL SERVER 2008 R2/2005/2000, Windows Server 2003/2008 R2, SSIS, SSRS, MS EXCEL.

Confidential

Jr. SQL Server DBA/Developer

Responsibilities:

• Involvement in the Design and Development of Database.
• Actively participated in gathering user requirements and system specifications
• Involved in automation of the job and was involved in daily monitoring of the tables and indexes for performance
• Monitoring Log shipping/Replication and trouble shooting of errors
• Creating Automatic data loading Procedures from the host system to master systems
• Used stored procedures, BCP and DTS Packages
• MonitoringSQLserver performance using profiler to find performance and deadlocks.
• Backup and Restoration of data/database.
• Identify Relationships between tables and enforce referential integrity using foreign key constraints.
• Create Clustered and Non-Clustered Indexes to improve data access performance.
• Create Triggers to generate alerts and notifications.
• Security issues related to logins database users and application roles and linked Servers.
• Analyzing the problems in the production environment and try to develop new procedures and methods for monitoring the problems and send alert messages to take pro-active action.
• Timely completion of activities for database backup, restoration and health check of databases.
• Scheduling Full and Differential Database backups to disks, tapes or remote servers, using batch scripts, TSQL and Maintenance Plan Wizard and configure appropriate Recovery Model for the databases.
• Troubleshoot the problems and document them.
• Most of the claims processing takes our involvement and support, which leaves me with good enough hold on the financial matters of processing like credit and taxes as well.

Environment: MS SQL Server 2000, Windows 2000 Server.