Mohammed M Hossain

Email: ad2kep@r.postjobfree.com

Phone: 703-***-****

Career Objective: Over 9 years of professional experience as a Database Administrator performing DB upgrades, migration, performance tuning, database encryption, monitoring, and vulnerability threat detection. Experienced in HA/DR and Clustering. Managed security risk, mitigate program and system level weaknesses followed by (POA&M). Adept in using Azure Services, IaaS, PaaS, migrating on-premises databases and Legacy products on Azure. Experienced with SDLC, AGILE such as requirement gathering, analysis, design, development, implementation, and testing such as UA, Black box, Regressation, 508 Compliance. Monitored and maintained database storage, health, performance, and sustainability. Experienced in Capacity Planning, POC, Server Virtualization, Security, and DISA STIGs. Extensive experience in creating a business, functional and technical documentation, and RMF. Strong ability to manage multiple complex projects, innovative and creative problem solver. Excellent verbal, written and communication skills, and conflict resolution.

Education: Bachelor’s in Computer Science, The City University of New York.

Status: US Citizen

Clearance: TS/SCI/wCI-Poly

Certification:

•MCITP (Microsoft Certified IT Professional)

•MCSA (70-765) SQL Database Administrator

•C*CURE 9000 System Installer/ Maintainer

•CompTIA Security+ SYO-401

•Cyber Security training: Ethical Hacker (CEH)

AREAS OF EXPERTISE:

Web/Application Server Administration:

•Deployed and administering applications in Web Server (IIS-Internet Information Services) in development, test, and production environment.

Development Tools: SSMS, Visual Studio 2010,2012,2013,2015, BIDS, CSS

Operating Systems:

•Worked and Managed Servers using Operating Systems (O/S) Windows Server 2012, 2008 R2, and 2003 R2

VMware: Installing, configuring, and administering and managing VM machines.

Networking: Configured and managed Router, Switch, AD (Active Directory) and users in Windows 2012/2008 R2/2003 R2 server.

SKILLS:

Database:

SQL Server 2016/2014/2012/2008R2/2005, MS Access 2007 & 2003

Operating System:

Windows Server 2012/2008 R2/2003.

Languages:

SQL, T-SQL, PL/SQL, HTML, XML,ASP, ASP.net and C++

Monitoring Tool

Solar Winds

Reporting:

SSRS (SQL Server Reporting Services), Power BI

Data Modeling:

ERWin, Visio, Toad Data Modeler, SSDD (SQL Server Database Diagram)

Third-Party Tools:

UltraBack, Collibra

Networking:

Active Directory, TCP/IP, DHCP/LAN/HTTP/ HTTPS

Hardware/Storage:

SAN, RAID

PROFESSIONAL EXPERIENCES

TRIAEM LLC April 2022- Present

CLIENT: NATIONAL GEOSPATIAL INTELLIGENCE AGENCY

Ashburn, VA 20146

Data Architect

Responsibilities:

•Ongoing support with definition and maintenance of metadata, business terms, data ownership and governance, CDO’s, information flow diagrams within the data domain.

•Participated in Enterprise data strategy & collaborated closely with enterprise architects and stakeholders.

•Proficient with GeoSpatial functionality and data modeling (Conceptual and Physical) techniques like CAMEO to support GeoSpatial solutions.

•Participated in Geospatial Data Governance and Data Management programs that comply with Zero Trust Architecture.

•Working with Enterprise Metadata Governance Platform’s (EMGP) Requirement Document that provides an organized baseline of EMGC’s functional, interface, and performance requirements that complies with NGA’s Data Strategy.

•Collaborated with Project MAVEN Cloud Transition and with L team for GeoSpatial Data Storage and Retention policy.

•Working experience with Minimum Metadata collecting from difference sources like NMF, DOD, Five Eyes, IC-COD for NGA standard.

•Working experience with Minimum Metadata Mapping and Requirement Traceability Matrix.

•Ingested and Harvested ESRI Data into Data Governance tool, Collibra.

•Participated with Data Lake House team to improve GEOINT data accessibility, data security policy, data labeling, data Ingest, data Harvest and enabled CDO to meet the NGAD 8005 directions.

•Involved in Data Governance Framework Strategy for CDO’s Data Life Cycle Management and Master Data Management.

•Participated DGC Weekly meeting for Data Ontology Roadmap and articulating what NGA would need to grow and maintain ontology services.

•Collaborated with Data Ontology Operation team for maximized use of NGA data for AI processing of ML Algorithm VS ML Model, and prediction/ detections.

The Buffalo Group. September 2020 to February 2022

Reston, VA

Client: US DoD

Database Administrator

Managing SQL Server database administration assignments for the federal government client. Enhance database Design, Development, performance, perform restores, implement recovery procedures, handle performance tuning, and conduct regular system backups. Ensure technical and functional designs meet business requirements and Database and System Security.

