Roland Ngwa Che

240-***-**** Dallas, TX

adkved@r.postjobfree.com

www.linkedin.com/in/rolandche/

POSTGRES DATABASE ADMINISTRATOR

Dedicated IT professional with proven experience supporting large databases in enterprise environments. Adept with maintaining high availability and devising backup strategies. Well-versed with troubleshooting and root cause analysis. Excellent communication skills; comfortable interacting with all organizational levels.

Core Competencies

Disaster Recovery

Capacity Planning

Server Migrations

Customer Service

Security

Backup and Recovery

Customer Service

General Database Management

Performance Monitoring

Database Design/Normalization

Automation Scripting

Issue Resolution

Virtualization

Database Design/Normalization

Issue Resolution

Ensuring High Availability

TECHNICAL

PROFICIENCIES

OS

Windows, Oracle Solaris, HP-UX, AIX, RH Linux, Oracle Linux

Databases

Languages

PostgreSQL (9.6, 10, 11 and 12) Oracle (10g, 11g, 12c,18c),

PL/SQL, Shell Scripting

Software/Tools

MTK, pgadmin-III, phppgadmin, Pgbench, pgbadger, Bart, pgCluu, PEM, OEM, pgDash,SQL*Loader, SQL*Plus, RMAN, Remedy, MS Office, LogMiner, Share Plex, ERwin, Migration Workbench, QDesigner, Golden Gate, Toad.

PROFESSIONAL

EXPERIENCE

PostgreSQL Oracle AWS DBA Dex Media Dallas, TX (7/2017 to Present)

Administer PostgreSQL DBs through automation scripts and patches, revise config files. Standardize and audit database access. Partner with storage teams for capacity management. Maintain tablespaces, data files, various logs, and logical database objects. Perform failover/failback testing. Develop stored procedures, triggers, packages, etc. in PL/SQL. Handle backups, refreshes, and server migrations.

Resolve Oracle RAC issues by using Clusterware and analyzing database logs. Create RMAN recovery catalogs. Execute performance tuning with AWR, ASH, SQL Trace, TKPROF, etc.

Spearheaded the upgrades of PostgreSQL servers from 9.6 to 12 as well as Oracle RAC and standalone databases from 11g to 12c.

Architected and deployed disaster recovery for PostgreSQL databases (using Streaming replication) and Oracle (using Data Guard).

Performing Point in Time Recovery in PostgreSQL.

Installed and configured PostgreSQL 9.6 for all db. servers in all environments; also upgraded all PostgreSQL database servers from PostgreSQL 9.6 to 12 and configured database servers to utilize systemctl /service commands for additional control of PostgreSQL services.

Establish policies and procedures pertaining to data management, security, maintenance, and utilization.

Diagnoses, resolves, and implements preventive measures to prevent problems for availability, recoverability, and performance of all supported database environments.

Configured Ansible and Troubleshoot Playbook.

Perform Logical replication for replicating data objects and their changes, based upon their replication identity.

Patch, Upgrade and keep the PostgreSQL DBs current. Develop and enhance scripts to automate and execute various DBA tasks.

Extensive experience with Warm Standby (PostgreSQL 8.4 and earlier), and Hot Standby (PostgreSQL 9.6 and greater).

Performed Streaming replication in PostgreSQL for disaster recovery and High Availability.

Installed and configured EFM in PostgreSQL to monitor streaming replication.

Install, configure, test, monitor, upgrade, and tune new and existing PostgreSQL databases.

Proactively monitor and tune for performance.

Develop, manage, and test database backup & recovery strategies, verifying data integrity.

Performs quality control audits to ensure accuracy, completeness, and proper usage of data in tables and various support tools, such as database dictionaries.

Successfully migrated databases from original virtual servers to physical servers.

Significantly reduced backup times (by 200-400%) via parallel backups and restores along with vacuum times (by 200-300%) via parallel vacuums; also automated database maintenance tasks (i.e. Backups, vacuum, and vacuum freeze/analyze) in all environments.

Data migration while upgrading database versions.

Tuning auto vacuum parameters to ensure up to date table stats and reclaim space consumed by dead tuples.

Performed incremental backups using Bart (backup and recovery tool).

Revised all PostgreSQL config files (along with other pertinent files such as crons, hosts, /etc./passwd, etc.) via GitLab; also previsioned shell scripts to GitLab with documentation on each.

Experience designing database structures, indexes, views, partitioning with PostgreSQL.

Removing the Index bloat Concurrently to improve the performance.

I have used PgBouncer to maintain a pool of connections for each unique user, database pair.

Work with data-warehousing and Business Intelligence tools.

Creation and management of ETL applications and pipelines.

