SUMMARY

• Very good Experience in installation, Configuration and Maintenance of SQL Server versions.
• Excellent DBA skills with Backup and Recovery
• Experience in query optimization and Performance tuning. Using SQL Profiler, Execution Plan, Performance monitor, DBCC Command, Extended event.
• Implemented and Scheduled Replication process for updating our parallel servers in autonomous sites
• Has Knowledge of SSIS,SSRS,SSAS with error handling
• Experience in SQL Server Clustering and Log Shipping
• Experience in Disaster Recovery Planning and Security Management Operations
• Strong Experience in mentoring team members and writing documentation
• Experience in using DMV for performance tuning
• Experience in administrating the created reports and assigning permission to the valid users for executing the report
• Experience in Replication - Snapshot, Merge and Transaction
• Knowledge on AWS
• Installation and configuration of MS SQL Servers, MS SQL Server 2008, 2008R2,2012,2014,2016 and MS SQL Server 2017. Periodic database maintenance. Project Management,
• Backup and Recovery, Root Cause Analysis, Performance Tuning, High Availability Solutions, Disaster Recovery, Database Security, Database Mirroring, Log Shipping, Clustering, Replication, Always On Availability Group, Call Support, Promoting Team bonding, SQL Server Upgrades/Patches, Database Migration, Proactive Monitoring, Change Control, Business Continuity, Active Directory.

TECHNICAL SKILLS

O/S: WINDOWS 2003, 2008, 2008R2, 2012R2 and 2016 GUI & Core

Database TOOLS: SSMS, SSCM, SSRCM, SQL Profiler, Extended Events, DTA, SSRG, DMVs, Activity Monitor, SQL Execution Plan, SSMA, SSIS, SSAS and SSRS, Red gate, Solar Winds (DPA)

RDBMS: MS SQL Server 2005, 2008/2008R2, 2012, 2014, 2016 and 2017

Third Party/ITIL Tools: BMC Remedy, Service Now, HPITSM, Solar Winds, Idera, SentryOne

Automation Tools: SCOM, SCCM, Autosys, DDBoost, BigFix

PROFESSIONAL EXPERIENCE

Confidential

SQL Server DBA (Consultant)

Responsibilities:

• Participate in on call rotation, 24/7 Production support.
• Migrating SQL Server production and non-production servers from SQL Server 2000, 2005, 2008r2 with upgrade to SQL Server 2012, 2014 and 2016.
• Install and configuring SQL 2008 and SQL 2012 on WINDOWS 2008r2 and 2012 systems.
• Creating the backup and restore strategy for production, development and test environments
• Implement AlwaysOn for HADR and reporting purpose and created the documentation.
• Performance tuning using Performance Monitor, SQL Profiler, SQL Query Analyzer and Index tuning wizards, Database Engine Tuning Advisor.
• Set up, testing, and maintaining business continuity/disaster recovery infrastructure for databases and applications including documentation of Disaster Recovery Plan (DRP).
• Handle monitoring and updating Backup and Recovery strategy to recover data using business RPO and RTO SLA requirements.
• Perform SQL Server service pack and Windows Service pack upgrades.
• Implement a robust Security policy for all access point, for windows AD, Server and Database authentication and permissions following standards and best practice.
• Implement encryption on column, database files and OS/Network to protect access to PII, PCI and Sox data.
• Automating database maintenance task jobs for index tuning, backups, integrity checks, logs and history recycling, leveraging Ola Hallengren stored Procedures.
• Create standard automation for SQL instance installation Always On Health check and database dashboard.

Confidential

SQL Server DBA

Responsibilities:

• Participate in on call rotation, 24/7 Production support.
• Production support for multi-terabyte global database operations environment in the US, Brazil, Korea, Germany, Mexico, Australia & China.
• Provide SQL Server (2005, 2008, 2012, 2014 & 2016) database administration (Installation, Configuration, administration, Upgrading, Monitoring, Tuning, Patching, Backup/Recovery) for over 3000 production and development databases (both standalone and cluster instances) environments on windows OS.
• Perform database refresh, backup and recovery.
• Work with the developers and other DBA's to create a well-designed, consistent data architecture to support business needs, while understanding the business processes that the data structure will sustain.
• Perform MS SQL Server database files and space management.
• Perform change and deployment tasks as scheduled
• Security provisioning and managing database users.
• Troubleshoot and resolve various problems that arise in day to day production tickets submitted through ITSM.
• Failover Clustering, SAN Replication, Log Shipping and other high Availability technologies.
• Raise SR’s for critical issues or bugs found on production databases.
• Monitoring SQL Server logs to ensure whether the backup operations, batch commands, scripts have completed successfully.
• Implement proactive measures with event notification, triggers and setting traces to monitor and resolve database lock escalations, consistent blocking, waits and deadlocks
• Perform updates and changes during maintenance windows as assigned.
• Work with others teams to review change requests and approval.
• Set up High Availability and Disaster Recovery with SQL AlwaysOn configuration across subnets to fulfil Enterprise Business Continuity strategy.
• Monitor backups to ensure they are being performed regularly and troubleshoot failures with quick fix or permanent resolution
• Restore database from time to time to a specific point in time as requested.