SUMMARY:

• Around Six years of experience in MS SQL Server 2016, 2014, 2012, 2008 R2, 2008, 2005 & 2000 Database Administration and Development in Windows environment.
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Datacenter Migration experience from SQL Server 2000,2008R2 to SQL Server 2016/2014/2012 .
• Extensively worked on High Availability solutions like Always ON, Clustered environment & Replication models such as Transactional and Snapshot.
• Implemented the new SQL Server 2012 mechanisms like data compressions, online indexing, Contained Databases, security principals and AAG.
• Expertise in core DBA tasks like Installation, Maintenance, Configuration, Backup & Restore, DR, Database Security and, Database designing.
• Having hands on experience in DR processes including Log shipping and Database Mirroring .
• Extensive knowledge in Tuning SQL queries & improving the performance of the Database.
• Handled multiple SQL Instances on Cluster environments for Server Consolidation projects built on SAN using RAID levels.
• Extensively used Red Gate SQL Compare and Data Compare tools to compare and synchronize SQL Database Schemas
• Experience on 64 - bit SQL Server 2012 / SQL Server 2008 R2 systems and MSCS Configurations.
• Experience in migrating SQL Databases to cloud environment like SQL Azure & Knowledge on Amazon Web Services (AWS).
• Good Knowledge on Azure PaaS Solutions like Azure Web Apps, Web Roles, Worker Roles, SQL Azure and Azure Storage.
• Expert in working with Third party backup tools like Veaam, SQL LightSpeed, Idera SQL Safe, Red Gate Tool Belt to improve Performance of backup and recovery.
• Experience on database design for very large databases (22 terabyte databases).
• Experience in using tools like Veeam Tool, SQL Sentry, SQL Profiler, Windows Performance monitor and performance counters for Monitoring and Tuning MS SQL Server Performance.
• Extensively worked on Data extraction using the (SSIS) Microsoft SQL Server integration services.
• Experience in using PowerShell script Desired State Configuration (DSC) for installing SQL Servers, create Maintenance Plans & Post install Server configuration.
• Creation of Jobs Schedules, Alerts using SQL Server Agent and Notifications using SQL Mail and Database Mail.
• Created Linked Servers between SQL Server 2008 R2 & Oracle 9i and 10g. Also created DTS package for data transfer between the two environments.
• Working knowledge in Analysis Services (SSAS) and Reporting Services (SSRS).
• Having VMware virtualization experience with vSphere 4.1 and 5.5 environment.
• Expertise in T-SQL writing stored procedures, triggers and functions.
• Worked on Sales Force, Jira, Service Now, VM Ware Service Manager and BMC Remedy ticketing system software’s.
• Good understanding of change control process.
• Available for 24*7 production support in mission critical environment.
• Good interpersonal, analytical and communication skills.

TECHNICAL SKILLS:

Databases: MS SQL Server (2016/2014, 2012, 2008 R2, 2008, 2005, 2000), MS Access.

Reporting Tools: SQL Reporting Services.

Scripting Languages: C, C++, T-SQL.

Operating System: Windows Server 2016/2012/2008 R2/2003, Windows 2000.

DBA & Others Tools: Veeam backup Tool, Idera SQL Safe, Idera SQL Diagnostic Manager, Red Gate SQL Compare, SCOM Monitoring Tool, Dell Lite Speed, Dell Spotlight.

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

MS SQL Server DBA

Responsibilities:

• Installation & maintenance of MS SQL Server 2016 /2014 and 2012
• Deploy High Availability and Disaster Recover solutions like AlwaysOn, Database Mirroring to provide multiple copies of production data that can be used for disaster recoveries.
• Database backed up regularly & available in the event of a disaster to meet the organization’s Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO).
• Work closely with infrastructure(LAN) and security teams in evaluation of hotfixes/security patches and make sure all environments are up-to-date.
• Extensively worked on auditing entire environment by building SQL Monitoring database to capture everything in the prod environment.
• Maintained tables, indexes, views, stored procs, Functions, Triggers, Synonyms
• Managing Backup and restore, export and import
• Implemented Database Mirroring with High Availability Mode in SQL 2005
• Migration of databases from SQL Server 2000 to SQL Server 2005, 2008 and 2012
• Configured and monitored replication, mirroring, SQL clusters and troubleshooting issues.
• Implemented Sync and Async MIRRORING for Disaster Recovery Implementation
• Monitoring the servers using Spotlight third party software.
• Documenting database activities on-day-to-day basis.
• Provided 24/7 on-call support on rotation basis for production database.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases, this involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Monitoring Notifications, Jobs and Alerts to make sure all jobs run successfully
• Managing of users including creation/alteration, grant of system/DB roles and permission on various database objects
• For Ticketing systems like SQL Server Requests and Problem Resolution used Share point and VMWare Service Manager etc.
• Use DTA (Database Tuning Advisor), to identify indexes that can help improve performance.
• Used SSIS to move auditing files from SQL server to UNIX server.

Environment:: MS SQL Server 2016/ 2014/2012/2008 R2/2008/2005,2000, Dell Spotlight, SharePoint, VMWare Service Manager, Visual Studio 2016/2010/2005 and Windows Server 2016/2102/2012 R 2/2008/2003.

Confidential, Irving, Texas

Sr. SQL Server DBA

Responsibilities:

• Installation & maintenance of MS SQL Server 2012 and 2014.
• Datacenter migrations with & without Veeam tool end to end copying from Physical servers to Virtual machines (VM’s).
• Work closely with the infrastructure and development teams to ensure databases are highly available up to uptime 98% and achieved 99%.
• Set up Always ON high availability with windows cluster on SQL server’s 2012/2014/2016 for newly created servers.
• Perform business analysis, technical analysis, systems design, application software programming.
• Involved in Optimization and Performance Tuning of SQL Server using SQL Profiler and Performance monitor.
• Create Database Objects using T-SQL like Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Planning & Managing SQL Server databases backup and recovery strategy using Veeam backup tool.
• Planning & Managing capacity planning of production, development and test servers.
• Diagnosing/Troubleshooting database issues on-day-to-day basis.
• Worked on upgrading and setting up alerts on Dell Spotlight Monitoring tool.
• Planning, managing, creating POC’s and Implementing/coordinating Windows & SQL Servers Patching and SQL Cumulative Upgrades and Database Maintenance Plans.
• One of the team member for core team which reviews Architecture and Design review team.
• Work with different team members and/or vendors to ensure applications are communicating securely and databases are designed correctly.
• Design, configure modify and enhance the applications as necessary.
• Documenting database activities on-day-to-day basis.
• Bi-Weekly on-call support for Production Environment.

Environment:: MS SQL Server 2014/2012/2008 R2, Veeam backup tool, Dell Spotlight, Red Gate SQL Compare, SQL Sentry, Visual Studio 2010/2005 and Windows Server 2012/2008, SSRS, SSIS, BCP and Microsoft Cluster.

Confidential, Irving, TX

SQL Database Administrator

Responsibilities:

• Analyzing the Database Infrastructure / servers / storage and provide technical recommendations for improving the SLA times with business users and implement optimization changes for better performance for applications.
• Migrated SQL2008 applications to SQL2012 with Always on high availability clusters for disaster recovery and reporting.
• Migrated few of PROD SQL Databases to cloud environment SQL Azure.
• Implementation of Replication Models (for OLTP Servers) using Merge and Transactional (with updatable subscriber) on large terabyte databases.
• Involved in Fine Tuning and Performance and Query optimization of the Database as required by the application.
• Extensively used T-SQL Scripts for developing stored procedures, triggers, functions etc.
• Successfully restored 22 TB database having thousands of data files and shrink back to 6 TB of size.
• Implemented 2way Replication (Peer-Peer/Snapshot) between 1 Publisher and 3 Subscribers.
• Worked closely with Storage groups to find out the underlying Disk I/O sub system issues with SAN.
• Implementing the Security strategy for each environment and the required backup strategy as well.
• Used DMV’s and custom scripts to tune performance of SQL Server queries.
• Provided support for SQL Server Reporting Services (SSRS) including installation, configuration, report deployment, setting up report subscriptions and managing security.
• Designed and Implemented backup solution using third party backup tool called Dell Litespeed.
• 24 X 7 On-call support rotation for SQL Server database systems, products and services.
• Work with Microsoft PSS Support to troubleshoot and debug SQL Server / Windows problems.
• Develop and deploy trace files to audit DBA activities, DDL commands and Security events in SQL Server. Automate the process of reporting unauthorized activities.
• Design and develop database backup and recovery procedures.

