| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Email: EMAIL AVAILABLEPhone:PHONE NUMBER AVAILABLEAtlanta, GAWork Status: US CitizenCareer 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/2019Proficiency in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilitiesProficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery planning and Security Management. Configured Service Broker and Table partitioningImplemented the new SQL Server 2016/2019 concepts like Data partitioning, Snapshot isolation, database mirroring, DDL triggers, Online indexing, DMVs, DMFs, Mail Setup, Jobs, and Alerts, DTA, SQLCMD, dedicated admin connection, MERGE statementWorked 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 ServersUsed Perfmon, profiler, DTA (Database Engine Tuning Advisor), DMVs and DMFs 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 ConfigurationsExtensively Worked on Transactional Replication, Snapshot Replication and Merge ReplicationHandled 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/2014Worked on configuring SQL Server in Single user mode and Minimal Configuration ModeData modeling experience in Physical and logical data modeling by using Erwin Data Modeler, Toad Data Modeler and Microsoft VisioExperience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support. Extensive usage of Proactive Monitoring tools of SQL ServerEDUCATION:Master of Information Technology (Year- 2018) Virginia Tech, Virginia, USAB.S. in Computer Science and Engineering (Year- 2006) University of Dhaka, BangladeshCertification & 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:DatabasesSQL 2022/2019/2017,2016,2014/2012/2008R2/2008/2005/2000,MySQL,MS-Access, DB2,Oracle 10g/11g/12c,SQL AzureProgramming LanguagesTSQL, PL/SQL, Power Shell, C, C#, VBScript, HTML, XMLSQL ToolsSQL 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 EnvironmentsMicrosoft Cloud(Azure), Amazon Web Services (AWS), Google Cloud PlatformThird Party ToolsLite speed, Erwin, Redgate, Fog lite, Spot Light, Splunk, Idera Diagnostic Manager, Autosys,SQL SentryNetworks and ProtocolTCP/IP, IPv4, IPv6, SSL, HTTP, SMTP, DNS, RDP.EnvironmentWindows Server 2003 / Server 2008 / Server 2008R2/ Server 2012, Server 2012R2/2016/2019,Unix, Linux.Professional Experiences:Zelis Healthcare, Dunwoody, GA July 2020 PresentMS SQL DBA/Database Administrator with AzureProviding 24x7 dedicated On-Call production supports for SQL Server problem resolution and server outages.Primary Pager Duty /On call one week in every monthWorking with build team to install, configure SQL as Microsoft StandardInstalled, configured and upgraded SQL Monitoring tool Idera Diagnostic Manager and Solarwinds SQL SentryStrong skill on performance tuning, troubleshooting, High availability, Disaster Recovery, Migration, upgradeMaking ready build requirement for any new build server, new technology, DR and High Availability solutionStrong experience on making build requirement & implement SQL Always On, Failover cluster, Log Shipping, Mirroring, ReplicationMigrating Database from 2014/2016/2017/2019 to 2022 with latest Patch/CUConfigure and Maintain Always On HA on SQL Server 2012/2014/2016/2017/2019/2022 for Prod and Non ProdConfigure and Maintain Failover Cluster on SQL Server 2008R2/2012/2014/2016 for Prod/DR/Non ProdSupport on SQL Log Shipping, SQL Failover Cluster, Always on AG, Mirroring and DR SituationSupport on Prod, DR, Staging, QA, Dev and Lab serversInstalled 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, upgradeResponsible 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 logsCreating T-SQL, stored procedures, tables, views, functions, triggers and indexesInvolve 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 etcExperiences on storage system and mount point configurationUsing 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 scheduleUsing Idera SQL Diagnostic Manager to analyze workload in Instance view and Business ViewsWorking with installation, configuration and creation of SSRSWorking with Data Warehouse team, Configure Analysis serviceStrong 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 toolManaged all ServiceNow and Jira tickets in Daily Stand up/Scrum callWorking on MS Visual Studio 2013 Team Web Access for file transferWorking on TDE (Transparent Data Encryption) and Vormetic encryptionWorking on Maintenance plan to configure jobs, alerts, SMTP, OperatorWorking on SSMA to migrate Database from MySQL/Oracle to MSSQLWorking on RP (Replicated Storage) for DR SolutionPart Time Support on MySQL,PLSQL and Oracle Database in build side and run sideSupport on SQL Cloud Azure, AWS; Ability to manage multiple projectsUsing Dynatrace, Monitor storage performance and SQL performanceMigration SQL from Premise to Azure, Working with Azure Storage AccountTable partitioning, Merging old records as schedule basisWorking experience with enterprise document management systems and Share PointExperience in an Agile environmentWorking on Automation and ScriptingWorking with SQL Server Performance tuning and Optimization ClinicImplement and Enforce Database Security policies and proceduresEnsure databases comply with industry standards, regulations and best practicesManage Delphix for Snapshot, masking,VDB,Refresh DB from Prod to Non ProdLead on DR Drills, Working with Networking and Infrastructure teamUsed ETL tools like DTS, SSIS, Import/Export, BCP (Bulk Copy), to import & export data from flat files, and excel to MS SQL Server databasesConfiguring IIS(Internet Information Services) in windows machineEquifax, Alpharetta, GA Jan 2020 June 2020MS SQL DBA/Database Administrator with AzureInstalling, 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 supportUpgrading SQL Server software to new versions and applying service packs and hot fixesWorking on Database Backup and Recovery proceduresScheduled and maintained routine Jobs, Tasks, Alerts and Maintenance PlansUsing Performance Monitor/Profiler to solve Dead Locks/Long running queriesMeeting the Service level agreements for the various customers.Disaster recovery and Log shipping of SQL ServersConfigure and maintain SQL Mirroring, Log shipping, Replication and Clustering, Always onProviding 24x7 technical database support for SQL Database systemsSupporting and managing multiple Production, Staging & Development instancesCreating 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 SSRSWorking with SSIS and DTS package to import & export operations in and out of the SQL Servers.Configure Analysis serviceConfiguring Azure Services PaaS, IaaS and Migrated databases from on-premises to AzureConfigured development and test environment on AzureCreating and monitoring Azure SQL Server databasesConfigured and Maintained Elastic DB poolsConfiguring and monitoring Geo ReplicationConfigured failover groups to provide high availability for PAAS SQL ServerWorking with Database Synchronizations using HUB-MEMBER TopologiesConfiguring backups and restoring database from recovery vaultConfiguring Server level and database auditing for SQL serverConfiguring CPU, Disk, DTU usage alerts and Monitoring for Azure SQL serversAbility to select correct tier for Azure SQL Databasesworking with Performance Metrics and Plan ManagementConfigured server level and database level firewalls as per security complianceImplementing TDE (Transparent Data Encryption) and DDM (Dynamic Data Masking) FeatureDeployed Azure IaaS virtual machines (VMs) and Cloud services (PaaS role instances) into secure VNets and subnetsConfigured Always on Availability groups using Cloud VMsExperience in using the tools AZ copy and storage explorer to migrate the databases from on premise to Cloud VM and PAAS SQL serversProvided high availability for IaaS VMs and PaaS role instances for access from other services in the VNet with Azure Internal Load BalancerMigrating the on premise database to Cloud and from cloud to on premise using multiple methodsUsed Database Migration Assistant tool to migrate the large databases to PAAS Server and VMPart Time support on MySQL and Oracle Database in build side and run sideGeneral Electric /Synchrony Financial, Alpharetta, GA March 2014 Jan 2020MS SQL DBA/Database AdministratorProviding 24x7 dedicated On-Call production supports for SQL Server Performance issue/OutageStrong skill on performance tuning, troubleshooting, High availability, Disaster Recovery, Migration, upgradeSupport 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 ProdInstall and configure MSSQL 2017 in Non Prod environmentConfigure and Maintain Failover Cluster on SQL Server 2008R2/2012/2014/2016 for Prod/DR/Non ProdSupport on SQL Log Shipping, SQL Failover Cluster, Always on AG, Mirroring and DR SituationUsing 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 scheduleUsing Dynatrace, Monitor storage performance and SQL performanceConfigure and Maintain AG in AzureOn Call Page Duty support one weak in each monthMaking ready build requirement for any new build server, new technology, DR and High Availability solutionStrong experience on making build requirement & implement SQL Always On, Failover cluster, Log Shipping, Mirroring, ReplicationSupport on Prod, DR, Staging, QA, Dev and Lab serversResponsible 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 SSRSWorking 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 toolWorking on TDE (Transparent Data Encryption) and Vormetic encryptionWorking on Maintenance plan to configure jobs, alerts, SMTP, OperatorPart Time support on DB2, MySQL, OracleWork on AutomationMigration SQL from Premise to AzureWorking with Azure Storage AccountCreate Jobs, Alerts, Maintenance Plan, ScheduleTable partitioning, Merging old records as schedule basisImplementation of SQL Logins, Roles and Authentication modes as a part of security policies for various categories of user supportInternal Revenue System (IRS), Washington DC July 2013 to February 2014Database Administrator SQL ServerInstalled, Configured, and Managed SQL Server 2005, 2008,2008 R2,2012 in development, test, and production environmentConfigure and Maintain Failover Cluster on SQL Server 2012 and 2008R2 for Prod and Non-ProdConfigured 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 SSISManaged Backup/Restore, Point-in-Time RecoveryManaged SQL Server Error Logs, space usage, growth patternUpgraded MS Access 2000 databases into MS SQL Server 2005 and 2008Expertise in database Performance tuningETL 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 databasesSecurity Management: Created and Managed users, roles, security at object level, data encryptionCreated 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 engineeringInstalled, Configured, Developed and Managed Report in SSRS (SQL Server Reporting Services) including managing securitiesExport & Import data from Oracle, Excel, Flat file, CSV file to SQL Server Database using EXP/Imp and DTS toolsHave experience on other tools like Share point, VPN, AD (Active Directory), Portals, Bulletin Board, VisioMigrated MySQL 4.1.0, Oracle 10g/11g databases to SQL Server 2008 R2Installed, Configured, and Managed SQL Server 2012 in Development and Test environment.Everbank, Jacksonville, Florida Jan 2013 to June 2013Database Administrator SQL ServerInstalled, Configured, and Managed SQL Server 2000, 2005, 2008,2008R2 in development, test, and production environmentInstalled 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 ReplicationsConfigured and Managed Log Shipping including Standby database for reporting purposesAdministered Fail-Over Clustering in SQL Server 2008R2Managed Backup/Restore, Point-in-Time Recovery including backup verificationManaged Server, Database Roles and Security for different users and user groupsUpgraded databases from SQL Server 2000/2005 to SQL Server 2008/2008 R2in Test and Production EnvironmentUpgraded MS Access 2003/2000 databases into MS SQL Server 2000, and 2008Applied SP (Service Pack) on SQL Server 2000, 2005, and 2008,Applied Patch SP2 on Windows Server 2003/2008Expertise in database Performance tuning,T-SQL, Stored-Procedures, TriggersCreated and managed Index, Constraints, Keys (PK, FK)Worked on different Data Modeling projects including creating scripts, E-R Diagram, backward/forward engineeringProcessed 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 toolSetup automated jobs for different purposes including backup, monitoring database health, disk space, backup verification, moving databases from environment to environment including creating test environmentDeveloped Different Maintenance Plans such as backups, index management, fragmentation management, cleaning history, deleting old filesSecurity Clearance: Clearable, References:Available upon request, Citizenship: U. S Citizen |
