USA Citizenship, Azure Data Solution Architect/ Azure SQL DBA & MCSE Certified Microsoft SQL Server Database Administrator and Developer 9 + years of experience. hands on experience supporting databases and servers in Development Test/UAT/DR & Production instances on On-Premises and migrating On-premises database to Azure SQL Database, SQL Managed instance, SQL Elastic pool on Azure & SQL server in Azure VM. managing Azure resource groups, subscriptions, Azure blob, File Storage, Vnet, subnet, load balancing & azure active directory users & groups.

Subject Matter Expert(SME) in Production Azure Database Management and Administration, including azure SQL, VM, automation, installation, configuration, backup, restoration, HA/DR solution like Always-On Availability Group, Clustering, Replication, Database Mirroring, Log shipping, upgrading, migration, apply patches/Patch Management, managing ON-Call and supporting clients, troubleshooting and managing Locks, Blocks, and Deadlocks, CPU usage, Memory utilization, Disk space analysis and utilization, managing Log file growth, Job fail, backup fail, troubleshooting different Linked server like Oracle SQL, MS SQL, IBMDB2, Teradata, ensure server & database Security. Proficient with SQL Server 2008R2/2012/2014/2016/2017.

Excellent Knowledge and solid experience in Database Development and BI Tools, which includes Data Modeling, SSIS, SSRS, SSAS, SQL, PowerShell Scripting, TSQL, Writing Stored Procedures, Functions, Joins, Cursors, triggers, views, Constraints, and Create, Deploying and Managing SSIS Packages using ETL Process.

Certifications:

Microsoft Certified: Azure Data Engineer Associate

DP-200_Implementing an Azure Data Solution

DP-201_Designing an Azure Data Solution

Microsoft Certified: Azure Security Engineer Associate

AZ-500_Microsoft Azure Security Technologies

Microsoft Certified: Azure Administrator Associate

AZ-103_Microsoft Azure Administrator

Microsoft Certified: Azure Solutions Architect Expert

AZ-300_ Microsoft Azure Architect Technologies

AZ-301_ Microsoft Azure Architect Design

SQL Server 2016/2017/2019_MCSE: Data Management and Analytics — Certified 2019 (Exam-70-762)

SQL Server 2016_ Administering a SQL Database Infrastructure (Exam 70-764)

SQL Server 2016_ Provisioning SQL Databases (Exam 70-765)

Certified MCSE (Microsoft Certified Solution Associate) – SQL Server 2012/2014.

Certified MCSE (Microsoft Certified Solution Expert) – SQL Server 2012/2014.

CompTIA Security + (Exam SYO-501)

Education: BS in Computer Science and Engineering

Clearance status: Public Trust Clearance

Other Certifications:

Azure Cloud SQL Server Professional Database Training from Sufia Institute of Science & Technology. (General Washington Dr. Alexandria, Virginia, USA-22312).

Security Clearance: Clearable (all over side)

LinkedIn profile: linkedin.com/in/md-manir-hossen-162b2018a

Technical Summary:

Azure architect design/Consultant/database admin/developer with 9 + years of experience which including system design, development, analysis, HA & DR solution, Data Archive, SSRS, SSIS and supporting project managers to build work breakdown structure (WBS) agile project task development and implementation.

3- 4 years azure hands-on experience & managing technical teams/projects, Azure cloud IaaS, PaaS Architect, Design, engineering & Solid understanding of native Cloud architecture/On-Prem networking, deploying VM automation, manage disk, managed instance using ARM Templates and Azure DevOps.

Strong Leadership experience at Data Center Migration Project & On-Prem to azure cloud Migrations with understanding of common technical pitfalls.

Manage the Cloud team in a fast-paced environment and effectively manage multiple tasks simultaneously as a technical expert in Cloud. Coordinates resources against multiple projects and ensuring the team is meeting scheduled objectives.

Modernize the current on-prem systems, architectures, resources & Migrate critical business databases and application to azure Cloud technologies, recommendation best practices, cloud native tools.

Make decisions and resolve project issues efficiently and effectively with discuss with higher management and team members.

Self-driven, identify risk/challenges and based on situation engage & escalate bridge call with the right teams/other stockholders to finding the root cause issues & resolve the risks.

