Database Administrator Sql Server

Anwar Hossain, Annandale, VA *****

***–***–****, ********@*****.***

Objective:

Looking for a challenging position as Database Administrator in a stable fast-paced environment. Seeking challenges, new ideas, and opportunities to leverage professional expertise to advance career.

Professional Experiences:

Department of Defense (OCIO/OIG) Feb 2023 to Present

Mark Center (Pentagon-Extn)

Alexandria, VA 22350

SQL Server Database Administrator

I have been part of the DBA Team close to three years. It is a complex environment of SQL Instances, Single Physical Server hosting 14 SQL Instances of different versions and all listening on 1433 Port. The fourteen instances are evenly distributed between two Physical nodes (HA between the two nodes) and DR with an Offsite. I work on several tasks like SQL Health check, Backup / Restore, Vulnerability Scans and Remediation. I have been a Team Player and support on any application tasks like implementation, Migration and Upgrade for applications like SharePoint, MS CRM, ZL, Team Mate.

Environment: Complex SQL Cluster environment with four Physical Nodes, with 14 SQL Instances (NIPR), Two Node Four Instances (SIPR), Both with AlwaysON HA

Key Activities: Operational Activities (Backup Reporting, Space Management, Monthly PM Patching), SQL Health Check (for Alwayson, Disk Usage, Encryption), Vulnerability Assessment and findings fix. Backup/Restore from On-Prem to SQL MI, URL Backup to Azure SQL MI, Troubleshoot AGs and Cluster issues, Compliance Check (Backup Verification, Fix Vulnerability for SSRS, SQL Server and PowerBI Report Server)

SQL Versions: SQL 2016, SQL 2019 and SQL 2022 (On-Prem).

Azure: SQL MI (4 on Production Subscription) – 3 GP (General Purpose) and 1 BC (Business Critical)

Summary Azure Expertise: Cloud deployment automation (ARM Template, Azure DevOps), Cloud security and compliance (Networking, VPNs Azure Active Directory, Microsoft Entra ID, Vulnerabilities remediation using Microsoft Defender for cloud), Database management and optimization (Azure Compute, Azure Storage), Cost management, Technical support and guidance (Alert, Log activity analysis), Serverless computing (Azure Functions), Database migration from On-prem to Azure cloud (SQL MI).

Responsibilities:

Managed systems in SIPRNet and NIPRNet environments

Performance maintenance by resource check - Network, CPU, Memory etc.

Participating in weekly meeting with update and possible future plan

Monitored Environment checking PRTG alerts and solving the issues

Customer request response using ticketing process

Backup/Restore-using NetBackup tool

Upgrading 2016 servers to 2019 servers

Database encryption in TDE method

Moved databases from on premise to Azure Manage Instances using DMA

Prepared Manage Instances with all features- Created VMs, V-net, firewall, NSG, alerts, audits and Log Activities monitoring

Monitoring Azure Manage Instance features, Storage uses, Log review, CPU and memory uses.

Monitoring security vulnerabilities using Microsoft Defender for cloud and perform remediation of issue find.

Perform Daily health check for Azure SQL Manage Instances

US ARMY Feb 2021 to Feb 2023

Fairfax, VA 22033

Lead Database Administrator

I was part of the DBA Team exactly for two years. It was a simple environment of SQL Instances, there were Two Physical servers, one production and other was COOP server. Also the environment had three training servers which had access to developers also. The environment maintained a large database of about five TB. The production and COOP servers were configured with Transactional replication. I work on several tasks like Daily SQL Health check, Backup / Restore and upgrade.

Environment: An environment of Transactional replication between Production and COOP Servers.

Key Activities: Operational Activities (Backup Reporting, Space Management, Monthly PM Patching), SQL Health Check (for Replication, Disk Usage, Encryption), User support with ad-hock reports, permissions, new user creation etc.

SQL Versions: SQL 2012, SQL 2014 and SQL 2016

Responsibilities:

Coordinate with management team solving database issues

Lead database team members delegating appropriate tasks

Conduct team meeting for discussing with current issues

Coordinate with different teams for timely completion of projects

Polished leadership skills in database monitoring for consistency with ability to motivate teams to increase database performance productivity.

Created Users, Groups, Roles, Profiles and assigned users to groups

Granted privileges and permissions to appropriate users and groups.

Applied STIGs on SQL server Databases and Instances.

Applied SP2 (Service Pack) and HOT Fixes on SQL Server database instances.

Experienced with TDE Encryption method.

Configured and Managed Database Transactional replication.

US ARMY Dec 2019 to Dec2020

Crystal City, VA 22202

Database Administrator

I had opportunity to work with a co-operative DBA Team exactly for one year. It was SIPRNet and NIPRNet environments, comprising several SQL Servers including COOP and training servers. The environment was set up with HA, Transactional and Merge replication. The environment maintained about 100 large complex databases.

Environment: It was SIPRNet and NIPRNet environments with Transactional replication, HA.

Key Activities: Operational Activities (Backup Reporting, Space Management, Monthly PM Patching), SQL Health Check (for Replication, Disk Usage, Encryption), User support with ad-hock reports, permissions, new user’s creation and upgrade etc.

SQL Versions: SQL 2012, SQL 2014 and SQL 2016

Responsibilities:

Manage systems in SIPRNet and NIPRNet environments.

Performed system health check including index management, log review and disc space maintenance.

Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.

Upgraded SQL Server 2012R2 to SQL Server 2016.

Applied Service Pack and HOT Fixes on SQL Server database instances.

Created backup strategy for Production databases based on business requirements.

All systems were updated for proper audit event implementation as per DISA STIGs rules.

Configured and Managed Database Transactional and Merge replication.

US COAST GUARD /(DMI) August 2016 to December 2019

Kearneysvillie, WA 25430

Database Management Specialist

US COAST GUARD is a large working scope environment. There it had 121 Instances, multiple applications and several hundreds of databases of different sizes. A co-operative team of 8 DBAs worked together. Although Each DBA was responsible for particular applications, Once, a week, each DBA had to support all instances for afterhours operation. The environment had Log shipping, Mirroring, Replication and Clustering (HA).

Environment: It was only NIPRNet environment with multi-level HA.

Key Activities: Operational Activities (Backup Reporting, performance monitoring, Space Management, Monthly PM Patching), SQL Health Check (for Replication, clustering, mirroring, Disk Usage, Encryption), User support with account permissions, new user creation and upgrade.

SQL Versions: SQL 2012 and SQL 2014

Responsibilities:

Installed, Configured, and Managed SQL Server 2012 and 2014 database instances.

Database Monitoring: Proactively monitored Database Servers, data files, log files, disk space, Agent jobs, error logs, sessions and connections and performed troubleshooting as needed.

Backup/Recovery: Created backup strategy for Dev, Stage, and Production databases based on business requirements, SLA, setup jobs and alerts.

Created, Modified, and Managed Indexes - Reorganize and Rebuild indexes.

Experienced within SDLC Methodologies such as Agile.

Resolved customer’s problems following business procedure using ticketing system.

Deployed DACPAC and TSQL code in Stage and Production Servers.

Certifications:

MCSA: (Microsoft Certified IT Professional-Microsoft SQL Query)

CompTIA Security +

AZ-900: Azure Fundamentals

AZ-104: Azure Administrator

DP-300: Azure Database Administrator Associate

Citizenship: U.S Citizen.

Clearances: Active Secrete Clearance.

Education: M.S., Cranfield Engineering University, U.K.

References: Strong references available upon request.

Contact this candidate