Senior SQL Database Administrator

*

FRANCIS UGWA

***********@*****.*** Tulsa, OK 918-***-**** LinkedIn: linkedin.com/in/francis-ugwa-6b20a2198/ CAREER SUMMARY

I’m results-driven SQL Database Administrator with 7+ years of experience managing enterprise database environments across on- premises and cloud platforms (AWS, Azure). I have proven expertise in database performance tuning, high availability, ETL automation, and reporting solutions. I am adept at improving system reliability, optimizing queries, and driving data integrity across production and test environments. Strong collaborator skilled at translating business needs into scalable database solutions. TECHNICAL SKILLS

Accomplishment Highlights

Developed, and the trained team worked with them for a system and database disaster recovery for coop operation purposes.

Patching, updates, cumulative updates, upgrade on WSFC and AlwaysOn AG.

Cloud Computing- AWS and Azure database migration, DB Instance creating O&M, HA, monitoring.

Increased high availability solutions for any level of customer/product we support.

Tuned underperforming locations into top-earning Organizations, user support, computer update, upgrade.

Upgraded staff quality and performance by developing and executing a customized training program for newly developed customer software.

Retained teams and met critical goals during challenges those severely impacted overall business revenues.

Safeguarded the platform, SQL Server, and databases in response to security auditing, worked on remediate venerability.

T-SQL Programming- writing T-SQL queries (Data Definition and Data Manipulation language), code review, manage security logins/users.

PROFESSIONAL EXPERIENCE

SQL DATABASE ADMINISTRATOR MAGNA HOME HEALTH TULSA, OK DURATION: 09/2021 - PRESENT

Supported mission-critical database platforms using SQL Server technologies at an enterprise scale, ensuring high availability and disaster recovery readiness.

Managed, maintained, and performed day-to-day administration of SQL Server databases, including backups, indexing, query optimization, and performance monitoring.

Worked on database upgrades and migrations from older SQL Server versions to SQL Server 2019, 2022 and 2025 (lab) ensuring minimal downtime and data integrity.

Installed, configured, and applied updates, patches, service packs, and security enhancements to SQL Server instances to maintain optimal security and stability for all platforms.

Provided customer and end-user support, addressing database-related issues, troubleshooting performance bottlenecks, and assisting with query tuning.

Working with end-user, system owner for account and system issues, upload media data, and edit, modify based on the end-user request.

Granted and managed access permissions, ensuring proper role-based security and compliance with organizational policies.

Administered SQL Server instances in AWS and Azure environments, leveraging high availability solutions such as Windows Server Failover Clustering (WSFC) and AlwaysOn Availability Groups.

Developed and maintained reports using SQL Server Reporting Services (SSRS), integrating data from multiple sources to provide actionable insights.

Designed, developed, and deployed ETL solutions using SQL Server Integration Services (SSIS) for data migration, transformation, and automation.

2

Utilized Power BI to create interactive dashboards and visualizations, enabling business users to make data-driven decisions.

Wrote and optimized T-SQL scripts for stored procedures, triggers, functions, and complex queries to improve database performance and functionality.

Implemented Transparent Data Encryption (TDE) to protect sensitive data at rest and enforced security best practices at both the SQL Server and database levels.

Provided support for database performance tuning, monitoring disk space, resolving I/O bottlenecks, and troubleshooting concurrency issues.

Assisted in data migration, integration, and validation across multiple systems.

Collaborated with stakeholders to understand data requirements and improve data accuracy.

Automated data processes using T-SQL and scheduled jobs for efficiency.

Created and maintained database documentation, including data dictionaries, standard operating procedures (SOPs), and service-level agreements (SLAs).

Collaborated with developers and business analysts to support application databases, ensuring efficient and reliable data access.

DATABASE ADMINISTRATOR ALTRAN FINANCIAL TULSA, OK DURATION: 04/2017-08/2021

Designed and implemented a full-scale reporting solution supporting a multi-client environment using Microsoft SQL Server, Power BI, and SSRS.

Installed, maintained, and applied updates, patches, and service packs for SQL Server instances on physical and VMware virtual servers, ensuring high availability in Windows Failover Clustering environments.

Developed, deployed, and maintained SSIS packages, overseeing report servers and managing user access for reporting and data integration.

Designed and integrated Power BI visuals into Power BI apps, providing customers with interactive dashboards and data- driven insights.

Coordinated data integration between Microsoft solutions, including Azure data services, enabling seamless data sharing and visualization across Power BI dashboards and reports.

Performed proactive database maintenance, including health checks, index optimization, and troubleshooting SQL Server performance issues.

Acted as a Database Engine Tuning Advisor, utilizing DBCC commands and Dynamic Management Views (DMVs) to analyze performance and address customer requirements.

Enhanced database and application performance through regular maintenance, best practice implementation, and continuous improvement initiatives.

Created, scheduled, and managed SSIS packages, SQL Agent jobs, database mail, alerts, and automated maintenance tasks.

Applied data modeling techniques and normalization principles to design and manage databases for optimized performance and scalability.

Served as a subject matter expert, providing guidance on database solutions, technical documentation, and multi-platform integration strategies.

Monitored and optimized query execution plans, rebuilt and aligned indexes based on fragmentation levels to improve database performance.

Implemented and managed SQL Server high availability and disaster recovery solutions, including log shipping, replication, clustering, and standby configurations.

Improved system response time through efficient resource allocation, load balancing, file group management, and partitioning strategies for MDF, NDF, and LDF files.

Ensured optimal system performance by monitoring I/O operations, wait statistics, memory usage, network bandwidth, connection concurrency, and storage availability.

Provided hardware/software support, troubleshooting system performance, network, and application issues.

Installed, configured, and upgraded operating systems, applications, and security updates.

Maintained network devices, managed Active Directory accounts, and applied security measures.

Deployed and configured workstations, printers, and peripherals for end users.

Assisted with backups, system imaging, and data recovery procedures.

Responded to help desk tickets, resolving technical issues and providing user support. 3

HELPDESK ASSOCIATE BEST WESTERN PLUS COWETA, OK DURATION: 01/2016 – 03/2017

Delivered high quality customer service, managed guest check-ins/outs, and ensured accurate billing.

Consistently recognized for professionalism and customer satisfaction. EDUCATION

B.Sc., Ebonyi State University, Nigeria (2010)

Diploma, UCSI Kuala Lumpur, Malaysia (2012)

TRAINING & CERTIFICATIONS

Microsoft SQL Server Database Administration

Microsoft SQL Server Reporting Service & Power BI

Microsoft SQL Integration Service

Microsoft Certified Azure Database Administration Associate DP-300 (2025)

AWS Fundamentals: Going Cloud Native, Certification SKILLS & CORE STRENGTHS

Database Administration

Database Migration

Cloud Services

Project Management

Technical Leadership

Analytical Skills

TDE (Encryption: SSL/TLS)

Strategic Planning

Time Management Skills

Customer Service Skills

Training & Development

Application Designs

Creative Problem Solving

Written Communication

Critical Thinking

Database Security

Database Design & Creation

Windows Server Clustering

Always On (HA/DR)

Visual Studio (ssdt)

LogShipping/Replication/Mirroring

REFERENCE: Available

Contact this candidate