SUMMARY

• 8 years of Database Administration and Development experience working on multiple MS SQL Server versions 2016/2014/2012/2008 R2/2008/2005 and applying patches, hotfixes and service packs.
• Experience in implementing Side - by-Side Migration and in-place Upgrade of MS SQL Server 2012/2008R 2/2008/2005.
• Experience with the 32-bit, 64-bit Microsoft SQL Server in Production, Development, Testing in Clustered and Stand-alone Server Environments.
• Expertise in Database Administration activities that include Installation, Configuration, Backup & Recovery, Database Security, Database designing and Query o­ptimization.
• Extensive experience with configuring high availability and Disaster recovery scenarios like clustered environments, set-up different topologies in replication, Log shipping and mirroring.
• Extensively Worked on Transactional Replication and Snapshot Replication.
• Expertise in setting up Active/Passive and Active/Active Clusters for High availability.
• Handling Memory configurations for SQL Server 2000 and 2005 on Windows 2000/2003.
• Implemented the new SQL Server 2005 concepts like Data partitioning, Snapshot isolation, database mirroring, database snapshot, DDL triggers, try-cache blocks.
• Experience in implementing Always on Availability Groups in SQL Server 2012.
• Experience in using the DMVs, DMFs, System Views and in-built global variables for analysis.
• Experience in analyzing Locks, Dead Locks and handling Isolation Levels.
• Expert in Performance Tuning and Optimization (PTO) by analyzing index fragmentation, Execution plans, and finding missing indexes.
• Extensively used the native tools SQL Server Profiler, PerfMon, Activity Monitor, Index Tuning Wizard, Database Tuning Advisor, Log Viewer and Event Viewer for performance analysis.
• Experience configuring and working MS SQL Server 2008 and MS SQL Server 2005 on VMware Environment and Unix/Linux.
• Experience trouble shooting SQL Server jobs and job monitoring tools.
• Extensive experience with Backup compression and data compression in SQL Server 2008.
• Worked on maintaining database security (logins, users, database/server roles and granting/revoking permissions).
• Experience in backup, restore the database manually and scheduling jobs and Maintenance Plans.
• Experience in Transportation
• Experience with Transparent Data Encryption (TDE).
• Experience in Configuring SMTP Server for Database Mail setup and received alerts for the Threshold values.
• Expert in creating database objects like Tables, Views, Indexes, Stored Procedures, Cursors and Triggers using T-SQL.
• Sound knowledge of RDBMS concepts including Normalization, Joins, Keys and Constraints.
• Handled multiple SQL Instances on clustered environment for projects built on SAN using RAID levels.
• Experience in configuring and managing Linked Servers.
• Rebuilding indexes with different fill factors and updating statistics.
• Experience in creating SSIS packages using control and data flow elements.
• Experience in extracting and transforming (ETL) data using SSIS, Import/Export, Bulk Insert, BCP and DTS Packages.
• Created SSIS packages to load robust data from different heterogeneous data sources like Oracle, DB2 to SQL server
• Experience in creating and manipulating Cubes using SSAS.
• Experience in creating Table, Matrix, Chart, Graph, Gauge, Indicator reports using SSRS.
• Experience in Database design, Performance Analysis, Production Support for very large (VLDB) and Complex Databases.
• Experience in SQL Programming, logical and physical data modeling of the database in Erwin and MS Visio.
• Experience in using third party tools including Foglight, Spot Light, LiteSpeed and Idera.
• Strong knowledge of Software Development Life Cycle (SDLC), Agile and SCRUM methodologies.
• Strong experience in mentoring, working with a team, coordinating with developers, good communication and documentation skills, decision support meetings and 24/7 on call production support.

TECHNICAL SKILLS

Operating System: Windows Server 2012/2008/2003/2000

RDBMS: MS SQL Server 2012/2008R 2/2008/2005/2000 , Oracle, MySql, Unix/Linux

