SUMMARY

• Results - oriented Database(SQL Server/Azure Database) Administrator with 15+ years of extensive experience in Planning, designing, coding, testing, Implementing, Securing and Troubleshooting database solutions in Dev to Prod environments.
• SQL Server DBA experience in Healthcare, Finance, Insurance, Mortgage and telecom domains.
• Expertise in Database migrations from On-Prem to On-Prem and On-prem to Azure(IaaS/PaaS).
• Expertise in Automation of SQL Builds, Post SQL builds, SQL Patching, creation of DB Health Check Reports using PowerShell.
• Expertise in Designing, Deploying and Troubleshooting solutions for AlwaysOn High Availability and Disaster Recovery.
• Expertise in Configuring and troubleshooting Windows Failover Clustering, Log Shipping, Snapshot & Transactional Replication.
• Having extensive technical skills and advanced understanding of SQL Server and Azure Database administration.
• Expertise in setting up and controlling user profiles and access levels for each database segment to protect important data.
• Proactive in establishing backup and recovery processes and protocols to protect and retain valuable company data.
• Hands-On experience in Performance Tuning and Automation.
• Strengths in troubleshooting and maintaining servers and systems to support smooth business operations.
• Motivated to stay informed of latest industry innovations to provide users with most up-to-date solutions.
• Excellent communicator with advanced presentation creation and delivery skills.
• Quickly and effectively identifies and resolves technical problems.
• Strong collaborator and team player with excellent communication skills and expertise in analytical problem-solving.

TECHNICAL SKILLS

Database Management Software: Microsoft SQL Server 2019/2017/2016/2014/2012/2008 R 2/2008/2005.

Cloud DatabaseTechnologies: Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure VMs.

Scripting or Automation Tools: PowerShell, DBATools and T-SQL.

Database Security: Transparent Data Encryption(TDE), Dynamic Data Masking, Always Encrypted, Row Level Security

Migration Tools: Data Migration Assistant(DMA), Azure Database Migration Service(DMS), Import Export Wizard, BACPAC.

SQL Server: Automation (Installs/Patches/post builds/Health Check Reports) using PowerShell.

Windows: Server 2019/2016/2012 R2/2012/2008R 2/2008/2003.

Windows Admin Tasks: Configuring Windows Server Failover Cluster(WSFC), Adding or Managing disks, Creating file shares etc.

SQL Server Integration Services (SSIS): Deploying, Securing, Scheduling and Troubleshooting SSIS packages.

SQL Server Reporting Services(SSRS): Deploying, Securing, Creating subscriptions for the reports. T-SQL experience in developing daily admin taks and assisting developers to fine tune the code and stored procedures.

Performance troubleshooting using: Query Store, Extended Events and DMVs, Perfrom, Server Side Trace, Trace Falgs.

High Availability and Dsiater Recovery(HADR) Technologies: AlwaysOn Failover Cluster Instances(FCIs) Availability Groups, Database Mirroring, Replication, Log Shipping

Performance Monitoring Tools: Microsoft SCOM, Quest Foglight, Quest Spotlight, Redgate SQL Monitor, Idera SQL Diagnostic Manager, IBM ITMS, IBM Guardium, Precise, BMC Remedy ITSM, Solarwinds Orion, Solarwinds Data Performance Analyzer(DPA), Logic Monitor

Backup Tools: Quest Litespeed, IBM TSM, EMC DDBoost, EMC Networker, Symantec NetBackup

Incident and Change management Tools: ServiceNow, Maximo, FrontRange Heat

Other Tools: BMC BladeLogic Automation Suite, CA Autosys, ASG Rochade

PROFESSIONAL EXPERIENCE

Confidential, Greensboro, NC

Senior SQL Server and Azure Database Administrator

Responsibilities:

• Created Automation scripts for SQL Server builds, Post-build tasks, SQL patches and Database Health Check Reports using PowerShell and T-SQL.
• Worked closely with app dev teams, Line Of Business (LOB) and Business Unit (BU) Teams
• Worked in an Agile environment and completed all the assigned stories before the end of the sprint.
• Migrated 100+ databases from On-Prem to Azure SQL Database.
• Experience in managing more than 500+ SQL Server Instances.
• Implemented and Supported Snapshot and Transactional replication systems.
• Experience in Database Administration and Data Engineering discipline with the ability to design, execute, and guide in best practices for performance and stability improvements for both SQL Server on-premise servers as well as Azure SQL servers.
• Implemented Database Encryption and security Audit for compliance requirements.
• Created Automation reports for backups, disk space, SQL Agent Job failures, users with elevated permissions etc.
• Deployed 100+ Azure PaaS SQL databases for modernize cloud ready applications.
• Produced high-standard database solutions to meet stability, reliability and performance metrics.
• Streamlined all the SQL Server in Azure VMs which includes deletion of backup BLOBs which are older than pre-defined retention period.
• Configure/Maintain/Deploy SSIS Packages.
• Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment.
• Reviews systems under development and related documentation.
• Coordinate activities of the project team and assist in monitoring project schedules.
• Experience with SQL, SQL tuning and data extraction/modification
• Managed systems and infrastructures by defining hardware requirements and planning storage capacity for Mission critical servers and databases.
• Planned and implemented security measures to safeguard vital business data.
• Handled more than 10 SQL Server migration projects.
• Migrated more than 200 databases from SQL Server 2012 to SQL Server 2017.
• Coordinated with project management staff on database development timelines and project scope. Worked in Agile environment.
• Worked closely with internal technical teams during incident resolution and root cause analysis
• Eliminated downtime by accurately implementing HA and DR Solutions.
• Created Documentation around AlwaysOn and Implemented AlwaysOn High Availability for mission critical applications
• Followed standard practices for migrating changes to test and production environments and provided technology support to meet business requirements.
• Implement complex physical data models, data dictionaries and schemas.
• Administering Azure SQL DW / Azure Synapse Analytics.
• Hands on experience with Azure Administration like deploy and configure servers, storage, Azure Data Factory(ADF), Azure Data Bricks, Azure Functions, Azure KeyVault, VNET, Subnet and Load Balancer.
• Set up and controlled user profiles and access levels for each database segment to protect important data. Implemented TSL, TDE and AlwaysOn Encryption.

Confidential, Burlington, NC

SQL Server Database Administrator

Responsibilities:

• Migrated 1200+ Database backups from EMC Networker to Symantec NetBackup client. Installed Symantec NetBackup Client on 130+ SQL Servers.
• Recovered 100+ SQL Instances using automation scripts during companywide Ransomware attack.
• Reviewed, corrected and documented AlwaysOn Implementation issues on Mission Critical applications.
• Installed SQL Server 2012/2014/2016/2017 versions through Automated Slipstreamed Installation on new servers.
• Configure/Maintain/Deploy SSIS Packages.
• Migrated On-prem SQL Servers to Azure VMs and configured Multi SQL Instances with Availability Groups.
• Implemented and Supported Snapshot and Transactional replication systems.
• Implement complex physical data models, data dictionaries and schemas.
• Used Data Migration Assistant (DMA), Azure Database Migration Services (DMS) during Azure Migrations.
• Implemented Geo-replication and Auto failover groups to Azure SQL Databases.
• Applied SQL Server service packs through automation scripts.
• Automated email notification of Backup Audit reports for Full, Differential and T-Log backups thus by eliminating huge number of emails.
• Worked closely with internal technical teams during incident resolution and root cause analysis.
• PowerShell scripting experience (Scripting from scratch and modifying existing scrips experience).
• T-SQL experience
• Troubleshooting experience
• Experience with Always-on clustering (Active-Active)
• Working with app dev teams
• RedGate SQL Monitoring
• Automated email notification Report for database health issues if exists any (Database files Auto Growth settings left at default values, Databases with large number of VLFs, Users that are having high level Privileges etc..)
• Windows failover clustering
• Involved and Implemented Automated Audit checks.
• Attended SQL Server Performance tuning training and also attended SQLPASS 2018 Summit in-person.
• Create SQL Server Inventory through automation.
• Participated in Disaster Recovery exercises.
• Administered SSIS packages and SSRS Reports.

Confidential, Charlotte, NC

Senior SQL Server Database Administrator

Responsibilities:

• Given solid capacity planning to LOBs for their future Data growth.
• Designed and Implemented AlwaysOn Technology for a mission critical application.
• Reviews systems under development and related documentation.
• Applied certified latest SQL Patches on SQL Server 2008/2008R2/2012 Instances.
• Applied MS Security patches relevant to SQL Server like MS14-044 etc.
• Respond to inquiries from business partners related to performance, application errors, storage capacity, etc.
• Troubleshooted database performance issues for applications like McAfee Endpoint, IT Security Data Warehouse
• Participated in the POC for Microsoft System Center Operations Manager (SCOM)
• Improved Backup performance for the IBM TDP for SQL Server.
• Participated and successfully completed DR Exercises for critical applications.
• Automating Database Health Check for across the servers.
• Documented and analyzed business reports for prompt communication, follow-up and ongoing support.
• Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision.
• Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment.
• Produced high-standard database solutions to meet stability, reliability and performance metrics.
• Periodically conducting health check on all the database servers that I am responsible for and ensure the stabilization of the servers all the time.
• Installing and Supporting SQL Servers in Multi Node Cluster Environments.
• Rolling out approved latest SQL Server service packs starting from Lower environments to higher environments.