Responsibilities:

•Installed, configured, and deployed MS SQL Server 2008, 2012 2014 and 2016.

•Database upgraded and Migration, performance tuning and optimization, troubleshooting and error resolution, Database and Logins creation and granting privileges, OLTP, OLAP.

•Maintenance and support of SQL server Mirroring, Replications, Log Shipping, AlwaysOn for High Availability, Clustering, and other methods of disaster recovery.

•Configured and developed solutions using SQL Server Reporting Services (SSRS) and Power BI analytics solutions.

•Involved in installing SQL Server with minimum access privileges service account to improve.

•Monitored and maintained database storage, and database health, performance, sustainability, and Security.

•Implemented troubleshooting of SQL Server performance issues using SQL Server Profiler, Trace, Index tuning wizard and Database Engine Tuning Advisor (DTA).

•Provided data migration, transformation, backup & recovery, performance, and tuning.

•Enforced Database Security by Managing user privileges and efficient resource management by assigning profiles to users.

•Followed the best practices like change management and raising tickets for any changes in

Production environment.

•Managed SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.

Business Integra, Inc. November 2015 to October 2019

Rock Spring, MD

Client: US Department of State

SQL Server Database Administrator

Supported the US Department of State Diplomatic Security application CCURE 9000 for access control system provided Installation, database backup/restore, HA/DR solution, DB upgrade/Migrate, maintenance plan, Security, cleanup restoration, DB Monitoring/ RMF, troubleshooting & problem resolution.

Responsibilities:

•Installed, Configured, upgraded/migrated and Maintained SQL Server 2005, 2008, 2012, 2014 & 2016 and BIRS in development, test, and production environment.

•Setup VMware in datacenter cloud system, configured on ODBC data source to connect to the MS SQL. Server Database.

•Managed and maintained production servers by checking stability and performance related issues for C*CURE 9000, MAS, and SAS.

•Effectively managed security program risk, mitigate program and system level weaknesses followed by (POA&M).

•Started the Progress client and connect to the Progress database that needs to be migrated and converted progress database source code to MS SQL database.

•Standardized and managed monitoring Database performance, testing, archiving, and optimizing.

•Maintained security hardened baseline configurations and deployed new software releases and patches.

•Involved in gathering and trending appropriate DB and server metrics, managing DB-level Security, and protecting against potential vulnerabilities such as SQL Injection.

•Led management and resolution of all warning, alerts, and incidents. Design automated responses to system issues such as automatic failover, resource allocation adjustments.

•Worked in using multiple data flow transformations provided by SSIS such as Data Conversion, Conditional Split, Merge and Union all.

•Managed and maintained Data Security, TDE, like Grants, Permissions, user/logins, roles, AD etc.

•Implemented, as directed, appropriate response measures to security threats.

•Maintained up-to-date documentation of all procedures, infrastructure diagrams, system configuration and baseline standards, implementation plans, system back out plans, system recovery plans, maintenance plans and retention policy, system upgrades, and all system changes.

•Monitored the alerts generated by the servers and ensure proactive measures are taken to prevent any major hardware and software failure.

Data Group USA, LLC April 2013 to October 2015

Alexandria, VA

SQL Server Database Administrator

Administering SQL Server High Availability and Disaster Recovery strategies. Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance.

Responsibilities and Accomplishment:

•Installed, Configured, Maintained and administering SQL Server 2008, 2008R2, 2012 and SQL Server Reporting Services (SSRS) and Reporting Server.

•Configured and Maintained Replications, Log Shipping, Mirroring, Always On AG for DB HA/DR Solutions.

•Upgraded/Migrated SQL Server 2005 and 2008 instances and databases to SQL server 2012.

•Experienced in creating and modifying tables, Index, Constraints, Views, Stored Procedures, Triggers, scripts for application and reports.

•Worked on Data Modeling projects in creating and managing schema, entities, relationship, constraints, developed E-R Diagram using ERWin and SQL Server Data Diagram.

•Involved in Data Modeling (Logical and Physical), Normalization and building Referential Integrity Constraints.

•Experienced in Data Dump/Export/Import of data from/to Flat file/CSV file/Excel to/from SQL Server Database using T-SQL

•Monitored and Maintained Database Health, disk space, backup verification, cleaning history, Server Activity, Error Log, space usage and solving problem by using Solar Winds.

•Applied SP (Service Pack) and patches on SQL Server 2012, 2008 R2 on a routine basis.

•Responsible for alerts on changes or leaks to help ensure data integrity, monitoring and real time security policies protect data across the enterprise.

•Monitored the database server performance and if required go for tuning of the T-SQL queries, Stored procedures.

References: Available upon request

Contact this candidate