PROFESSIONAL SUMMARY:

• 9.6+ years of experience in designing and developing database solutions for industry verticals like healthcare, banking and Public domain
• Experience in Installation, Configuration, Maintenance and Administration of SQL Server 2016,2014, 2012, 2008R2, 2005, 2000
• Experience in Installation, Configuration, Maintenance and Administration of MySQL Servers
• Good experience in Database design & architecture
• Good Experience in Backup & Recovery scenarios
• Good experience in implementing High Availability & Disaster Recovery solutions using Always ON, Clustering, Replication, Mirroring and Log Shipping
• In - depth knowledge on Database Internals
• Good knowledge & experience on Cloud Computing like Azure/AWS
• Experience working as a DEVOPS Automation Engineer for database deployment
• Experience in designing ETL for 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.)
• Handling locking, Blocking & Deadlock Scenarios
• Expertise in Index tuning, rebuild, reorg strategies
• Extensively worked on system analysis, design, development, testing and implementation of projects (SDLC) with different methodologies like Agile, Scrum & Waterfall etc. and capable of handling responsibilities independently as well as a proactive team member
• Experience in Data Centre Migration Activities
• Good knowledge and understanding of Virtualization
• Provided 24x7 production support for 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 troubleshooting 3-Tier Architecture
• Good Knowledge on NoSQL database like MongoDB (University Certified), Dynamo & Cosmos DB
• Good knowledge in BizTalk & IIS

TECHNICAL SKILLS:

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

Platform: Windows 2012,2008 R2, Windows 2003, Windows 2000 Advanced Server

Tools Used: 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, Visual Studio 2010,2012,2013,2015, BIDS 2005,2008,2012

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

Version Control: TFS 2015,2012,2010

Modeling Tools: Erwin, MS Visio

Project Management: Version One

Programming Languages: T-SQL, PL/SQL, MDX/DAX, VB .NET, C#

PROFESSIONAL EXPERIENCE:

Confidential, California

Sr. SQL DBA Consultant/ Azure Database Engineer

Responsibilities:

• Design, implement and administer databases on MS SQL Server 2014/2016 platforms for OLTP
• Migration of SQL Server Instances from 2008 R2 to,2014,2016
• Migrating on-premises SQL Server Database to Confidential
• Implemented new SQL Server features by performing successful POCs
• Experienced in providing analysis on High availability/Disaster recovery & scalability
• Good Understanding & Knowledge on Cloud 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
• Implemented Extended Events to replace custom scripts for monitoring & troubleshooting issues
• Design & Implemented In-memory tables in 2016 OLTP database server
• Use of Query Store feature for monitoring performance of database systems
• Scripting PowerShell to automate database/Server level activities like monitoring disk space, Status of services etc.,
• Have Good understanding & experience on different RAID levels
• Good knowledge on Networking concepts and Protocols
• Experienced in Securing data with Dynamic Data Masking, Always Encrypted, Row-level security
• Designed ETL process to move CDC data for reporting purpose as per business needs
• Configuring database instances for Development and Testing purpose

Confidential, Louisville, KY

Sr. SQL Server DBA/ Consultant

Responsibilities:

• Design, implement and administer databases on MS SQL Server 2012/2014 platforms for OLTP
• Managed over 200+ database servers monitoring, working on incidents and providing support
• Performed as a Tech Lead (Managing several application teams) in Agile to Administer, guide teams in Code development, Migration and Performance Tuning
• Worked as a Scrum master to estimate project, discuss with business team understanding the scope and driving project completion
• Proficient in using Dynatrace to 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 Vertical Partitioning of tables to achieve better Performance and scalability
• Fine Tuning Server/Database level setting for optimal performance
• Responsible for schema & Data Migration using TFS, sqlPackage & Red Gate tool from Dev, Test, and QA to Prod Environment
• Managed Final Builder configuration for database deployments to DEV/TEST
• Proficient in PowerShell to monitor database servers’ health & status
• Use of Dacpac & SSDT for automated/Manual database deployments
• Experienced in designing database and code with proper Isolation level to avoid locking and deadlock scenarios.
• Implemented Columnar Data Store Index for faster response
• Extensive experience in Troubleshooting and Query Tuning complex SQL Code, Stored Procedures, Triggers, Views etc., by analyzing wait stats, Execution plan & updating statistics
• Proficient in analyzing I/O, CPU, Memory issues and providing fix using Ignite tool and DMVs
• Troubleshooting log file space issues, tempDb contention
• Ensuring Database security by restricting and following corporate standards
• Experience in TFS VC with skill set in Branching and Merging Strategy
• Good knowledge on Continuous Integration and Continuous Delivery Pipeline for 3-tier Application
• Perform query optimization & performance tuning using tools like SQL Profiler, SQL Query Analyzer, Index Tuning Wizard, Database Engine Tuning Advisor, DBCC commands, DMVs and Third-Party Tools like Ignite, SQL Sentry Plan Explorer, Dynatrace etc.,
• SecureFX Configuration with Perl Scripts for File Transfer
• Designed ETL process to mitigate issues with huge data transfer
• Migrated & Configured SSIS in 2012 version using environmental variables
• Good Knowledge in TFS 2015 and Microsoft RM
• Good knowledge on Chef, Docker

Confidential

SQL DBA (SME) & MySQL DBA

Responsibilities:

• Installing & Administrating SQL SERVER 2000,2005,2008,2008 R2, MySQL 5.5 & 5.6
• Configuring 2 node SQL Server in Active/Passive mode
• Installed Stand-alone SQL Server on VMWare
• Applying Patches and Hot-fixes
• Upgraded databases from SQL Server 2000 to SQL Server 2005 and 2005 to 2008
• Involved in capacity planning, sizing and database growth projections
• Involved in data center migration activities 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 schedule DTS/SSIS Packages
• 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)
• Implemented SSRS in 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 in Kimball Lifecycle Methodology
• Used SQL Server Profiler to 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 in Change Management and Problem Management which ensures/tracks code changes
• Worked in 24x7 Production support and On Call duties
• Executed Change management scripts on daily/weekly basis
• Minimal exposure and working on Sybase, Netezza