SUMMARY

• Infrastructure professional with 12 Years of experience open to new opportunities with broad background in Information Technology as an SQL Server (2008r2,2012,2014 and 2016) in Production, Development and Test Environments.
• 10 years of experience in Database Design, Administration, Azure Cloud, Implementation, and Application Development.
• 3+ Years of experience as a Technical Project Delivery Lead and delivered more than 45+ projects successfully.
• 5+ years of experience in Project Management.
• DR Lead for SQL tower and handled multiple regions for organizations worked and prepared required table top exercise.
• Experience on servers involved in SOX compliance Audits.
• Expertise in configuring Always - On Availability Groups (AAG) synchronous and asynchronous-modes.
• Created Snap shot, Transactional Replications and Log shipping, Mirroring for different customers.
• Designed the backup strategy for all databases based on the regions and data loads from upstream. So that it does not affect the ETL loads.
• Experience in Change Management, Incident Management and Release Management process in Service Now.
• Experience in Azure Cloud installing, configuring and administering both Clustered and Standalone Systems with different editions and versions of SQL Servers on Cloud servers.
• Implementation of tools like TECTIA, WINSCP to transfer data from Oracle, FTP to windows servers.
• Experience in configuring TDE encryption for highly securable databases.
• Implemented CDC Change Data Capture for Critical tables.
• Expertise in performance tuning the application and Database.
• Expertise in migrating databases from legacy platforms to latest versions of SQL server.
• 24 X 7 Production Database On Call Support.
• Installing SQL Server in a Cluster Environment.
• Backup and Restore OLEDB databases using Net backup, Symantec Backup tool.
• Played a key role in business requirement analysis, architecture design, physical and logical Data modeling, application development, testing, training, production support and Project review with client.
• Extensive experience in space allocation, database migrations and database security.
• Extensive experience in Capacity planning, Performance Tuning, Disaster Recovery and troubleshooting.
• Mentoring Junior DBAs in database troubleshooting.
• Manage and maintain database changes in Development, QA, Staging and Production
• Extensive experience in backup and restore procedures.
• Experience in Batch processes, Import, Export, Backup, Sql Loader, Shell scripting, Database Monitoring tools and application support.
• Experience in Installation of Oracle Client and testing connections.
• Extensive experience in multiple instances on single Database, share memory, design and implementation.
• Extensive experience in controlling the user privileges, monitoring the security and Audit issues.
• Extensive experience on working with Data masking.
• Strong Communication and Time Management skills and excellent team player.
• Ability to adapt quickly to changing environments.

TECHNICAL SKILLS

Databases: MS SQL Server 2014, 2012, 2008, MS SQL Server 2005, Azure Cloud SQL server Reporting Services & Integration services

Programming: C, T-SQL

DBA: Database Administration of MS SQL Server 2016,2014,2012,2008, 2005,2000

Operating System: Windows NT/2000/XP/2003,2008/2008R2/windows2012/Windows 2012R2, Windows 2016.

Tools: Backup Utility, Symantec Backup tool, Net backup, Perfmon, SQL Profiler, Service now

Markup Languages: HTML, XML

Network Topologies: TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP

PROFESSIONAL EXPERIENCE

Confidential

SQL Server Lead, Onsite Coordinator

