MOHAMMAD RAHMAN

EMAIL: adwint@r.postjobfree.com

PHONE: 703-***-****

Objective:

Certified Microsoft SQL Server Database Administrator with 6+ years of experience with managing Databases and Database Servers using SQL Server 2019/ 2016/2012/2014/2008 R2. Experience in SQL Server Database Management System in the areas of Database Administration, Database Design and Development, Installation, Configuration, Backup and Recovery, Upgrade, Service Pack

(SP), SQL/T-SQL, Stored Procedure, Trigger, DMV, DBCC, Clustering, Always On, Log Shipping, and Replication, SSIS AND SSRS and Performance tuning, Troubleshooting. Migration from On-Premises to Azure Cloud Environment. Extensive experience in Designing and developing databases using SQL Server (SQL and T-SQL) using Microsoft technologies Power BI and MSBI (SSIS). Designed and implemented Report using Power Query & Power Pivots to be included in dashboard reporting. Certifications

Certified DP-300 (Azure Database Administrator Associate) Certified MCP (Microsoft Certified Professional) – SQL Server 2012-2014 Education

Bachelor in Computer Science America Bangladesh University May 2001 Security Clearance

Clearable

Legal Status

U.S Citizen

Technical Skills:

Operating system Windows Server 2016, 2012, 2008, VMware Database MS SQL Server 2019, 2016, 2014, 2012, 2008 R2 SQL server tools SSMS, SQL profiler, Query analyzer, Database Engine Tuning Advisor (DETA), PerfMon

ETL & BI Tool SSIS/DTS, SSDT, SSRS, SSAS, Report builder, Power BI (power Query)

Reporting Tools SSRS, Report builder, Power BI

Database Migration SQL Server to SQL Server, MySQL to SQL Server, MS Access/Excel to SQL Server, Migrated on-premises SQL Server databases to Azure SQL databases

Languages SQL, T-SQL, DAX

Third Party Tools Red Gate, ERWin, Idera

Data Security TDE, SSL, Dynamic Data Masking, Column level security and Row level security.

DR and HA

solutions

Backup & Recovery, Replication, Log Shipping, Mirroring, AlwaysOn and Clustering

Database Tools SSMS, SSMA, SQL Server Configuration Manager, SQL Profiler, Query Analyzer, SQL Agents, SQL Alerts, SQL Jobs, SQL Mail, SQL Backup and restore, mirroring, replication, Log shipping, Cluster. Professional Experiences

Comcast, Richmond, VA April 2020 – Present

SQL DBA

Key responsibilities:

Administer production and development servers running with MS SQL Server 2016, MS SQL Server 2014, MS SQL Server 2012, MS SQL Server 2008 R2

Installed, configured, and managed MS SQL Server 2016, 2014, 2012, and 2008 R2, managed in development, test, and production environments.

Migrated On-premises 2012 version to 2019 version using DMA (Data Migration Assistance) / DMS

(DB Migration Services), Migrated On-premises to Azure platform using Data Tier Application

(Export/Import),)

Installed, configured, and maintained database Log shipping, replication, mirroring, AlwaysOn and clustering

Maintained fail-over clustering using MS SQL Server 2016/2012 Experienced in Database backup and disaster recovery, designed and maintained backup strategy for databases, and point in time recovery solutions Setup jobs, maintenance plans for backups, rebuilding indexes, check server health, alert, and notifications

Create and manage different types of indexes (clustered/non-clustered) Upgraded databases from MS SQL Server 2008R2 to 2012/2014 and 2012 to MS SQL Server 2016/2019 Enterprise edition.

Monitored Server, Database, Query Performance, Memory, CPU, Disk IO issues and performed Troubleshooting of long running query, used different tools (Native & Third-Party tools) SQL Server Profiler, Extended events, Database Tuning Advisor, Execution plan, Performance Monitor and Activity Monitor, DMV, DBCC, Windows Event Viewer, SQL server Error Log, Agent Error Log. Applied SP and HOT fixes on MS SQL Server 2008 R2, 2012, 2014 and 2016 Applied Patch on Windows server 2008 and 2012 R2

