Database Administrator Sql Server

FLORENCE OUEDRAOGO

SQL SERVER DATABASE ADMINISTRATOR

Dayton, Texas 77535 Email: **********@*****.*** Phone: +1 (443) 510- 8415 www.linkedin.com/in/floued

Professional Summary -

Results-oriented SQL Server Database Administrator with over 5+ years of experience in managing mission-critical databases, consistently reducing downtime by 20% and optimizing query performance by 30%. Expertise in PL/SQL, SQL Server installation, migration, patching, and troubleshooting across on-premise and cloud environments. Proven experience with high availability solutions (Always-On, Replication) and adept at leveraging monitoring tools like Redgate and SolarWinds. Strong cross-functional collaborator with a commitment to enhancing database performance, security, and compliance.

Skills

Database

Management

High Availability

Solutions

Database Security Cloud Platforms &

Virtualization

Monitoring &

Performance Tools

• T-SQL

• Modeling

• PL/SQL

• Backup and Recovery

• SSIS

• SSRS

• SSAS

• Redgate

• DMV

• Always On

Availability Groups

• Replication

• Log Shipping

• Disaster Recovery

Planning

• High Availability

Solutions

• TDE

• DDM

• Azure

• VMWare

• Hyper-V/VM

• Solar Winds

Education

Bachelor Degree in Business and Administration,

University of Burkina Faso 2012

Certification

Microsoft Certified Azure Database Administration Associate (AZ104) Pursuing

Advance Database Administrator Training Program 2017

MTA Certification 2022

Experience

TDCJ (Texas Department of Criminal Justice) March 2024 - Present MS SQL Database Administrator

• Developed and maintained mission-critical SQL Server databases, ensuring 99.9% availability for state justice applications.

• Implemented and optimized PL/SQL procedures for data processing, improving query performance and response times by 25%.

• Spearheaded performance tuning initiatives by analyzing DMV and query plans, reducing execution times by 30%.

• Architected and managed high availability systems using AlwaysOn Availability Groups and replication for failover and disaster recovery.

• Automated routine database tasks, including backups and restores, using PL/SQL and PowerShell scripts, reducing manual workloads by 40%.

• Led security and compliance initiatives, including encryption and role-based access control, to meet TDCJ and state regulatory standards.

• Managed SQL Server upgrades and patching across critical systems, ensuring minimal downtime and smooth transitions.

• Mentored junior database administrators and cross-functional teams on PL/SQL, high availability configurations, and troubleshooting complex database issues.

Blue Cross Blue Shield January 2022– February 2024 MS SQL Database Administrator

• Managed large-scale Medicare and healthcare databases, ensuring data integrity and 99.9% system uptime across critical healthcare applications.

• Optimized Medicare claim processing times by 30% through advanced query optimization and indexing strategies.

• Led the implementation of PL/SQL scripts for Medicare data extraction and reporting, improving accuracy and reducing processing time by 40%.

• Successfully migrated on-premise healthcare databases to Azure SQL, streamlining cloud transitions and ensuring seamless integration.

• Automated key database maintenance processes, including backups, disaster recovery tests, and system audits, using PL/SQL and PowerShell scripts.

• Enhanced database security with Transparent Data Encryption (TDE) and Dynamic Data Masking (DDM) to meet HIPAA compliance requirements.

• Managed SQL Server version upgrades, including migrations from SQL Server 2012 to 2019, with minimal disruption to ongoing services.

• Collaborated with healthcare application developers to optimize SQL queries and database schemas, improving application performance and user experience.

Whataburger, San Antonio September 2018 – November 2021 SQL Database Administrator

• Installed and configured SQL Server databases, gaining hands-on experience with both on-premises and cloud environments.

• Assisted senior DBAs in monitoring database performance and identifying performance bottlenecks.

• Supported daily database maintenance tasks, including backups, restores, and routine index maintenance to ensure optimal performance.

• Collaborated with developers and application teams to write basic SQL queries, stored procedures, and participate in minor schema changes.

• Began learning and implementing basic high availability solutions such as Log Shipping and Database Mirroring to ensure business continuity.

• Monitored database security by creating and managing user roles, permissions, and assisting with encryption protocols.

• Conducted SQL Server version upgrades under the supervision of senior DBAs, starting from SQL Server 2008 to SQL Server 2016.

• Utilized monitoring tools such as Redgate and SQL Server Management Studio (SSMS) to track server performance and optimize database processes.

• Gained experience in troubleshooting basic database issues, working closely with senior DBAs to resolve incidents and maintain database uptime.

• Documented basic processes and learned to create standard operating procedures for routine database tasks.

Contact this candidate