Sql Server Database

Md Shahadat Hossain

MSCA, MCA, CompTIA Security+, PMP

Email: **********.***@*****.***

Phone: (571) 477- 6220

Clearance- Active Secret Security

Virginia, Citizen Status: US Citizen

Over many years of experience in managing and administering Microsoft SQL Server Database and working as a Database Administrator with Microsoft SQL/TSQL skills along with Oracle industry knowledge. Experiences in supporting Microsoft MS SQL Server 2019, 2017,2016, 2014, 2012, 2008 R2, and along with Oracle 11g,12/19C, in Development Environments on various business domains. Strong understanding and implementation of business logic, system design, database design, monitoring, and troubleshooting. Experiences in gathering requirements, designing and implementing business process applications with strong business process management skills and experience including database mapping, data modeling, process visualization, analysis, frameworks & business rules, and Standards. Experience in providing systems delivery, and database support on SQL Server Database Management Systems in database administration, reporting, database design, and development. Experiences in configuration, backup and recovery, upgrade, service pack (SP), stored procedure, trigger, DMV, DBCC, clustering, database performance tuning using SQL Server Profiler, Extended event, Database Engine Tuning Advisor, Execution plan, Performance Monitor. Configured and managed High Availability and Disaster Recovery solutions like Log shipping, Mirroring, Replication, SQL Server FCI clustering, and Always On. Strong work experience and knowledge in Query Optimization, Database and Column Level Encryption, and Security Management, etc. Experience in creating, supporting, and maintaining database scripts. Proficient in Installed, Configuring, and administering SQL Server Reporting Services (SSRS), creating, deploying, managed reports also experienced in Data Movement, and data dumping using different tools like Export & Import utility, Data Tools, BIDS, SSIS, and DTS including Excel File, Flat file, CSV file, SQL Server Database and also including Oracle, Linux, Windows operating system including Virtual and Cloud Environment. Expertise in designing and implementing efficient data migration solutions and managing large-scale data migration projects in SharePoint and Azure environments, including API integrations, CICD pipeline deployment, Azure Data Factory, Synapse, and Data Lake utilization.

Education:

Bachelor of Science, Australia.

Certifications:

Project Management Professional. PMP

SYO-601 CompTIA Security +

Microsoft Azure Administrator Associate certified.

Microsoft Solution Architect Expert certified.

Summary of Expertise:

Extensive experience in SQL Server Database Management Systems in the areas of Database Administration, Reporting, Data Modeling, Database Design and Development, Advanced Installation, Configuration, Backup and Recovery, Upgrade, Service Pack (SP), SQL/T-SQL, Stored Procedure, Trigger, DMV, DBCC, Clustering,

Database Performance Tuning using SQL Server Profiler, Extended event, Database Engine Tuning Advisor, Execution plan, Performance Monitor, and other third-party tools like Red Gate, and, Commvault.

Configured and managed High Availability and Disaster Recovery solutions like Log shipping, Mirroring, Replication, SQL Server FCI clustering, and Always On.

Exposure to Azure Services migrated on-premises databases and Legacy databases to Azure, deployed products on Azure, and set up development and test environment on Azure.

Strong work experience and knowledge in SQL Server Replication, Log shipping, Mirroring, Clustering, Performance tuning, Backup/recovery, Query Optimization, Database and Column Level Encryption, and Security Management.

Experience in creating, supporting, and maintaining database administration scripts.

Experienced with SQL/T-SQL scripts including scripts/SQL/TSQL for managing Databases and database objects.

Experience in implementing RAID technologies used with the SQL server database technology

SSIS & DTS Packages: Created, configured, deployed, and managed including Migrate and Upgrade.

Reports: SSRS - Highly proficient in installing, Configuring, and administering SQL Server Reporting Services (SSRS), created, deployed, and managed reports including migrating reports. Experienced in Data Movement, and data dumping using different tools like Export & Import utility, Data Tools, BIDS, SSIS, and DTS including Excel File, Flat files, CSV files, and SQL Server Database.

Upgraded and migrated from SQL Server databases and instances from older versions to newer versions like SQL 2005 to SQL Server 2008 R2/2012/2014/2016/2017/2019 in different environments. Migrates from MySQL to SQL server 2008, 2012, 2014, and 2016/2017/2019. Add roles, migrate table and related objects using SSMA, export-import, map data using SSIS and migrate from MySQL to Microsoft database and Azure SQL database.

