Frank Kamanda
MS SQL Server DBA | Azure & On-Prem Expert | Performance Tuning | HA/DR | ETL | Cloud Migrations | T-SQL | 6+ Years Experience
- Role
- Ms Sql Server Database Administrator at PNC
- Location
- Glendale, AZ, US
- LinkedIn followers
- 500 followers
About Frank Kamanda
I’m an experienced MS SQL Server DBA with 6+ years managing on-premises and Azure SQL…
Experience
Ms Sql Server Database Administrator
Sep 2022 — Present
Tuned long-running queries using execution plans, indexing strategies, and T-SQL rewriting. Implemented and maintained Always on Availability Groups and Log Shipping for HA/DR. Automated daily health checks, index maintenance, and backup validation using PowerShell. Conducted database migrations using DMA and Azure Database Migration Service. Monitored performance using SolarWinds DPA and SentryOne, reducing bottlenecks by 40%. Administer and maintain multiple SQL Server instances (2012–2022) across on-premises and cloud environments (Azure & AWS RDS). Perform query tuning and optimization using indexing strategies, execution plans, and monitoring tools like Redgate and SentryOne. Implement HA/DR solutions including Always On AG, log shipping, and replication to ensure 99.99% uptime. Automate routine database tasks using PowerShell and Python scripts to reduce manual overhead and improve efficiency. Monitor database health and proactively resolve bottlenecks using Extended Events, SQL Profiler, and SolarWinds DPA. Architect and configure Always On Availability Groups within multi-node clusters, enhancing high availability and data resilience. Managed Replication and Log Shipping to ensure continuous data synchronization and availability. Developed efficient ETL pipelines using Talend, integrating data from sources like Oracle, MySQL, and SAP-HANA into the SQL Server ecosystem to enhance data flow efficiency. Manage backup strategies including point-in-time recovery and cloud backups via Azure. Skilled in administering and optimizing SQL Server databases across versions 2005–2019, with hands-on experience in performance tuning, query optimization, and database integrity. Successfully integrated SQL Server with Google Big Query to enable advanced healthcare analytics, reducing reporting times by up to 60%. Led data migration projects from SQL Server to Big Query and implemented GCP tools for real-time data processing.
Education
University of Bamenda
Bachelor's degree
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.