Database Administrator Ssrs

MOHAMMED MAHDI HASAN SQL SERVER DATABASE ADMINISTRATOR

Tel: 561-***-**** *********@*****.*** 1593 Quail Lake Dr, Apt#112, West Palm Beach, Fl-33409

SUMMARY

5+ years of experience in Database Administration in SQL Server 2012, 2016 & 2019 for production, development, integration & test platforms.

Administering SQL Server high availability and disaster recovery strategies.

Strong technical background along with the ability to perform business analysis, project management, and compose written documentation for support of administration software including step-by-step operational procedures.

Proficiency and expertise in all high availability solutions, backup/recovery, disaster recovery planning, and security management operations.

Worked on data modeling/designing, data migration, software/program configuring, and maintenance.

Troubleshoot performance problems, fine-tuning of database & index analysis with rebuild/reorganize and update statistics.

Deploy security protocols, data encryption; apply updates, service pack & STINGING SQL Server instance.

Optimize database performance, monitoring, and streamline data handling processes.

PROFESSIONAL EXPERIENCE:

Innosight Lexington, MA August 2019 – Present

Role: SQL Server Database Administrator

Perform SQL Server 2012-2019 Database Administration duties, including database backup/restores, database migration, Transparent Data Encryption (TDE), Always On High Availability Groups, and security configurations to conform to industry standards in supporting of domestic and internal SharePoint sites.

Install, maintain, and implementation update SQL Server Service Packs and security updates on physical and VMware virtual servers, on Windows Failover Cluster nodes (shared and dedicated storage).

Creating, building, and deploying SSIS packages, building and managing report servers and users are other parts of my daily responsibilities.

I worked for building/designing Power BI visuals into Power BI apps for the customer.

I have the working experience to integrate with other Microsoft solutions, such as Azure data services, share data, dashboards, and reports with other Power BI users.

Database maintenance such as health check, rebuild and reorganize indexes, troubleshooting issues for using SQL Server Profiles, Database Engine Tuning Advisor and run DBCC or Dynamic Management Views for concisely identifying issues and resolving them by understanding customer needs.

Involved in Migration/Upgrade of Data Base servers.

Designed and developed a full-scale reporting solution for a multi-client environment using MS SQL Server and MS SSRS.

Generated multi-parameterized reports in MS SSRS allowing users the ability to make selections before executing reports; thus, making them user-friendly.

Developed reports using SSRS 2008 and involved reports migration of SSRS and Tableau.

Performed SQL Server 2012 Database Administration (DBA) duties in a production environment, including security, configuration, developing maintenance plans for the backup and recovery of system and user databases.

Migrated an Access database to SQL Server 2012/2014 using Integration Services, stored procedures, and SSMA tool.

Developed data objects, forms, and Reporting Services report.

Monitored and did performance tuning on indexes, queries, and stored procedures on databases.

Ran database clean-up scripts to ensure database performance remained high.

Coordinated any emergency database backups for committed customer service.

Conducted code migrations for various billing systems.

Aggressively pursued resolution SQL Server performance issues.

Working experience with another team on Python, Jira, and TFS (Team Foundation Server).

Setup new user accounts with the appropriate application-level security

Cognizant Plano, Texas January 2017 – August 2019

Role: SQL Server Database Administrator

Maintained SQL Server Database; ensured accuracy of the information and automated numerous functions.

Performed database logical and physical design, maintenance, tuning, archiving, backups, replication, recovery, software upgrades, capacity planning, and optimization for SQL Server database.

Update and upgrade – Windows Server and SQL Server.

Monitored and administered DBMS security; adding and removing users, administering quotas, auditing, checking for security problems, and assigning user privileges

Monitored system performance and constantly tuned databases for efficient performance

Managing Database Structure, Storage Allocation, Table Index segments, Rollback Segments, Undo Segments, and Constraints.

Developed an effective backup and recovery strategy to maintain the integrity of the database

Used database consistency checks using DBCC utilities.

