MD SARKAR

484-***-**** • adkeqt@r.postjobfree.com

*** ******** ****, ***** ** 19341

Senior SQL Server Database Administrator

Installation, Patching,Migration,Upgrade

AlwaysOn,Replication,Mirroring,Logshiping

Database Design,Store Procudure,Backup

Security,Audit, Encryption,Data Masing

SSIS,SSAS,SSRS

SQL Azure and Managed Instance

T-SQL, PowerShell

IAAS,PAAS,SAAS

oOver 7+ years of experience in Database Administration for very large and complex databases in SQL Server 2019,2017,2016,2014,2012, 2008 R2 and 2008.

oExpert on MS SQL Server Installation, Upgrade, Migration, patching, MS SQL Failover, SQL Server Agent, BCP, Transparent Data Encryption (TDE), Index Tuning, Perfmon, Profiler, Database Tuning Advisor, DMVs, DMFs, SP_PROCS, Wizard, DBCC Commands.

oExpertise in implementing Disaster Recovery (DR) and High Availability Solutions (HA) using Database Mirroring, Log Shipping, Transactional replication and AlwaysOn Availability Group.

oWorked on Azure IAAS,PAAS, SAAS model and Azure datafactory, Azure databricks and Azure Synapse.

oHands on experience in implementing Full, Transaction and Differential Backups and restore functions.

oInvolved in Administration, Database Design, Performance Analysis and Production Support for Large (VLDB) and to troubleshoot SQL Server related CPU, memory, Disk I/O, and other resource contention.

oWorking knowledge in Reporting Services (SSRS), Integration Services (SSIS) and Analysis Services(SSAS).

oKnowledge of SQL Server best practices for database security, availability and recoverability.

oExtensively worked on DBCC,DMVs commands and Dynamic Management Objects.

oHands on experience in Installation, Configuration, Migration and Maintenance of SQL Server Databases.

oSkilled in maintaining security such as adding users, roles, and maintaining security to database objects.

oPerform daily monitoring to include backups, error and system logs, disk utilization, etc

oExpertise in creating, setting up and scheduling SQL maintenance jobs for database administration.

oExperience in configuring of Database mail(s) and automating all the manual monitoring’s.

oAutomated Daily DB Severs Check Report on multiple servers which includes Disk Spaces, Last Boot Up information, Database sizes, Transaction log file sizes, Scheduled job running history, Any job schedule disabled, DB Backup history, Any errors in error log or in event viewer.

oAutomated Instant Blocked Process Alerts, Deadlock Alerts and Low Disk Space Alerts.

oImplementry Coyp Activity Custom Azure Data Factory Pipeline Activities for On-Cloud ETL processing.

oProactively Azure address issues to ensure optimum performance. Maintain database integrity, stability and availability.

oExperience in controlling the User Privileges, Monitoring the Security and Audit issues in sql server. .

oExpertise in Scheduling Database tasks - Jobs, Alerts, Emails, Notification and maintenance plan.

WORK EXPERIENCE

Senior SQL Server Database Administrator

Zoetis,Malvern Pennsylvania September 2019 to Present

Senior DBA Responsibilites.

oAs a Senior of the SQL DBA team I have to take care of Sql Engineering and Sql Operations activities daily

oExpert on MS SQL Server2019, 2017,2016/2014/2012/2008 R2/2008, MS SQL Failover, SQL Server Agent, BCP, Transparent Data Encryption (TDE), Index Tuning, Perfmon, Profiler, Database Tuning Advisor, DMVs, DMFs, Wizard, DBCC Commands.

oKnowledge of SQL Server best practices for database security, availability and recoverability.

oSkilled in performance tuning and Query Optimization using execution plan, SQL Server Profiler and Database Tuning Advisor to resolve dead Locks, long running queries & slow running Queries.

oWorked on Azure IAAS, PAAS, SAAS model and Managed Instance,Single database,DTU,Vcore model.

oPrimarily involved in Data Migration using SQL,SQL Azure,Azure Storage and Azure Data Factory SSIS.

oExperience in solving Database issues with Index fragmentation, DBCC checks, Optimization of Query, Data Integrity, Index tuning, Update Statistics, Error and Event Handling.

oUsed ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into target tables.

oDeveloped and installed SSIS packages, windows tasks and SQL Server Agent Jobs.

