Sql Server Database Administrator

EDUCATION

University of Rajshahi,Bangladeh

M.Sc Physics

SQL Server DBA with 10+ years of experience in SQL Server administration, Implementation, and support. Hands-on experience in supporting SQL Servers

‘2000/2005/2008/2008R2/2012/2014/2016/2017/2019/2022’ in investment banking, media, telecommunication and education industries. Offers solid track record based on professionalism, thoroughness, and dedication.

Able to work both independently and as a team player. Excellent communication, presentation and interpersonal skills.

Troubleshoot performance problems, fine-tuning of databases and index Analysis.

Migrated data between the two environments with SSIS and Import, Export wizard.

Experience with git Extension to create PR for feature branches and Release Branches.

Significant experience in creating Release Guide.

Experience with git Bash to create PR for feature branches and Release Branches.

Experience with Visual Studio to create PR for feature branches and Release Branches.

Experience with git Extension to resolve the conflict of the PR for feature branches and Release Branches.

Experience in working with SSRS, SSAS.

Working experience migrating on-prem databases to Cloud environments.

Expertise on Production Server with Server Configuration, patch, upgrade, maintain complex and huge databases, and apply encryption to sensitive data and migration experience.

Expert in creating and developing Power BI Dashboards in to rich look.

Experience in Disaster Recovery Planning and Security Management operations.

Experience in troubleshooting SQL issues by using SQL Tools, execution plans, Trace, statistics, index tuning wizard.

Experience in installation, maintain,manage and configure HA Solution such as (WSFC) Cluster, Always ON, Replication, Mirroring and Log Shipping.

Maintained individual service accounts for SQL Server Services on cluster.

Experience in working in a team as well as individual and writing documentation.

Experience in Managing SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.

Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.

Designed data Partitioning solutions for tables and indexes & Risk Monitoring.

Create jobs, Alerts, Maintenance plans to perform index defragmentation, reorganize index, rebuild index, and update the index statistics.

Implemented various Replication Models such as p2p, Merge, Transactional and Snapshot on the basis of business specification.

Experience in using Performance Monitor, SQL Profiler and optimized queries, traced long running queries and deadlocks.

Experience in SQL Scripting and automation in Test, Development and Production Server.

Experience with working knowledge with Microsoft Azure in windows platform.

Experience in migration of databases from SQL Platform to Azure Platform.

Strong MS Outlook, Word, Excel knowledge.

Certification:

Microsoft Certified Solutions Associate: SQL SERVER 2012/2014.

Microsoft Certified IT Professional: Database Administrator 2008.

Microsoft Certified Technology Specialist: SQL Server 2008, Implementation, and maintenance.

Azure Database Administrator Associate Certification

Professional Experiences

SQL Server DBA

United States Department of Agriculture

Fort Collins, CO

November 2020 to Present

Responsibilities:

Perform database deployments and provide support for application releases.

Experience with git to control source code for any tool scripting developed.

Experience being part of a continuous integration and deployment process.

Significant experience in Migration from on-premise to Azure SQL Platform

and SQL Server 2016 to SQL Server2019.

Executes and troubleshoots database backup,DR Plan and Implement Backup Strategy.

Experience with git Extension to create PR for feature branches and Release Branches.

Significant experience in creating Release Guide.

Experience with git Bash to create PR for feature branches and Release Branches.

Experience with Visual Studio to create PR for feature branches and Release Branches.

Experience with git Extension to resolve the conflict of the PR for feature branches and Release Branches.

Creates and executes results from simple ad-hoc SQL queries.

Monitors and troubleshoots SQL server health, including database status, security, indexing, logging, and similar issues that may affect performance, security, integrity, or availability.

Monitors and troubleshoots general SQL database custom code and configurations including stored procedures, replication, SQL jobs, and DTS/SSIS packages. Identifies and applies changes to SQL data, SQL databases, SQL server settings, instance settings, and database code.

Interprets output of database management tools and queries and determines recommended course of action to resolve or prevent issues.

Participates in database architecture and design projects and activities.

Fully understands database infrastructure and processes to recognize and implement improvements.

Adheres to and complies with company database standards, policies, procedures, and best practices; assists with creating and/or updating, as dictated by business needs.

Assist developers with MS SQL Server issues and questions.

Interface with developers, network, virtualization, storage and system operations, teams to resolve problems with applications and database systems.

Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users and using TDE for ensuring sensitive data.

Implemented partitioning for both tables and Indexes.

Experience in Query Plans, Query plan Optimization for TSQL.

Maintain and troubleshoot Bidirectional Transactional Replication.

Monitoring pro-actively Disk, CPU, Memory, I/O issues.

Automated SQL queries and developed custom SQL Agent jobs to streamline database operations; created and maintained SQL maintenance and clean-up jobs using Ola Hallengren’s SQL Server Maintenance Solution.

Deploying Database Changes in Dev, Test, Cert, Production Environment.

Implementing Partitioning for File and Filegroup based on time duration.