Deep understanding and working experience of SQL Server (SQL 2005, 2008/2008 R2/2012/2014/ 2016/2017) includes installation, configuration, and maintenance of standalone and Clustered Servers [Active/Active and Active/Passive Cluster Design

Optimizing and Performance Tuning such as Query Optimization, Performance Tuning using execution plan, Profiler, Database Tuning adviser and Windows Performance Monitor tools to resolve Dead Locks or long running queries and slow running server.

Hands-on experience on Always on High availability groups, Distributed Always-on Availability Group, database mirroring, Clustering, Replication, Database Migration, server & Database credential, Backup and recovery, Managing Storage and Assigning Tickets, weekly team meeting and deal with clients.

Applying Service Pack (SP) for Databases instances, and patching SQL servers with hotfixes.

Installed and maintained SQL Server Reporting Services [SSRS] 2008 R2/2012, 2014, 2016,2017.

Good experience in writing and debugging SQL Server stored procedures/triggers, Function, Join, sub query, TDE, Column and Row Level Security, Data Masking and documenting issues/resolutions of SQL Server Applications.

I am able to do multi-task, work independently and as part of a team, share workloads, and deal with sudden shifts in project priorities.

Technical skills:

Expertise & Skills

Experience(Yrs.)

Databases Experience

SQL Server 2017/2016/2014/2012/2008/2005/MS Access and MySQL, Azure SQL Database, Azure managed Instance, Azure VM SQL. Azure Hyperscale SQL Database.

9 +

Upgrade/Migration

MS SQL Server to SQL Server, Oracle to SQL, MySQL to SQL, On-premises SQL Server to Azure sql Database and Azure VM.

9 +

Operating System

Windows Server2016/ 2012/R2, 2008/2003 including UNIX/Linux.

9 +

Ticketing Tools

ServiceNow, JIRA, Remedy, Service Desk.https://nau.service-now.com/

9

Third party tools

NetBackup,RedGate,SolarWinds,idera diagnostic manager, SentryOne.

8

Virtualization Technology

VMWare (ESXi 5.5), Virtual Box, Hyper-V, V-Spare, vCenter server

6

Azure SQL Database/managed instance

Configuration, Migration from On-premises Server to Azure database & Managed Instance, Azure SQL database Instance, Azure SQL instance on Virtual machine.

3-4

Languages

SQL, T-SQL – DDL, DML, DCL, TCL, PowerShell, C#, C/C++, Java Script, Visual Basic, HTML, XML, ASP.Net, PHP

6

ETL/Data Warehouse Tools

SSIS/DTS, BCP, Informatica, Pentaho

8+

Reporting

SSRS, Enterprise Reporting, Tableau, Report Builder 3.0/2.0, Power BI

8+

Data Modeling Tools

Erwin, Toad Data Modeler, MS VISIO

8

Networking & Security

Active Directory, Setup TCP/IP, Setup DNS Server, Create User & Groups, IPsec, SSL. ADO.NET, OLEDB, ODBC

9

Hardware/Storage

SAN, NAS, RAID, ISCSI

6

Graphics Design Skill

Adobe Photoshop, Adobe illustrator, MS VISIO

12

Web Server

IIS: Installation, Configuration, And Deployment of Applications & Administration. SSL Certificate installation.

6

Professional Experience:

CO-OP Financial Services. Des Moines, IOWA January, 2020 – March 2020

Azure Solution Architect/ Azure SQL DBA

Responsibilities and Accomplishment:

Worked with CO-OP/Capgemini team for 10 weeks consultant Project. Architect, Designing & implementing High availability (HA) & Disaster Recovery (DR) for 48 critical production databases.

3 weeks Workshop with CO-OP team to modernization their current old system to azure cloud infrastructures.

Designing & implementing Lift and shifting Data migration process with Azure Migrate tools, DMS (Database Migration Services) to migrate data from On-premises to PaaS and IaaS Cloud.

deploying Azure Data Pipelines, SQL Databases, Virtual Machine, disk, resize, automation, NSG, subnet using ARM Templates (json & PowerShell script) and Azure DevOps tools (Git).

Identifying database dependency with application, cross database query, Linked server, DDL, DML stored procedure dependency, Linked Queries of Databases and supporting Applications team.

Supporting project managers in building, performing, updating, systems engineering and managing technical projects including resource loading and Work breakdown structure (WBS) agile task planning, development & implementation.

Identifying SSIS job dependency with databases & Applications, SSIS job connection strings & Migrating SSIS Packages to Azure Data Factory, Data Lake storage gen1 & gen2, Azure Blob Storage.

Architect and design Report server in Azure cloud in PaaS and IaaS & Identifying On-premises SSRS report dependency and connection string, data source, data set.

Advising cost effective solution in azure cloud right platform IaaS and PaaS, Azure SQL database with elastic pool, Azure managed Instance with instance pool & Azure SQL on VM, SQL & VM Licensing.

Architect & designing SQL Always on technology high availability (HA) and disaster recovery (DR), Azure site recovery (ASR) solution in IaaS.

Worked on azure blob storage, Azure data Lake, data factory, data warehouse, azure active directory.

Architect and design Data Archive policy for historical data in Data Warehouse (OLAP).

Integrating Azure Data Factory Pipelines with Source Control Using Azure DevOps

Ingesting, Transforming and Transferring data into Azure Data Lake, Azure Synapse

Provisioning Azure Synapse in Large scale Data Analytics Environment

Grouping aggregating and Performing Transactions in Azure Synapse

Expert level Knowledge of different types of distribution, Indexes and Partition.

Export & Importing Data into azure SQL Data Warehouse.

Rebuilding and optimizing Performance with Various Indexing mechanism

Knowledge of Various Azure Monitoring tools and Best practices for maintaining performance

Worked with PCI Compliance team to fulfill the requirements of azure compliance.

Work Environment: Windows Server 2012 R2, 2008, IIS 7.5, SQL Server 2016/ 2017, 2014, 2008r2, 2008, Azure cloud, Azure VM, Azure Devops, Agile methodology, Azure Migrate, Movere, Hybrid Infrastructure, Azure monitor, App Dynamic, ERWind, ASP.net. Service-Now, SolarWinds, Redgate, DB2, SharePoint 2010.

Inova Health System, Nokes Blvd. Sterling VA August, 2019 – Dec 2019

Senior SQL Database Admin/Azure SQL DBA

Responsibilities and Accomplishment:

worked with Inova Server Engineering team. Architect, Designing & implementing High availability solution (HA) for most critical production database & working with Networking & OS team.

Hands on experience in azure development, worked on azure storage, azure sql database, Virtual machine, azure Monitoring, key vault, SQL Azure firewall, Migration, managing sql database, security management, web application and notification hub, load balancing, Vnets.

Supporting Azure SQL databases cloud dba infrastructure and Azure cloud SQL migration from on premises to Azure sql database, azure managed instance and Azure virtual machine. Currently managing 10-12 data migration project & dynamically work on project & supporting application team

Support day-to-day operations and management of an enterprise level production database in the Azure, installing, configuring, upgrading and maintaining Azure SQL Database, SQL Managed instance, SQL Elastic pool on Azure & SQL server in Azure Vm, Always On clustering, distributed AlwaysOn availability group configuration and developing SQL Scripts, AZ CLI, PowerShell Script, queries, and reports.

Supporting Microsoft azure sql database, azure automation, manage resource group, azure active directory, storage services, networking, firewall, NSG and apply role & group-based access control policy to users.

Perform applications database administration functions including SQL code review, performance analysis, query tuning, database application design, physical data modeling, and developer support.

Migration of SQL server databases from on-premise to Azure IAAS/PAAS

Implement database technology policies, and procedures for maximum systems uptime.

Deployed Azure IaaS virtual machine (VMs) and Cloud services (PaaS role instance) into secure Vnets and subnets, gateway, load balancing.

Implemented always-On high availability in Azure IaaS & Azure Resource Manager deployment models

Working on AGILE methodology in our environment, setup everyday morning standup meeting with team and agile scrum master.

hands On experience Azure data factory, azure SQL Database, Data Lake storage gen1 & gen2, Azure Blob Storage and worked with BI team in MS Azure SQL Datawarehouse.

Experience Azure SQL Database Import and Export Service and deploying SQL Databases in AZURE.

On time Support for production database, managing server and database level permission, troubleshooting critical issues, finding root cause and managing ServiceNow Tickets.

Planning Capacity management, Disk space, I/O, CPU, Memory, license usage, server and Database post configuration setting and HA Solution

Hands-on experience large database migration from on premises to Azure sql database and Azure Managed instance & Azure VM SQL instance.

Knowledge experience azure data factory and azure Data lack to build enterprise level dataware house.

Hand on experience PowerShell scripting and sql automation for system and user database separately.

Estimate Database and server workload DTU/eDTU of servers and vCore purchasing model.

Managing azure sql database performance tuning, azure Runbook, Full/Differential/Transaction Log Backups into Disk, automation of index fragmentation, rebuilds and re-organize.

Designed and developed SSIS packages using different Control flow tasks, Transformations and Dataflow tasks.

Participate in 24X7 on call rotation schedule for various production support, database maintenance, handle technical and non-technical people.

Work Environment: Windows Server 2016, 2012,2008, IIS 7.5, SQL Server, 2017/2016, 2014, 2012, 2008r2, 2008, 2005, Azure cloud, Azure VM, JavaScript, ASP.net. Service-Now, Science Logic, Azure Migrate, Movere, Hybrid Infrastructure, SolarWinds, Oracle, SharePoint.

Pentagon Federal Credit Union Bank, Chantilly, VA Feb, 2019 – August 2019 Sr. SQL Database Administrator/ Azure SQL DBA

Responsibilities and Accomplishment:

Working experience IT Infrastructure Architecture Solution team with Pentagon Federal Credit Union Bank. architect design, Capacity Planning, Build new server for Dev, Test/UAT and Production.

Leadership experience of Data-center migration project & successfully accomplished 4 to 6 migration project, sql server 2005, 2008, 2008 R2, 2012 to sql 2016 & sql 2017.

Azure SQL migration consultant from on premises to Azure sql database and Azure virtual machine.

Hands-on strong working experience and managing Always-On, clustering configuration & manages databases, troubleshooting, hands-On critical Databases Migration more than 3 TB+ database to higher version.

Microsoft Azure SQL Database, azure manage Instance & Azure VM SQL Instance, Resource Groups, subscription, Azure blob Storage, Azure Data lake Gen1 & gen2, Databricks, Data Factory and Azure group role-based access control policy to users.

Server Post configuration and setup automation job for each server with stored procedure, maintenance Jobs, full back up, differential backup, transaction log backup, DB indexes maintenance, index rebuild and reorganize job, maintains schedule based on RPO & RTO and SLA, database mail setup, server & database level auditing, trigger, login trigger, operator, alert for each database size.

Working with Server team/Network/ firewall team to open port to communicate new build SQL server & Application server, working also with compliance team.

Planning Capacity management, Disk space, I/O, CPU, Memory, license usage, server and Database post configuration setting and HA Solution.

Hands-on experience SSRS to generate report and migrate and deploy .rdl file in report Manager, Dev, UAT, Prod Environment & managing users and groups Policy login.

In SSIS to archive historical data, using Partitioning and slowly changing Dimension in data warehouse, project deploy in SSISDB Catalog, job create and schedule bases on SLA.

Managing database and server level security, Encrypted PII information in critical databases, apply TDE, Dynamic Data Masking, Always Encrypted in SQL 2016/2017.

Managed Security and User Privileges granting/deny/revoke access Server and Database level.

Escalated bridge call with other team regarding any complex issue in production.

Joining CAB Meeting and also 24x7 “on-call" Production support, handle technical and non-technical people.

Environment: SQL server 2005, 2008/R2, 2012, 2014, 20016, 2017, Postgree SQL, IBMDB2, Sybase, Windows server 2008/R2, 2012, 2016, Suse linux, IIS, Tableau, Service Desk, Jira, VDI, KeePass, Logic Monitor, XO-Soft, DynaTrace, EverBridge, File server, Asset Portfolio Management, Inventory management.

Charter Communication, St. Louis, MO August 2018 – Dec 31, 2018

Sr. SQL Database Administrator

Responsibilities and Accomplishment:

Database operational supports in production environment like Locks, Blocks, and Dead locks, CPU, Memory, Disk space analysis and utilization, managing Log file growth, Tempdb, Job fail, backup fail, deploy SSIS package, migrate and deploy .RDL file in Report server, troubleshooting different Linked server like Oracle, Oracle client, MS SQL, IBMDB2, Teradata, ensure Server & Database Security.

Planning Capacity management, DB indexes maintenance, DB security, license usage, DB consistency, DB integrity checks and DB Backup and Recovery.

All day-to- day activities to keep the service up and running to agreed SLAs ad to be compliance with JPMC IT control policy such as health checks, monitoring ticket queues, Change Ticket, C-Task, Incident ticket, Technical Request Ticket, End user requests and automation of processes.

Leadership working experience Data Migration projects from lower version to higher version of different SQL Products, 2008, 2012, 2014, 2016, 2017, change SQL version enterprise to standard and vice versa to minimize company cost, Always on High availability groups, database mirroring, Clustering, Replication, Server & Database credential, Backup and recovery, managing Storage and assigning Tickets, weekly team meeting, project update and deal with clients.

Decommission Instance and Databases then update server & Database inventory portal, and raise different Tickets like as Technical request ticket, Task ticket, incident ticket, change ticket, CTask, DR ticket, Firewall ticket then Assign task to Group-wise using ServiceNow Ticketing System.

Implement storage/Disk management strategies, Table Partition in order to archive data in database Warehouse, SAN, NAS and RAID Technology.

Designing and hardening SQL Server Security (Server hardening, Auditing, SOX compliance and user/group access monitoring).

24x7 “on-call" Production support rotations.

Environment: MS SQL Server 2017,2016,2014, 2012/2008 R2, Windows Server2016, 2012, 2008 R2, 2003 Enterprise Edition, SolarWinds, NetBackup, ServiceNow, ERWin, Splunk, SSIS, SSRS, BIDS, IIS 7.5, 8.5, Oracle SQL, Teradata, Big Data.

National Oceanic and Atmospheric Administration (NOAA), Suitland, MD Feb 2016 – May 2018

SQL Server DBA

Responsibilities and Accomplishment

Worked for the NOAA’s SQL Team where my primary focus on performance tuning, troubleshooting and in-depth root cause analysis (RCA) for database related issues.

Designing and Implementing Cloud Data Platform Solutions in Azure IaaS and PaaS environment.

Support for Microsoft Azure IaaS and SQL Azure DB'S Environments & Setting up SQL Azure Firewall

Supports day to day operational activities for the production database platform like service requests and tickets, monitoring Server Activity, database health, troubleshooting long running queries, locks, deadlocks, CPU, I/O, Memory bottlenecks, Disk space usage, Backup verification and Restore, jobs, shrinking database, cleaning history and solving the problem as needed.

Supports Database Developers to optimize and troubleshoot SQL Server slow running queries /Stored Procedures/index/Function/Views.

Worked on Database refresh in Dev/Test servers with PROD data and synchronize SID login and Users, DB consistency, DB integrity checks.

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.

Provide project support of engineering-based decisions and scope to assist the customer with over all layouts, design and installation of DB system, Configuration, Migration, Upgrades and Patching.

Designing and hardening SQL Server (Server hardening, TDE (Transparent Data Encryption), Row Level Security, Dynamic Data Masking Encryption, Role based Security Policy, Security Auditing.

Configured and Maintained AlwaysOn Availability Group using SQL Server 2016/2014/2012 with Synchronous Asynchronous automatic-failover mode. And push traffic to DR server using AG Listener (ApplicationIntent=ReadOnly)

Have created Azure SQL Database in Microsoft Azure Cloud (PAAS) and Migrated On-Premise SQL Server Database into Azure SQL Database.

Effectively interface between the business and technology teams in order to ensure business objectives are met and communicated to senior management.

Provided 7 x 24 Production support for the database and application issues

Work Environment: SQL Server, 2016, 2014, 2012, 2008r2, 2008, 2005, MS Azure Environment, AD (Active Directory), Windows Server 2012r2, 2008, IIS 8.5. JavaScript, ASP.net, In-house Application, SQL Fog-light, TFS, SharePoint, Oracle and DB2.

Blue Cross Blue Shield, Washington, DC Mar 2011– Dec 2015

SQL Server Database Administrator/SQL Developer

Responsibilities and Accomplishment:

Database Migration projects, Upgraded/Migrated SQL Server 2005/2008 to SQL Server 2012/2014, Installation, Upgrades SQL Server versions, Patching/Applied SP/Hot Fixes on SQL server Instances to address Security and upgraded related issues.

Install, configure and Administering SSRS Report server, SSIS/DTS Package and SSAS.

Developed and deployed SSIS Packages from different sources like SQL Server Database, Flat file, CSV, Excel and Export & Import data from the Flat file (CSV, Excel) to SQL Server Database

Recommend and Review Backup and Recovery Strategies and test plan for failure scenario.

Designing SQL Server Security (Server hardening, Auditing, DISA, STIG, SOX compliance).

Implementing HA Features (Failover Clustering, Database Mirroring, Log Shipping and Replication)

Configured and Maintained SQL Server 2012 Fail-Over Clustering and Always-On Availability group

Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space and backup verification.

Monitored Server Activity, Error Log, space usage and the solving problem as needed

Rebuilding the indexes at regular intervals for better performance.

Experience on Azure cloud IaaS, PaaS, SaaS.

Advance Database Performance tuning (Perfmon, SQL Profiler, Database Engine Tuning adviser etc.)

Perform root cause analysis and troubleshooting technical issues.

24x7 “on-call" Production support rotations.

Work Environment: Windows Server 2012, 2008, IIS 7.5, SQL Server, 2016, 2014, 2012, 2008r2, 2008, 2005, AD, JavaScript, ASP.net. Service-Now, BMC Control-M, TFS, SQL SentryOne, RedGate, Oracle, and DB2.

References: Strong References available upon request.

Contact this candidate