Database Tools/ Technologies: SSMS, SSIS, SSRS, SQL Profiler, Query Analyzer, Power Shell

Programming Languages: T-SQL, C++, Java, HTML, CSS, JavaScript, JSP, .Net, C#

Other Tools: LiteSpeed, Foglight, RedGate, Idera, MS Visio, Erwin, MS Office, MS Project, SharePoint, DB Artisan

Network Protocol/Topologies: TCP/IP, SMTP, FTP

PROFESSIONAL EXPERIENCE

Confidential - Charlotte, NC

SQL Database Administrator

Responsibilities:

• Providing support to line of business in AML (Anti Money Laundering) and analyze data.
• Support/maintain NICE Actimize software
• Automat manual process by Creating 4 SSIS job that needs to be ran manually.
• Build 1 report through SSRS.
• Managing AlwaysOn Availability Group.
• Performance tuning and VM configuration standards.
• On call support rotation.
• Improved hardware optimization and configuration onsite, using remote desktop support
• Monitoring Backups, performance checks, event logs and create logins with limited privileges.
• Audit the Logins, remove and add users as per request.
• Monitor Availability Groups.
• Performance tuning SQL 2005 2008, 2012 and 2014 servers
• Provide Backup and Restore for Developer team.
• Performance tuned and monitored production databases
• Troubleshooting Blocking, deadlocks, replication, Log Shipping.
• Assisting Developer with Store Procedures.
• Provided performance tuning for the application servers and optimization for customer applications
• Migrate databases from SQL 2012 to SQL Server 2016
• Build SQL Clustering environment on 3 node.
• Working experience in Azure.
• Experience in Windows Azure, migrating database to Azure.
• Experience in Moving Data in and out of Windows Azure SQL Databases and Blob Storage.
• Knowledge of Tableau and Power BI
• Optimized the query performance with modification in TSQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins, creating useful clustered index and non-clustered indexes.
• Setting up maintenance plan, Backup, rebuild index, update statistic.
• Review SP, Views, triggers, indexes and constraints
• Working experience in Azure

Environment: Microsoft Windows Server 2016, SQL Server 2016 & 2014

Confidential, Orlando, FL

SQL Server DBA

Responsibilities:

• As a DBA, my day to day task was creating logins, assigning permissions, scheduling jobs, alerts, operators & lots of back-ups and restore.
• Performed analysis for setting up a comprehensive Backup and Recovery strategy for SQL Servers.
• Worked on Side by Side migration from SQL Server 2000/2005/2008 to SQL Server 2016.
• Created maintenance jobs for performance of SQL Server which includes updating statistics, database integrity checks and Index Rebuild
• Monitored SQL Server performance using profiler to find issues like blocking and deadlocks.
• Managed and Administrated the SQL Server 2016/2014/2012/2008 production and Non-production servers.
• Monitored servers by checking Error Logs and Windows Logs.
• Performance tuning and maintaining database consistency using DMVs DMFs and DBCCs
• Worked on DBCC checkDB to check the database consistency errors
• Optimized the query performance with modification in TSQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins, creating useful clustered index and non-clustered indexes.
• Adding fields to the table once it approved to deploy in production database
• Managaing SQL Instances with global listener.
• Worked on Azure.
• Experience in Windows Azure, migrating database to Azure.
• Experience working with Azure SQL Database.
• Cloud Administrator on Microsoft Azure, involved in configuring virtual machines, storage accounts, resource groups.
• Experience in providing Production Support for 24x7 Environments.
• Supporting on-call (off hours) schedule in providing technical support.
• Trouble Shooting and Solving the Production issue 's
• Shrink Dev/QA server database when there is low on disk space.
• Reviewing T-SQL code to verify and meets standards for both performance and error handling according to DBA standards.
• Working Extensively on Disk Space Utilization and Capacity Planning.
• Experience Working in SharePoint.
• Actively Participated in meetings, recommended the necessary changes required in present database or business systems
• Installed SQL SERVER on Microsoft Cluster (Active/Passive)
• Created and modified Stored Procedures and Functions to generate reports.
• Using Splunk for monitoring and visualizing the server.

