Md Hossain,Comptia Security Plus,Asea,Mcsa,Mcitp.1St Email & Phone Number

Lynnwood, Washington, United States

Roles and Responsibility:• Designed, Installed, Administrated and Maintenance of SQL Server 2019/2017/2016.• Migrated databases from SQL Server 2012/2014 to 2016/2017/2019/Microsoft Azure.• Experienced with software upgrades including SQL, applications, patches/hotfixes instillation.• Configured and Managed Azure SQL databases, backups, geo-replication, recovery procedures, create custom monitoring and maintenance plans, troubleshoot, and resolve database problems.• Provided production support as primary DBA for over 75 financial, trading, reporting, asset management, and various vendor applications. • Helping senior management to purchase various SQL server licenses, tools, storage, capacity planning, and implementing policy.• Performed troubleshooting, resolution, and root cause analysis for database & application-specific incidents/events.• Worked directly with developers to design databases and tune SQL code to increase query response time.• Worked closely with the application team to ensure a smooth transition from old to new systems with minimal disruption of workflow and daily process.• Troubleshooting & optimization for performance issues including performance tuning of SQL as well as an index & database-level changes to improve performance.• Built Microsoft Windows Cluster with versions 2016/2019.• Implemented High Availability (HA) and Disaster Recovery (DR) solution with Always ON.• Expertise with Microsoft SQL Server databases, capacity planning, performance tuning, high availability in complex environments and mission critical applications• Developed backup and disaster recovery strategies for production environment.• Managed index usage, fragmentation, and updated statistics in databases.• Worked on Query optimization and tuning using SQL Server Profiler, Database Engine Tuning advisor, Activity Monitor, and analyzing execution plan.• Supported SQL Server Integration (SSIS), Analysis (SSAS), and Reporting Services (SSRS).

Suitland, Maryland, United States

Roles and Responsibility:• Installed, Configured, and Managed SQL Server 2016/2014 • Migrated databases from SQL Server 2008R2/2014 and 2016/2017.• Configured and administered Always On, transactional and Peer-to-Peer replication.• Performed DB Backup and Point-In-Time Recovery solutions using SQL Server Client.• Managed index usage, fragmentation, and updated statistics in databases.• Troubleshot and fine-tuned DB performance and concurrency and root cause analyses. • Worked on Query optimization and tuning using SQL Server Profiler, Database Engine Tuning advisor, Activity Monitor, and analyzing execution plan.• Support performance tuning and monitored Memory, Processor, Disk, I/O.• Implemented Partitioned for Tables and Indexes.• Created and monitored database maintenance plans for the performance of SQL server which covers backup jobs, database integrity checks, update database statistics, re-indexing.• Used SSIS to populate data from various data sources, created packages for different data loading operations for ETL applications

Germantown, Maryland, United States

Roles and Responsibility:• Installed and configured SQL Server 2012 and Migrated SQL server 2005/2008 to 2012.• Configured and maintained SQL Server High Availability Solution Log Shipping and Mirroring.• Designed and implemented comprehensive Backup plan and disaster recovery strategies. • Worked in Query analyzer and profiler for tuning queries using a variable for characteristics.• Troubleshot and fine-tuned databases for performance and concurrency.• Resolved blocking and long-running queries issues and participated in various root cause analyses by using the profiler, query execution plan, event viewer, etc.• Worked as the project lead for SQL server upgrade and patching for various database servers.• Monitored database performance by monitoring Index fragmentation level and updating Statistics.• Created logins, tables, clustered and non-clustered Indexes, views, and stored procedures.

Master Of Science In Physics

Bachelor Of Science In Physics