Manage Security Management: Securing SQL Servers and Databases, managing users, Data encryption, granting/ revoking access.

Extensive work experience in Compression, Database maintenance, and Optimization.

Worked on Operating Systems like Windows Server 2003 R2, 2008 R2, and Windows Server 2012/016 including installation, and configurations.

Virtualization: Installed, Configured, and Managed SQL Server in a virtual environment using VMware and vSphere.

Ticketing tool: Xira CR and project management, Service Now ticketing tool, and Confluence for documentation

Configuring Azure policies, resource locks, and executing cost management and implementing and managing virtual networks, and securing access to those networks.

Managing Azure Active Directory and managing users, groups, and administrative units also involves managing device settings and performing bulk updates to ensure streamlined operation.

Configuring load balancing, monitoring and troubleshooting virtual networking, integrating on-premise networks with Azure virtual networks, and effectively monitoring resources using Azure Monitor. Professional Experiences:

Azure SQL Database Administrator/Developer

DISA, Defense Information Systems Agency, Duration: 07/2023 – Current Responsibilities:

Deploy and configure Azure Synapse Analytics solutions, including meticulous data modeling and schema design.

Continuously monitor and optimize query performance and data processing workflows within Azure Synapse Analytics to meet business requirements efficiently.

Implement robust data security measures, access controls, and encryption mechanisms to safeguard sensitive information and maintain compliance standards.

Develop and execute backup, restore, and disaster recovery strategies for Azure Synapse Analytics databases to ensure data integrity and business continuity.

Collaborate closely with data engineering teams to fine-tune data ingestion, transformation, and loading processes for optimal performance and reliability.

Identify and resolve data-related issues by employing advanced troubleshooting techniques, addressing query performance bottlenecks, and optimizing data pipelines.

Automate routine database maintenance tasks using Azure tools and scripts, enhancing operational efficiency and reducing manual effort.

Configure and manage large-scale deployments of SQL Server in Azure environments, ensuring seamless integration with Azure Synapse Analytics.

Perform provisioning, administration, and operations of Azure Synapse Analytics/Dedicated SQL Pools, conducting thorough performance analysis and optimization.

Troubleshoot performance issues, such as costly SQL queries, blocking/deadlocking, and excessive waits, leveraging monitoring software and network interaction understanding.

Collaborate with users to resolve issues and ensure smooth operation of ETL/ELT and data migration tools, utilizing Azure portal and PowerShell for support.

Conduct installation, configuration, and maintenance of production and non-production environments, including setup of high availability and Disaster Recovery measures.

Manage user permissions and security frameworks, ensuring robust protection of assets and resolving database integrity and performance issues.

Implement operational automation through script development, optimizing SQL agent jobs, elastic jobs, and runbook automation.

Maintain databases, managing statistics, indexes, and fragmentation, and overseeing upgrades and patches for SQL Server and related software.

Design and create databases to support development initiatives, ensuring efficient Synapse workload management and optimization.

Page- 3

Technical Consultant- U.S Department of Health and Human Services (HHS) Contractor: CSCI Consulting, Duration: 10/22 to 07/20023 Responsibilities:

Identify opportunities to streamline reporting to make processes more automated and develop and manage business intelligence solutions. Utilize Power BI to deliver high solutions sourcing a variety of data, and build data visualizations including dashboards and reports.

Interpret data, analyze results using statistical techniques or relational databases, and produce to meet client or business needs. Design, create. test and document new and amended SharePoint Online applications.

Data migrated from the On-Premises SQL Server to Azure SQL Databases and SQL server on Azure VM Instance using different tools like Always On, DMA, DMS, and Azure Data Lake/Factory.

Implement and maintain database security measures, including access controls, user permissions, and data encryption.

Configured and Managed HA solutions on AlwaysOn Availability Group on Azure VM using SQL Server 2017 with asynchronous/synchronous Commit automatic-failover mode.

Managing & Troubleshooting SQL Server Failover Cluster SQL Server 2012/2014/2016/2017.

Installed, configured, monitor, troubleshoot and administer and monitor performance

Create Index, Index rebuild & reorganize, index management tasks for monitoring and tuning performance and collaborate with development teams to optimize database index, designs, and SQL queries.

