SUMMARY

• Certified SQL Database administrator with 7 years of IT Experience in Database Administration ON Premise an Azure cloud and Development for very large and complex databases in Microsoft SQL Server 2019/2017/2016/2014/2012/2008 R / 2000 in Development, Test and Production Environments.
• Extensively worked on installing, configuring, optimizing and managing different versions SQL Server 2005, 2008 R2, 2012, 2014, 2016 and 2017 updating with latest hot fixes and service packs as per CIS Standards.
• Expert in Migrating from SQL server 2005 to 2008/2008R2 and 2008/2008R2 to 2012, 2014,2016 and 2017 by using In - Place upgrade process as well as side-by-side upgrade process and documented the Upgrade Process.
• Proficiency and expertise in SQL Server Backup/Recovery, Disaster recovery planning and Security Management.
• Good exposure with SQL Server High Availability Always ON Availability Groups, DB mirroring, log shipping and clustering.
• Hands on experience on SQL SERVER 2016 new features like Query store, IN memory OLTP and database stretching to Azure platform.
• Experience in supporting Very Large Database (VLDB) more than 2 to 4 TB and troubleshooting problems.
• Expertise in implementation of security models, Database authentication modes, creation of logins, granting permissions and assigning roles to users on databases.
• Extensively worked on Locks, Deadlocks, Handling Isolation Level and Concurrency Effects, Detect CPU, I/O, Memory Bottlenecks .
• Expert in Monitoring, Optimization, Performance tuning of SQL Server databases using DMVs, Activity Monitor, SQL Profiler, DB Tuning wizard and third-party tools.
• Expertise in reading and understanding execution plan and fixing the query to execute with low cost.
• Experience in using Native tools like SQL Server Profiler, extended events, Database Tuning Advisor, Perfmon and third-party tools like IDERA.

TECHNICAL SKILLS

Languages: C, C++, .Net, SQL, T-SQL, Python.

RDBMS: MS SQL Server 2019,2017,2016,2014, 2012, 2008R2, 2008, 2005, 2000, MS Access. Confidential 12c.

BI Tools: SQL Server Integration Services (SSIS), INFORMATICA, SQL Server DTS, SSRS, OBIEE

Other Tools: Microsoft Visual Source Safe, IDERA, Red gate, Fog light, Sentry, BMC, BMC PATROL, Remedy Ticketing tool

Data Modeling Tool: Erwin, Microsoft Visio 2007

SQL Server Tools: SQL server Management Studio, SQL server Query Analyzer, DBCC, DTS, BCP, SQL server profiler, Event Viewer, and Index Tuning Wizard, SQL Server Agent, SQLCMD, Triggers

Operating system windows: Windows 2016, 2012, 2008, 2003, 2000 Advanced Server, Windows 2000 data center, Windows NT, Windows 95/98/2000 XP.

Linux operating systems: Centos, ubuntu, Red hat.

PROFESSIONAL EXPERIENCE:

Confidential, CARY, NC

SQL/Azure Database Administrator

Responsibilities:

• Experience in monitoring and troubleshooting performance issues like long -running queries, CPU, Memory and I/O issues.
• Configuring and maintaining high availability solutions (Always on, log-shipping and Clustering) on Prem /Cloud.
• Configuring Azure services PaaS/IaaS and migrated database from on premise to Azure.
• Experience in creating and maintaining Azure SQL databases using the right tiers.
• Configured and maintained Elastics Db pools.
• Experience in configuring and monitoring Geo Replication.
• Experience in working with database Synchronizations using HUB-Member Toplogies.
• Monitored and worked with audit teams on security related issues.
• Configuring Always on and troubleshoot sync issues between prod and DR servers.
• Database refresh activities includes sensitive data using data masking.

Confidential

SQL/AZURE Database Administrator

Responsibilities:

• Maintaining production databases, performing periodic patch upgrades and reviewing existing policies and procedures and suggesting suitable changes if necessary.
• Implemented Always on availability groups and Log shipping for disaster recovery.
• Data refresh activities from prod environment to Dev environment and fixing orphan users.
• Migrated on-premise SQL databases to AZURE Portal.
• Created SQL Database on azure on based on DTU as per client’s requirements.
• Monitored Azure databases on weekly basis to cut costs on DTU basis.
• Outstanding grasp of ITIL principle and process.
• Resolved business issue and complaints in accordance with appropriate professional standards.
• Implemented Database integrity checks, update statistics and reindexing.
• Experienced in using tools like Extended events, windows performance monitor and performance counters for monitoring and tuning the SQL Server Performance, IDERA Diagnostic manager.
• Managed Production environment for High Availability and implemented Always ON availability group with three replicas for reporting and backup.
• Developed database and database objects as per client requirements
• Worked on setting up and managing Snapshot and Transactional Replication.
• Involved in Monitoring Performance of different production servers.
• Resolving performance related issues to Blocking, Deadlocks and long running queries
• Worked extensively with Execution plan and Index Tuning Wizard for performance bottlenecks
• Involved in Migration MS SQL Server 2008 to MS SQL Server 2012
• Interacted with concern application team in fixing the problems when ever needed.
• Monitoring and scheduled jobs on production and staging environment.
• Configure SQL / DB MAIL for sending server / database alerts :
• Responsible in Monitoring and Troubleshooting SQL Server Performance issues.
• Used the query store and Execution Plan to improve the optimization of the T-SQL code.
• Performance tuning of SQL queries and stored procedures using query store and extended events and Index Tuning Wizard
• Provided 24 x 7 Production support for the database and application issues.

Environment: SQL Server 2017/206/2014/2012/2008 R2, SQL extended events, Clustering, Always on, Log Shipping, Windows 2008 R2/2003/2000, Commvault, IDERA mgmt.

Confidential, CHICAGO, IL

SQL Database Administrator

Responsibilities:

• Installation and Configuring MSSQL Server 2005/2008/2008 R2/2012 on Dev, Test and Production boxes.
• Handling Problem Management to provide the permanent resolution to the frequently repeating issues and customer raised Problem Records.
• Extensive hands on experience Service Pack deployment on both stand alone and cluster environment with respect to latest patches level.
• Provide support for database administration, database migrations and disaster recovery solutions for production databases.
• Data refresh activities from prod environment to Dev environment and fixing orphan users
• Implementation of SQL logins, roles and authentication modes as part of security policies for various categories of users.
• Scheduled Full and Transactional log backups for the user defined and system databases using the Database Maintenance Plan Wizard
• Troubleshooting of data maintenance issues and Linked server issues
• Attending CAB and TAB meeting on weekly basis to get the approvals for scheduled changes.
• Perform business analysis, technical analysis, systems design, application software programming.
• Involved in end to end transition process from onsite team to support base line

Environment: SQL Server 2012/2008, Confidential 11g/10g, .Net Framework 3.5/4.0, C#.Net, Asp.Net2.0, JavaScript, SSIS, SSRS, VSS, Windows 2000, Windows 2003 Server, MS TFS, MS-Access, SPSS, Erwin, Visio Professional, TFS

Confidential, PA

SQL Database Administrator

Responsibilities:

• Installed, Configured and Administered SQL Server 2012/2008R2/2008 Servers in Production, QA, Pre-Prod and Dev environments.
• Responsible for overall database environment and maintain operational uptime of 99.9%.
• Performance tuning, capacity planning, trend analysis, and server sizing for very large databases.
• Installed and managed multiple 3 node failover cluster set up in active/active clustered environment as a High Availability mechanism
• Daily support, troubleshooting, monitoring, optimization and tuning of server and SQL server environments across entire system.
• Implemented Transactional Replication for different applications and managed replication and database modifications for replicated objects
• Monitoring the servers using Idera third party software and backups using Commvault.
• Ticketing systems like Resolve for Change Request, Sales Force, BMC Remedy etc.,
• Deployed SSIS packages and worked on Reporting services.
• Created logins and Roles with appropriate permissions for temporary and permanent access requests.
• Scheduling the Backups and performing the restoration. Support for huge Databases.
• Provided 24/7 on-call support on rotation basis for production database.

Environment: MS SQL Server 2012/2008R2/2008/2005, Idera Diagnostic, SQL Lite Speed, Red Gate SQL Compare, Visual Studio 2010/2005 and Windows Server 2008/2003