Environment: MS SQL Server 2016, MS SQL Server 2019, MS SQL Server 2022, Microsoft visual Studio 2017, Microsoft visual Studio 2019, Replication, Windows Server 2016, TSQL, .Net Framework, C#.Net, Java8 Update60, MS TFS, MS-Access, SSMS, SharePoint 2010, Oracle 10g, JIRA, Notepad++, Microsoft Visual C++2013,VNC Server5.3.2,Adobe Flash Player 27 NPAPI, Bit Bucket, Xymon, Splunk, Jira Confluence, Git, Git Extension, Git Bash.

SQL Server DBA

Department of Administrative Services

State of Oregon

March 2020 to October

Salem, OR

Responsibilities:

Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.

Rebuilding / Monitoring the indexes at regular intervals for better performance.

Maintain database consistency by checking with DBCC Utilities at regular intervals.

Maintain Active/ passive and Active/ Active cluster environments with Virtual Machines.

Use Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers and uptime in production environment.

Involved in troubleshooting and fine-tuning of databases for its performance and concurrency.

Implemented partitioning for both tables and Indexes.

Successfully negotiated significant cost reductions with various vendors and utilities.

Implemented Data partitioning, Error Handling through TRY-CATCH-THROW statement, Common Table Expression (CTE).

Basic experience in MySQL.

Design and implement comprehensive Backup Plan and Disaster Recovery strategies.

Created and maintained Windows Task Scheduler Jobs.

Participate in implementation of new releases into production.

Expertise in Power BI, Power BI Pro.

Created Reports using Charts, Gauges, Tables, matrix, Stacked Reports.

Created Drill Down Reports, Drill Through Report.

Facilitates application deployment and joint effort deployments.

Environment: MS SQL Server 2016, SQL Server Clustering, Windows Server 2012 and Windows Server 2016, .Net Framework, C#.Net, JavaScript, MS TFS, MS-Access, SharePoint 2010, Oracle 10g, Power BI, DevOps, Smart Vault, Commvault, Trello, RT Ticketing System, Trello, Apex SQL.

SQL Server DBA

Verizon November 2018 to February 2020

San Diego, CA

Responsibilities:

Deploys and maintains Microsoft SQL Server databases/DB projects across a range of current SQL Server versions in both physical and virtual environments.

Serve as support for database administration tasks including configuration management, backup/recovery, performance optimization, and space management.

Perform database deployments and provide support for application releases.

Assist developers with MS SQL Server issues and questions.

Interface with developers, network, virtualization, storage and system operations, teams to resolve problems with applications and database systems.

Working experience migrating on-prem databases to Iaas environments.

Planning to Configure and monitor clustering including Always on and Failover clustering.

Provides support to the user community using incident and problem management tools.

Establishes database security procedures.

Creates Custom users, assign roles and manages permissions.

Administer and monitor 24/7 applications and systems, developing automated alerts to warn of failure.

Plan and Assist database development, documentation and maintenance of databases including.

Automate SQL Agent Jobs and Failover in DR Scenario.

Working experience migrating on-prem databases to Paas environments.

Working experience with DevOPs.

Experience Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.

Experience in Query Plans, Query plan Optimization for TSQL.

Maintain and troubleshoot Bidirectional Transactional Replication.

Applied changes on Production through Change Review management after thoroughly testing on development servers.

Experience in migration of databases from SQL Server 2012R2 to SQL Server 2016 SP2 and 2008R2to SQL Server 2016.

Installed, authored, and managed reports using SQL Server 2016/2019 Reporting Services (SSRS).

Created SSIS packages to extract data from OLTP sources like MS SQL Server 2016, Text Files, Excel and Access to OLAP systems (SQL Server 2016).

Maintain and manage SQL Server Agent Jobs which also included SSIS and ETL processes.

Implementing and managing SSRS.

Basic experience in Oracle and NoSQL.

Environment: MS SQL Server 2017/2016/2012/2008R2, Always On, Windows Clustering, Replication, Windows Server 2008R2, Windows Server 2012 R2, Windows Server 2012, Windows Server 2016, TSQL, .Net Framework, C#.Net, Java8 Update60, MS TFS, MS-Access, SharePoint 2010, Oracle 10g, JIRA, Notepad++, Microsoft Visual C++2013, VNC Server 5.3.2, Adobe Flash Player 27 NPAPI, SVN Tortoise portal, Idera SQL Diagnostic Manager.

SQL Server DBA TD BANK July2017 to November 2018

North Canton, OHIO

Responsibilities:

Install and configure SQL Server Troubleshooting Performance issues and database issues.

Install and configure latest Service Packs/Hotfixes on SQL 2008R2, 2012, 2014 and 2016 servers.

Design and implement a comprehensive Backup Strategy to save disk space and Disaster Recovery strategies.

Maintain database consistency by checking with DBCC Utilities at regular intervals.

Maintain Active/ passive cluster environment with Virtual Machines.

Experience Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.

Maintain and troubleshoot P2P Replication.

Used DMVS, DMFS, and SP_PROCS for the instant analysis.

Maintain and Manage Security related issues like assign permissions and disable users.

Use Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers and uptime in production environment.

Involved in troubleshooting and fine-tuning of databases for its performance and concurrency.

Implemented partitioning for both tables and Indexes.