Hands on experience and outstanding knowledge of HA SQL Server solutions including Log shipping, replication mirroring, AlwaysOn and clustering. Configured and maintained AlwaysOn Availability Groups using SQL Server 2012/2016 Upgrade/migrated SQL server instances/ databases from older version MS SQL Server to new version of MS SQL Server like 2008 to 2012/2014and 2012 to 2016-2019 Designed, developed and implemented Power BI Dashboards, Scorecards & KPI Reports. Created Power BI visualization of Dashboards & Scorecards (KPI) for Finance Department Designed, developed and tested various Power BI visualizations for dashboard and ad-hoc Experience in creating dashboards using power BI visualizations. Created new calculated column Measure using DAX expressions. Expertise in writing DAX functions in Power BI and Power Pivot. Installed and configured Enterprise gateway and Personal gateway in Power bi service. Scheduled Automatic refresh and scheduling refresh in power bi service. Created stored procedures and SQL queries to pull data into power pivot model. Worked on the Project with Combination of SQL server and MSBI (SSIS) and Power BI. Hands on experience in writing and implementation of the stored procedures, functions, Views, joins, Sub –Queries CTE’S, Indexes using SQL and T-SQL. Creating Roles to implements Row Level Securities (RDS) for the report. Publish the report into Power BI services and sharing the dashboards report to the users. Hands on experience in extract transform load (ETL) development using SQL Server, Integration services (SSIS).

Excellent knowledge on full loading and incremental loading with SSIS. Designed and developing SSIS packages using different transformations Conditional split, Derived column, Data conversation, Lookup, Marge, Marge Join, multicast, Sort, Union all, OLE BD command, Row count, slowly changing Dimension.

Experience in providing Logging, Error handling by using Event Handler and Custom Logging for SSIS Packages.

Report Development Installed, configured, and administrated SQL Server reporting services Developed and managed report in SSRS including managing securities Delivered reports to users in variety of formats like Report server (web based), excel, pdf, html, access, and CSV formats.

Provided 24X7 production support to ensure timely and error free delivery of reports. ADF Company LLC. OCT 2016 – April 2020 Fairfield,

New Jersey

SQL Database Administrator

Configured and managed different High Availability and Disaster Recovery solutions. Working on multiple data modeling projects including gathering information, analysis, conceptual, Logical and Physical data modeling using tools ERWin, SSDT. Designed backup strategies for development, Training, Staging, UAT, and Production Environment, setup automated backup jobs.

Experienced with SQL/T-SQL scripts

Experienced using DBCC commands to manage database consistency and repair as needed. Manage Security Management: Securing SQL Servers and Databases, manage users, Data encryption, granting/ revoking access.

Secured Database, using Principal/Roles, Auditing, Policy Based Management, (Transparent Data Encryption), Row/Column Level Encryption, Dynamic Data Masking (DDM) and Always Encrypted. Tools: SQL Server Profiler, Extended Events, Database Engine Tuning Advisor, Performance Monitor, Activity Monitor, Execution plan, Toad Data Modeler, SQL Server Data Diagram (SSDD), ERWin, DMA/SSMA

Created and managed Indexes, Constraints, and Keys (Primary Key, Foreign Key). Ticketing tools: Jira

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

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

Regularly checked databases consistency.

Prepared/designed and implemented backup strategy, maintenance and disaster recovery plan. Performed regular backups, restores and database.

Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification, cleaning history, deleting old files, and index and fragmentation managements.

Installed, Configured and Maintained Fail-Over Clustering using SQL Server 2008 R2. Setup, configured, monitored, troubleshoot and maintained Log Shipping, Database Mirroring and Replication.

Applied SP (Service Pack) on SQL Server 2008, 2008 R2 and 2012. Export & Import data from Flat file, CSV file to/from SQL Server Database using DTS, SSIS, and BCP.

Export & Import data from Oracle, My-SQL, and Access to SQL Server. Created user accounts and managed database object permissions. Regularly inspected SQL Server Logs, SQL Server Agent Error Logs, and Windows Event Viewer for Information, errors and warnings.

Involved in resolving dead lock issues and performance issues and Health Check process for database.

Monitoring of database size and disk space in Production, Staging & Development environments. Conducted various meetings and conferences with application teams to meet corporate milestones for database consolidation and data migration. Security and architectural planning issues met as well as testing and training.

Extensive database programming Experience in writing T-SQL Stored procedures, Triggers, Constraints and Indexes using various DDL and DML commands. Developed and Managed Report in SSRS (SQL Server Reporting Services) including managing securities.

Performed Production support and on Call duties.

Executed Change management scripts on weekly basis. Worked on Data Modeling projects, Backward Engineering, developed E-R diagram and used multiple tools like ERWin and SQL Server data diagram Deployed SSIS packages to move data across server, load data from different data sources Worked on creating SQL Server agent jobs and maintenance plans. Good skills in Integration of various Data Sources like MS Excel, Flat Files, Different Database Sources and Other Sources into the Staging Area.

Worked with various tasks such as Control Flow (Execute Sql task, Foreach loop container, Data Flow task, File System etc...) and transformations such as Sort, Lookup, conditional split, Multicast, Aggregate, derived column etc...

Good knowledge and well use the Condition Split, Data conversion, Derived column, multicast transformations in the project.

Experience in providing Logging, Error handling, and Package configuration. References

References available upon request

Contact this candidate