Environment:: MS SQL Server 2012/2008R2/2008, Microsoft Azure/Cloud environment (IaaS, PaaS, SaaS), SQL Lite Speed, Red Gate SQL Compare, SQL Sentry, Visual Studio 2010/2005 and Windows Server 2008/2003, SSRS, SSIS, BCP and Microsoft Cluster.

Confidential, Richardson, TX

MS SQL Server DBA

Responsibilities:

• Installed/Configured and upgraded PROD/COB/UAT/DEV environments from SQL Server 2005/2008 R2 to 2012.
• Deploy High Availability and Disaster Recover solutions like AlwaysOn, Database Mirroring to provide multiple copies of production data that can be used for disaster recoveries.
• Installed SQL Server 2012 versions using PowerShell Desired State Configuration (DSC) and post install Server configuration.
• Database backed up regularly & available in the event of a disaster to meet the organization’s Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO).
• Worked on Cob tests during weekends to test COB environment by business users.
• Work closely with infrastructure and security teams in evaluation of hotfixes/security patches and make sure all environments are up-to-date.
• Extensively worked on auditing entire environment by building SQL Monitoring database to capture everything single thing in the prod environment.
• Successfully implemented a project to set up process of automated log shipping without primary server by just using backups.
• Monitoring the servers using Idera Diagnostic Manager third party software and backups using SQL Safe.
• Design, document and implement SSIS packages and stored procedures.
• Moved secured databases to AWS cloud environment from SAN.
• Provide expertise for using best RAID Technologies based on application requirement.
• Use DTA (Database Tuning Advisor), to identify indexes that can help improve performance.
• Used SSIS to move auditing files from SQL server to UNIX server.

Environment:: MS SQL Server 2012/2008R2/2008/2005, Idera SQL Safe, Idera Diagnostic Manager, Lotus Notes, Microsoft Outlook, Visual Studio 2010/2005 and Windows Server 2008/2003.

Confidential

SQL Server DBA/Developer

Responsibilities:

• Installed, Configured and Administered SQL Server 2008R2/2008 Servers in Production, QA, Pre-Prod and Dev environments.
• Responsible for overall database environment and maintain operational uptime of 99.9%.
• Performance tuning, capacity planning, trend analysis, and server sizing for very large databases.
• Installed and managed multiple 3 node failover cluster set up in active/active clustered environment as a High Availability mechanism.
• Creating Virtual Machines in VMware vCenter and maintain virtual Machine and performance.
• Daily support, troubleshooting, monitoring, optimization and tuning of server and SQL server environments across entire system.
• Generating reports with SAS EG and other tools wherever required.
• Implemented Transactional Replication for different applications and managed replication and database modifications for replicated objects.
• Ticketing systems like Resolve for Change Request, Sales Force and BMC Remedy etc.
• Responsible for migrating all SQL changes to production and are in line with the organizations SDLC policy.
• Create Database Objects like Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Created logins and Roles with appropriate permissions for temporary and permanent access requests.
• Scheduling the Backups and performing the restoration. Support for huge Databases.
• Provided 24/7 on-call support on rotation basis for production database.

Environment:: Microsoft Windows Server 2012/2008R2/2005, SCOM, Red Gate SQL Compare, Visual Studio 2010/2005 and Windows Server 2008/2003.