SUMMARY

• Over 13 years of experience in MSSQL DBA production database support and maintenance.
• Extensive experience in managing and working wif teams in offshore - onshore model.
• Experience in client facing roles in US, process documentation, and people management.
• Excellent working experience in installation and configuration of SQL Server in Production, Test and Development Servers.
• Configured SQL Cluster, replication, Log Shipping, Mirroring and Always On.
• Expertise in Transition and Transformation project activities.
• Translate comprehensive DB architecture, implementation and upgrade plans and assists in definition of database standards, policies, and procedures.
• Worked closely wif Customer, Engineering and Application teams.
• Involved in Change Management and Problem management activities.
• Installed and configured 3rd party database Backup & Monitoring Tools like IDERA, SolarWinds, Commvault and Tivoli.
• Experience in AWS RDS and Azure SQL Cloud environments.
• Experience in capacity planning, system availability, backup and recovery.
• Involved in SQL security audit activities.
• Expertise in handling database optimizations and query tuning.
• Experience in weekly & monthly deck preparation for client meeting.
• Experience in Database Design and Programming (Stored Procedures, Functions, Triggers, and Views) using MS SQL Server.
• Hands-on experience wif SQL Reporting Services (SSRS), SSIS and PowerBI.
• Experience in Excel Macros, PowerShell and VBA application.

TECHNICAL SKILLS

Programming Languages: C#, ASP.NET, VBA, Excel Macros, PowerShell

Development Tools: VisualStudio.NET 2010/2008

RDBMS: MS-SQL Server 2000, 2005, 2008, 2012, 2014, 2016, 2017, 2019

Reporting Tools: SQL Server Reporting Services

Cloud Technologies: AWS RDS, S3, EC2, Azure SQL, Azure VM

Backup & Monitoring Tools: TSM, IDERA SQLDM, SQLSafe, Solar winds, Commvault, Tivoli.

Ticketing Tools: Service Now, Remedy

PROFESSIONAL EXPERIENCE

Confidential, Chicago

Senior SQL DBA

Environment: SQL Server 2008/2012/2014/2016/2017 , AWS RDS, Azure PaaS.

Responsibilities:

• Managing more than 1200 SQL instances in prod and non-prod environments.
• Migrate On-prem SQL instance to Azure PaaS & Managed Instance
• Installing & configuring SQL Server 2016, 2017 & 2019 both on premises and Azure & AWS cloud.
• Installing & configuring SQL Cluster & AlwaysOn availability groups.
• Involved in Data center migration and project transition.
• Database backup/restore and disaster recovery plans for production servers.
• Handling critical issues and participate in P1/P2 bridge.
• Closely working wif customer, engineering, and application teams for new implementation.
• Coordinating wif offshore team.
• Involved in new SQL monitoring & Backup tool implementation.
• Attending customer weekly and monthly meetings
• Troubleshooting performance and cloud issues.
• Involving SQL security monthly and yearly audit activities.
• Performed automation using Powershell script.

Confidential

Senior SQL DBA

Environment: SQL Server 2008/2012/2014/2016.

Responsibilities:

• Managing more than 2000 SQL instances in prod and non-prod environments.
• Installing & configuring SQL Server 2016, 2017 both on premises and Azure.
• Installing & configuring SQL Server 2016 and 2017.
• Installing & configuring AlwaysOn availability groups.
• Involved in Data center migration and project transition.
• Database backup/restore and disaster recovery plans for production servers.
• Handling critical issues and participate in P1/P2 bridge.
• Closely working wif customer, engineering, and application teams for new implementation.
• Coordinating wif offshore team.
• Involved in new SQL monitoring & Backup tool implementation.
• Attending customer weekly and monthly meetings
• Troubleshooting performance and cloud issues.
• Involving SQL security monthly and yearly audit activities.
• Performed automation using Powershell script.

Confidential

Senior SQL DBA

Environment: SQL Server 2005/ 2008/2012/2014/2016.

Responsibilities:

• Managing more than 1600+ SQL instances and 15000+ databases in production and non-Production environment.
• Installing & configuring SQL Server (2012, 2014 & 2016) and upgrading to latest service pack.
• Database backup/restore and disaster recovery plans for production servers.
• Handling Critical cases and PBI.
• Migrated databases from SQL Server 2000 to SQL Server 2012 and 2014.
• Closely monitoring the growth of the databases.
• Reviewed DB Scripts from the development team before releasing them into the Production.
• Coordinating wif developers/application team to resolve the critical application issues (both connectivity and availability)
• Coordinating wif change management team and application team and implemented the required changes.
• As a part of the DBA team providing 24/7 production support to the clients
• Troubleshooting all the customer support requests wifin the specified time interval
• Implementing the changes by coordinating wif the Change Management & Application team.

Confidential

Team Lead

Environment: SQL Server 2000/20 /2014 , IDERA SQLDM, IDERA SQLSafe, Commvault backup, TSM Tivoli backup, Remedy, AWS RDS cloud.

Responsibilities:

• Managing more than 750+ SQL instances and 15000+ databases in production and Non-Production environment.
• Create & configure AWS RDS instances
• Installing & configuring SQL Server (2008, 2008 R2, 2012 & 2014) and upgrading to latest service pack.
• Database backup/restore and disaster recovery plans for production servers.
• Migrated databases from SQL Server 2000 to SQL Server 2008 and 2012.
• Closely monitoring the growth of the databases.
• Reviewed DB Scripts from the development team before releasing them into the Production.
• Coordinating wif developers/application team to resolve the critical application issues (both connectivity and availability)
• Coordinating wif change management team and application team and implemented the required changes.
• As a part of the DBA team providing 24/7 production support to the clients
• Troubleshooting all the customer support requests wifin the specified time interval
• Implementing the changes by coordinating wif the Change Management & Application team.

Confidential

Environment: SQL Server 2008/R2

Responsibilities:

• Involved in installation and configuration of SQL server 2005/2008/2008 R2.
• Database backup/restore and disaster recovery plans for production servers.
• Upgrading databases from earlier versions to latest versions.
• Troubleshooting performance issues and fine-tuning queries.
• Involved in MS SQL Server Cluster installation on Windows servers.
• Resolving the production issues.
• Job scheduling and maintenance.
• Monitoring the backup jobs

Confidential

Environment: SQL Server 2005/2008/2008 R2

Responsibilities:

• Involved in installation and configuration of SQL server 2005/2008/2008 R2. Applied patches and service packs to keep the database at current patch level.
• Database backup/restore and disaster recovery plans for production servers.
• Upgrading databases from earlier versions to the latest versions.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Implemented database standards and naming convention for the database objects.
• Involved in MS SQL Server Cluster installation on Windows servers
• Job scheduling and maintenance.

Confidential

Environment: SQL Server 2005/2008

Responsibilities:

• Going through the clients' requirements and coming up wif database design and application architecture.
• Installing, configuring, administering and securing our as well as our clients' production servers.
• Database backup/restore and disaster recovery plans for production servers.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Writing code and creating jobs to automate repetitive tasks.
• Upgrading databases from earlier versions to the latest versions.
• Involved in loading the partner flat files into the OLTP database. Also, developed the T-SQL stored procedures/functions to process these data and populate them in the appropriate destination tables.
• Providing consultation on SQL Server to our development teams.