SUMMARY:

• 9 + Years’ of IT experience as SQL Server Database Administrator.
• Experience in supporting Very Large databases (VLDB).
• Extensive experience with SQL Profiler/Extended Events.
• Extensive experience with regulatory compliance audits such as PCI, SOX.
• Expertise in query tuning, performance tuning.
• Extensive experience in Configuration, Implementation and Maintenance of Disaster Recovery solutions using Log Shipping, Mirroring, Replication and Clustering.
• Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services ( SSAS ).
• Involved in authoring, deploying of reports using SSRS.
• Extensive ETL experience using DTS/SSIS for Data Extractions, Transformations and Loads.
• Extensive experience as a SQL/Oracle DBA.
• Expertise in Always on Availability Groups (AAG) and HA/DR Troubleshooting.
• Expertise in writing, troubleshooting, modifying complex PowerShell/T - SQL scripts.
• Hands on experience with SQL Azure.
• Expertise in Cloud migrations.
• Performed Migration across cross platforms.
• 24/7 Production Database on Call Support.

TECHNICAL SKILLS:

Operating Systems: Linux, UNIX, Windows

Programming Languages: Java, C, C++, C#.Net on IIS, Flex 3

Web Technologies: HTML, CSS, Servlets, JSP, JavaScript, ASP

Database: DB 2 9.5/ 9.7/ 10.1/ 10.5 , SQL Server 2016/ 2014/ 2012/ 2008/ 2005 , MY SQL 4.1/ 5.0/ 5.1/ 5.5/ 5.6 , PL/SQL, Oracle 10g/ 11g

Networking: IPV4, IPV6, TCP, HTTP, DNS

Tools: Quest Central, Ignite, Toad, Flex Builder 3, Visual Studio 2005/2008, Adobe Dream Weaver, SQL* Plus, SQL* Loader, SQL Developer

Methodologies: UML, Model driven, Agile and Scrum

IDES: Eclipse, NetBeans, My Eclipse

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH

Sr. SQL DBA

Responsibilities:

• Involved in extensive performance tuning as part of the DLP (Data Loss Prevention) scans.
• Performing in-depth RCA on various SQL server related issues.
• Involved in multiple SQL server builds.
• Configured 4-node Always On.
• Responsible for deploying code changes, code review and code releases in all environments
• Involved in multiple patching activities.
• Developed and deployed SSIS packages.
• Extensive experience with deploying and scheduling reports using SSRS to generate daily, weekly, quarterly reports.
• Written PowerShell scripts to automate admin tasks like backups, re indexing, database integrity checks.
• Expertise in scheduling backup jobs through SQL server agent using Ola Hallengren scripts
• Extensively worked on OLAP cubes using SSAS.
• Implemented TDE (Transparent Data Encryption)
• Generated quarterly SOX auditing reports.
• Extensive experience with GMSA (Group Managed Service Accounts).
• Documented the build procedures and was involved in capacity planning for all the new build servers.
• Documented the backup and recovery policies at Huntington bank.
• On call Support.

Confidential, MA

Sr. SQL DBA

Responsibilities:

• Involved in multiple P2V (Physical to virtual) migrations.
• Performed business analysis, technical analysis and system design.
• Provided on call support for multiple application releases.
• Extensively worked on query tuning, application performance issues with the application owners and suggested measures for better performance.
• Developed and deployed SSIS packages.
• Design and development of logical model and physical database structures involving Normalization techniques
• Configured Always on SQL 2016.
• Hands on experience in PCI compliance standards.
• Lead multiple projects, designed and implemented comprehensive backup plan and disaster recovery strategies.
• Extensive experience with Guardium.
• Generated quarterly SOX audit reports.
• Documented the Avamar backup procedure.
• Extensively used monitoring tools like Spotlight, SolarWinds.
• Configured Transactional Replication.

Confidential

Sr. SQL DBA

Responsibilities:

• Configured Always on SQL 2012/2014
• Performed multiple PMM activities, applied patches.
• Recommended strategies for better performance of the application.
• Upgrading of SQL servers from .
• Developed multidimensional objects using SSAS
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Installation, maintenance and administration of SQL 2016 servers.
• Installed SQL service packs based on the errors and flaws that were found in the application.
• Experience with Azure migrated on-premise databases to Azure as part of a POC.
• Configured log shipping on multiple servers.

Confidential

SQL DBA

Responsibilities:

• Migrated over 500 databases from the HPE domain to the HPI domain.
• Managed the servers that were under Veritas Clustering environment.
• Worked with the development team on query optimization for better performance of the databases.
• Resolving all kinds of performance issues after the migration is done.
• Worked on logical and physical database modelling with UML and Erwin Tools.
• Involved in major production issues and provided the client with root cause analysis.
• Configured Log shipping on production servers and performed role reversal of the primary and the secondary log shipped database.
• Responsible for maintenance and administration of SQL server 2016 servers.
• Capacity planning.
• Extensively worked on change, release, incident and configuration management.
• Documented the migration activity, backup and restore procedures being used at HP.
• Documented RCA (root cause analysis) for many major production issues.

Confidential - Columbus, OH

SQL DBA

Responsibilities:

• Involved in upgrading of several SQL servers from .
• Configured Replication, Database Mirroring and Clustering.
• Developed and deployed multiple SSIS packages.
• Involved in multiple patching activities.
• Experience working with monitoring tools like SCOM, IGNITE and Solar winds
• Involved in Data archiving and purging process as a part of maintenance.
• Suggested better strategies to avoid slow performance of the database.
• Resolved issues which involved high usage of system CPU, Disk, Deadlocks and other performance related issues.
• 24x7 production Support.

Confidential - WI

SQL DBA

Responsibilities:

• Involved in Migrating SQL Server 2005 Servers to SQL server 2008, SQL server 2008 to SQL Server 2012.
• Installed and Configured MS SQL Server 2012, and responsible for configuration, tuning and provide support to all Production and development servers.
• Converted several DTS packages into SSIS packages.
• Involved in Installation of SQL Server with Multiple instances, Service packs and Hot Fixes.
• Assisted in Setup and troubleshooting Active/Passive Clustering for SQL Server 2005/2008/2012.
• Written PowerShell scripts to automate DBA tasks.
• Configured Always on on SQL 2012(3 replicas)
• Configured Transactional replication between Primary Server and three Read-Only servers, with separate Distributor server and experience in troubleshooting replication problems.
• Used SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
• Responsible for monitoring and making recommendations for performance improvement in hosted Databases. This involved index creation, index removal, index modification, file group Modifications and updating statistics in databases.
• Handled up to 5 TB Size databases with clustered and replication environment
• Responsible for defining Check constraints, Business Rules, tuning data, indexes, and queries.
• Handled issues in Replication like Replication Agents Failure, Subscription failure etc.
• Created SQL Server audits and policies to monitor activity on SQL databases to ensure databases complied and met the Service Level requirements of our clients.