SUMMARY

• Microsoft Certified Professional with 8+years of extensive experience in Administering and Managing multiple MS SQL Server Databases in Production and non - Production environments. Responsible for 24x7 technical support of SQL Server 2019/2017/2016/2014/2012/ Enterprise/Standard infrastructure.
• Relational Database Administration (RDBMS), support of MS SQL Server 2016/2014/2012/2008 R2/2008 in Production, Test, Development andClusterServer Environments.
• Experience with MSBI - SSIS, SSRS and SSAS 2008R 2/2012/2014/2016
• Reviewed primary objects like views, indexes, stored procedures, functions, and triggers based on logical design models, user requirements and physical constraints
• Experience and knowledge of high availability (HA) and disaster recovery (DR) techniques; Mirroring, Log shipping, transactional replication, Always on Failover Cluster Instance (FCI) and Always on Availability Groups.
• Proficient on Upgrading and applying service packs and hotfixes.
• Implement database migration of SQL Server 2005/08/08R2 to SQL Server 2012/2014/2016/2017/2019.
• Experience on backup, restore and recovery model.
• Proficient on database maintenance to check physical, logical consistency and integrity of database.
• Expertise in query optimization and performance tuning.
• Scheduled SQL agent jobs to inspect and automate different database related activities including backup, monitoring database health, disk space, backup verification, alerts, operators, and SSIS packages.
• Experienced on monitoring and troubleshooting infrastructure issues related with CPU, memory, I/O, disk space, database space usage, growth of transaction log files and other resource contention.
• Participate in on-call rotation for SQL server database support.
• Experience in problem solving, detail oriented, multitasking,
• Possesses a strong sense of responsibility and teamwork with a track record of dependability. Excellentwritten and verbal communication skills.
• Team player with a strong analytical, technical, interpersonal, and self-motivated skills

TECHNICAL SKILLS

RDBMS: MS-SQL Server Configuration Tools SQL Server Surface Area Configuration, SQL Server Configuration Manager, Microsoft Database Upgrade Advisor

Development Environment: SQL Server Management Studio, Enterprise Manager, Query Analyzer, Export / Import (DTS), SSIS, SSDT

Performance Tool: Database Engine Tuning Advisor, SQL server profiler, Performance Monitor, SQL Trace, Trace flags, Extended event, DMV, DBCC

Server Operating Systems: Windows 2012, Windows Server 2017

HA & DR: AlwaysOn Replication, Log shipping

LANGUAGE: SQL, T-SQL, C++, JAVA

NETWORKING: Active Directory, DNS, TCP/IP

THIRD PARTY TOOL: SQL Backup-Pro (Red Gate), Idera SQLDM, LiteSpeed, SQL Sentry

Ticketing System: ServiceNow, Service Desk, Mojo

PROFESSIONAL EXPERIENCE

SQL Server Database Administrator

Confidential, Maryland

Responsibilities:

• Installed, configured, and deployed new SQL Server 2019/2017/2016/2014 Database Server for Development, Testing and production environment.
• Migrated SQL Server 2012 databases to 2016, patched and applied service pack on 2016 production and development servers.
• Managing SQL Server security by creating user logins with appropriate roles, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Support SQL Server and manage permissions and perform database refresh from Prod to dev servers.
• Production support and deployment of SSIS package, replication, and SQL Always On.
• Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
• Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
• Implemented backup and Recovery Model based on RTO and RPO (SLA) and implemented a database maintenance plan, created Index rebuild and reorganize, DBCC CHECK DB and schedule backups.
• Working with the team on configuration of Always On with the availability group for one of our critical servers on SQL 2014/16.
• Experience in using Performance Monitor,SQLProfiler and optimizing the queries, tracing long running queries and deadlocks.
• Involved in restore operations to refresh the data from production to test servers
• Created linked servers for developers to access data on the linked server.
• Designed Database Maintenance Plans to check database consistency, reorganize indexes, and update stats.
• Assigned to the monitoring of server performance by using SQL Server Profiler, Microsoft Windows Performance Monitor, and DMV’s during peak periods of server utilization to ensure system performance.
• Create and configured Azure subscriptions, resources groups and deploy resources such as Azure SQL Databases, Virtual Machines, Azure Storages, Virtual Networks, and Azure Key Vaults
• Analyzed and evaluated azure pricing, availability options, reliability, and security of azure resources before and after deployment through azure adviser
• Configured IaaS (Infrastructure as a service), PaaS (Platform as a service), SaaS (Software as a service) with respect to SQL Server
• Used Azure Migration tools to Migrate on-premises SQL Databases to Azure
• Providing 24/7 Support for Production, Development & Test Servers of MS SQL Servers.

Environment: SQL Server 2008/R2, 2012, 2014, and 2016, Windows 2012R2/2016 Server, SQL Server Management Studio, Query Analyzer, SQL Profiler, Extended Event, Database,Tuning advisor, SQLCMD, Upgrade Advisor

MS SQL Server Database Administrator

Confidential, Tampa, Florida

Responsibilities:

• Installed SQL Server 2016 SP2, 64bit enterprise edition instance (Database engine, SQL Server Integration Services (SSIS) on windows server 2012 environment for Development, Testing and Production Environmenton both local and virtual machines
• Created & administered database objects, tables, views, indexes, procedures for implementing some application functionality at the database side for performance improvement.
• Administered the MS SQL Server security by enforcing security policy, creating user logins with appropriate roles, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Install Database Management Software for SQL Server on the server and client machines, provide connections and manage databases.
• Transfer data among SQL boxes using SSIS, and Backup and Restore methods
• Maintenance of existing User Databases and System Databases.
• Performed Backup and recovery and Automation of Backups.
• Responsible for Designing and implementing the backup strategy required as per the requirement.
• Performed Data Transfer/Migration using Export/Import and SSIS.
• Worked on linked servers to run distributed queries in SQL Server Database.
• Implemented a database maintenance plan (DBCC, updating statistics, rebuilding, and reorganizing indexes).

SQL Server Database Administrator

Confidential, Tampa, Florida

Responsibilities:

• Installing and configuring new SQL Server 2012 and 2014 Database Server instances, and upgrading SQL Server 2008,
• SQL Server Integration Services (SSIS), for Development, Testing and Production Environment.
• Preparing Backup strategy and performing Full, Differential and Transaction Log Backups and restoring them whenever necessary.
• Regular Monitoring of SQL server.
• Troubleshooting SQL Server Problems related to SQL Server service, Concurrency (blocks, locks, deadlocks, activity monitor), and SQL Agent job execution.
• Rebuilding clustered and non-clustered Indexes as part of performance tuning.
• Installing SQL Server service packs.
• Resolving various performance issues and running DBCC commands, SQL Tracer, SQL Profiler.
• Administering the MS SQL Server security by Creating User Logins with appropriate roles, dropping and locking the logins,
• Monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Creating users and assigning permissions using Windows and SQL Authentication.
• Maintenance and Correction of Transact SQL (T-SQL) Statements.
• Implemented SQL server high availability tools like Log shipping and used Failover clustering to minimize downtime.