Sql Server Database Administrator

PHILEMON BANJONG FORGWE

ORACLE/SQL SERVER DATABASE ADMINISTRATOR

480-***-**** ️ ****************@*****.***

PROFESSIONAL SUMMARY

Database Administrator with 5+ years of expertise in managing, optimizing, and securing Oracle (10g, 11g, 12c, 19c) and SQL Server (2008-2022) databases across complex environments. Skilled in performance tuning, high availability, disaster recovery, and automating database tasks using Python and PowerShell. Adept at ensuring data integrity, meeting compliance standards, and implementing best practices for database health and reliability. Proven record of successful migrations, patching, and support for mission-critical applications.

TECHNICAL SKILLS

Databases: Oracle (10g, 11g, 12c, 19c), SQL Server (2008, 2012, 2014, 2017, 2019, 2022)

Operating Systems: Red Hat Linux (RHEL 5.x/6.x/7.x), AIX 6.x, Solaris 10/11, Windows (2000-2022)

Languages: SQL, PL/SQL, UNIX Shell Scripting (Bash)

Tools & Applications: Oracle Enterprise Manager (OEM), Oracle Data Guard, Golden Gate, ASM, RMAN, TOAD, SQL Developer, Crontab, ServiceNow, Remedy

Tuning & Monitoring: SQL Trace, TKPROF, AWR, ASH, SQL Tuning Advisor, ADDM

Cloud Platforms: AWS, Azure

PROFESSIONAL EXPERIENCE

UHS (Valley Hospital) – Phoenix, AZ

SQL Server Production DBA

June 2021 – Present

Database Administration: Led SQL Server administration across production and development environments. Installed, configured, and upgraded SQL Server instances (2008, 2012, 2014, 2017, 2019 2022) ensuring high availability and disaster recovery (HA/DR) for critical applications.

Performance Tuning: Optimized database performance by analyzing Execution Plans, SQL Profiler, and Database Engine Tuning Advisor. Reduced query processing times by 30% and increased throughput by optimizing indexes, implementing table partitioning, and fine-tuning SQL code.

Automation: Developed automation scripts with Python and PowerShell to streamline backups, data migration, and routine maintenance tasks, resulting in a 20% reduction in manual workload.

Backup & Recovery: Implemented robust backup and restore strategies using native SQL Server backup tools, SSMS, and third-party tools. Reduced recovery time by designing automated failover processes and tested recovery scenarios monthly to ensure data integrity.

Security & Compliance: Enforced security protocols by configuring database permissions, creating roles, and managing user authentication for SQL Server instances. Utilized ServiceNow for incident management and ensured all configurations met regulatory compliance standards.

Data Migration: Migrated data across platforms using SSMS, WinSCP, and SecureCRT, including a successful large-scale data transfer from Oracle to SQL Server. Ensured data accuracy through ETL processes, utilizing CSV imports/exports, and automated data validation.

High Availability Solutions: Implemented and managed Always-On Availability Groups for HA/DR. Built Windows Failover Clusters, ensuring near-zero downtime and efficient load distribution during peak hours.

Cross-functional Collaboration: Collaborated with developers, network teams, and system administrators to address bottlenecks and maintain database stability. Coordinated with application teams on schema changes and query optimizations for enhanced performance.

Taylor Farm – Annapolis, MD

Oracle Database Administrator

January 2019 – May 2021

Database Instance Management: Managed over 100+ Oracle database instances across production, development, and testing environments. Conducted installations, upgrades (10g, 11g, 12c, 19c), and configurations to support application needs and business continuity.

High Availability & Disaster Recovery: Deployed Oracle RAC for load balancing and Oracle Data Guard for disaster recovery. Conducted failover testing to validate DR plans and minimized potential data loss through automated RMAN backups.

Replication and Data Integrity: Set up Oracle GoldenGate for real-time data replication across production and staging environments, ensuring data synchronization and business continuity.

Automation and Scripting: Developed shell scripts for daily maintenance, backups, and monitoring jobs, improving efficiency and reliability. Leveraged Crontab for job scheduling and automated patching and backups, ensuring minimal disruption.

Backup & Recovery Strategy: Designed and executed comprehensive backup and recovery plans with RMAN, including full and incremental backups, and tested recovery processes regularly to verify data integrity.

Security Implementation: Established Virtual Private Database (VPD) and Fine-Grained Auditing (FGA) to enforce row-level security. Defined user roles, privileges, and configured TDE encryption for sensitive data.

Documentation & Reporting: Created and maintained documentation for database configurations, schemas, and standard operating procedures. Produced monthly performance and capacity planning reports for senior management to inform resource allocation and planning.

Cross-Platform Support: Provided support for SQL Server environments, assisting with data migrations, schema design, and query optimizations. Created Materialized Views and optimized large datasets for fast access and retrieval.

EDUCATION & CERTIFICATIONS

Bachelor’s degree in computer science – University of Buea, 2014

Oracle Certified Associate (OCA) 12c – 2019

SQL Fundamentals Certification – 2019

Contact this candidate