Yao Amegnran

Architect and administer enterprise Microsoft SQL Server (2016–2022) environments supporting high-volume marketing analytics, ensuring 99.9%+ availability and strong query performance. Designed automated backup/restore and DR strategies to reduce RTO/RPO gaps, and led tuning by optimizing indexing and resolving blocking/deadlock issues.

Completed 48 hours of hands-on SOC training focused on Linux hardening, network defense, and incident response aligned to NIST best practices. Triaged security alerts and conducted threat analysis using Splunk Enterprise, and performed simulated defense exercises with pfSense.

Engineered secure, high-performance database environments on Linux using RMAN backup/recovery patterns and supported on-prem to AWS/Azure migrations aligned to NIST 800-53 controls. Administered Snowflake (RBAC, virtual warehouses, health monitoring) and delivered performance tuning using AWR/ADDM/Statspack alongside rigorous patch management with CPU/PSU using OPatch.

Executed backup and disaster recovery using RMAN, Data Pump, and Veritas NetBackup to improve RPO/RTO, and maintained high-availability using Oracle RAC and PostgreSQL master-slave replication for 24/7 uptime. Managed monitoring and tuning through OEM and performance tools (AWR/ADDM/EXPLAIN PLAN), while administering Oracle Cloud/AWS RDS and supporting SQL Server upgrades and maintenance.

Completed an Associate of Applied Science in Cyber Security at Montgomery College (Takoma Park Campus).

Activities and societies: Hands-on SOC training; Splunk Enterprise SIEM/log monitoring; pfSense firewall attack/defense exercises; foundational Active Directory and incident response concepts.

Completed SOC Operations Analyst Trainee training focused on Linux hardening, network defense, and incident response aligned to NIST best practices. Practiced alert triage and incident documentation using Splunk in a simulated SOC environment.