SUMMARY

• Having 11+ Years of experience in Production Support and Database Administration using Microsoft SQL Server versions like 2005 and 2008, 2012, 2014, 2016,2017 and 2019.
• In - depth experience in Database Administration as well as Database Development.
• Experience in administration, trouble shooting and maintenance of production, development & UAT server databases.
• Proficient in meeting tight deadlines and adopting new technologies.
• Extensive experience in MS SQL Server Database Administration including planning, installation, deployment/implementation, configuration
• Expertise in SQL Server databases Backups/Restore, High availability features.
• Has good experience in migrating databases, Jobs, DTS packages, Logins from 2000 servers to 2005,2008,2008 R2,2012 2014,2016,2017 and 2019.
• Experience in planning and implementing Security Standards for MS SQL Server on Windows NT 2000/2003/2008/2008 R 2/2012/2014/2016/2017/2019.
• Experience in using Native Tools for Performance Monitoring and tune the performance issues.
• Implemented Replication of MS SQL Server Databases, successfully configured transactional replication and Merge replication on Production databases.
• Implemented Log Shipping of MS SQL Server Databases on MS SQL Server 2000/2005/2008/2008 R 2/2012/2014/2016/2017/2019 versions.
• Extensive Experience in configuring Database Mirroring/Always on High Availability on SQL Server versions.
• Experience on planning and performing the DR tests of various environments.
• Experience in efficient use of Dynamic Management Views and functions.
• Experience in guiding the developers to make efficient use options and features available in SQL Server.
• Configuring resource governor for trouble shooting purposes in case of any performance issues.
• Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor, DMVs and DBCC Commands and Database Tuning Advisor

TECHNICAL SKILLS

Operating Systems: Windows Server 2000-2019

Functional Area: 24*7 Production Database Support

Languages: T-SQL, PL/SQL, PowerShell Scripting

Databases: SQL Server, Oracle 9i/10g,Azure SQL Server, AWS SQL,RDS

Domain: Telecom, Finance, Banking

Other Skills: Oracle Database

PROFESSIONAL EXPERIENCE

Confidential

SQL DBA

Environment: SQL 2019/2017/2016 ServersResponsibility: Production Support

Responsibilities:

• SQL Server installation, migrations expertise from on-prem to various clouds (Azure & AWS), schedule and maintain routine Jobs, Alerts and Maintenance Plans.
• Applying Service Packs and Security patches for the Servers as released/requested.
• Managing Backups daily and Recovery as per request.
• Implemented and maintaining Log shipping, mirroring, Always on High-Availability & replications.
• Performing daily checks on regular day-to-day basis.
• Migration of SQL Server various versions to 2005,2008, 2008 to 2012,2014,2016,2019 as per the request.
• Ensuring uptime of all database servers through monitoring tools.
• Configuring SSRS on Always-on servers and Configured SSRS as a Cluster known server.
• Analysis, problem solving, and solution design related to different issues
• Installation/configuration of SQL Server in standalone and failover clustered environments
• Predictive analysis and proactive management to reduce high severity incidents
• Patch management, disaster recovery planning and implementation

Confidential

SQL Server DBA Consultant.

Environment: SQL2019/SQL 2017/2016/2014/2012/2008 R2/2005/2000 ServersResponsibility: Production Support

Responsibilities:

• Providing production L3 DBA support to 1000+ SQL Server database servers alone.
• Installed different versions of SQL Server like 2005,2008,2008 R2, 2012, 2014, 2016,2019 at standalone and cluster level.
• Applied patches at both stand alone and cluster level for different versions of SQL Server.
• Involved in Major Migration and upgrading Projects between Datacenters.
• Implemented Always on High Availability in MS SQL Server 2016,2019.
• Migrating SQL server from lower to higher level of versions.
• Experience in implementing HADR solutions like Clustering, Replication, and Log shipping
• Implemented Database Mirroring in SQL Server versions
• Designed Database Recovery Plans and Participated in Disaster Recovery Drill processes.
• Created and modified Database objects as per change requests from Development teams.
• Created Linked Servers between different Servers in SQL Server Environments.
• Performed database consistency checks using DBCC Utilities and handling data corruption.
• Experience in Rebuilding/ Reorganizing Indexes based on Index fragmentation levels.
• Used Index tuning wizard to redesign and create the indexes for better performance.
• Configured the DB SMTP mail and Alert system for notification purposes.
• Used Database Tuning Advisor, Perf. Monitor and Activity Monitor for performance tuning.
• Experience in SQL Server Reporting Services (SSRS).
• Created a SSIS package from Production servers.
• Created Logins and Roles wif appropriate Permissions.
• Implementing SOX controls and best practices for database security under SOX compliance.
• Fixed the failed Logins, and user permissions in Active Directory and at the SQL Server Level.
• Database backup and restores, and periodical database refreshes.
• Configured CDC to capture user accounts as a part of Auditing.
• Experience wif SQL Server TDE, Auditing, key Management.
• Configured different types of Encryptions in SQL Server 2012,2016,2019 versions.