SUMMARY

• Senior Database Administrator with 5+ years of solid technical experience in management, administration, availability and security of Microsoft SQL Server 2005 to 2017 Databases with experience in On - premise, and in-Cloud implementations with Microsoft Azure and Amazon AWS. Extensively skilled in handling production and non-production environments to minimize downtimes and ensuring system availability, meeting the Recovery Time Objectives (RTO) and the Recovery Point Objectives (RPO) as per Service Level Agreements.
• Currently managing 1500+ databases in 100+ SQL instances across all the environments in a team of 2 DBAs.
• Creating and Supporting Databases in Amazon RDS and Azure SQL Databases (PaaS); and databases in Virtual Machines in Azure and EC2 instances in AWS (IaaS).
• Microsoft Certified Solutions Associate (MCSA) in Microsoft SQL Server 2012 with in-depth knowledge of the product, its features, and capabilities.
• Highly proficient in SQL Server Performance Tuning using Wait Statistics, and confirming the issues by corroborating the findings with the results of other DMVs, perfmon, profiler, or Extended Events.
• Adept at using DevOps tools and methodologies to properly meet clients’ demands.
• Installing and configuring SQL Server, SSIS, and SSRS on Windows and Linux Operating Systems (SQL 2017+), including Docker and Kubernetes implementations, applying latest Service Packs and Cumulative updates.
• Proficient with handling extra-large databases which are 10+ TB in sizes.
• Experience in Installation, maintenance and support of various High Availability and Disaster Recovery features like Always-On Availability Groups, Failover Clustering, Database Mirroring, Log Shipping, and Replication.
• Thorough understanding of SQL Instance level and Database level security configurations.
• Detailed understanding of Database backup, recovery and maintenance strategies, setups utilizing SQL Server Maintenance Plans in SSMS, or industry certified Ola Hallengren’s scripts.
• Strong Scripting skills and experience in PowerShell, Linux and UNIX (bash, ksh, and csh).
• Thorough understanding of Windows group policies, NTFS file system permissions, and Active Directory Domain Services.

TECHNICAL SKILLS

Database Systems: MS SQL Server 2005 - 2019, Oracle Database, MS Access, SQLite

Version Control: Microsoft TFS, IBM ClearCase, Git

Bug Tracking: Cherwell CSM, IBM ClearQuest, JIRA, TFS

Programming Languages: PowerShell v3+, T-SQL, PL/SQL, Shell Scripting, C#, Visual Basic, C/C++

Operating Systems: Windows, UNIX and LINUX

PROFESSIONAL EXPERIENCE

Confidential

Senior SQL Server Database Administrator

Responsibilities:

• Currently administering 1500 + databases in a 100 + SQL Server instances across all environments, which include 10 Failover Cluster Instances and 5 Always on Availability groups.
• Handling the databases for the two major applications which are used across all the hospitals in the province of Ontario - Wait Times and The Electronic Canadian Triage and Acuity Scale (eCTAS), in addition to a lot more in-house applications.
• Performance tuning of SQL servers using various methodologies including wait statistics, DMVs, Profiler, Extended Events, Perfmon, Query Store, and, common sense
• Managing SQL Server in Virtual Machines in Microsoft Azure (IaaS) as well as the Azure SQL Database (PaaS).
• Developing and maintaining PowerShell scripts to achieve Automation in frequently used database related tasks as well as regular database monitoring.
• Maintaining proper security for all SQL Server instances by granting access to only the users who require them and also making sure that they don’t get any more permissions than what’s required - the Principle of Least Privilege.
• Ensuring the availability of verified backups across all production environments to restore in case of a Disaster Recovery.
• Assist in deployments across all environments with attention to detail.
• Migrating Databases on SQL Server 2008 and 2008R2 to later versions, making sure all the logins, users with permission, corresponding jobs etc. are moved with them.
• Assisting developers and business owners alike in selecting and setting up high-availability options like Replication, Failover Clustering, Log Shipping, Always-On Availability Groups, and Mirroring.
• Installing and configuring SQL Server 2012 to 2017, with their latest Service Packs, in addition to installing and configuring SQL Server Reporting Services and SQL Server Integration Services for applications that require them.
• Building basic SSIS packages for Proof of Concept and ETL needs.
• Installing and configuring Biztalk 2013 to 2016 for the application that requires so.
• Troubleshooting access issues, performance problems and other pain points of the databases using DMVs and other scripts and fixing the identified issues.
• Working on Service Request and Incident Reports tickets, giving users access to sensitive databases ensuring transparency.
• Providing 27/7 On-call support on a rotational basis with other team members.
• Accomplishing automation for tasks with a large number of steps by developing Orchestrator Workflows in Microsoft System Center.
• Managed 50+ SQL instances with databases, their ownership, accesses, backups, restores, refreshes etc.
• Managed and troubleshooting security issues from testers/business analysts on test SQL systems, building T-SQL scripts to automate these tasks.
• Installed and configuring SQL server, SSRS, SSIS and restoring databases and making them ready to use according to business requirements.
• Performed Database deployments on all the environments.
• Controlled access to the Test and production 2003 to 2012 windows servers.
• Performed web deployments on IIS servers on the Windows Server environment.
• Performed setups of new IIS applications, UDDI applications.

Confidential

Release Code Management Analyst

Responsibilities:

• Performed highly complex releases on UNIX, Windows and AS 400 platforms.
• Accepted only approved requests for changes to the testing and production servers.
• Reviewed release checkout list, back out plans and environment requirements.
• Built relationships and understandings with development, support, and infrastructure groups.
• Managed ClearQuest user accounts for all development teams.
• Resolved ClearCase technical issues from different development teams.
• Worked on internal projects like modifying/enhancing regular use UNIX scripts.
• Provided user consultation and technical support for internal and external project activity.
• Provided On-Call Support, and performing off hours releases for clients in case of emergencies.