PHILEMON BANJONG FORGWE

ORACLE/SQL SERVER DATABASE ADMINISTRATOR

480-***-**** ad2gl2@r.postjobfree.com

SUMMARY

High-skill Oracle/SQL Server Database administrator with 8 years of experience in Oracle database version 10g, 11g, 12c, and 19c in development and production environments. With SQL Server I have explored 2008, 2012, 2014, 2017, and 2019 versions.

I have proactively monitored and tuned system available resources using tools and utilities like OEM, customized scripts, AWR report, ASH, and the Explain plan SQL tuning advisor to keep the performance of database systems up and running. Possess complete SDLC knowledge with great working experience on Oracle 10g, 11g, 12c, and 19c versions.

TECHNICAL ENVIRONMENT

OPERATING SYSTEMS:

Red Hat Linux RHEL 5.x/6.x/7.x, AIX 6.x, MS SQL SERVER, Solaris10/11and Windows 2000-20xx

RDBMS:

Oracle 10g/11g/12c/19c

LANGUAGES:

SQL, PL/SQL, UNIX Shell Scripting, Ksh, bash Scripting

SOFTWARE/ APPLICATIONS/ TOOLS:

Oracle Enterprise Manager (OEM), Oracle Data Guard, Agents, RAC, ASM, SQL Developer, TOAD, Exp/Imp, DBCA, DBUA, Recovery Manager (RMAN), DataPump (expdp/impdp), SRVCTL, AWS, SQL*Plus, Recovery catalog, Crontab, Golden Gate, Data Guard, TDE, Data Redaction, Service Now, Remedy etc.

TUNING TOOLS:

SQL TRACE, TKPROF, EXPLAIN PLAN, AWR, ASH, SQL TUNING ADVISOR, ADDM, ORACLE DATABASE REPLAY, SQL ACCESS ADVISOR, etc

ORACLE DATABASE

Golden gate for replication

Data Guard for disaster recovery

RAC for availability

Performance Tuning/Analysis

Testing

AWS migration

Production Support

OEM Grid/ cloud control

Shell Scripting

Multitenant Architecture

Installations and Configurations

Upgrade and Patches

Database Administration

RMAN (Recovery Manager)

Data pump and export/import

Transportable Tablespace

AWR, ADDM, ASH, Explain plan

SQL TRACE, TK PROF

SQL Tuning & Access Advisor

MS SQL server

Backup and recovery

Use SSMS

Mirroring

Performance tuning

Upgrade and patching

DATABASE $ SOFTWARE SUPPORTED

Oracle- 10g,11g,12c, and 19c

MS SQL server- 2012,2014

OPERATING SYSTEM

Linux (Red Hat), Unix, Solaris, Windows, Aix

PROFESSIONAL EXPERIENCE

Taylor Farm – Annapolis, MD June 2020 – Sep 1st 2023

Role: SQL Server Production DBA

Installs configures, and maintains Databases as per product requirements and industry best practices. Ensure that the database is available, secure, healthy, efficient, and recoverable as expected.

Performing regular system reviews using Solar wins, plan and implement solutions for current and future needs.

Run database maintenance as required, backup, and restore different databases.

Complete the first level of analysis (CPU, memory, space, blocking sessions, failed jobs, tuning queries for performance, etc.)

Create database users/logins and security groups. Make sure that all privileges are set as required.

Performing database import and export of CSV files, migration, upgrade, and patching from one system to the other.

Rebuilding cluster and non-cluster indexes off and online.

Design and develop MSSQL automation workflows using Python and PowerShell.

Import and Export CSV files from one database to another using the MSSMS Import and Export wizard.

Recover tables from existing backup tables. Make sure that tables match their character sizes.

Data Modeling Skills compare two different environments using the ERWIN Data Modeling tool.

Migrating data from Oracle to SQL Server Environment using WinSCP.

Apply MS Patch, version control, and vulnerability management as needed.

