SUMMARY

• Excellent understanding of conceptual, logical, and physical database modeling and software development life cycle (SDLC)
• Strong understanding of the database development life cycle including data modeling, database coding, testing, and implementation
• Provisioning an Azure SQL Server and SQL Azure database through Azure web portal and Azure PowerShell
• Configuring server level and database level firewall rules to connect to secure SQL Azure server
• Setting up Active Geo - Replication using Azure web portal and PowerShell
• Database administration on Production and non-production MSSQL Servers with server configuration, performance tuning, and maintenance with troubleshooting capabilities.
• Installing and configuring SQL Server on standalone and clustered environments, SSIS, SSRS and SSAS and Applying Service packs, patches, hotfixes, and cumulative updates.
• Excellent understanding of SQL Server architecture and Database storage structure
• Have experience with Normalization (1NF, 2NF, and 3NF) techniques for improved database performance in OLTP environments.
• Experience in implementing Business logic by using T-SQL Objects like stored procedures, triggers, and user-defined functions (UDF).
• Worked on Virtualization technologies like VMware, Virtual Box, and Hyper -V
• Migration of databases Side-by-side and in place upgrade from old version to newer version and from one edition to another edition
• Experience in analyzing Performance, Query optimization and tuning, creating Indexes and re-writing and tuning stored procedures
• Worked with system administrators and developers to migrate databases from SQL Server 2008 to SQL Server 2012 and SQL Server 2016
• Identified the I/O and memory bottlenecks, blocking and deadlocks caused by complex queries using SQL Server Activity monitor/profiler, Dynamic Management Views (DMV) and handling them by implementing better Query Execution plans
• Solid experience and outstanding knowledge on High availability (HA) and Disaster recovery (DR) solutions like log shipping, Mirroring (HIGH safety and High performance), Replication (Snapshot & Transactional), Clustering and Always on
• Designing and implementing database Backups including Full, Differential & Transactional log and restoring databases based on the company’s RPO and RTO
• Excellent knowledge of point-in-time recovery of databases
• Experience in automation of administrative tasks like creating Maintenance plans, creating Jobs, Alerts using SQL agent and monitoring and troubleshooting Job Failures
• Owning, tracking, and resolving database related incidents and requests, fulfilling requests and resolving incidents within SLAs.
• Responding to database related alerts and escalations and working with engineers
• Experience in Managing Windows server, Active Directory and SAN disk configurations
• Experience in Creating and deploying SSRS reports
• Experience in Data Extraction, Transforming and Loading (ETL) packages and deploying on a production server
• Experience in Azure Big Data technologies
• Adding and monitoring servers via SCOM
• Expert knowledge on cloud technologies with hands on experience in Microsoft azure
• Managed and configured azure data factory, data warehouse, data lake store/analytics, logic apps,
• Monitored and troubleshooted azure data factory pipelines
• Performed azure VM migration using Azure site recovery services
• Performed a VM migration from on-premise to azure using a lift and shift method
• Created extended events session for performance-related issues and for auditing purpose
• Created azure automation accounts for patching and resource optimization
• Created and configured Azure virtual machines and storages, integration runtimes, Azure data warehouse, Azure SQL database
• Scaled down underutilized VMs, SQL databases, azure data warehouse that resulted in big cost saving
• Converted unmanaged disks to managed disks and cleaned up orphaned disks that resulted in cost saving, fewer footprints, and improved performance
• Created and configured alerts and audits for tracking administrative operations like resource creation, deletion etc. in our azure subscriptions
• Troubleshooted CPU, Disk I/O and Memory related bottlenecks, blocking and deadlocks by using activity monitor, SQL logs, extended events, perfmon, azure metrics, query store, and other mechanisms
• Created and applied system-hardening checklists for our virtual machines that resulted in performance improvement
• Created a maintenance plan that will save backups to azure blobs as part of our disaster recovery plans
• Configured ASR and azure VM backup as a disaster recovery plan
• Created and managed azure virtual networks

TECHNICAL SKILLS

• SQL DBA
• DBA
• ETL
• PostgreSQL
• Azure
• Microsoft SQL Server
• SSIS
• Disaster Recovery
• Scripting
• MySQL
• Linux
• ADF, Azure Data Lake, Azure Databricks, Azure Log Analytics, Azure DevOps, Azure Active Directory

PROFESSIONAL EXPERIENCE

SQL/Azure SQL DBA

Confidential - Stamford, CT

Responsibilities:

• Worked on Azure SQL database and Azure SQL data warehouse (PaaS)
• Worked on Migration and SQL upgrade projects. Migrated on premise databases to the cloud (Azure)
• Used Azure DevOps CI/CD pipelines for deploying Azure SQL Servers and Databases.
• Worked on securing Azure SQL databases and Data warehouse in terms of Server level and database level firewalls.
• Worked on troubleshooting performance and connectivity issues in Azure SQL databases
• Worked on Azure Data Factory, Azure Synapse Analytics, Azure Storage Accounts, Azure Databricks for data engineering workflows
• Managed Identity and Role based Access (RBAC) using Privileged Identity Management (PIM)
• Worked on Setting up different Vnet and Subnets for different environments
• Worked on Azure Database for PostgreSQL, MySQL, and Azure Cosmos Db
• Implemented different auto scale down and up jobs for Cost Optimization for Azure SQL Data Warehouse.
• Managed SQL Servers on Azure Virtual Machine (IaaS)
• Worked on setting up High availability and Disaster Recovery solutions like Geo-replication
• Planned and implemented Database Backup strategy with associated Disaster Recovery procedures according to RPO, RTO, and SLA of the company
• Used Windows PowerShell and different Maintenance plans to automate tasks like updating statistics, reorganizing, and rebuilding Indexes and check the consistency of databases
• Removed Security Vulnerabilities from Multiples Machines on both On Premise and Azure by consistently applying patches and hot fixes
• Solved Concurrency problems of blocking and deadlocks, by viewing and tracking them using Activity Monitor and Management Studio summary page and Profiler
• Configured SQL Server Reporting service, developing, and publishing reports
• Implemented and monitored SQL server high availability and disaster recovery solutions like Log Shipping, Mirroring, Clustering and Always on Availability Group
• Evaluating CPU, Disk I/O and Memory related bottlenecks, blocking and deadlocks by using activity monitor, SQL logs, SQL Profiler & other tools
• Installed and Configured SQL Server on virtual like VMware and Virtual server
• Responding to requested tickets and fixes any database issues.
• Working with CDC, Data Compression, and TDE
• Set up baseline workloads using the SQL profiler and database tuning advisor (DTA) which resulted in providing the missing and superfluous indexing on tables.
• Configured SSRS using configuration manager, created, and maintained security roles
• Responsible for creating and deploying reports based on requirements using SSRS.
• Used Various SSIS tasks such as Conditional Split, Derived column for Data Scrubbing
• Used SSDT to extract data from multiple sources (Excel and flat files) and load into SQL Server databases and from SQL Server to Spreadsheets.
• Deploy SQL scripts in production environments, applying patches, performing code review/optimize SQL for reporting, interfaces, and data conversions.
• Executed Change management scripts on daily/weekly basis

Environment: MSSQLServer2008R2/2012/2014, MS Access, Azure DevOps, Azure Portal, PowerShellWindows 2003/2008/2012 /2016/2017 DTS/ SSIS, SSRS, Visio, Lite speed, SQL Diagrams, Index tuning wizard, SQL Profiler, Query Analyzer, HPSM, PowerShell, Service Now, Jira

MSSQL Server Production DBA

Confidential - Richmond, VA

Responsibilities:

• Responding to developer issues and guiding them to write performing T-SQL codes.
• Worked on Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to multiple Terabytes.
• Developed and created new database objects including tables, views, index, stored procedures and functions
• Created Entity-Relationship diagrams and flow diagrams using Visio and documenting
• Created maintenance plans to automate updating statistics, reorganizing, and rebuilding Indexes and check the consistency of databases
• Addressed SQL Server security issues by creating user logins with the principle of least privilege and monitoring those user accounts regularly by using SQL Profiler
• Planned and implemented Database Backup strategy with associated Disaster Recovery procedures according to RPO, RTO, and SLA of the company
• Used Windows PowerShell and different Maintenance plans to automate tasks like updating statistics, reorganizing, and rebuilding Indexes and check the consistency of databases
• Solved Concurrency problems of blocking and deadlocks, by viewing and tracking them using Activity Monitor and Management Studio summary page and Profiler
• Configured SQL Server Reporting service, developing and publishing reports
• Worked with developers during Capacity planning, logical and conceptual modeling and ER- diagram development of databases and placement of data
• Implemented and monitored SQL server high availability and disaster recovery solutions like Log Shipping, Mirroring, Clustering and Always On Availability Group
• Evaluating CPU, Disk I/O and Memory related bottlenecks, blocking and deadlocks by using activity monitor, SQL logs, SQL Profiler & other tools
• Installed and Configured SQL Server on virtual like VMware and Virtual server
• Responding to requested tickets and fixes any database issues.
• Working with CDC, Data Compression, and TDE
• Set up baseline workloads using the SQL profiler and database tuning advisor (DTA) which resulted in providing the missing and superfluous indexing on tables.
• Configured SSRS using configuration manager, created and maintained security roles
• Responsible for creating and deploying reports based on requirements using SSRS.
• Used Various SSIS tasks such as Conditional Split, Derived column for Data Scrubbing
• Used SSDT to extract data from multiple sources (Excel and flat files) and load into SQL Server databases and from SQL Server to Spreadsheets.
• Deploy SQL scripts in production environments, applying patches, performing code review/optimize SQL for reporting, interfaces, and data conversions.
• Executed Change management scripts on daily/weekly basis

