MD Kamrujjaman

Database Administrator (Associate Manager)

BRAC BANK LTD.•  November 2021 - Present

1. Install and configure new Microsoft SQL Server instances, including AlwaysOn availability groups and failover clustering. 2. Create, modify, and optimize SQL Server Agent jobs and maintenance plans. 3. Banking Database Management:Performance tuning, indexing, user access and security ,quality testing, back-up and recovery plans, Clustering. 4. Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security. 5. Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems. 6. Check all statistics related to memory, locks, I/O, database response time, wait events, top sessions and background processes. 7. Proactively monitor SQL Server maintenance tasks, troubleshoot failed jobs and resolve issues in a timely manner. 8. Provide 24x7 support for critical production systems.

Lead Database Administrator

The Christian Cooperative Credit Union Ltd(CCCUL) - Dhaka•  October 2020 - November 2021

1. Co-operative Database Management: (Performance tuning, indexing, user access and security ,quality testing, back-up and recovery plans, Clustering). 2. Database design & development for CFS (Core Financial Solution) in MS SQL Server. 3. Writing T-SQL (Store procedure, function ,VIEW, Trigger etc.). 4. Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability. Proficiency and expertise in SQL Server Replication, Backup/Recovery Disaster recovery and Planning. 5. Data migration from existing MS SQL database and also from excel data . 6. Disaster Recovery Planning and Security Management operations. 7. Administering SQL Server High Availability and Disaster Recovery strategies with Always On technology. 8. Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark. 9. Vulnerability assessment for Servers, Applications, Databases etc. 10. Penetration testing based on VA report for Servers, Applications, Databases etc.

Senior Software Engineer

Transcom Group•  June 2015 - October 2020

1. Installed, Configured, and Maintained SQL Server 2017 and 2012 in development, test, and production environment. 2. Configured and Maintained Fail-Over Clustering using SQL Server 2016. 3. Scheduled many jobs to automate different database related activities including backup, monitoring database health, disk space, and backup verification. 4. Configured and Maintained Replications, Log Shipping, and Mirroring for High Availability. 5. Upgraded/Migrated SQL Server Instances from older version SQL Server to new version of SQL Server. 6. Performed database and SQL/TSQL Performance Tuning. 7. Wrote SQL/T-SQL queries, Stored-Procedures, functions, and Triggers. 8. Developed Different Maintenance Plans for database monitoring. 9. Maintenance plans for backups, Rebuilding indexes, check server health, alert, notifications. 10. Create and managed different types of Indexes (Cluster/Non-Cluster), Constraints (Unique/Check). 11. Manual, on Demand and setup jobs for Database Backup, and design backup strategy. 12. Monitor Server Activity, Error Log, space usage and solving problem as needed. 13. Web Application Development using Asp.net MVC & Asp.net core MVC. Developed business report using SSRS and Data integration using SSIS.

Jahangirnagar University

Computer Science, M.Sc.•  August 2019 - Present

This is a masters program designed to give fundamental knowledge related to computer science, OOP, Software Engineering, Web Development, BigData,Data Science,Database Security . Completed the first semester and hoping for the best.