Sql Server Database Administrator

*/*

Ganesh Salgaonkar

Troy, MI-***** – 248-***-**** – **********@*****.***

Database Administrator

Microsoft SQL Server and Oracle Database Administrator with over 15 years of extensive experience in Database Engineering, Architecture, Performance Tuning, and Administration. Proficient in MySQL, PostgreSQL, Windows, Linux, Networking, and SAN. Strong leadership skills in managing global teams and customer relationships in complex IT environments. Expert technical abilities complemented by excellent communication, interpersonal, and analytical skills.

Key Accomplishments:

• Led datacenter migrations for SQL Server and Oracle databases, ensuring minimal downtime and seamless transitions.

• Installed, configured, and administered Failover Clusters and Availability Groups on Azure and on-premise.

• Upgraded SQL Server versions from SQL 2000 to SQL 2022 ensuring compatibility and performance improvements.

• Migrated on-premise SQL Databases to Azure SQL Database and Azure SQL VMs, optimizing scalability and cost efficiency.

• Configured Distributed Availability group for seamless SQL Server Migration.

• Managed and optimized databases on Azure Elastic Pools and Managed Instances to enhance resource utilization.

• Installed, configured, and administered Oracle 12c, 18c, & 19c on Linux.

• Implemented and managed Data Guard for high availability and disaster recovery.

• Applied PSU/CPU patches and resolved bug fixes to maintain database security and performance.

• Designed and implemented backup and recovery strategies to meet business SLA requirements for SQL Server and Oracle.

• Optimized SQL Server performance using PSSDIAG/SQLDIAG, Extended Events, Profiler, Perfmon, and DMVs to resolve bottlenecks, deadlocks, and performance issues.

• Assisted developers with query writing, optimization, and performance tuning to improve application efficiency.

Core Skills:

• High Availability & Disaster Recovery (HADR) solutions • Datacenter Migrations

• SQL Server standalone & clustered installations • Database Migration to Azure

• Oracle standalone server administration • SQL Server Consolidations and Upgrades

• SQL Server Replication, DB Mirroring, Log Shipping • Performance tuning & query optimization

• SQL Server Always-On Failover Cluster and Availability Group • PowerShell scripting for Monitoring/automation

• Installation/Configuration/Administration - SSIS, SSRS & SSAS • Performance Monitoring and Tuning.

• Install and configure Oracle Enterprise Manager (OEM)13c • RMAN Backup and recovery strategies

• Windows & Linux System administration • Data pump utility for DB refresh 2/2

Professional Experience:

Lead DBA – Azure/SQL Server & ORACLE 06/2013 – present T-Systems. MI, USA

• Lead Database Operations and Data Center migration team, coordinate day to day activity including SQL Server consolidation, performance tuning, upgrades, patching and deployments.

• Provide production support to over 250 SQL Server Instances and over 100 Oracle Databases.

• Mentor and manage DBA teams to adhere to best practices and industry standards

• Develop high level design based on the requirement and estimate the amount of effort required to deliver on time.

• Architect and implement high availability and disaster recovery solutions

• Install and configured SQL Server Always-On Availability Group and Failover Cluster.

• Implement Transparent Data Encryption (TDE) for secure data storage.

• Migrate SQL Server Databases from on-premise to Azure IAAS/PAAS.

• Install and upgrade Oracle 11g/12c databases

• Applying PSU/CPU and bug fixing patches and trouble shooting.

• RMAN Active database cloning, cloning using Hot and cold backups

• Schema refreshes using Data pump utility in 11g and 12c databases Senior SQL Server DBA 10/2012 – 06/2013

Ally Financials. MI, USA

Principal SQL Server DBA 10/2011 – 10/2012

Benesys Inc. MI, USA

SQL Server Database Engineer/Administrator 01/2006 – 09/2011 SPAR Group Inc. MI, USA

Software Engineer/Database Architect/Technical Project Lead 06/1998 – 12/2005 SPAR Group Inc. MI, USA

Education & Certifications:

Bachelor of Science – University of Mumbai, India.

Post Graduate Systems Management – Mumbai, India

Microsoft Certified Azure Database Administrator

MS Certified IT Professional (MCITP-Database Administrator)

Microsoft Certified Technology Specialist (MCTS-DBA)

Certified ITIL 4 – IT Service Management (06/2021)

Project Management Professional (PMP Certified)

Microsoft Azure Architect

Azure SQL Server DBA

Oracle Database Administrator

Cisco Routing and Switching

Cloudera Hadoop Administration

Sun Certified Java 2.0 programmer

Contact this candidate