Worked experience in a DMS environment and helped operators to operate efficiently and control the distribution systems. I implemented data management procedures for the unclassified program and utilized available automated data management tools to support DMA (Data Management Activities)/ DMS (Data Management Service/Specialist) to ensure adequate version control, storage, and data retention.

Create database, create a new table, set identity, set constraints, modify the design, create an index, update-index, defrag an index, rebuild and update statistics, file upload from a different source to destination and directly work with app/web team for any release and migration.

Worked/working on Migration to AWS (EC2) and MS Azure platform – SQL Server, PostgreSQL.

Install, maintain, and update SQL Server Service Packs and security updates on physical and VMware virtual servers, on Windows Failover Cluster nodes (shared and dedicated storage).

Creating, building, and deploying SSIS packages, building and managing report servers and users are other parts of my daily responsibilities.

I had to apply STIGS and followed FSO (DISA Field Security Operations) guidelines in order to stay noncompliance with security for SQL Database Servers.

Mercer LLC Manhattan, NY March 2015 – December 2016

Role: SQL Database Administrator

Worked with development and systems teams to perform application and database tuning.

Migrated databases from SQL Server 2008 to SQL Server 2012.

Setup and maintenance of appropriate database and application monitoring.

Setup, test and maintain business continuity/disaster recovery infrastructure database and applications.

Provided highly available database and application infrastructure according to Business Continuity requirements using SQL clustering, load-balancing, etc.

Install, maintain, and update SQL Server Service Packs and security updates on physical and VMware virtual servers, on Windows Failover Cluster nodes (shared and dedicated storage).

Creating, building, and deploying SSIS packages, building and managing report servers and users are other parts of my daily responsibilities.

Database maintenance such as health check, rebuild and reorganize indexes, troubleshooting issues for using SQL Server Profiles, Database Engine Tuning Advisor and run DBCC or Dynamic Management Views for concisely resolving performance issues.

I worked as a DBA and IT support Tech for the SQL Server database on the Windows Server platform.

Developed database maintenance plan.

Migration - Performed database migration from SQL Server 2008 to 2008 and 2012.

Performed performance tuning using SQL Server profiler, Database tuning advisor, Windows performance monitor, Query Analyzer, and fine-tuning of long-running queries and stored procedures and slow running servers.

Created documentation for installation, monitoring procedures, security policies, configuration changes, migration procedures, and best practices.

Applied Service Packs patch and hot fixes, grant permission, support end-users.

EDUCATION/TRAINING & CERTIFICATIONS:

·Bachelor of Science in Engineering (Electronics & Telecommunication), UODA, Dhaka Bangladesh, 2010

·Certificate of Completion in MS SQL Server Database Administration, DB Tech, 12/2021

·Completion Certificate in SQL Server Integration and Reporting Services, DB Tech, 12/2021

·Online training on AWS cloud computing

Course Works: the Year 2006 -07

·Academic course on Cisco Certified Networking Associate (CCNA), Bangladesh University Of Engineering Technology (BUET)

·Linux System Administration, BUET

·Server Configuration (BUET)

PROVEN IN SKILLS:

WFC, Cloud Computing (AWS-RDS, EC2), VMware, MS Azure.

Relational Database Management System (RDBMS) managing/administering experience on different environments and platforms for SQL Server between 2008 and 2019.

Expert on Installation, Configuring, Managing and Administering SQL Server different components such as Database Engine (SQL Server Instance), SSRS, SSIS, SSAS and other ETL tools.

Monitoring, Diagnosing problems, Performance Tuning/Optimization with SQL/T-SQL Tuning.

Backup recovery, Point-In-Time recovery, Disaster recovery planning, and implementing expert.

High Availability such as windows failover clustering with Always On Availability, mirroring, log-shipping, replication.

Securing server and database by applying security updates, patching, service pack and implanting STIG, TDE

Database designing, data modeling, developing

T-SQL: DML, DDL

Ability to adapt to changing environments.

Developed an academic project on Trainer Board, 555 Timer IC Tester, and Parallel Port Interface.

Contact this candidate