SUMMARY

• A highly motivated and committed person having 9+ years of experience as SQL Server DBA
• Expert Level skills in providing DBA support in Production and PRE - PROD environment
• Involved in day-to-day monitoring and maintenance, problem investigation and resolution, SQL and database optimization and tuning as well as researching, analyzing and recommending patches, upgrades, and new technologies surrounding all aspects of data management using relational databases
• Design/administration of cloud service models including Infrastructure-as-a-Service & Platform-as-a-Service
• Good knowledge in server Hardware and Storage systems.
• Migrated databases from Oracle to SQL Server Using SSMA
• Proven ability to translate Business needs into technology requirements that supports the company's Business objectives, and to successfully manage all phases of IT Projects from needs analysis and requirements definition to vendor, implementation, and training
• Experience in maintaining SQL instances on AWS EC2 cloud computing and RDS instances
• Adept in various Backups/Restore operations through various tools (Native, TSM, LiteSpeed & Commvault), in SQL Server
• Experience in performance and query tuning of SQL Server using profiler, DMVs and Extended Events.
• Hands-on experience in migrating/replicating data between cross RDBMS platforms using Microsoft SQL BI and SQL Native replication
• Design, Architect and build HADR environment using Always-on Availability groups, log shipping, Database Clustering technologies
• End to End exposure towards implementing High availability & Disaster Recovery

TECHNICAL SKILLS

Operating systems: Windows Server 2012/2008/ 2003/ 2000

RDBMS: MS SQL Server 2017/2016/2014/2012/2008 R 2/2008/2005/2000

Database Utilities: SSMS, Enterprise Manager, Perfmon, SQL Profiler, BIDS

Backup / Archive tools: Litespeed, Commvault and Tivoli Storage Manager

Monitoring Tolls: Spotlight,ignite and Foglight

PROFESSIONAL EXPERIENCE

Confidential

SQL Administrator

Responsibilities:

• Installing, Configuring and Administering SQL Server 2014 & 2016.
• Monitoring Disk Space of all the Servers and Troubleshooting Space issues.
• Have worked on various deployments based on client requirement.
• Implemented automation scripts using PowerShell.
• Design, Architect and build HADR environment using Always-on Availability groups, log shipping, Database Clustering technologies
• Have created SSRS Inventory report into Share point.
• Planning and execution of necessary upgrades like service packs, cumulative updates and hot fixes
• Recovered databases from backup in disasters
• Handling security and creating SQL/Windows logins and granting permissions as per roles or individual permissions.
• Rectifying orphaned users and fixing user access issues after performing Restorations.
• Created SQL jobs as per the requirement and troubleshooting the job failures.
• Rebuilding of indexes at regular basis for high performance.
• Regular monitoring of Temp DB and Memory issues for better performance
• Identifying and resolving long running sessions & blocking for effective performance
• Handling outage notification accordingly and following the process during production maintenance/production down issues
• Performing new instance installation as per the build policy
• Verifying the backup taken on daily basis
• Reviewing SQL Server and SQL Server Agent Error Logs for any issues.

Confidential

Tech Specialist

Responsibilities:

• Installing, Configuring and Administering SQL Server 2014 & 2016.
• Developed and successfully implemented a robust database backup and recovery strategy with client assistance.
• Monitoring Disk Space of all the Servers and Troubleshooting Space issues.
• Planning and execution of necessary upgrades like service packs, cumulative updates and hot fixes
• Checking the general Health of the servers by using DMV S & DBCC.
• Recovered databases from backup in disasters
• Handling security and creating SQL/Windows logins and granting permissions as per roles or individual permissions.
• Rectifying orphaned users and fixing user access issues after performing Restorations.
• Created SQL jobs as per the requirement and troubleshooting the job failures.
• Rebuilding of indexes at regular basis for high performance.
• Regular monitoring of Temp DB and Memory issues for better performance
• Identifying and resolving long running sessions & blocking for effective performance
• Handling outage notification accordingly and following the process during production maintenance/production down issues
• Performing new instance installation as per the build policy
• Verifying the backup taken on daily basis
• Reviewing SQL Server and SQL Server Agent Error Logs for any issues.

Confidential

Technical Lead

Responsibilities:

• Implemented step by step migration document for AWS EC2 and AWS RDS.
• Worked on launching AWS EC2 and AWS RDS instances.
• Implemented Databases mirroring document for AWS EC2.
• Installing, Configuring and Administering SQL Server 2014 & 2016.
• Developed and successfully implemented a robust database backup and recovery strategy with client assistance.
• Monitoring Disk Space of all the Servers and Troubleshooting Space issues.
• Planning and execution of necessary upgrades like service packs, cumulative updates and hot fixes
• Applied Patches on Standalone, Cluster and Database Mirroring Environment.
• Troubleshooting Service Pack failures during upgrade Activity.
• Hands-on experience on Migration of Database Environment from On-Premise to RDS
• Checking the general Health of the servers by using DMV S & DBCC.
• Recovered databases from backup in disasters
• Handling security and creating SQL/Windows logins and granting permissions as per roles or individual permissions.
• Rectifying orphaned users and fixing user access issues after performing Restorations.
• Created SQL jobs as per the requirement and troubleshooting the job failures.
• Rebuilding of indexes at regular basis for high performance.
• Regular monitoring of Temp DB and Memory issues for better performance
• Identifying and resolving long running sessions & blocking for effective performance
• Handling outage notification accordingly and following the process during production maintenance/production down issues
• Performing new instance installation as per the build policy
• Verifying the backup taken on daily basis
• Maintained and Implemented Database ALWAYS ON
• Reviewing SQL Server and SQL Server Agent Error Logs for any issues.
• Performing failover operations and adding disk dependencies in a cluster
• Attended daily client calls for updates and changes
• Worked as CAB member from DBA perspective

Confidential

Technical Lead

Responsibilities:

• Monitoring the Log Space for successful execution of all the specified jobs.
• Working on Log shipping and mirroring
• Verify backups and error logs on the servers and troubleshoot on any failures or alerts, open trouble tickets if necessary to work with technicians from other departments.
• Using profiler for tracing down SQL server activities.
• Also refreshing Database as per the requirements of the clients.
• Implementing disaster recovery plans.
• Managing Security (Creating users, logins and roles, granting permissions)
• Performance Monitoring and tuning.
• Ensuring Data consistency in the database through DBCC commands.
• SBO and SBO+ have implemented about 17 countries put together, there are around 500 users are working in all the countries.
• Finance, Logistics and service are major module and apart from that, there are tool like b1-up add on, task centre are also covered in the scope of support
• Support SAP Business one all Modules ticket basis
• Worked on SM7 tool
• Knowledge on Task Centre Tools

Confidential

Application DBA

Responsibilities:

• End to end exposure towards Knowledge transition process from various client regions and documenting the entire information
• Hands-on exposure towards Datacenter Migrations
• Monitoring and Managing SQL Server Health using system stored procedure and DBCC commands
• Installing, Configuring and Troubleshooting SSIS/SSRS/SSAS
• Experience in Configuring and Managing SQL Server High Availability solutions - Cluster, Mirroring and Log Shipping
• Experience in ETL (Extraction Transformation and Loading) tools like SSIS/DTS Packages, Bulk Insert and BCP Utility
• Setting up and Managing Linked Servers
• Troubleshooting and resolving the issues in the Apps/Database
• Creating and Managing SQL Server Jobs, Alerts, SQL/Database Mail. Scheduling and monitoring SQL Server Jobs, DTS/SSIS Packages
• Exposure on various cut-over of SQL Servers
• Synchronizing Production and UAT environments
• Preparing end to end Database inventory
• Performing the business reviews with senior leadership
• Preparing MOM for all the meetings held for constant updates to other team members
• Designing SQL Server Databases for Monitoring Tools requirements
• Highlighting Risks and Issues to Customers regarding Database servers
• Planning and managing the release cycle till Go-Live
• Responsible for the Quality of Service
• Conducting Technical theoretical as well as practical oriented trainings for SQL DBAs on required topics
• Analyzing the Incident ticket dumps and fixing the reoccurring issues which helps to reduce the work load
• Applying Security updates, hot fixes and SP up gradation on all servers

Confidential

Software Engineer

Responsibilities:

• SQL server daily health check.
• Installing and Configuring SQL Server, including service pack deployments.
• Monitoring the Log Space for successful execution of all the specified jobs.
• Working on Log shipping and mirroring and replication
• Verify backups and error logs on the servers and troubleshoot on any failures or alerts, open trouble tickets if necessary to work with technicians from other departments.
• Using profiler for tracing down SQL server activities.
• Also refreshing Database as per the requirements of the clients.
• Migration of SQL Server databases.
• Database Administration and Maintenance
• Implementing disaster recovery plans.
• Managing Security (Creating users, logins and roles, granting permissions)
• Performance Monitoring and tuning.
• Ensuring Data consistency in the database through DBCC commands.