Tools: SQL Server (SQL Server Integration Services 2012/2016, SQL Server

Responsibilities:

• Installation, configuration, Managing and Monitoring of all SQL server with Service packs, Cumulative updates and hot fixes. Involved in Physical and Logical design and Schemas for databases of new application.
• Experience in SERVICENOW activities on Incident, Problem and Change Management processes.
• Experience in EPIC released products like Caboodle, Clarity and Chronicles which are used for data analytics for hospital data.
• Configuring High Availability SQL AlwaysOn, DB Mirroring, Log shipping for NCAL, SCAL regions.
• Implemented TDE encryption for PHI included databases.
• Designed the backup strategy for all databases based on the regions and data loads from upstream. So that it does not affect the ETL loads and Capacity planning for all our SQL/Web servers.
• Created the maintenance plans for better performance of queries.
• Flexible and available for 24X7 support.
• Automated the SQL Server and Web server patching activity.
• Implemented monitoring for high CPU and RAM utilization on SQL Servers.
• Implemented Alert notifications for long running queries to the Dev teams and application teams.
• Implemented CDC Change Data Capture for critical tables which includes PHI data to audit the DML statements.
• Created audit for all the SQL Server logins to capture the activities performed by users.
• Extensive experience in space allocation, database migrations and database security.
• Extensive experience in Capacity planning, Performance Tuning, Disaster Recovery and troubleshooting.

Confidential

Senior SQL Server DBA

Tools: SQL Server (SQL Server Integration Services 2008/2012, SQL Server\ Reporting Services 2008/2012, SQL Server Database 2008/2012/2014/2016 ).

Responsibilities:

• Experience in ITIL activities like Incident, Problem and Change Management processes.
• Experience on installing, configuring, Managing and Monitoring of all SQL server with Service packs, Cumulative updates and hot fixes. Involved in Physical and Logical design and Schemas for databases of new application.
• As a Technical Project Delivery Lead delivered more than 45+ projects successfully this involves Application Migration, Environment Upgradation, Capacity Planning projects.
• Tuning of SQL Server Memory structures and troubleshooting the existing issues with Buffer Pool and Paging.
• Migrated on premises SQL databases to Azure SQL Cloud.
• Monitor and troubleshoot ETL, SSIS and Application Jobs and other tools.
• Installed SQL Server Clusters in Active\Active and Active/Passive Topology.
• Remote Monitoring of SQL Server 2008r2, 2012 and 2014.
• Install, configure and Deploy SharePoint Services and Team Foundation Servers.
• Monitor Confidential SQL Server activity on a proactive basis and tune the system for optimal performance
• Performed Physical and Logical Data Modeling for databases of varied sizes including VLDBs. Designed and implemented capacity planning module to make future projections in terms of system resources
• 24 X 7 Production Database On Call Support.
• Troubleshoot Blocking and Deadlocking issues by making appropriate changes to Transaction Isolation levels and the types of locks being held; avoiding keeping transactions open for long durations, breaking large transactions to smaller ones.
• Upgraded the existing Servers from SQL Server 2008 to SQL 2012 and 2014.
• Experience in deploying SSIS Packages for integrating data using OLE DB connection from heterogeneous.
• Experience in configuring SSRS for different environments.
• Monitor and tune both server and databases using DBCC, Server configurations options (sp configure) and Database options (sp dboption). Contributed to automation of many daily administrative activities like backups, thresholds, monitoring server resources and proactive problem diagnosis.
• Manage and maintain database changes in Development, QA, Staging and Production.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Worked extensively on Data scrubbing and masking for restored databases.
• Created security policies for SOX and PCI environments.
• Configured and wrote SQL scripts for automated deployments.
• Creating Replication, database Mirroring and Always-on for different Applications.

Confidential

SQL Server DBA

Tools: SQL Server (SQL Server Integration Services 2008/2012, SQL Server Reporting Services 2008/2012, SQL Server Database 2008/2012)

Responsibilities:

• Designed backup strategy for Production, Validation and Development environments.
• Designed Database maintenance plan for database consistency and optimization.
• Monitoring and Creating scheduled jobs.
• Maintaining the Production servers online 24/7.
• Updating the tables with latest data modifications
• Backup Data bases using Symantec.
• Keep watch on Store Procedure, Trigger etc.
• Making changes in the database with respect to the change document.
• Trouble Shooting all user related issues.
• Managing Database Security.
• Creating VM’s using Hyper - V.
• Maintaining 700+ servers using SCOM monitoring tool.
• Create Logins and users. Managing Database Users and Security.
• Maintaining high availability of databases by configuring Always On, DB Mirroring, Log shipping.
• Performed SQL database migration from 2008 R2 to 2012 and 2012 to 2014.
• Worked on TFS (Team Foundation Sever) to release the SSIS Package from DEVELOPMENT TEST PPE PRODUCTION
• Installed all SQL versions on production servers.
• Mentor and transfer knowledge to junior DBAs.
• Shrinking transaction log and databases as per requirement and troubleshooting transaction logs and temp db full issues.
• Deploying SSIS packages and SSRS rdl’s
• Running SQL Profiler & Usage of Index Tuning Wizards for performance optimization