Sql Server Database Administrator
Resume:
Sharafat Sarker
Email: ad8i7v@r.postjobfree.com
Phone:470-***-****
Atlanta, GA
Work Status: US Citizen
Career Summary:
Having working experience in a fast-paced environment as a Database Administrator for VLDBs in SQL Server 2008R2/2012/2014/2016/2017/2019/2022 over the Windows 2000/2003/2008R2/2012/2016/2019
Proficiency in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities
Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery planning and Security Management. Configured Service Broker and Table partitioning
Implemented the new SQL Server 2016/2019 concepts like Data partitioning, Snapshot isolation, database mirroring, DDL triggers, Online indexing, DMV’s, DMF’s, Mail Setup, Jobs, and Alerts, DTA, SQLCMD, dedicated admin connection, MERGE statement
Worked on High Availability atmosphere (Active-Active/Active-Passive Cluster, Transactional Replication). Mirroring, Log Shipping and Replication. Evicting (dropping) nodes and adding node in cluster 2008/2012/2014/2016/2017/2019. Documentation and Inventory maintenance for various SQL Servers
Used Perfmon, profiler, DTA (Database Engine Tuning Advisor), DMV’s and DMF’s for troubleshoot performance problems, fine-tuning of databases, for finding long running queries and index analysis. Worked on 32- and 64-bit SQL Server and MSCS Configurations
Extensively Worked on Transactional Replication, Snapshot Replication and Merge Replication
Handled multiple SQL Instances on Cluster for Server Consolidation projects built on SAN using RAID levels. Worked on SQL Server 2016/2017/2019 migration from SQL Server 2008/2012/2014
Worked on configuring SQL Server in Single user mode and Minimal Configuration Mode
Data modeling experience in Physical and logical data modeling by using Erwin Data Modeler, Toad Data Modeler and Microsoft Visio
Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support. Extensive usage of Proactive Monitoring tools of SQL Server
EDUCATION:
Master of Information Technology (Year- 2018) Virginia Tech, Virginia, USA
B.S. in Computer Science and Engineering (Year- 2006) University of Dhaka, Bangladesh
Certification & Training:
SQL Server Database (Microsoft Certification ID: 8204884):
Microsoft Certified Solution Associate: SQL 2016 Database(December 18,2019)
Microsoft Certified Azure Fundamentals(November 23,2019)
Microsoft Certified Azure Administrator Associate(November 27,2019 & July 22,2024)
Microsoft Certified Azure Architect Design(November 30,2019)
Administer a SQL Database Infrastructure using MSSQL 2016 (September 15,2019)
Transition MCTS MSSQL 2008 to MCSA: MSSQL 2012(August 1,2015)
Designing Database Solutions & Data Access using MSSQL 2008(July 30,2013)
Microsoft SQL Server 2008, Database Development (Jan 28,2013)
Transition MCITP DBA Skills to MCITP DBA 2008 (June 22,2012)
Designing a Database Server Infrastructure using MSSQL 2005(April 25,2011)
Optimizing & Maintaining a Database Administration Solution Using MSSQL 2005(April 18,2011)
Microsoft SQL Server 2005-Implementation and Maintenance (April 4,2011)
Oracle Database (OCA ID: OC1497136):
Oracle Database 11g Administrator Certified Associate (Jun 27,2015)
MySQL Database:
MySQL Database 5.6 Administrator (December,2018)
CISCO (CISCO ID: CSCO12805465):
CCNA Cisco Certified Network Associate (May 17,2015)
SKILLS:
Databases
SQL 2022/2019/2017,2016,2014/2012/2008R2/2008/2005/2000,MySQL,MS-Access, DB2,Oracle 10g/11g/12c,SQL Azure
Programming Languages
TSQL, PL/SQL, Power Shell, C, C#, VBScript, HTML, XML
SQL Tools
SQL Server Management Studio, SQL Navigator, Microsoft Visual Studio, SQL Server Enterprise Manager, BIDS, SQL Profiler, SQL Networking, Activity Monitor, DTA, PerfMon, SQL Configuration Manager, IIS.
Cloud Environments
Microsoft Cloud(Azure), Amazon Web Services (AWS), Google Cloud Platform
Third Party Tools
Lite speed, Erwin, Redgate, Fog lite, Spot Light, Splunk, Idera Diagnostic Manager, Autosys,SQL Sentry
Networks and Protocol
TCP/IP, IPv4, IPv6, SSL, HTTP, SMTP, DNS, RDP.
Environment
Windows Server 2003 / Server 2008 / Server 2008R2/ Server 2012, Server 2012R2/2016/2019,Unix, Linux.
Professional Experiences:
Zelis Healthcare, Dunwoody, GA July 2020 – Present
MS SQL DBA/Database Administrator with Azure
Providing 24x7 dedicated On-Call production supports for SQL Server problem resolution and server outages.
Primary Pager Duty /On call one week in every month
Working with build team to install, configure SQL as Microsoft Standard
Installed, configured and upgraded SQL Monitoring tool Idera Diagnostic Manager and Solarwinds SQL Sentry
Strong skill on performance tuning, troubleshooting, High availability, Disaster Recovery, Migration, upgrade
Making ready build requirement for any new build server, new technology, DR and High Availability solution
Strong experience on making build requirement & implement SQL Always On, Failover cluster, Log Shipping, Mirroring, Replication
Migrating Database from 2014/2016/2017/2019 to 2022 with latest Patch/CU
Configure and Maintain Always On HA on SQL Server 2012/2014/2016/2017/2019/2022 for Prod and Non Prod
Configure and Maintain Failover Cluster on SQL Server 2008R2/2012/2014/2016 for Prod/DR/Non Prod
Support on SQL Log Shipping, SQL Failover Cluster, Always on AG, Mirroring and DR Situation
Support on Prod, DR, Staging, QA, Dev and Lab servers
Installed and configured SQL server 2014/2016/2017/2019/2022 on Windows Server 2008/2012/2016, applied service packs and security fixes.
Strong skill on performance tuning, troubleshooting, High availability, Disaster Recovery, Migration, upgrade
Responsible for a large scale of database migration from SQL server 2008R2/2012 to SQL server 2012/2014/2016/2017/2019.
Support on Database Migration Side by side and in place as application requirement.
Responsible for configuring and maintaining transactional, snapshot and merge replication in production environments.
Setup HPA Audit, Qualys trace, Splunk logs
Creating T-SQL, stored procedures, tables, views, functions, triggers and indexes
Involve in creating Logical & Physical Database Design using Toad Data Modeler.
Using DDBoost & native tool ensuring all the databases are backed up on the regular basis and restoring databases as requested.
Strong knowledge and working experience in Database Backup and Disaster Recovery.
Improving database performance using SQL Profiler, Trace Flags, Execution plan and Index Tuning Wizards.
Support weekly deployment for update store procedure, trigger, Jobs, alerts, table, insert etc
Experiences on storage system and mount point configuration
Using Idera SQL Diagnostic Manager to monitor all agents, Alarms, Databases, Domains, Hosts, the servers and their jobs in a single Management Console, to run and manage reports as required and as schedule
Using Idera SQL Diagnostic Manager to analyze workload in Instance view and Business Views
Working with installation, configuration and creation of SSRS
Working with Data Warehouse team, Configure Analysis service
Strong experience on user management, assigning permissions & roles using SQL Server Management Studio (SSMS)
Working with SSIS and DTS package to import & export operations in and out of the SQL Servers.
Working with Central Management Server, ServiceNow and Jira Ticketing tool
Managed all ServiceNow and Jira tickets in Daily Stand up/Scrum call
Working on MS Visual Studio 2013 Team Web Access for file transfer
Working on TDE (Transparent Data Encryption) and Vormetic encryption
Working on Maintenance plan to configure jobs, alerts, SMTP, Operator
Working on SSMA to migrate Database from MySQL/Oracle to MSSQL
Working on RP (Replicated Storage) for DR Solution
Part Time Support on MySQL,PLSQL and Oracle Database in build side and run side
Support on SQL Cloud Azure, AWS; Ability to manage multiple projects
Using Dynatrace, Monitor storage performance and SQL performance
Migration SQL from Premise to Azure, Working with Azure Storage Account
Table partitioning, Merging old records as schedule basis
Working experience with enterprise document management systems and Share Point
Experience in an Agile environment
Working on Automation and Scripting
Working with SQL Server Performance tuning and Optimization Clinic
Implement and Enforce Database Security policies and procedures
Ensure databases comply with industry standards, regulations and best practices
Manage Delphix for Snapshot, masking,VDB,Refresh DB from Prod to Non Prod
Lead on DR Drills, Working with Networking and Infrastructure team
Used ETL tools like DTS, SSIS, Import/Export, BCP (Bulk Copy), to import & export data from flat files, and excel to MS SQL Server databases
Configuring IIS(Internet Information Services) in windows machine
Equifax, Alpharetta, GA Jan 2020 – June 2020
MS SQL DBA/Database Administrator with Azure
Installing, configuring, managing, monitoring and troubleshooting SQL Server.
Implementation of SQL Logins, Roles and Authentication modes as a part of security policies for various categories of user support
Upgrading SQL Server software to new versions and applying service packs and hot fixes
Working on Database Backup and Recovery procedures
Scheduled and maintained routine Jobs, Tasks, Alerts and Maintenance Plans
Using Performance Monitor/Profiler to solve Dead Locks/Long running queries
Meeting the Service level agreements for the various customers.
Disaster recovery and Log shipping of SQL Servers
Configure and maintain SQL Mirroring, Log shipping, Replication and Clustering, Always on
Providing 24x7 technical database support for SQL Database systems
Supporting and managing multiple Production, Staging & Development instances
Creating T-SQL, stored procedures, tables, views, functions, triggers and indexes.
Involve in creating Logical & Physical Database Design using Toad Data Modeler.
Using native tool ensuring all the databases are backed up on the regular basis and restoring databases as requested.
Improving database performance using SQL Profiler, Trace Flags, Execution plan and Index Tuning Wizards.
Working with installation, configuration and creation of SSRS
Working with SSIS and DTS package to import & export operations in and out of the SQL Servers.
Configure Analysis service
Configuring Azure Services PaaS, IaaS and Migrated databases from on-premises to Azure
Configured development and test environment on Azure
Creating and monitoring Azure SQL Server databases
Configured and Maintained Elastic DB pools
Configuring and monitoring Geo Replication
Configured failover groups to provide high availability for PAAS SQL Server
Working with Database Synchronizations using HUB-MEMBER Topologies
Configuring backups and restoring database from recovery vault
Configuring Server level and database auditing for SQL server
Configuring CPU, Disk, DTU usage alerts and Monitoring for Azure SQL servers
Ability to select correct tier for Azure SQL Databases
working with Performance Metrics and Plan Management
Configured server level and database level firewalls as per security compliance
Implementing TDE (Transparent Data Encryption) and DDM (Dynamic Data Masking) Feature
Deployed Azure IaaS virtual machines (VMs) and Cloud services (PaaS role instances) into secure VNets and subnets
Configured Always on Availability groups using Cloud VMs
Experience in using the tools AZ copy and storage explorer to migrate the databases from on premise to Cloud VM and PAAS SQL servers
Provided high availability for IaaS VMs and PaaS role instances for access from other services in the VNet with Azure Internal Load Balancer
Migrating the on premise database to Cloud and from cloud to on premise using multiple methods
Used Database Migration Assistant tool to migrate the large databases to PAAS Server and VM
Part Time support on MySQL and Oracle Database in build side and run side
General Electric /Synchrony Financial, Alpharetta, GA March 2014 – Jan 2020
MS SQL DBA/Database Administrator
Providing 24x7 dedicated On-Call production supports for SQL Server Performance issue/Outage
Strong skill on performance tuning, troubleshooting, High availability, Disaster Recovery, Migration, upgrade
Support on Database Migration Side by side and in place as application requirement.
Creating T-SQL, stored procedures, tables, views, functions, triggers and indexes.
Strong knowledge and working experience in Database Backup and Disaster Recovery.
Improving database performance using SQL Profiler, Trace Flags, Execution plan and Index Tuning Wizards.
Configure and Maintain SQL Always On HA on SQL Server 2012/2014/2016 for Prod and Non Prod
Install and configure MSSQL 2017 in Non Prod environment
Configure and Maintain Failover Cluster on SQL Server 2008R2/2012/2014/2016 for Prod/DR/Non Prod
Support on SQL Log Shipping, SQL Failover Cluster, Always on AG, Mirroring and DR Situation
Using Idera SQL Diagnostic Manager to monitor all agents, Alarms, Databases, Domains, Hosts, the servers and their jobs in a single Management Console, to run and manage reports as required and as schedule
Using Dynatrace, Monitor storage performance and SQL performance
Configure and Maintain AG in Azure
On Call Page Duty support one weak in each month
Making ready build requirement for any new build server, new technology, DR and High Availability solution
Strong experience on making build requirement & implement SQL Always On, Failover cluster, Log Shipping, Mirroring, Replication
Support on Prod, DR, Staging, QA, Dev and Lab servers
Responsible for a large scale of database migration from SQL server 2008R2/2012 to SQL server 2012/2014/2016.
Working with installation, configuration and creation of SSRS
Working with SSIS package to import & export operations in and out of the SQL Servers.
Creating T-SQL, stored procedures, tables, views, functions, triggers and indexes.
Working with Central Management Server and ServiceNow Ticketing tool
Working on TDE (Transparent Data Encryption) and Vormetic encryption
Working on Maintenance plan to configure jobs, alerts, SMTP, Operator
Part Time support on DB2, MySQL, Oracle
Work on Automation
Migration SQL from Premise to Azure
Working with Azure Storage Account
Create Jobs, Alerts, Maintenance Plan, Schedule
Table partitioning, Merging old records as schedule basis
Implementation of SQL Logins, Roles and Authentication modes as a part of security policies for various categories of user support
Internal Revenue System (IRS), Washington DC July 2013 to February 2014
Database Administrator –SQL Server
Installed, Configured, and Managed SQL Server 2005, 2008,2008 R2,2012 in development, test, and production environment
Configure and Maintain Failover Cluster on SQL Server 2012 and 2008R2 for Prod and Non-Prod
Configured and Managed Database Replications (Snapshot/Transactional/Merge)
Installed and Configured SQL Server Reporting Services (SSRS)
Responsible for developing and implementing SSIS Solutions and Configuring, Deploying, and Maintaining SSIS
Managed Backup/Restore, Point-in-Time Recovery
Managed SQL Server Error Logs, space usage, growth pattern
Upgraded MS Access 2000 databases into MS SQL Server 2005 and 2008
Expertise in database Performance tuning
ETL Tools: Used ETL tools like DTS, SSIS, Import/Export, BCP (Bulk Copy), to import & export data from flat files, and excel to MS SQL Server databases
Security Management: Created and Managed users, roles, security at object level, data encryption
Created and managed Index, Constraints, Keys (PK, FK)
Installed, Configured and Maintained Fail-Over Clustering using SQL Server 2008 for High availability solutions.
Worked on different Data Modeling projects including creating scripts, E-R Diagram, backward/forward engineering
Installed, Configured, Developed and Managed Report in SSRS (SQL Server Reporting Services) including managing securities
Export & Import data from Oracle, Excel, Flat file, CSV file to SQL Server Database using EXP/Imp and DTS tools
Have experience on other tools like Share point, VPN, AD (Active Directory), Portals, Bulletin Board, Visio
Migrated MySQL 4.1.0, Oracle 10g/11g databases to SQL Server 2008 R2
Installed, Configured, and Managed SQL Server 2012 in Development and Test environment.
Everbank, Jacksonville, Florida Jan 2013 to June 2013
Database Administrator –SQL Server
Installed, Configured, and Managed SQL Server 2000, 2005, 2008,2008R2 in development, test, and production environment
Installed and Configured SQL Server Reporting Services (SSRS)
Developed and Managed Report in SSRS (SQL Server Reporting Services)
Created and Managed Securities for Reports,Configured and Maintained Database Replications
Configured and Managed Log Shipping including Standby database for reporting purposes
Administered Fail-Over Clustering in SQL Server 2008R2
Managed Backup/Restore, Point-in-Time Recovery including backup verification
Managed Server, Database Roles and Security for different users and user groups
Upgraded databases from SQL Server 2000/2005 to SQL Server 2008/2008 R2in Test and Production Environment
Upgraded MS Access 2003/2000 databases into MS SQL Server 2000, and 2008
Applied SP (Service Pack) on SQL Server 2000, 2005, and 2008,Applied Patch SP2 on Windows Server 2003/2008
Expertise in database Performance tuning,T-SQL, Stored-Procedures, Triggers
Created and managed Index, Constraints, Keys (PK, FK)
Worked on different Data Modeling projects including creating scripts, E-R Diagram, backward/forward engineering
Processed data dump and Exported& Imported data from Flat file, CSV file, Oracle, My-SQL, and Access to/from SQL Server Database using DTS, SSIS, and EXP/IMP tool
Setup automated jobs for different purposes including backup, monitoring database health, disk space, backup verification, moving databases from environment to environment including creating test environment
Developed Different Maintenance Plans such as backups, index management, fragmentation management, cleaning history, deleting old files
Security Clearance: Clearable, References:Available upon request, Citizenship: U. S Citizen
Contact this candidate