Professional Summary:

*+ years of IT experience in Database Administration, Design and Development of SQL Server. On-Prem and in Azure.

Strong experience in SQL Server 2019/2017/2016/2014/2012 installing, configuring and managing.

Upgraded SQL Server version from 2012/2019 to higher versions.

Applied Service Packs (SP), Cumulative Updates (CU) and hot fixes.

Managed database backups and disaster recovery, restored databases from backup and performed Point-in-Time recovery.

Scheduled jobs to automate different database relate activities including backup, Index DE-fragmentation, reorganize-indexing, update index statistics, history cleanup and notify operators tasks.

Automated database tasks (created jobs, alerts, and schedules for database maintenance tasks)

Implemented High Availability technologies of Database using Database Mirroring, Log shipping and Replication.

Configured, Managed and Monitored High Availability and Disaster recovery Solutions using AlwasysOn Availability Groups.

Installed, configured, and maintained Window Server Fail-Over Cluster (WSFC).

Managed and maintained user’s security and permissions, creating logins with appropriate roles, creating users and groups account, and granting, denying and revoking permission.

Scripting the Database Consistency Checks (DBCC), Scheduling the scripts to run daily and weekly basis.

Skilled in Database Auditing, Security Configuration such as TDE (Transparent Data Encryption), SSL (Secure Sockets Layer) etc.

Expertise in SQL Server Native tools Query Optimization, Performance Tuning, Activity Monitor, Profiler and Extended Events, Database Tuning Advisor and Windows Performance Monitor.

Proficient in both DDL and DML query languages-T-SQL quires using Sub-queries, and merge joins.

I involve in setting up and implementing on migrating Oracle Databases to SQL Server

Expertise in creating and managing database objects, stored procedures, user defined functions, indexes (clustered and non-clustered), views and triggers using T-SQL

Experienced in Conceptual, Logical and Physical Database design.

Managed large and very large databases (VLDB) in 24/7 environment.

Creating and Deploying SSIS Package to automate table migration.

Designed, developed, and implemented robust and extensible Extraction, Transformation and Loading (ETL) solutions to support key business data flows using SSIS.

Establish backup and recovery strategies based on recovery point objectives (RPO) and recovery time objectives (RTO).

Perform regular backups and test the restoration process to ensure data integrity.

Define and implement data retention policies for backups.

Experience in data migration from other platform to SQL and from On-Prem to Azure using DMA (Data Migration assistant).

Experience on producing report and managing and deploying using SQL Server Reporting services (SSRS).

Experience in Software Development Life Cycle (SDLC) especially in Agile and SCRUM methodology.

Experience with IT Service Management-incident, change, configuration, and release management processes

Strong analytical and communication skills, team player and able to quickly grasp new technologies and products.

Extensive exposure to Azure PaaS services, including Azure App Service, Azure SQL Database, Azure Functions, and Azure Logic Apps.

Proficient in deploying and managing PaaS resources using Azure Resource Manager templates or Azure CLI.

Experienced in monitoring and optimizing Azure PaaS solutions for performance, scalability, and cost-efficiency.

Skilled in identifying and resolving issues related to Azure PaaS services, collaborating with teams for troubleshooting, and providing technical support.

Extensive exposure in scripting and automation using PowerShell, Azure CLI, or other relevant tools to streamline deployment and management tasks.

Scaling and Capacity Planning:

Monitor database resource usage and plan for scalability.

Scale up or down database resources based on workload demands.

Plan for data growth and storage requirements.

Technical Skills:

RDBMS/DBMS

SQL Server 2017/2016/2014/2012/2008R2/2008/2005

Database Tools

MS Enterprise Manager, SQL Profiler, Extended Events, SQL Query Analyzer, Index Analyzer, Backup Server, SQL Agents, SQL Alerts, SQL Jobs, SSRS

ETL Tools

DTS, Integration Services (SSIS)

Design Methodology

UML, Microsoft Visio, Agile/SCRUM

Data Modeling

Erwin, MS Visio

Tools Used:

SQL Server Management Studio, T-SQL, Query Analyzer, SQL Profiler, Replication, Clustering, Database Tuning Advisor, Upgrade Advisor, SQL Configuration Manager and Service Manager, Active Monitor, Performance Monitor, Resource monitor, SSIS, SSAS, SSRS, Red Gate SQL Compare, IDERA, Ola Hallengren’s Maintenance Solution and Dba Tools.

Programming Languages

Transact -SQL, HTML, XML, VBScript, Java