Using an operating system like Linux, Unix, and Aix for creating of the database mount point and job schedule

Migrating data from one platform to the other using tools like WinSCP and SecureCRT file transfer.

Making changes on batch profiles as required on a Linux operating system.

Expert level of understanding of SQL Server and Oracle administration and troubleshooting.

Having knowledge of High Availability implementations (e.g. Windows Failover Cluster, “Always On” availability groups).

Excellent written and verbal communication skills

Pfizer – Peapack, NJ. Jan 2017–May 2020

Role: Oracle Database Administrator

Responsibilities:

Manage all database instances across development, staging, and production environments, handling installation, configuration, and maintenance. Monitor database performance, optimize query execution, and tune database parameters to ensure optimal efficiency and responsiveness.

Implement and enforce database security measures to protect sensitive data. Monitor database access, audit trails, and user privileges to ensure compliance with internal security policies, regulatory requirements, and all applicable legal requirements.

Develop and implement backup and recovery strategies to protect critical data and ensure data integrity. Perform regular backups and test recovery procedures to minimize the risk of data loss.

Identify and resolve database performance issues by analyzing query execution plans, tuning SQL statements, and optimizing database structures and indices. Implement performance monitoring tools and provide recommendations for enhancing system performance.

Access database storage requirements and plan for future growth. Monitor database space utilization, allocate storage resources, and implement partitioning strategies to optimize storage efficiency.

Implement high-availability solutions to ensure database uptime and minimize downtime. Develop and test disaster recovery plans to ensure business continuity in the event of system failures or disasters.

Investigate and resolve database-related issues, including performance bottlenecks, connectivity problems, and data inconsistencies. Work closely with developers and system administrators to diagnose and troubleshoot complex database problems.

Create and maintain documentation, including database schemas, configuration settings, and standard operating procedures. Prepare reports on database performance, capacity, and system health for management and stakeholders.

Collaborate with other teams, including developers, system administrators, and network engineers, to ensure seamless integration and efficient database operations. Great team player.

Refreshing Dev and Test instances with data from Production regularly.

Provided instance-level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO, and Memory Usage.

Extensive experience in RMAN recovery testing, RAC, and standalone databases.

Experience in setting up Oracle ASM storage for Oracle RAC databases.

Performed database replication through Golden Gate.

Implemented Data Guard with high availability and performance configurations and participated in Data Guard Failover tests.

Successfully implemented Backup & Recovery using RMAN which includes hot backups and Cold backups.

Worked extensively on Performance tuning by partition, indexing, use of Hints, and gathering Statistics.

Supported development teams by providing SQL statement tuning and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, AWR, ASH, ADDM

Performing monthly and annual performance reports for trend analysis and capacity planning.

Assist in SQL tuning and providing consultation such as creating Materialized views, adding indices, dropping

Supported SQL Server Databases Designed and implemented the database servers for two new data centers.

Administration of large databases in SQL Server 2014 and 2016

Used Execution Plan, SQL Profiler, tuning SQL query, and Database Engine Tuning Advisor to optimize queries and tune databases

Created and managed databases, and schema objects such as tables, views, indexes, procedures, triggers, and database constraints to meet business requirements and policies and maintained referential integrity.

Implemented SQL Server Security and object permission like creation of users, configuring permissions database authentication modes, and assigning roles of users.

Provided 24x7 production support for SQL Server databases on Clustered Servers to achieve maximum performance and uptime in production environment

Create and maintain all SQL Server databases required for development, testing, education, and production usage.

Implemented Security through a Virtual Private Database and Fine-grained Auditing.

Created users, and roles and granted privileges according to the business requirements.

Education & Certification

Bachelor’s Degree in Computer Science 2014

University of Buea

Oracle Certified Associates (OCA 12C) 2019

SQL Fundamentals 2019

MS AZURE Advance certification

Contact this candidate