Create and document dashboards and reports and distribute them to users in a variety of methods.

Defined and managed role-based access control strategies to ensure secure access to Azure resources.

Configured and managed Azure Storage including Azure files and Blob Storage.

Automating deployment of VMs and containers using ARM templates and PowerShell scripts.

Configured load balancing and secured access to virtual networks by implementing Azure Firewall

Managed cost and governance by configuring Azure policies and applying tags to resources.

Implemented backup and recovery solutions for Azure SQL Databases.

Monitored database performance, implemented tuning activities, and performed regular system and database health checks.

Managed data migration programs for large-scale data transfers.

Provided technical support and guidance on data management issues, working closely with development and product teams.

Secure storage includes managing the access key and configuring access to Azure files.

Creating and configuring containers, configuring Azure app services including deployment and networking settings, and creating and securing an App Service,

Configuring endpoints on subnets and implementing subnets to secure access to virtual networks, creating security rules, and implementing Azure Firewall.

Implement backup and recovery services and backup vaults, configuring backup policies

Managing Azure Active Directory and managing users, groups, and administrative units also involves managing device settings and performing bulk updates to ensure streamlined operation.

Created reports based on your SQL data, using Crystal Reports design and data visualization tools using data from SQL Server Databases connected via ODBC or OLE DB to Azure SQL databases to extract and manipulate data. Data Migration Specialist- US Navy. Washington DC

Contractor: CSCI Consulting, Duration: 08/21 – 10/2022 Responsibilities:

Responsible for working with Process Owners to identify Navy and non-Navy Data systems that shall meet those Process Owner needs.

Report directly to Information Systems leadership for deliverables, direction, and approach. Ensure that all migrations are performed without negative effects on mission-essential data and processes.

Build database diagrams design, structure, and relationships.

Extract master and transactional data and determine the appropriate migration approach for each source.

Utilize Azure Data Factory and Data Lake for efficient data extraction, transformation, and loading (ETL) processes.

Deployed CICD pipelines to automate and improve the efficiency of data migration processes.

Managed API integrations, ensuring seamless data exchange between disparate systems.

Wrote complex SQL scripts to extract, manipulate, and load data as part of the migration process.

Coordinated with different teams and stakeholders to plan, manage, and execute data migration projects.

Troubleshot and resolved data-related issues during the migration process. Monitored and ensured the integrity and quality of migrated data.

Worked with SQL databases, managing data extraction, transformation, and loading (ETL). Managed data within ServiceNow and SharePoint environments.

Utilized Azure Data Factory and Data Lake for efficient data processing and storage. Coordinated with software development teams to integrate APIs into the data pipeline.

Load data into the target system and perform final data validation with end users.

Prepare training materials SOP and user guides on data migration effect.

Requirements gathering, documenting analysis, business process reviews, and task and workflow analysis.

DoD audit scope identification for the Azure Migration and data ingestion via their ETL tool with Data Factory and Databricks. Database Administrator/System Architect.US Dept of State. Contractor: ActioNet, Vienna, Virginia, Duration: 12/19 – 07/2021 Responsibilities:

Develop, implement, and optimize stored procedures and functions using T-SQL.

Analyze existing SQL queries, stored procedures, and functions for performance improvements.

Suggest new queries, stored procedures, and functions based on ongoing business changes.

Develop procedures and scripts for data migration.

Perform DBA functions like backups, restores, and performance tuning.

Support CST DEDM dba/developer team for large database on Exadata Engineering System, backup solution for DEDM project.

Support databases, capacity planning, creating, setup and configuring production databases, troubleshooting production issues, monitoring production databases, development of scripts to monitor production databases.

Performance tuning, troubleshooting the production issues, identifying the performance bottleneck, and recommendations in architecture to avoid performance issues.

Installed, Configured, and managed SQL Server 2008R2, 2016 Server 2017 on Dev and Prod environment.

Performed Backup and restore in SQL Server as needed in Prod support.

Database Monitoring: Responsible for daily monitoring and managed Database Servers, Databases, Agent, Jobs log files

Database Automation: Set up automated jobs for different purposes like database maintenance, backup verification, etc.

Troubleshooting: Monitored Server Activity, Error Log, space usage, and solving problems as needed

Strong on SQL Server Profiler, Extended Events, Database Engine Tuning Advisor, and Performance Monitor, Activity Monitor, and Execution plan.

