SUMMARY

• 11+ years of experience in designing and developing database solutions for industry verticals like healthcare, healthcare Manufacturing and Public domain
• Experience in Installation, Configuration, Maintenance and Administration of SQL Server 2019, 2016,2014, 2012, 2008R2
• Experience in Installation, Configuration, Maintenance and Administration of SQL Servers
• Good experience inDatabase design & architecture
• Good Experience inBackup & Recoveryscenarios
• Good experience in implementing High Availability & Disaster Recovery solutions usingAlways ON, Clustering, Replication, Mirroring and Log Shipping
• In - depth knowledge onDatabase Internals
• Good knowledge & experience on Cloud Computing like Azure/AWS
• Experience working as aDEVOPSAutomation Engineer for database deployment
• Experience in designingETLfor data movement between excel, flat file, RDBMS like Oracle, DB2 and SQL Server using Bulk Insert, BCP utility, DTS and a variety of SSIS (ispac) packages including custom transformations for a wide range of business requirements
• Expert in Troubleshooting, Optimization and Performance tuning of SQL Server database server (Ex., Query Tuning, Server Tuning, Disk Performance Monitoring, Memory Pressure, CPU bottleneck etc.)
• Handlinglocking,Blocking&DeadlockScenarios
• Expertise inIndex tuning, rebuild, reorgstrategies
• Extensively worked on system analysis, design, development, testing and implementation of projects (SDLC) with different methodologies likeAgile, Scrum & Waterfalletc. and capable of handling responsibilities independently as well as a proactive team member
• Experience in Data Centre Migration Activities
• Good knowledge and understanding ofVirtualization (Hyper-V)
• Provided24x7 production supportfor SQL Server databases on standalone and Clustered Servers with sizes ranging from 100s of GB to 20+ TB to achieve maximum performance and uptime in production environment
• Experienced in troubleshooting3-Tier Architecture
• Azure Cloud Computer Solutions, Azure Data Explore using Kusto Query Language
• Good knowledge in BizTalk & IIS
• Hyper-V production Support provided on Nutanix Platform

TECHNICAL SKILLS

Database Version: SQL Server,2005,2008R2,2012,2014,2016,2019

Platform: Windows, 2008 R2, Ubuntu 20.1 LTS (SQL Server 2017 on Ubuntu)

Tools: Used: Sentry One, Idera, SQL Lite, Spotlight, Red gate SQL Compare, Ignite8, Solar Winds Performance Analyzer, Power shell, SQL Sentry Plan Explorer, Dynatrace, DMVs, DBCC Commands

Development Tools: SSMS, Azure Data Studio, Visual Studio 2010,2012,2013,2015,2019, BIDS 2005,2008,2012

ETL Tools: SSIS, DTS, SSAS, SSRS, Crystal Reports, Excel, Power BI

Version Control: TFS 2015,2012,2010, Azure DevOps

Modeling Tools: Erwin, MS Visio

Project Management: Version One

Programming Languages: T-SQL, MDX/DAX, C#

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Sr. SQL DBA / Azure Database Engineer

Responsibilities:

• Design, implement and administer databases on MS SQL Server 2014/2016 platforms for OLTP
• Migrationof SQL Server Instances from 2008 R2 to,2014,2016
• Migrating on-premises SQL Server Database toAzure
• Implemented new SQL Server features by performing successfulPOCs
• Experienced in providing analysis onHigh availability/Disaster recovery&scalability
• Good Understanding & Knowledge onCloud computing architecture, technical design and implementations including Infrastructure as a Service (IaaS), Platform as a Service (PaaS) and Software as a Service (SaaS)
• Experience in managing Very Large databases (VLDB) and troubleshooting problems
• Migration of database to Azure SQL Database
• Familiar with Logic apps in Azure for Creation of Triggers.
• ImplementedExtended Eventsto replace custom scripts for monitoring & troubleshooting issues
• Design & ImplementedIn-memory tablesin 2016 OLTP database server
• Use ofQuery Storefeature for monitoring performance of database systems
• ScriptingPowerShellto automate database/Server level activities like monitoring disk space, Status of services etc.,
• Requirement from business users for reporting framework.
• SSIS package to pull data from production to Staging tables for Datawarehouse for ETL process.
• Created Reports using SSRS 2019 reporting.
• SSAS OLAP cube process for reports.
• Created Power BI reports for data visualization.
• Visual studio tools used for creating SSRS; SSIS and SSAS.
• Created Reports using tableau reporting tools
• Experience in Syspro ERP application Server
• Experience with all aspects of DBA.
• Monitoring tools used SentoryOne, Native SQL Server, SQL Digger.
• Have Good understanding & experience on differentRAIDlevels
• Good knowledge onNetworkingconcepts andProtocols
• Worked on Nutanix environment for creation of Hyper- V servers.
• Experienced in Securing data with Dynamic Data Masking, Always Encrypted, Row-level security
• DesignedETLprocess to moveCDCdata for reporting purpose as per business needs
• Configuringdatabase instancesfor Development and Testing purpose