Environment: MSSQLServer2008R2/2012/2014, MS Access, Azure, Windows 2003/2008/2012 , DTS/ SSIS, SSRS, Visio, Lite speed, SQL Diagrams, Index tuning wizard, SQL Profiler, Query Analyzer, HPSM, PowerShell

SQL Server Production DBA

Confidential - Houston, TX

Responsibilities:

• Installed, configured, administered, and secured SQL server 2005, 20008R2, 2012/2014 on production and non-production in Clustered and Standalone server environments.
• Configured and monitored Always On availability group on windows failover cluster
• Re-synced availability database on all replicas using T- SQL script and manually.
• Implemented SQL Security and object permissions like creating end users and logins and assigning roles to the users and managing user permissions
• Identify orphan users in the servers, successfully migrated end users between multiple servers.
• Developed and approved T-SQL scripts to production SQL server databases
• Worked on production issues like log space full, blocking and deadlocking
• Worked in a process-based environment, responded to trouble tickets with various severity levels and fix any database issues promptly to meet SLA of the company
• Implemented Change requests and infrastructure service requests on a regular basis
• Redesigned and placed the physical files of a tempdb database on their own drives.
• Reassessed database capacity growth patterns and set up accounts for the SQL Server to avoid using the SA account.
• Posting an Incident resolution ticket, perform Root cause analysis and documenting solutions
• Performed Server buildups and decommissioning on a regular basis
• Monitored Maintenance plans and jobs to maintain database quality and troubleshooting Job failures when they occur in the system.
• Tested Backup and Recovery strategies by simulating various recovery scenarios like loss of datafiles, Transaction logs, Point in time recovery
• Worked on data maintenance tasks like Reorganizing and rebuilding indexes
• Checked database Health and consistency by using DBCC commands and DMVs
• Created SSIS Packages to Extract, Transform and Load data into Reporting instance to generate the reports easily and quickly

Environment: Windows 2008R2, 2012R2, MS-SQL Server 2016/ 2014/2012/2008 r2, T-SQL, MS SQL Server Integrated Services (SSIS), SQL Server Agent, SSRS, SQL Profiler, Visual Studio, TFS, Service Now and JIRA Ticketing System.

SQL Server DBA

Confidential

Responsibilities:

• Installed and configured SQL Server 2008 on Windows 2003/2008 servers applied service packs and security fixes in Clustered and Standalone environments.
• Worked extensively on installation, upgrade and configuration of MS SQL server 2008 and 32/64 bit SQL Server Cluster for SQL 2008
• Configured Merge and Transaction Replication from production to DR Servers and reporting server with multiple subscribers.
• Implemented high availability solutions for mission-critical databases with clustering and Always on Availability group
• Configured Log shipping using SQL Server Management Studio.
• Created and scheduled maintenance plans for tasks like backups and cleanups
• Monitored job and alerts, CPU utilization, Data and log file sizes and space availability Verify backups and error logs on the servers and troubleshoot any failures alerts
• Tested Backup and Recovery strategies by simulating various recovery scenarios
• Monitored database quality including database consistency check with DBCC, Defrag, and index tuning and monitored error logs.
• Created ETL packages with different data sources (SQL Server, Flat Files, and Excel ETC) and loaded the data into destination tables by performing different transformations using SSDT.
• Created and modified tables, stored procedures, views, indexes trigger and UDFs
• Tuned queries and improve performance by using tools like DTA and SQL Server Profiler
• Created Active Directory Users, Computers, and Organizational Units and assigned NTFS permissions by interacting with system administrator
• Installed Virtual box and created multiple VMs and installed Windows Server 2008 R2
• Worked with System administrator for configuring DHCP and Static IP Addresses for different machines

Environment: MS SQL Server 2008 R2/2008/2005, T-SQL, MS SQL Server Integrated Services (SSIS) SQL Agent, SSRS, SQL Profiler, Windows 2008/2003 server, Visual Studio, and.Net Framework.