SANDRA FANG
Database Administrator
***********@*****.***
Huntsville, TX
PROFESSIONAL SUMMARY:
Experienced and detail-oriented MS SQL Database Administrator with over 5 years of proven expertise in administering, maintaining, and optimizing SQL Server databases across development, testing, and production environments. Skilled in database installation, configuration, performance tuning, backup and recovery, high availability (HA)/disaster recovery (DR) solutions, and writing complex T-SQL queries. Adept at ensuring data security, integrity, and compliance with industry standards. Strong background in troubleshooting, monitoring, and automation to improve database performance and reduce downtime. Collaborative team player with excellent problem-solving skills, committed to delivering robust and scalable database solutions that align with business objectives.
Expertise in managing enterprise-level MS SQL Server environments with a focus on performance tuning, high availability, disaster recovery, and data security across production and non-production systems.
Proven ability to automate and streamline database administration tasks using T-SQL and PowerShell, while collaborating with cross-functional teams to deliver reliable, compliant, and scalable database solutions.
PROFESSIONAL EXPERIENCE:
Truist Financial September 2022 – Present
Role: MS SQL Database Administrator
Administer and maintain SQL Server databases across development, testing, and production environments to ensure high availability and optimal performance.
Perform routine database maintenance tasks including backups, restores, integrity checks, index management, and consistency checks using automation tools and scripts.
Monitor system health and performance using tools like SQL Server Management Studio (SSMS), SQL Profiler, and third-party monitoring solutions to proactively resolve performance issues.
Implement and manage high availability and disaster recovery (HA/DR) strategies using Always On Availability Groups, Log Shipping, and Database Mirroring.
Collaborate with application developers and business analysts to design and optimize T-SQL queries, stored procedures, and indexing strategies for efficient data retrieval.
Ensure data security and compliance with internal policies and industry standards by managing user roles, permissions, encryption, and auditing.
Comcast Corporation January 2020 – August 2022
Role: SQL DBA
Managed and supported SQL Server environments, including installation, configuration, patching, and database migrations across development, staging, and production.
Performed regular backups, restores, and disaster recovery testing to ensure data availability, integrity, and compliance with internal and regulatory standards.
Tuned SQL queries, indexes, and database configurations to optimize performance and reduce response times in high-transaction systems.
Developed and maintained T-SQL scripts, stored procedures, and automation routines to streamline database administration tasks.
Collaborated with cross-functional teams to support database requirements for application deployments, troubleshooting, and performance monitoring.
Implemented role-based access controls, encryption, and auditing features to enhance data security and ensure compliance with corporate policies
Mobile Telephone Network MTN June 2017 – September 2019
Role: MSSQL Database Administrator
Monitored and tuned SQL Server performance using Activity Monitor, Spotlight, and index optimization techniques to ensure optimal database efficiency in a 24/7 production environment.
Implemented and managed backup and disaster recovery strategies including native SQL Server backups, Log Shipping, and automated biweekly database refreshes across PROD, STG, DEV, and UAT environments.
Enforced database security by configuring logins, roles, permissions, Transparent Data Encryption (TDE), and contained databases to safeguard sensitive data and support compliance.
Automated routine DBA tasks, supported on-call production environments, and provided critical system testing, integration testing, and UAT support prior to production deployments.
Installed SQL Server in clustered environments and executed version upgrades, patch management, and compatibility level changes to align with performance and application requirements.
Created and maintained comprehensive documentation for all SQL Server processes, code reviews, and knowledge-sharing initiatives to support team collaboration and operational consistency.
SKILLS:
Categories
Skills
Database Platforms
Microsoft SQL Server (2012–2022), Azure SQL Database
Database Tools
SQL Server Management Studio (SSMS), Azure Data Studio, Redgate Toolbelt
Performance Tuning
Execution Plans, Query Optimization, Index Tuning, SQL Profiler, Extended Events, Activity Monitor
HA/DR Solutions
Always On Availability Groups, Log Shipping, Failover Clustering, Backup & Restore Strategies
Security & Compliance
Transparent Data Encryption (TDE), Row-Level Security, Role-Based Access Control (RBAC), Auditing, Data Masking, HIPAA, GDPR
Scripting & Automation
T-SQL, PowerShell, SQL Agent Jobs, Maintenance Plans, Backup/Index Rebuild Automation
ETL & Data Movement
SQL Server Integration Services (SSIS), Data Import/Export, Data Migration
Incident & Change Management
ServiceNow, Jira, Patch Management, Change Control, Documentation
Environment Management
Production, Development, UAT Environments, Runbook Creation, Root Cause Analysis, Issue Resolution
EDUCATION:
Postgraduate Degree in ML and AI, ML, DBA, AI, Data science April 2025
Texas A&M University
Bachelor of Science in Computer Science December 2018
University of Bamenda
CERTIFICATIONS:
MTA DATABASE Fundamental, PYTHON, ml and AI