OBJECTIVE:

• Self - motivated individual with fourteen plus years of strong technical experience in the IT and service delivery. Organized and detail oriented, who exemplifies professionalism, and an ability to provide solutions for complex problems. Rich expertise in support and management of SQL Server.
• Primary technical expertise is in the areas of installation, management, troubleshooting and maintenance of Databases and providing high-quality operational guidance and timely resolution.

SUMMARY

• Over fourteen years of Professional experience as SQL SERVER Database Administration and Production Servers maintenance.
• Having experience in multiple domains including Telecom, Health, Retail and Finance.
• Gathering data requirements and designing and fine-tuning of databases as per the requirement of clients. Complete Administration of Microsoft SQL Server Databases is my primary responsibility.
• Experience in Import, Export, Backup, Database Monitoring tools and Application support.
• Good working knowledge in Logshipping, Mirroring, Replication, Clustering and AlwaysON.
• Experience in planning and implementing the Disaster Recovery (DR) strategies as per the client requirements
• Experience in AWS RDS & Azure PAAS database administration.
• Hands on experience with scripting languages like PowerShell & VBS.
• Experience in configuring & Administering 3 rd party monitoring tools SolarWinds, Spotlight, Nagios, Check MK.
• Built a SQL monitoring tool based on PowerShell scripts and integrated it with ServiceNow ticketing system to convert Alerts to Tickets automatically.
• Strong Technical background to direct, manage, grow, and lead a team with strong leadership capabilities.
• Ability to work effectively in a very independent environment, balancing multiple priorities and keeping stakeholders apprised of status and issues
• Strong interpersonal skills, with the ability to easily and effectively interact with technical, non-technical, support, and business staff at all levels
• Experience with onshore/offshore business models and sourcing concepts. Worked with global clients/teams to support and manage large projects.
• Received numerous accolades from customers and at executive management level. Takes ownership and responsibility to create/commit to SOWs, SLAs, SOP, and process improvement.

TECHNICAL SKILLS

Databases: SQL SERVER 2000, 2005, 2008, 2008R2, 2012, 2014, 2016, 2017, PostGreSQL

Operating System: Windows Server 2016\2012\2008\2003\2000, XP.

Scripting Languages: PowerShell, VBScript

Monitoring Tools: SolarWinds, Spotlight, Nagios, Check MK.

PROFESSIONAL EXPERIENCE

Confidential

Lead SQL Server DBA

Technologies Used: SQL Server 2017\2016\2014\2012\2008R2\2008\2005\2000, Windows 2016\2012\2008\2003\2000, PostGreSQL

Responsibilities:

• Lead a pool of SQL DBAs from junior to expert level. Mentor, coach and train the DBAs and provide technical support for 10 plus clients.
• Pro-active monitoring of Database related activities, Installations, applying SQL Security Patches, Version Upgrades.
• Work closely with clients to detect problems and provide resolution to improve optimization and efficiency.
• Responsible for client interaction, incident management, change management, problem management, alert management and service delivery.
• Automation of day to day activities using the PowerShell scripts.
• Configuring SQL monitoring with SolarWinds, Spotlight.
• Built a SQL monitoring tool based on PowerShell scripts and integrated it with ServiceNow ticketing system to convert Alerts to Tickets automatically.
• Implementation and maintenance of Log shipping, mirroring and Transactional replication, clustering and AlwaysON.
• Database Performance Tuning - Understanding and recommendation based on SQL.
• Upgrade \ Migrate databases from on-perm to cloud and vice versa. Hands on experience with AWS RDS & Azure PASS.
• Working knowledge on PostGreSQL database in Windows Enviornment
• Implementing and troubleshooting the issues with Transactional Replication.
• Designed and Implemented DR strategies as per the client requirement.
• Independently managing Production and Development database support.
• Good knowledge in troubleshooting issues with SSIS and SSRS.

Confidential

Sr. SQL Server DBA

Technologies Used: SQL Server 2014\2012\2008R2\2008\2005\2000, Windows 2012\2008\2003\2000

Responsibilities:

• Working with multiple UK and US based clients and managing team of four members.
• Pro-active monitoring of Database related activities, applying SQL Security Patches, Version Upgrades.
• Implementation and maintenance of Log shipping, mirroring and Transactional replication, clustering and AlwaysON.
• Good experience in installing the SQL Server (2014\2012\2008R2\2008\2005) on the windows clusters 2012\2008R2\2008\2003.
• Database Performance Tuning - Understanding and recommendation based on SQL.
• Upgrade \ Migrate databases from SQL Server 2005 to SQL Server 2008R2\2012\2014.
• Implementing and troubleshooting the issues with Transactional Replication.
• Designed and Implemented DR strategies as per the client requirement.
• Independently managing Production and Development database support.
• Good knowledge in troubleshooting issues with SSIS and SSRS.
• Configured SQL monitoring through Nagios monitoring tool.
• Attended ELP (Emerging Leadership Program) training.

Confidential

SQL Server DBA

Technologies Used: SQL Server 2008\2005\2000, Windows 2008\2003\2000

Responsibilities:

• Worked with a large US based Telecom environment with a total of 200+ servers in which around 70 production servers with a total of more than 3000 databases.
• Good understanding in incident management.
• Monitor the status of Maintenance jobs - schedule to run daily and on weekends (tasks like rebuilding indexes, defragmenting Databases, Shrink Database, and Database complete backup).
• Created and scheduled scripts for Database growth Monitoring, Disk Space Monitoring, Check Blockings on the server and SQL Server Performance snapshot application which gives the CPU and Memory utilizations, Long running jobs and processes information of a selected server
• Attend to user calls using Remedy call tracking system, resolve problems over the phone or email
• Escalate support requests to next level of internal support upon approach of established resolution targets
• Escalate application issues/bugs to the development team and provide resolutions
• Experience in Database mirroring, Log Shipping and Snapshot\Transactional Replication
• Scheduling and Troubleshooting of SSIS packages and Jobs
• User administration in SSRS and SSAS
• Troubleshooting and scheduling of SSIS packages.
• Troubleshooting problems with reports in SSRS.
• Hands-on experience with SQL Server installations and patching
• Basic knowledge in troubleshooting Clustering issues.
• Performance Tuning of Database by using query plans, profiler and DTA.

Confidential

SQL Server DBA

Technologies Used: SQL Server 2005\2000, Windows 2003\2000

Responsibilities:

• Backup client databases and perform database restore and run consistency checks from SQL Server and application. Performs and monitors daily database operations and set-up backup schedules
• Troubleshooting any SQL related issues in Client Servers
• Monitor the status of Maintenance jobs - schedule to run daily and on weekends (tasks like rebuilding indexes, defragmenting Databases, Shrink Database, and Database complete backup).
• Creating users and giving appropriate permissions.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
• Monitored and Modified Performance using execution plans and Index tuning.
• Rebuilding the indexes at regular intervals for better performance
• Complete Documentation about the database
• Export or Import data from other data sources like flat files using Import/Export of DTS / SSIS.
• Recovering the databases from backup in disasters
• To set up SQL Server configuration settings