Environment: Microsoft Windows Server 2016/2012/2008 R2/2003/2000, SQL Server 2016/2014/2012/2008 R2/2008/2005, SharePoint, TIDAL & Remedy (for ticketing and RFC)

Confidential, Midland, MI

SQL Server DBA

Responsibilities:

• Worked on Side by Side migration from SQL Server 2000/2005/2008 to SQL Server 2012.
• Worked on Filtered Views, views and Base table integration between different Source systems.
• Managed and Administrated the SQL Server 2012/2008/2005 production and Non-production servers.
• Installed stand-alone and clustered SQL Server 2008 R2 and 2012 on 64 bit systems.
• Extensively worked on Profiler, Perfmon, DMVs, DMFs and DTA to tune the databases, servers and query tuning.
• Managed Security using SQL Logins, Roles and Security Modes for various users.
• Rebuilding the indexes on regular intervals and placing the huge table/non-clustered index on the separate file group to improve the performance.
• Optimized the query performance with modification in TSQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins, creating useful clustered index and non-clustered indexes.
• Developed and created the new database objects including tables, views, index, stored procedures on Web UI Integration and functions, advanced queries and also updated statistics using Query Analyzer and Enterprise Manager on the existing servers.
• Analyze execution plans and generate suggestions for improvement.
• To set up SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options.
• Configured data partitioning/table partitioning on huge tables containing millions of rows for better performance.
• Used Change-data-capture (CDC) for capture changes on a daily basis.
• Extensively used Foglight Tool to monitor servers and database activities
• Supported 24 X 7 Production environment

Environment: Microsoft Windows Server 2008/2003, SQL Server 2012 / 2008 R2/2008/2005, SharePoint, SSRS, Microsoft Visual Studio 2008/2005, MS Business Intelligence Development Studio 2008, MS Access

Confidential, Chicago,IL

SQL Server DBA

Responsibilities:

• Worked on Side by Side migration from SQL Server 2000/2005/2008 to SQL Server 2012.
• Worked on Filtered Views, views and Base table integration between different Source systems.
• Managed and Administrated the SQL Server 2012/2008/2005 production and Non-production servers.
• Installed stand-alone and clustered SQL Server 2008 R2 and 2012 on 64- bit systems.
• Extensively worked on Profiler, Perfmon, DMVs, DMFs and DTA to tune the databases, servers and query tuning.
• Managed Security using SQL Logins, Roles and Security Modes for various users.
• Rebuilding the indexes on regular intervals and placing the huge table/non-clustered index on the separate file group to improve the performance.
• Optimized the query performance with modification in TSQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins, creating useful clustered index and non-clustered indexes.
• Developed and created the new database objects including tables, views, index, stored procedures on Web UI Integration and functions, advanced queries and also updated statistics using Query Analyzer and Enterprise Manager on the existing servers.
• Analyze execution plans and generate suggestions for improvement.
• To set up SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options.
• Configured data partitioning/table partitioning on huge tables containing millions of rows for better performance.
• Created SSIS packages to load robust data from different heterogeneous data sources like Oracle, DB2 to SQL Server
• Used Change-data-capture (CDC) for capture changes on a daily basis.
• Extensively used Red Gate SQL Compare and Data Compare tools to compare and synchronize SQL Database Schemas
• Experience working in AWS and Azure
• Supported 24 X 7 Production environment

Environment: Microsoft Windows Server 2008/2003, SQL Server 2012 / 2008 R2/2008/2005, SharePoint, SSAS, SSRS, SSIS, Microsoft Visual Studio 2008/2005, MS Business Intelligence Development Studio 2008, MS Access