Microsoft SQL Server DBA with 5+ Years Experience, US Citizen, Secret

Microsoft Certified SQL Server Database Administrator having more than 5years of experience on supporting databases and servers in Development, Test/UAT, and Production instances. Database Management and Administration experience entails installation, configuration, backup, restoration, HA/DR solution like Replication, Always-On Availability Group, Clustering, Log shipping, Mirroring, upgrading, migration, apply patches/Patch Management, troubleshooting, supporting clients, Database Monitoring, Performance Tuning, Database Security, Database Development, Data Modeling, SSIS and SSRS. Citizenship: US Citizen

Clearance: secret (DOD)

Education: Bachelor

Professional Certifications: CompTIA Security+

Technical Summary:

• Database Administration in MS SQL Server (2019/2017/2016/2014/2012) in Production, Development, UAT, and Test Environment.

• Database Performance Tuning using SQL Server Profiler, Extended event, Database Tuning Advisor, Execution plan, Performance Monitor and Activity Monitor, DMV, DBCC, Windows Event Viewer, SQL Server Error Log, Agent Error Log.

• Monitoring Server Activity, Error Log, space usage, database health, backup verification, cleaning history and solving problem as needed.

• High Availability and Disaster Recovery solutions (Log shipping, Mirroring, Replication, SQL Server Fail Over-clustering and Always on

• Capacity implementing DR solutions, Backup, Restore, Point-in-Time Recovery, RTO and RPO.

• SQL/T-SQL for creating, altering and maintaining database and database objects.

• Administering SQL Server Reporting Services (SSRS) and various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.

• ETL/SSIS Packages for integrating data from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations.

• Database and Instance Architecture Design.

• Upgrade/ migrate SQL Server, MySQL and Oracle Databases and Instances.

• Documentation, writing SOP (Standard Operating Procedures), decommissioning Servers after Migrati

• Security Management: SQL Servers and Databases, users and Logins, Data Encryption TDE and Column and Row Level Encryption, and Dynamic data masking and Always System Database configuration and Management such as Temp DB. MSDB and Master DB Partitioning, shrinking, Link server Etc.

SANJAY BARUA

Phone: 571-***-****

Email—***************@*****.***

professional Work Experience

Spry Methods LLC 03/22 to 05/25

Vienna, Va.

Database Administrator

• Worked on Database refresh in Dev/Test servers with PROD data and reinstate the server

• Install, maintain, configure, Microsoft Azure, Linux, and VMware server operating systems

• Database Migration, Installation, Upgrades Database and Patching.

• Handling tickets / requests. Using service now.

• Monitor RDS performance and EC2 and look for any potential performance problems Bottleneck.

• Design, implement data storage Back up Recovery server software and firmware upgrades. And standard server maintenance.

• Provide Production Support and Deploy Changes/SPs/Queries in Production Environment

• Provide database technical support preventive maintenance. Data center Administration shall Include data center planning and design.

• Use query store Extend event, Profiler, DMV Monitor server health, diagnose problems and Performance

• Develop server site ASP, Asp.net, structure query language (SQL) server for managing relational database management system.

• Monitored and scheduled automation jobs using SQL Server Agent and Maintenance Plan.

• Create data dictionary and continuity manual to track changes and provide backup justification.

DoD – Defense Info System Agency (DISA

Oklahoma City, OK 07/21 to03/22

SQL Database

• Installed, Configured, and Maintained SQL Server 2019, 2017 and 2016 in Development, Microsoft, Linux and VMware server operating systems,

• Provides database assistance and problem support to application developers, business.

• support for GOTS/COTS hardware/software to include application servers, web servers, print servers, virtual file servers, reporting tools, etc. and all tasks associated with their backup/recovery, performance, and operations.

• Help developers improve the performance by optimize and troubleshoot or modifying SQL Server slow running queries, indexes, Stored Procs and Views

• Setup, Configure, & Manage Azure SQL Database Instances on Azure VM Machine

• Configured and Maintained Always on Availability Group using SQL Server 2016/2014 with Synchronous Asynchronous automatic-failover mode.

• Developed, Implemented & Managed DR (Disaster Recovery) Solutions by Performed regular backups, restores for prod/test/dev environments including mission critical database.

• Designed and Implemented RPO, RTO and SLA, Setup Retention Policy, Backup recovery, server software and firmware upgrades, and standard server maintenance

• Responsible for Monitored Server Activity, Error Log, database health, space usage, cleaning history and solving problem as needed

• Applied SP (Service Pack) on SQL Server on a routine maintenance work

• Managed Security User Privileges Granting/deny/revoke access server and database level

• TDE (Transparent Data Encryption), Row Level Security, Dynamic Data Encryption, Role based Security Policy

• Experienced in using DBCC commands to manage database consistency and repair as needed

• Performed performance tuning for Server, Database, SQL/TSQL queries and stored

• Used different Native and Third-Party tool for Performance Related monitoring and Troubleshooting purposes

• Used Query Store, DMVs and DMFs to monitor the server health, diagnose problems, and performance tune

• Configure and manage SQL Server tables with data partitioning

• Installed and Configured SQL Server Services (SSRS), Developed, Deployed and managed Reports, Upgraded and Migrated Reports and Reporting Server, Managed Security for Reports and Reporting Server

• Installed and Configured SQL Server Integration Services (SSIS), Developed SSIS packages to perform various ETL operations, Deployed and Managed SSIS Packages, Upgraded and Migrated SSIS ETL Packages and SSIS Instance, Managed Security for SSIS Package STILOG Incorporated, Hoboken, NJ July2019-aug2021

Responsibilities and Accomplishments:

• Installed, Configured, and Maintained SQL Server 2017, 2016 and 2014 in Development, UAT, Production Environment, On Premises, Cloud Environment and VM Machine

• Worked as Production Support Engineer overseeing SQL Server 2008R2 to 2017 on a very large scale

• Provides database assistance and problem support to application developers, business analysts and business users

• Provides support in capacity planning, forecasting, and Database Designing

• Provide Production Support and Deploy Changes/SPs/Queries in Production Environment

• Help developers improve the performance by optimize and troubleshoot or modifying SQL Server slow running queries, indexes, Stored Procs and Views

• Performed database/infrastructure physical design, and configured storage for data and log files, Backward and Forward Engineering, Creating E-R Diagram.

• Provide technical leadership to Upgrade SQL Server 2005 and 2008 instances and databases to 2012/2016/2017

• Migrate Database from Oracle 10g/11g, MySQL, MS Access to SQL Server 2008R2/2012/2014

• Setup, Configure, & Manage Azure SQL Database Instances on Azure VM Machine

• Have created Azure SQL Database in Microsoft Azure Cloud (PAAS) and Migrated on Premise SQL Server Database into Azure SQL Database

• Configured and Maintained Always on Availability Group using SQL Server 2014/2012 with Synchronous Asynchronous automatic-failover mode.

• Developed, Implemented & Managed DR (Disaster Recovery) Solutions by Performed regular backups, restores for prod/test/dev environments including mission critical database.

• Designed and Implemented RPO, RTO and SLA, Setup Retention Policy, Backup Verification. Point-in- Time Recovery, jobs, Alerts, Notification with Maintenance plan in SQL Server.

• Responsible for Monitored Server Activity, Error Log, database health, space usage, cleaning history and solving problem as needed

• Applied SP (Service Pack) on SQL Server on a routine maintenance work

• Worked on Database refresh in Dev/Test servers with PROD data and reinstate the server

• Managed Security User Privileges Granting/deny/revoke access server and database level

• Implemented & Managed Database and Data Security Solutions including monitoring and troubleshooting

• TDE (Transparent Data Encryption), Row Level Security, Dynamic Data Encryption, Role based Security Policy

• Proficiently worked on T-SQL scripting, creating and modifying Tables, Index (Cluster/Non-Cluster), Views, Stored Procedures, Triggers, Functions, Constraints and variables, CTEs and PowerShell

• Experienced in using DBCC commands to manage database consistency and repair as needed

• Performed performance tuning for Server, Database, SQL/TSQL queries and stored

• Used different Native and Third-Party tool for Performance Related monitoring and Troubleshooting purposes like Execution Plan, SQL Server Profiler, Database Tuning Advisor, SolarWinds, Activity Monitor

SQL Database Administrator

• Used Query Store, DMVs and DMFs to monitor the server health, diagnose problems, and performance tune

• Configure and manage SQL Server tables with data partitioning

• Installed and Configured SQL Server Services (SSRS), Developed, Deployed and managed Reports, Upgraded and Migrated Reports and Reporting Server, Managed Security for Reports and Reporting Server

• Installed and Configured SQL Server Integration Services (SSIS), Developed SSIS packages to perform various ETL operations, Deployed and Managed SSIS Packages, Upgraded and Migrated SSIS ETL Packages and SSIS Instance, Managed Security for SSIS Package

• Managed Client Requests and Provide on Call Support

Contact this candidate