Operating Systems

Windows 2008, Vista, windows server 2012/2016/2019

Education & Certifications:

Bachelor’s Degree in Computer Science

Work History

Freddie Mac, Sr. SQL Server Database Administrator

January 2022 – Present

McClean, VA

Responsibilities:

Installing, configuring, and managing various databases on Production and development environments using SQL Server 2012/2014/2016/2017.

Installed necessary Service Packs and cumulative updates for various SQL Servers.

Upgraded SQL Servers from 2012 and 2014 to higher version.

Experience in data migration from other platform to SQL and from On-Prem to Azure using DMA (Data Migration assistant)

Managed security on Production, Test and Development environments.

Monitored all Backup operations.

Created Indexes Maintenance Jobs for optimum server performance.

Installing, Configuring, Managing and Monitoring High availability and Disaster recovery using AlwaysOn Availability Group.

Tuned databases for better performance.

Created and maintained various logins and managed security based on the required access.

Created various jobs to monitor resources on various servers and to mail the necessary information when threshold was reached.

Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes.

Responsible for fine tuning of the database, troubleshooting, user administration, memory management, and running DBCC (Reorganize/Rebuilding Indexes and fine-tuning Stored Procedures).

State Farm Insurance, SQL Server Database Administrator

May 2020 – December 2021

Newport News, VA

Responsibilities:

Installed, configured, and managed SQL Server /2019/2016/2014/2012 in development, test, and production environment.

Upgraded databases from SQL Server 2012 to SQL Server 2019 and 2014 using side by side and In-Place method

Performed patching - applied SPs and Hot Fixes.

Managed security on Production, Test and Development environments.

Responsible for providing 24 X 7 critical production environment support.

Exposure in Configuring and managing AlwaysOn Availability Groups feature of SQL Server 2012/2014

Configured Log Shipping as standby database from production database for reporting purposes.

Configured and maintained different types of Replications.

Create and manage database maintenance plans.

Design and implement backup and disaster recovery plans.

Created and modified tables, indexes (cluster/non-cluster), constraints (unique/check) and views to developed different maintenance plans for database monitoring,

Automated database tasks (created jobs, alerts, and schedules for database maintenance tasks)

Performed database monitoring and performance tuning using SQL server native tools.

Monitored server activity and solved problem as needed

Applied DMV and DMF for finding out long running queries and other related activities

Aberdeen Asset Management Inc., Jr. SQL Server Database Administrator

April 2019 – March 2020

Philadelphia, PA

Responsibilities:

Installed and administered four-Node cluster Active/Active on Microsoft Windows Server 2012 Enterprise Edition.

Installed, Configured and Monitored AlwaysOn Availability Groups on SQL Server 2012 SP2

Perform SQL Server service pack and Windows Service pack upgrades.

Reorganize/Rebuilding and Monitoring the indexes at regular intervals for better performance.

Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

Monitored and modified Performance using execution plans and Index tuning.

Troubleshoot performance problems and fine-tuning of databases.

Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.

24 X 7 Production Database on Call Support

THE HALFAKER, QA tester/Software Tester February 2017 – February 2018

Arlington, VA

Responsibilities:

Agile Methodology driven projects based on Off-Cycle and Enterprise releases.

Created Test Strategy, Test Cases and Test scripts from initial story kickoff design discussions.

Participated in daily stand up and SCRUM meetings discussing the progress and goals.

Working with Business Analyst and Developers to clearly define iteration stories.

Translated the functionality of the applications & testing methods in different platforms.

Report, track, and monitor defects in the defect tracking system.

Tested all workflow tasks with appropriate data and permissions.

Understood the business flow for configuring, creating and updating/access Ticket systems.

Set up the required test beds and create test data required for testing.

Wrote test cases based on the requirements, stories or UI Snapshots.

Performed System testing and integration testing of products.

Performed Security Testing by writing using Positive and Negative Testing approach to ensure appropriate user authentication.

Checked the schema of Oracle database manually or using Toad after every upgrade, while validating stored procedures.

Used Quality Center/ALM and JIRA for tracking, analyzing and documenting defects.

Retrieved records from multiple tables from Oracle Database through SQL by using joins such as Inner Joins, Outer Joins using Oracle.

Used SQL Queries to pull data through SQL Server 2012 from the Database to write and execute test cases.

Wrote simple to complex SQL queries to verify the database tables for the data inserted from the GUI.

Performed Database Integrity Testing by executing SQL statements.

Contact this candidate