Confidential, Greensboro, NC

SQL Server DBA

Responsibilities:

• Installed SQL Patches on all SharePoint Database servers including standalone, Active/Passive or Active/Active or n+1 clusters.
• Participated in Database Monitoring POC Tests for different products like Quest Foglight, IBM ITM, IPSoft, and Valkyrie.
• Installed 2nd Cluster SQL Instance on multiple Windows clusters to support migration of SharePoint 2007 farms to SharePoint 2010.
• Respond to inquiries from business partners related to performance, application errors, storage capacity, etc.
• Troubleshooting SQL Server production issues handed over by the offshore team.
• Validating daily/weekly/monthly checklist against all business critical database servers.
• Automating database refreshes to lower environments.
• Configuring and troubleshooting and management of Log Shipping, DB Mirroring, Clustering and Replication on database servers.
• Installing Oracle, Sybase, DB2, Teradata client software on SQL Servers and setting up DSNs and setting up Linked servers.
• Extensive MS SQL experience
• PowerShell scripting experience (Scripting from scratch and modifying existing scrips experience).
• T-SQL experience
• Troubleshooting experience
• Experience with Always-on clustering (Active-Active)
• Working with app dev teams
• Development experience
• Coordinate activities of the project team and assist in monitoring project schedules.
• Experience with SQL, SQL tuning and data extraction/modification
• War room experience
• Work closely with internal technical teams during incident resolution and root cause analysis
• Reviewed systems under development and related documentation.
• Coordinating with BTG/LOB teams and educating them importance of upgrading servers/applying service packs etc..
• Improved Performance of databases by proactively reacting to Reports and warnings alerts before they become critical.

Confidential, Jersey City, NJ

SQL Server DBA

Responsibilities:

• Assisting Co-DBAs on their migration projects.
• Worked on SQL2012 AlwaysOn Projects with different flavors like FCI+AG and Standalone+AG on multi subnet environments.
• Reviews systems under development and related documentation.
• Troubleshooting performance issues using bank internal tools like precise, native SQL Server tools like profiler, DMVs and Database Tuning Wizard and perfmon.
• Controlling changes by implementing them first in Lower environments followed by Production by following the change approval process.
• Extensive MS SQL experience
• PowerShell scripting experience (Scripting from scratch and modifying existing scrips experience).
• T-SQL experience
• Troubleshooting experience
• Experience with Always-on clustering (Active-Active)
• Working with app dev teams
• Remediation of Security issues in database servers reported by Enterprise Security Management tools.
• Actively participated in implementing Change Requests.
• Development experience
• Windows failover clustering
• Managing SQL Server security by granting required access to Active directory groups wherever possible.
• Ensure all production jobs are running successfully.

Confidential, Jersey City, NJ

SQL Server DBA

Responsibilities:

• Troubleshooting performance issues using bank internal tools like precise, DNT and native SQL Server tools like profiler, DMVs and Database Tuning Wizard and perfmon.
• Validated daily/weekly/monthly checklist against all business-critical database servers.
• Actively participating in Disaster Recovery Exercises.
• Code review and making sure code comply with current company standards.
• Testing the patches before deploying on production.
• Installing/upgrading tools like Litespeed and Foglight and precise on database servers.
• Extensive MS SQL experience
• PowerShell scripting experience (Scripting from scratch and modifying existing scrips experience).
• T-SQL experience
• Troubleshooting experience
• Experience with Always-on clustering (Active-Active)
• Working with app dev teams
• Development experience
• Windows failover clustering
• RedGate SQL Monitoring
• War room experience
• Installing, upgrading/migrating, configuring database servers applying Service Packs and Cumulative Updates.
• Interacting with Security Audit team and working towards remediation of security vulnerabilities like removing elevated access in Database for the users.

Confidential, CA

SQL Server DBA

Responsibilities:

• Actively participated in gathering of User Requirement and System Specification, coordinating closely with managers and business users.
• Worked extensively on database space management, performance monitoring and alert management.
• Tuned SQL statements and stored procedures.
• Experience in Migrating from SQL Server 2005 to SQL Server 2008.
• Implemented Log Shipping to move the database to another server at regular intervals.
• Followed standard practices for migrating changes to test and production environments and provided technology support to meet business requirements.
• Extensive MS SQL experience
• PowerShell scripting experience
• T-SQL experience
• Troubleshooting experience
• Working with app dev teams
• Development experience
• Windows failover clustering
• War room experience
• Supported multiple concurrent projects enabling delivery efficiencies and technical resolution.
• Created optimal technical solutions to user needs through research and in-depth system analysis.
• Produced high-standard database solutions to meet stability, reliability and performance metrics.
• Designed and implemented TSQL queries for reporting and complex solution development.

Confidential

Senior Analyst

Responsibilities:

• Administering SQL Server Production Databases/Database servers.
• Backup and Restore and Refreshes.
• Ensure all production jobs are running successfully.
• Actively participating in Disaster Recovery Exercises.
• Monitoring and troubleshooting SQL Server Jobs (SQL Server Agent and Maintenance Plans Jobs).
• Installing, upgrading/migrating, Configuring database servers applying Service Packs and Cumulative Updates.
• Extensive MS SQL experience
• T-SQL experience
• Troubleshooting experience
• Working with app dev teams
• Development experience
• Windows failover clustering
• War room experience
• Installing Litespeed and Foglight.
• Troubleshooting SQL Server production issues handed over from the L3 Team.
• Configuring and troubleshooting and management of Log Shipping, DB Mirroring, Clustering and Replication servers.
• Managing SQL Server security and logins.
• Importing Exporting data using DTS, SSIS packages.
• SSIS and SSRS Administration.
• Actively participated in implementing RFCs.
• Building rebuilding indexes to improve performance.
• Dealing with performance issues on production servers. Search performance bottlenecks or perform other monitoring tasks using SQL Server Profiler.
• Moving objects from QA to Production databases.
• Security of Data and Database System.
• Ensuring all the RFCs closed as per the SLAs.
• Provided 24x7 supports, Supported systems beyond regular hours/ weekends/ holidays.
• Code review and making sure code comply with current company standards.
• Testing the patches before deploying on production.
• Working with application developers to know how front-end application work and testing results.
• Indexing database and making sure required indexes are present on all objects.

Confidential

Senior Analyst

Responsibilities:

• Designed and implemented SQL Server 2000/2005 databases for mission-critical business applications by using Microsoft .NET N-tier Enterprise Application Architecture.
• Monitored and tuned databases to meet the performance and availability requirements of on-line systems and multiple applications.
• Provided support to business operational models, including off-hour support.
• Modeled and forecasted database and platform resource utilization to meet user needs and respond to anticipate technological innovations.
• Created logical and physical database design, data structures, and implemented large databases using Erwin.
• T-SQL experience
• Troubleshooting experience
• Working with app dev teams
• Development experience
• Windows failover clustering
• War room experience
• Created and developed the stored procedures, triggers, views, and user-defined functions to handle complex business rules, activity log, error log, and audit analysis.
• Developed and created data dictionary, tables, views, indexes, and functions advanced queries for databases by using Query Analyzer and SQL Server Enterprise Manager.
• Developed, modified, and optimized very complex queries to data retrieval and modification.
• Developed scripts to migrate data from multiple sources.
• Scheduled and monitored all maintenance activities of SQL Server 2000 including database consistency check, and index defragmentation.
• Monitored database status including CPU, memory, I/O, space, and dead lock using SQL Server Utilities.
• Worked closely with IT project managers, programmers, and testers.

Confidential

SQL Server Database Administrator

Responsibilities:

• Developed custom database objects, stored procedures and delivered application support.
• Produced high-standard database solutions to meet stability, reliability and performance metrics.
• Followed standard practices for migrating changes to test and production environments and provided technology support to meet business requirements.
• Documented and analyzed business reports for prompt communication, follow-up and ongoing support.

Confidential

Consultant - Databases

Responsibilities:

• Supported clients with business analysis, documentation and data modeling.
• Planned and implemented security measures to safeguard vital business data.
• Created scripts and processes for data integration and maintenance.
• Authored and coded logical and physical database descriptions.
• Created optimal technical solutions to user needs through research and in-depth system analysis.
• Supported multiple concurrent projects enabling delivery efficiencies and technical resolution.