oManaging deployment of database objects and structure changes to various environments

Support ETL/BI specialists and application developers

oExpertise in creating, setting up and scheduling SQL maintenance jobs for database administration.

oProactively Azure address issues to ensure optimum performance,Maintain database integrity, stability and availability.

oI have an experienced with powershell script writing and Automated works by powershll.

oCreated and implemented backup, recovery plan and point-in-Time Recovery based on requirements.

oWork on Azure database deployment and monior the database in metricks.

oExperience with data migration to cloud based environment and on-premise

oWorked on Database migration, upgrade, patching and sql server installation .

January 2015 to September 2019

SQL Server Database Administrator

Deutsche Bank, New York, New York.

Responsibilities:

oResponsible for Operations and Maintenance of the Database infrastructure including security, backups, optimization, monitoring, performance tuning etc.

oProvide database administrator support on production and development environment of SQL server 2016,2014 /2012/2008 R2/2008 and on windows server 2012R2/2008 (standalone and clustered servers).

oPerformed Database Objects Development-Table,Views,Triggers,Store procedures,Functions,Cursors and T-SQL Batches.

oInstalled, Configured, and Managed SQL Server 2012/2008 R2/2008 and SQL Server 2012 on development, test, UAT and production environment and also applied Service Packs and Hotfix.

oConfigured and Monitored Log Shipping, mirroring, Replication and Always On for the Databases as a High Availability Solution and for Reporting purposes.

oCreated and managed users and roles and monitor user accounts and added group roles.

oCreate and implement backup, recovery plan and point-in-Time Recovery based on requirements.

oCreated and modified tables, Indexes, Constraints, Views, to improve scalability and performance.

oMonitored SQL Server to resolve deadlocks/Blocks, memory, index, and other performance issues

oExport & Import data from Flat file, CSV file to/from SQL Server Database using SSIS .

oEnsured smooth system backups, recoveries, data import/export, Index Tuning, and complete SQL system software configuration.

oExperience in Performance Tuning and Optimization (PTO), profiling, and using native monitoring and troubleshooting tools.

oAdministered and used JIRA for ticketing and for future documentation.

June 2013 - January 2015

SQL DBA

Capital One, Mclean, VA Responsibilities:

oSQL Serve 2008 R2/2008/2005 DBCC Utility Constructed up-to-date Service Packs/ Hot Fixes onto an SQL Server with proper implementation of SQL Logins, roles, and authentication modes with adherence to security policies companywide.

oRebuilding indexes using jobs at regular intervals for better performance.

oDesigned and implemented comprehensive Backup plan and disaster recovery strategies.

o Monitored and modified Performance using execution plans and Index tuning.

oDeploying new code base release to Testing and Production Environments.

oManaging deployment of database objects and structure changes to various environments

Support ETL/BI specialists and application developers.

oConducted Data Analysis with data profiling, data verification, data lineage, data migration, data quality, and data validation.

oParticipated in the ETL job design and testing in data warehouse.

oCreated and utilized Source to target documents, business rules documents, and technical documentation.

oResolved database errors and Corruptions using DBCC utility.

oTroubleshoot fixed issues on scheduled maintenance plan and configure DB mail

oServers Performance problems,fine-tuning of Databases,servers, Index Analysis.

oVerified and maintained database backups, restore,recovery Index,maintenance, statistics,integrity checks scheduled jobs.

Technical Proficiencies

Operating Systems:

Windows Server 2008 R2/2012,2016,Windows 10, Windows 8 and windows 7.

Database Management:

MS SQL Server 2019/2017/2016/2014/2012/2008R2/2008, 2005.

Tools:

SQL Server Profiler, SQL Query Analyzer, Index Analyzer, SQL Server Management Studio, Perfmon Counter, Database Tuning Advisor, Execution Plan, DBCC, DMV, DMF,Crystal Report, Microsoft Visual Studio,(SSIS,SSRS,SSAS). Azure data factory, Azure synapse.

Programming:

SQL, T-SQL, PowerShell,

Education and Certification

Masters of Arts, 2007- University of Dhaka.

Microsoft @Certified Solutions Associate (MCSA-H578-8361)

Microsoft Azure Administrator Associate(H536-7263)

Work Authorization – US Citizen

Contact this candidate