Confidential, Atlanta, GA

Sr. SQL Server DBA/ Consultant

Responsibilities:

• Design, implement and administer databases on MS SQL Server 2012/2014 platforms for OLTP
• Managed over200+database servers monitoring, working on incidents and providing support
• Performed as aTech Lead(Managing several application teams) in Agile to Administer, guide teams in Code development, Migration and Performance Tuning
• Worked as aScrum masterto estimate project, discuss with business team understanding the scope and driving project completion
• Proficient in usingDynatraceto troubleshoot performance issues from Application layer to database layer
• Experience in Windows Azure,migrating database to Azure
• Experience in Migrating SQL Server databases to Amazon RDS
• Experience in Horizontal and VerticalPartitioningof tables to achieve better Performance and scalability
• Fine TuningServer/Databaselevel setting for optimal performance
• Responsible forschema & Data Migrationusing TFS, sqlPackage & Red Gate tool from Dev, Test, and QA to Prod Environment
• ManagedFinal Builderconfiguration for database deployments to DEV/TEST
• Proficient inPowerShellto monitor database servers’ health & status
• Use ofDacpac&SSDTfor automated/Manual database deployments
• Experienced in designing database and code with properIsolation levelto avoid locking and deadlock scenarios.
• ImplementedColumnar Data StoreIndex for faster response
• Extensive experience inTroubleshootingandQuery Tuningcomplex SQL Code, Stored Procedures, Triggers, Views etc., by analyzingwait stats,Execution plan&updating statistics
• Proficient in analyzingI/O, CPU, Memory issuesand providing fix using Ignite tool and DMVs
• Troubleshootinglog filespace issues,tempDbcontention
• Ensuring Database security by restricting and following corporate standards
• Experience inTFS VCwith skill set in Branching and Merging Strategy
• Good knowledge onContinuous IntegrationandContinuous Delivery Pipelinefor 3-tier Application
• Perform query optimization & performance tuning using tools like SQLProfiler, SQLQuery Analyzer, Index Tuning Wizard, Database Engine Tuning Advisor,DBCCcommands, DMVs and Third-Party Tools likeIgnite, SQLSentryPlan Explorer,Dynatraceetc.,
• Designed ETLprocess to mitigate issues with huge data transfer
• Migrated & ConfiguredSSIS in 2012version using environmental variables
• Good Knowledge in TFS 2015 and Microsoft RM

Confidential, Atlanta, GA

SQL Server DBA / Network Admin

Responsibilities:

• Installing & Administrating SQL SERVER 2005,2008,2008 R2
• Configuring 2 node SQL Server inActive/Passive mode
• Installed Stand-alone SQL Server on Windows Failover Clusters.
• Applying Patches and Hot-fixes
• Upgraded databases from SQL Server 2000 to SQL Server 2005 and
• Involved incapacity planning, sizing and database growth projections
• Involved indata center migrationactivities for SQL Server
• Expertise in Database Maintenance Plan Wizard, creating, scheduling Maintenance Jobs
• Implemented disaster recovery solution Database Mirroring, Log Shipping and Replication
• Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and scheduleDTS/SSISPackages
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS)
• ImplementedSSRSin SharePoint Integration mode for content & document management
• Implemented SQL Server OLAP services (SSAS) for building data cubes
• Developed MDX scripts to create datasets to perform reporting and included interactive drill down reports, report models
• Experience in Designing Multidimensional model, creating Parameterized Reports, KPI, Scorecards
• Designed & built Cubes with Star/Snowflake Schema, created several Dashboards and Scorecards with Key Performance Indicators (KPI) in Analysis Services (SSAS)
• Knowledge inKimballLifecycle Methodology
• Used SQL ServerProfilerto monitor and record database activities of users and applications
• Used Index tuning wizard to redesign and created the indexes for better performance
• Fine tune Stored Procedures using Execution Plan in T-SQL for better performance
• Streamlined the server/database level security by creating the Windows and SQL logins with the appropriate server/dB roles and object level permissions
• Experience inChange ManagementandProblem Managementwhich ensures/tracks code changes
• Worked in24x7 Production supportand On Call duties
• Executed Change management scripts on daily/weekly basis