Migration/deployment: Migrated SQL server 2008r2 to SQL Server 2017 databases in Prod and Dev and mediated automation migration scripts using SQL query and PowerShell.

Monitoring: Database Monitoring: Responsible for daily monitoring daily job

Monitor Servers and User Activity and provide solutions as needed using OEM tools.

Configured and monitored replication and SQL Server always on availability group, monitor and manage mirroring and log shipping.

Architect and Implementation of data replication using Oracle Goldengate

Installation, configuration, and troubleshooting of Oracle Goldengate, Data Migration using Goldengate, building, configuring, monitoring, and troubleshooting the Golden Gate processes.

Documentation: Prepared detailed documentation/SOP for different aspects of servers and its databases.

Data Modeling: Worked on multiple Data Modeling projects, and created logical/Physical models from existing SQL Server

write SQL DDL DML scripts

Applied service pack on the version of Database Server 2008R2,2016 and 2017

Move a TDE Protected Database to another SQL Server

Perform insert, and update data from Excel to SQL Server

Security Management: Managed SQL server user logins, database users, roles, and permission and troubleshooting and resolving access issues. Managed Security using SQL Logins, Roles, and Security Modes for various users.

Configured a centralized management server and added all the servers and monitors from one place.

High Availability: Managed, monitored, and troubleshoot SQL Server Always on Availability group.

Managed SQL server user logins, database users, roles, and permission. Apply TDE and solve TDE-related problems.

Database sizing, capacity planning, forms/application errors, Apache tuning, and database tuning for Oracle Applications environments.

Page- 5

Installation and configuration Cluster Database installation, data guard setup, backup and recovery using RMAN, performance tuning, resolving complex production issues, and streamlining production databases to ensure uptime of the database systems.

Analyze, evaluate, and identify production database issues using stats pack reports, SQL tuning using DBMS SQL Tune

Coordination with Systems Engineering, Systems Administration, Production Support, and Network teams. SQL Database Administrator

Bureau of Labor Statistics. Washington DC, Duration: 06/16 – 11/2019 Responsibilities:

Managed Database Servers in Development, Test, and Production environment.

Installed, Configured, and Managed SQL Server 2008 R2, 2012, 2014, and 2016 in the Development, Test, and Production environment.

Installed, configured, and Maintained HA/DR Solutions using WFCI to FCI multi-subnet Clustering, Always On migration, Mirroring, and Log Shipping. Installed, configured monitored, and troubleshoots Log Shipping as a Standby database from the Production database for Reporting purposes.

Installed, Configured, and administered SQL Server Reporting Services (SSRS) & Power BI configuration, integration, visualization, data analysis, cloud-based report generation, and implementation.

Developed and deployed different types of reports using different data sources like SQL Server, Oracle, CSV, and Excel.

Delivered reports to users in a variety of formats like Report Server (Web Based), Excel, CSV, and PDF formats.

Database Upgraded and Migrate (development, testing, and production environment):

Upgraded/Migrated SQL Server 2005 to SQL Server 2012/2008 R2 & 2012 to 2014/2016

Migrated MS Access Database 2000, 2003 into SQL Server 2008 R2, 2012.

Migrated Oracle 10gR2/11gR2 and My SQL 5.1.23 Database to SQL Server 2008 R2/2012.

Good understanding of data modeling projects and generated E-R diagrams.

Applied SP/Hot Fixes on SQL server Instances to address Security and upgraded related issues.

Enable SSL or IPSEC for connections to enable password policy checking. Implement Transparent Data Encryption to protect confidential data, encrypt SQL Server, Azure SQL Database, and Azure SQL Data Warehouse data files, and encrypt data at rest.

Managed Security using SQL Logins, Roles, and Security Modes for various users.

Strong in database Monitoring and Performance tuning. Monitor SQL Server Error Log and space usage.

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

Identifying the memory, I/O bottlenecks, blocking, and deadlocks triggered by complex queries where using SQL Server Activity monitor and profiler and implementing better Query Execution plans.

Strong on SQL Server Profiler, Extended Events, Database Engine Tuning Advisor, and Performance Monitor, Activity Monitor, and Execution plan. The native tool used OpNet as a Third-Party Tool for monitoring and Performance Tuning.

