Sql Server Database Administrator

MICROSOFT SQL SERVER DATABASE ADMINISTRATOR

Professional Summary

More than 8 years of IT experience in Database Administration, Designing Development and Supporting MS SQL Server, and Azure Databases,

Experience in RDBMS database design, database files management in MS SQL Server,

Setup and maintain test and production databases,

Solid experience and knowledge in database backup, restore and copy across servers,

Extensive experience in capacity planning and monitoring, Performance tuning,

Experience in Disaster Recovery Planning, Execution, Testing and Troubleshooting,

Experience in using SQL Server Tools like DTS, SQL Server Enterprise Manager, SQL Profiler, SQL Query Analyzer, Extended Event, PERFMON, ETL and Query Store,

Experience in database Security (creating logins, users, roles, and assigning permission),

Experience in implementing high availability solutions using Log shipping, AlwaysOn and Replication

Azure SQL database Administration, Azure Data Factory Setup,

SSRS, SSAS and SSIS installation and configuration,

Very good written and verbal communications

Provides leadership and work guidance to less experienced personnel.

Professional customer support on SQL Server

Cognizant October 2018-Present

Raleigh, North Carolina

SQL Server Database Administrator

Installing and configuring SQL Server database instances and setting up jobs,

Provisioning Azure databases, and SQL on Azure VMs,

Deploying changes to production servers after CAB approval,

Migrating and upgrading databases to newer versions, & and to Azure VMs, Azure Databases and Managed Instances,

Installing SQL Server/SSIS/ SSRS services on SQL 2019/2017/2016/2014 /2012/2008R2 \2005\2000 versions,

Monitoring database servers proactively for performance related and resource contention issues,

Creating, optimizing, and debugging queries and stored procedures,

Creating triggers and functions,

Configuring and monitoring High Availability and Disaster Recovery solutions like AlwaysON/Clustering Distributed Availability Groups, Log Shipping, Replication,

Performing and maintaining database backups, recovery, security and ensuring the integrity of all database components through daily system checks,

Designing and developing highly complex database systems for internal and external users/clients,

Performing complex analyses and reviews of applications being released into production databases,

Developing and overseeing the implementation of test application code in client server environments to ensure that software conforms to standard management practices,

Analyzing new and emerging technologies and tools for applicability to the field,

Responsible for SQL server logical and physical database design, implementation, and maintenance,

Creating databases, tables, indexes, stored procedures, views, database management policies and constraints, defaults, rules, functions, triggers, and dynamic SQL queries.

Investigating and analyzing the root causes of problems to provide long lasting solutions using tools like SQL Profiler, Query Store, Extended Events, Database Tunning Advisor and Query Performance Insight,

Working knowledge of reporting tools like SQL Server native like SSRS, SSIS, SSAS, and others

Conducting code reviews for standardization of codes and performance.

Datagroup, Alexandria, VA August 2016-August 2018

SQL Database Administrator

Responsibilities:

●Installed, configured, and administered SQL Server versions of 2016, 2014 and 2012 in Production, Development and Staging,

●Managed Microsoft Active-Active and Active-Passive Clustered SQL Server 2005, 2008/R2 and 2012 environments,

●Made sure the availability of databases by configuring, implementing, and maintaining solutions like Log Shipping, Mirroring and Replication, AlwaysOn AG and FCI,

●Ensured that the new database code meets company standards for readability, reliability, and performance,

●Monitored the regular backup of the production databases and resolved the backup failures ensuring a perfect database backup strategy for the organization,

●Monitored data activities like database status, logs, space utilization, locks, and long transactions,

●Ensured database security by controlling user privileges, diagnosing connection attempts, monitoring the security and audit issues as per Enterprise Standards,

●Worked on root-cause analysis of and troubleshoot SQL Server problems related CPU, Memory, Disk I/O, and network contentions,

●Resolved database performance bottlenecks using SQL Profiler, PerfMon, DB Engine Tuning Advisor, DMVs, SolarWinds and SpotLight,

●Developed efficient stored procedures, indexed views, User Defined Functions (UDF), Triggers, and Distributed Queries that alleviated some performance bottlenecks,

●Involved in resolving deadlock and blocking issues for concurrent users,

●Properly documented all the changes made in the database environment using SharePoint,

Environment

SQL Server 2019, 2017, 2016, 2014, 2012, 2005,2000, VMWare, SAN, LiteSpeed, SpotLight, Windows 2016, 2012, 2003 Server, Enterprise Manager, SSRS, SSIS, SolarWinds, Business Intelligence Development, Teams, Service Now, SharePoint, AppDynamics,

TECHNICAL PROFICIENCY

Administration of MS SQL Server 2019/2016/2014/2012/ 2008/2005/2000. ETL Tools MS SSIS, TSQL, Database Engine Tuning Advisor, Business Intelligence Development Studio, SQL Server Configuration Manager, SQL Client Connectivity SDK Visual Studio, Team Foundation Server, Enterprise Manager, Query Analyzer, Performance Monitor, SQL Profiler/Trace, Extended Event, Redgate, Solar winds, AppDynamics

Databases SQL Server 2019/2016/2014/2012/2008R2/2008/2005/2000, MSSQL, MS Access.

Languages: SQL, TSQL, PowerShell, Java

Operating Systems: Windows NT/2000/XP/2003, 2008/2008R2/windows2012/Windows 2012R2 and window 2016, Azure VMs,

CERTIFICATION

Microsoft Certified Professional (MCP)

Azure Database Administrator Certified Professional

EDUCATION

Bachelor of Science in Computer Science.

Contact this candidate