BRANICK WANGIA
Summary
Senior database administrator with expertise in PostgreSQL, Oracle, SQL Server, and MySQL across on-premises and cloud environments. Achieved 99.99% uptime SLAs and implemented automation strategies that reduced mean-time-to-resolution by 40%. Proficient in high availability, disaster recovery, and cloud migrations.
Overview
1
1
Certification
7
7
years of professional experience
Work History
Lead Database Administrator - PostgreSQL & MySQL
T-Mobile
05.2025 - Current
- Led a team of 4 DBAs managing 200-500 PostgreSQL and MySQL databases across on-premises and AWS environments.
- Owned installation, configuration, patching, upgrades, and migrations for PostgreSQL and MySQL fleets.
- Configured and maintained replication, high availability, and failover solutions for critical databases.
- Managed backup, recovery, and point-in-time recovery strategies to minimize downtime risks.
- Utilized AWS CloudWatch, Performance Insights, IAM, KMS, and DMS for monitoring and security.
- Automated routine database administration tasks using Bash, Python, and Terraform.
- Collaborated with IBM teams to design database solutions that enhanced overall system reliability.
Senior Database Administrator - PostgreSQL, Oracle & MySQL
Atlantic Union Bank
Middleburg, USA
06.2022 - 03.2025
- Managed PostgreSQL, Oracle 19c, and MySQL 8.0 databases across on-premises data centers and cloud environments, supporting 50+ production databases with 99.99% uptime SLAs
- Administered Oracle 19c databases on-premises (Linux/AIX) and on Oracle Cloud Infrastructure (OCI); managed Pluggable Databases (PDB/CDB), ASM storage, and Oracle Data Guard standby configurations
- Managed MySQL 5.7 and 8.0 on-premises and on AWS RDS/Aurora MySQL; configured master-slave and Group Replication topologies for high availability; used ProxySQL for connection routing and load balancing
- Implemented enterprise backup strategies for PostgreSQL, Oracle, and MySQL using pgBackRest/pg_dump, RMAN with Data Pump, and Percona XtraBackup/mysqldump, ensuring point-in-time recovery capabilities across all platforms
- Architected HA solutions using PostgreSQL streaming replication + Pgpool-II, Oracle Data Guard (Active/Passive and Active/Active), and MySQL Group Replication + MySQL Router; reduced RTO from 4 hours to 30 minutes
- Led migrations of Oracle and MySQL databases to cloud platforms, transitioning Oracle on-prem to OCI with Data Pump and GoldenGate, MySQL on-prem to AWS Aurora MySQL via AWS DMS, and PostgreSQL to AWS RDS using AWS Database Migration Service, enhancing scalability and performance
- Used pgBadger + EXPLAIN ANALYZE (PostgreSQL), AWR/ADDM/SQL Tuning Advisor (Oracle), and Percona pt-query-digest + Performance Schema (MySQL) to deliver consistent performance improvements across all platforms
- Enforced role-based access control, SSL/TLS encryption, and KMS-based encryption at rest across PostgreSQL, Oracle, and MySQL; conducted quarterly security audits and maintained compliance with SOX and PCI-DSS requirements
- Managed schema migrations across environments using Flyway and Liquibase; maintained Informatica ETL pipelines integrating Oracle, MySQL, and PostgreSQL data sources into data warehouses
- Monitored database platforms with Datadog, Prometheus/Grafana, AWS CloudWatch, and pgAnalyze, configuring automated alerts for CPU usage, replication lag, slow queries, and disk thresholds to maintain optimal performance
- WTS | Middleburg, DC
- Collaborated with development teams to optimize queries and improve efficiency.
- Created and maintained database documentation for system processes and procedures.
- Conducted security assessments to safeguard sensitive data against breaches.
- Provided training and support to junior staff on database management practices.
- Developed SQL scripts for data manipulation and reporting needs of stakeholders.
- Troubleshot complex SQL queries to identify problems or potential improvements in performance.
- Maintained disaster recovery plans including backup schedules and testing procedures for recovering from unforeseen events.
- Created tables, views, functions, stored procedures and other database objects.
- Performed root cause analysis when diagnosing issues with database systems.
- Implemented replication between multiple servers to ensure high availability of the system.
- Coordinated with developers on schema design decisions related to application development projects.
- Reviewed query execution plans to identify inefficient code or recommend index changes for improved performance.
- Researched new features available in the latest version of SQL Server software to determine their usefulness.
- Automated routine tasks using PowerShell scripting language to streamline processes and reduce manual workloads.
- Deployed patches and upgrades according to established change management policies.
- Analyzed existing databases for opportunities to improve efficiency through restructuring or re-indexing.
- Configured security settings to protect against malicious activities such as unauthorized access or data tampering.
- Designed databases in accordance with industry best practices for scalability, security, reliability, and performance.
- Performed daily maintenance tasks such as backups, restores and log shipping operations.
- Generated reports about server health status for review by senior IT personnel.
- Provided technical support for applications that use the database system by troubleshooting errors or providing advice on optimizing queries.
- Developed and implemented strategies to ensure data integrity, reliability, and availability.
- Monitored and optimized database performance using indexes, stored procedures, triggers, and other techniques.
- Collaborated with project teams on developing solutions that integrate SQL Server databases into larger architectures.
- Supported planning for software development and purchases and coordinated implementation.
- Defined synchronization plan for patch management.
- Established security controls to help protect client systems.
- Monitored database performance and implemented changes to improve response times.
- Managed database security, backup, and recovery procedures to safeguard information.
- Prepared and maintained detailed documentation for database architectures and procedures.
PostgreSQL, SQL Sever Cloud Database Administrator
Enterprise Mobility
08.2020 - 11.2022
- Provided 24/7 support for PostgreSQL production and development databases; developed incident response protocols reducing mean-time-to-resolution by 40%
- Conducted Oracle-to-PostgreSQL migrations using Ora2pg, converting PL/SQL stored procedures, triggers, and sequences; validated data integrity post-migration with custom reconciliation scripts, ensuring seamless transition and operational continuity.
- Administered MySQL 5.7 databases on-premises and on AWS RDS MySQL; configured master-slave replication, monitored replication health with Orchestrator, and optimized InnoDB buffer pool and query cache settings
- Used EXPLAIN/EXPLAIN ANALYZE and pg_stat_statements to diagnose and remediate slow queries; achieved average 50% improvement in query response times across core application workloads
- Deployed PgBouncer and PgPool across PostgreSQL environments; configured ProxySQL for MySQL read-write splitting, improving throughput and reducing connection overhead by 60%
- Applied PostgreSQL minor version upgrades, Oracle CPU/PSU patches, and MySQL security patches across all environments with zero unplanned downtime
- Deployed and managed AWS RDS PostgreSQL and Aurora clusters; designed cost-optimized architectures with Multi-AZ deployments, automated backups, and read replicas
- Developed and tested disaster recovery plans for on-prem and cloud databases, including cross-region replication in AWS and PITR recovery procedures; maintained documented runbooks, enhancing operational readiness.
- Automated database provisioning and configuration with Terraform and AWS CloudFormation; managed configuration state using Ansible playbooks across on-prem and cloud environments, streamlining deployment processes.
- Leveraged AWS CloudTrail, ELK Stack, and Datadog for comprehensive database activity monitoring; built Grafana dashboards for real-time visibility across PostgreSQL and MySQL environments
- Collaborated with team to assess project requirements
- Designed databases to store application data using SQL Server or MongoDB technologies.
- Created stored procedures and other database objects in MS SQL Server.
- Developed comprehensive data architecture solutions for enterprise-level organizations utilizing SQL Server Integration Services, Oracle Data Integrator and other ETL tools.
- Maintained current knowledge of trends in database technologies such as SQL Server, Oracle, PostgreSQL, MongoDB.
- Designed database objects such as tables, views, triggers and stored procedures using SQL Server 2008, 2012, 2014, 2016.
- Designed database models for data storage and retrieval of information using SQL Server.
- Developed stored procedures, functions and triggers in MS SQL Server 2008, 2012, 2014 database environments as per project requirement.
- Created reports using software such as Microsoft Excel, Access, SQL Server Management Studio.
- Implemented complex queries to retrieve data from SQL Server database by joining multiple tables with different conditions.
- Provided technical support for applications related to SQL server databases.
- Designed and implemented data models using SQL Server Management Studio.
- Developed ETL packages to extract data from various sources and loaded into SQL Server database using SSIS.
- Designed databases using SQL Server Management Studio.
- Utilized various development tools such as Visual Studio, C#, HTML, CSS, JavaScript, and SQL Server.
- Analyzed business requirements and designed appropriate software solutions using C#, ASP.NET, and SQL Server.
- Created and maintained database objects such as tables, views and stored procedures in SQL Server.
- Participated in troubleshooting of complex issues related to SQL server instances.
- Migrated existing DTS packages to new versions of SQL Server using Migration Wizard tool in SSIS.
- Created stored procedures, functions, views and triggers in MS SQL Server 2012 environment.
- Designed database structures for data storage and retrieval using SQL Server technologies.
- Developed and maintained applications using C#, ASP.NET, HTML, CSS, JavaScript and SQL Server.
- Assisted clients in developing customized reports using reporting tools like Crystal Reports or SQL Server Reporting Services.
- Configured and maintained enterprise databases such as Oracle, SQL Server, and DB2.
- Researched new features released with each version of Microsoft SQL Server and assessed their potential benefits towards improving overall system performance.
- Assisted in the development of internal reports from various sources such as Excel spreadsheets, Access databases and SQL Server databases.
- Developed complex stored procedures, triggers, functions and views for SQL Server databases.
- Monitored performance of ETL jobs on a daily basis using automated tools such as SQL Server Agent Jobs or Unix Shell Scripts.
- Designed detailed database structures including tables, views, stored procedures and triggers using SQL Server Management Studio.
- Created stored procedures, triggers, functions, views and other database objects in SQL Server.
- Built new databases and tables in MS SQL Server to store the extracted data.
PostgreSQL Database Administrator
Cognizant
03.2019 - 06.2020
- Designed and maintained PostgreSQL database architectures aligned with enterprise requirements; documented standards adopted across Cognizant project teams
- Gained hands-on exposure to Oracle 12c environments and participated in Oracle-to-PostgreSQL migration projects using Ora2pg; developed deep understanding of Oracle PL/SQL vs. PL/pgSQL differences
- Provided DBA support for MySQL 5.7 development and test databases; performed schema refreshes using mysqldump, configured binary logging, and optimized MySQL configuration files (my.cnf) for performance
- Tuned SQL and database configurations using pgHero and pg_stats_statements; implemented indexing strategies reducing average query time by 45%
- Installed and maintained PostgreSQL logical replication environments; troubleshot replication conflicts and lag to maintain data consistency
- Used pg_dump/pg_dumpall for schema refreshes across TEST and DEV environments; established automated backup schedules with retention policies
- Deployed AWS resources using Terraform; managed EC2, RDS, EBS, and S3 infrastructure with consistent IaC patterns
- Secured databases with KMS encryption, least-privilege access principles, and configuration hardening across PostgreSQL and MySQL instances
- Developed Ansible playbooks to automate routine DBA tasks - database provisioning, user creation, backup verification, and patch application - reducing manual effort by 70%
- Monitored resources with AWS CloudWatch, Performance Insights, and Enhanced Monitoring; configured alarms for EC2, RDS, EBS, and S3 thresholds
- Configured Multi-AZ deployments, cross-region replication, and read replicas on AWS RDS to ensure HA and DR objectives were met
- WTS
Education
Bachelor of Science - Computer Science
University of Buea
Buea, Cameroon01-2018
Skills
- PostgreSQL and MySQL
- Oracle 12c and 19c
- Amazon Aurora and AWS RDS
- SQL and PL/SQL
- Data backup and recovery
- Database performance tuning
- High availability solutions
- Database auditing and compliance
- Cloud migration strategies
- Automation and orchestration tools
- Infrastructure as code (Terraform)
- Monitoring and logging solutions
- Role-based access control (RBAC)
- Disaster recovery planning
- Capacity planning and management
- Systems integration techniques
Certification
- AWS Certified Solutions Architect
- Oracle Database Administrator Certified Professional (OCP)
- MySQL Database Administrator Certification (Oracle)
Additional Information
Proven ability to manage complex multi-platform database environments (PostgreSQL, Oracle, MySQL) across on-premises and cloud with consistent delivery under pressure., Strong verbal and written communication skills with focus on client service and cross-functional team collaboration., Committed to continuous learning - actively pursuing Oracle OCP and MySQL certifications; participates in AWS re:Invent, PostgreSQL conference, and Percona Live events.
Timeline
Lead Database Administrator - PostgreSQL & MySQL
T-Mobile
05.2025 - Current
Senior Database Administrator - PostgreSQL, Oracle & MySQL
Atlantic Union Bank
06.2022 - 03.2025
PostgreSQL, SQL Sever Cloud Database Administrator
Enterprise Mobility
08.2020 - 11.2022
PostgreSQL Database Administrator
Cognizant
03.2019 - 06.2020
Bachelor of Science - Computer Science
University of Buea