Applied changes on Production through Change Review management after thoroughly testing on development servers.

Successfully negotiated significant cost reductions with various vendors and utilities.

Experience in migration of databases from SQL Server 2012 to SQL Server 2014 and 2008R2to 2014.

Administer and monitor 24/7 applications and systems, developing automated alerts to warn of failure.

Used encryption for taking backup of sensitive data.

Installed, authored, and managed reports using SQL Server 2008 R2Reporting Services (SSRS).

Created SSIS packages to extract data from OLTP sources like MS SQL Server 2012, Text Files, Excel and Access to OLAP systems (SQL Server 2012).

Create documentation for steps that need to be taken while upgrading the SQL server 2008R2 to SQL Server 2012.

Maintain and manage SQL Server Agent Jobs which also included SSIS and ETL processes.

Migration experience in Production and test environments. Also have experience in migration from SQL Server to different platform and vice-versa.

Working knowledge of data modeling tools and reporting tools.

Environment: MS SQL Server 2014/2012/2008R2, Windows Clustering, Replication, Windows Server 2008R2, .Net Framework, C#.Net, Java8 Update60,

MSFTS, MSAccess, SharePoint 2010, Oracle 10g, SCOM 2012/2014, Notepad++, Microsoft Visual C++2013, VNC Server 5.3.2, Adobe Flash Player 27 NPAPI, ER/Studio,Redgate.

Database Administrator

PSECU - Pennsylvania State Employees Credit Union

March 2015 to June 2017

Harrisburg, PA

Responsibilities:

Design and implement comprehensive Backup Plan and Disaster Recovery strategies.

Migrating over 100 databases from physical servers to VMware Machines.

Maintain database consistency by checking with DBCC Utilities at regular intervals.

Maintain Active/ passive and Active/ Active cluster environments with Virtual Machines using HyperV.

Create and maintain Transactional and Peer to Peer Replication environments.

Implement Database mirroring. Configured Principal, witness and mirror on the 2008R2 SQL Servers.

Implement Asynchronous mode for Database mirroring in Staging Environment.

Use Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers and uptime in production environment.

Involved in troubleshooting and fine-tuning of databases for its performance and concurrency.

Implemented partitioning for both tables and Indexes.

Used Online Indexing and online Restoring in SQL Server 2008.

Applied changes on Production through Change management after thoroughly testing on development servers.

Successfully negotiated significant cost reductions with various vendors and utilities.

Experience in migration of databases from SQL Server 2012 to SQL Server 2014.

Experience in configuring, Maintaining and managing Always On.

Involved in normalization of the Database in OLTP.

Installed, authored, and managed reports using SQL Server 2008 Reporting Services (SSRS).

Created SSIS packages to extract data from OLTP sources like MS SQL Server 2012, Text Files, Excel and Access to OLAP systems (SQL Server 2012).

Create documentation for steps that need to be taken while upgrading the SQL server 2008R2 to SQL Server 2012.

Migration experience in test environments. Also have experience in migration from SQL Server to different platforms and vice-versa.

Monitoring, taking Backup, restoring using PowerShell.

Environment: MS SQL Server 2012/2008R2/2005, Windows Clustering, Replication, Windows Server 2008R2 and Windows Server 2003, .Net Framework, C#.Net, JavaScript, MS TFS, MS-Access, SharePoint 2010, Oracle 10g, Lite Speed.

Technical Skills

Languages: T-SQL, POWERSHELL, HTML,

ETL Tools: SSRS, SSIS, Visual Studio and Remedy MDM.

Data Model: Darwin 2.0, Erwin, and SSAS.

Reporting Tools: Microsoft Power BI, SSRS, Crystal Report and Diamond Report.

Backup Software: SQL Backup, FTP, EMC, TDP and TSM.

RDBMS & Tools: SQL Server 2000/2005/2008/2008r2 and 2012, 2014, 2016,2017,2019 MS Access 2003/2007/2010, SQL Loader and Export/Import.

Operating System: Windows NT/2000/2003/2008 and 2008r2 /2012 servers.

Third Party Tools: Xymon, Red Gate, Spotlight, SCOM and IDERA.

Ticketing System: JIRA, Remedy

Database Query Tools: MS SQL Server Query Analyzer, SQL Profiler, ETL,

SQL Server Management Studio and Enterprise Manager.

Source version Control Tools: Git, Bitbucket.

EDUCATION:

Master of Science in Physics

University of Raj Shahi, Bangladesh

Bachelor of Science in Physics

University of Raj Shahi, Bangladesh

CERTIFICATION EXAM:

EXAM

TITLE

70-461

70-461 Querying Microsoft SQL Server 2012/2014

70-462

70-462 Administering Microsoft SQL Server 2012/2014 Database

70-463

70-463 Implementing a Data Warehouse with Microsoft SQL Server 2012/2014

70-450

70-450 Designing, optimizing and maintaining DBA solutions using MS SQL Server 2008

70-432

DP-300

70-432 Microsoft SQL Server 2008, Implementation and Maintenance.

DP-300 Administering Microsoft Azure SQL Solutions

Contact this candidate