Creation, Configuration and Setting up of RMAN Catalog databases and registering target Databases with the Catalog.

Worked on setting up of Goldengate Integrated Capture for replication purposes from OLTP system to Downstream systems.

Responsible for configuring Data guard physical and standby database setup for high availability and handling synchronization issues between primary and standby.

Implemented Goldengate integrated replicat and coordinated replicat (available from OGG 12c) to improve the performance of data replication to targets.

Completed the process of standardizing and auditing database access and controlling who/what can access data and what those roles can do with the privileges in each environment.

Database Capacity Management (Working with Storage teams for ASM Disks) using automated scripts/processes and Reports.

Performing tuning of application using SqlTrace, Tkprof, Explain Plan, Stats pack, AWR and ASH/ADDM.

Proficient in writing UNIX Shell scripts to automate business process and daily backups.

Exposure to new 12c Features, Container and Pluggable Database, FAR-SYNC Instance, Cascade Redo Transport Destination, allowed usage of SYNC and NOAFFIRM to extend Data Guard Range, Moving online Data file, etc.

Applied the Clusterware (GI), Database (RDBMS) Patches that is PSU patches and one-off patches (for Bug resolution) using opatch.

Follow up on SRs for different issues (SCAN behavior, Node eviction, Failover etc.).

Refreshing Dev and Test instances with data from Production on a regular basis.

Resolving issues related to Network Congestion, Memory (SGA and PGA), CPU & IO and other oracle related issues.

Responsible for setup and implementation of 2 Node RAC on Linux in 10g and 11g R2

Scheduling and maintaining level 0 and level 1 RMAN (Recovery Manager) backups.

Monitoring free space in tablespaces, space requirements of tables, indexes. Performing database.

Capacity Planning for OLTP environment- Allocating system storage and planning future storage requirements for the existing and new databases.

Proactive performance monitoring by implementing UNIX scripts and automated jobs (Grid) for alerts.

Firm grasp on cloud security, leveraging Linux and Windows operating systems, using the AWS console and CLI (command line interface).

Experience in Implementing security using IAM roles

Engage with customers of Platform-as-a-Service environment to assess, document, and elaborate their business requirements.

Acts as a subject-matter expert around AWS for other sales and solutions teams

Ensure security is integrated into all cloud architecture solutions.

Capture and share best-practice knowledge amongst the AWS solutions architect community

Develop business case analysis on potential projects.

Cloud infrastructure configuration and optimization

Performs advanced systems modeling, simulation, and analysis.

PostgreSQL Oracle Database Administrator, CareSource, Dayton, OH (6/2013 to 7/2017)

Prepared automation scripts and developed PostgreSQL database architecture.

Proactive in updating the latest security patches to database, which are provided by PostgreSQL Enterprisedb.

Configuring log analyzation tools like pgbadger.

Installing and configuring connection pooling tools like Pgbouncer and pgpool etc.

Implemented migration tasks from Oracle apps to PostgreSQL databases.

Automated DBA activities and upgraded existing databases.

Maintained and optimized database application performance through tuning.

Formulated database access methodologies and APIs.

Designed, developed, and maintained PostgreSQL database architecture.

Developed scripts for database monitoring and tuning procedures.

Conducted Linux administration activities and managed test databases.

Evaluated database performance and executed table maintenance processes

Installed Oracle databases with grid infrastructure. Performed cloning and migration via both Data pump and traditional export/import utilities. Utilized Cron jobs and shell scripts for automation of monitoring, performance, and backup/recovery processes. Collaborated on disaster recovery and high availability for Oracle RAC/ASM databases. Performed query tuning and troubleshooting. Replicated/refreshed databases and applied security patches. Handled capacity planning and created physical standby databases.

Devised backup strategy incorporating RMAN, EXPDP, IMPDP and OS methods.

Planned, tested, and implemented backup strategy using RMAN, Oracle Utilities (Export/Import) EXPDP and OS methods.

Performed troubleshooting of database using AWR and ADDM reports.

Responsible for network configuration and involved in a Client-Server environment using TNSNAMES, LISTENER, Net Configuration Assistant, and other configuration files.

Creating and restoring databases using Oracle Flashback Technology with Guaranteed restore point.

Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch).

Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Data pump Export/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases.

Used to run scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.

Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.

EDUCATION

University of Buea, Cameroon Bachelor’s degree in Computer Science

Institute of Commercial Management Britain Diploma in Human Resource Development.

Difotronics Diploma in Computer Software

CERTIFICATIONS

Oracle Database 12c Administrator Certified Associate

Oracle Cloud Infrastructure 2019 Architect Associate

AWS Certified Solutions Architect – Associate

Oracle Database 12c: SQL Fundamentals

Contact this candidate