Writing T-SQL, Functions, Trigger, Partition, View, and Stored-Procedures, join, union, and writing scripts for job set-up.

Assisted Database Developers to optimize SQL queries and Stored Procedures.

Export & Import data from Excel files, Flat files, and CSV files to/from SQL Server Database using BIDS, SSDT.

Export & Import data from/to databases as My-SQL, and Access to/from SQL Server.

Creating SSIS Packages and deploying from different sources like SQL Server Database, Flat files, CSV, Excel, and many other data sources supports OLEDB Data sources.

Skilled in creating simple, parameterized, and complex reports involving Sub Reports, Matrix/Tabular Reports. SQL Database Administrator

Alarm.com. Tysons Virginia, Duration: 05/15 – 05/2016 Responsibilities:

Installed, Configured, and Managed SQL Server 2014, 2012, 2008 R2, 2005 in Dev., Test and Production Servers.

Applied SP and HOT Fixes on SQL Server Database Servers in the Development, QA, and Prod environment

Upgraded from SQL Server 2005 2008 R2 to 2012.

Monitored Database Servers, Databases, Agents, and Jobs log files.

Assisted with SharePoint SQL Server upgrade from 2008 to 2012 in QA and Production

Analyzed the root cause of a variety of Database performance issues and rectified them accordingly

Utilized DBCC and DMV to monitor Database stats, validity, health, and performance periodically

Supported and managed a few production servers and any related issues with direct client

Setup jobs and troubleshoot jobs related to backup, recovering database in point in time.

Worked on performance tuning to optimize different applications, SQL/TSQLQuery Execution plan, Database Tuning Advisor, Profiler, and Monitoring Lock/block.

Create, modify, or update index constraints, views, and stored procedures in query tuning for better performance.

Exported & Imported data from Flat files SQL Server Databases for ad-hoc purposes.

Supported and managed production servers and related issues with client

Installed, Configured, and Managed Database Mirroring, Log Shipping, Replications, and Always on AG monitoring, on a FCI cluster environment.

Wrote T-SQL, and Stored-Procedures for reports, and applications

Excellent in loading data, data conversion from Flat files, CSV files, Excel, and from other Data Sources like Oracle, MySQL, and Access to SQL Server.

Database Administrator

African Development Foundation. Washington DC, Duration: 02/2014 - 05/2015 Responsibilities:

Installed, Configured, and Managed SQL Server 2008 R2, and 2012 in development, test, and production environment.

Installed, and configured database-associated tools and performance monitoring Software.

Setup, Configured, monitored, and Maintained Database Replications.

Installed, configured, maintained, and monitored troubleshoots SQL Server Database Mirroring.

Configured and Maintained Log Shipping as a Standby database for Reporting Purposes.

Securing SQL Servers and Databases, managing users, Data encryption, granting/ revoking access.

Planning, controlling, and monitoring the Security and Audit issues as per SLA and Standards.

Data Encryption and Data Decryption for data security at the Database & Column level.

Managed Backup/Restore and point-in-time Recovery including backup verification, and security by native tools and Red Gate tools.

Applied SP (Service Pack) on SQL Server 2008R2 and 2012

Expertise in database Performance tuning SQL profiler, Execution Plan, Database tuning Advisor, Activity Monitor, and Performance Monitor.

Monitored data activities such as logs, space utilization, locks, and long transactions.

T-SQL, Stored-Procedures, Triggers, Function, Views, Indexes.

Developed and maintained scripts, and utility jobs or implemented needed software for database maintenance.

Created and managed Indexes, Constraints, and Keys (Primary Key, Foreign Key).

Worked on different Data Modeling projects including creating scripts, E-R Diagram, backward/forward engineering

Worked on multiple Data Modeling projects for different applications

Processed data dump and Exported & Imported data from Flat file, CSV file, Oracle, My-SQL, and Access to/from SQL Server Database using DTS, SSIS, and EXP/IMP tool.

Export & Import data from Flat files (CSV, Excel) to SQL Server Database using EXP/Imp and DTS tool.

Set up automated jobs for different purposes including backup, monitoring database health, disk space, backup verification, and moving databases from environment to environment including creating test environment.

Developed different maintenance plans such as backups, index management, fragmentation management, cleaning history, and deleting old files.

Monitored Server Activity, Error Log, space usage, and solving problems as needed.

Contact this candidate