Rene Shosiwah

Database Administrator

adcmm9@r.postjobfree.com

(252) - 202-8206

Professional Summary

Excellent experience in managing large-scale OLTP databases 5+TB size in HA and DR setup.

Managed 11+ TB Oracle 10g & 11g, 12c databases in Data warehousing environment.

Experienced in Installation of high availability RAC environment (3 and 4 node clusters) and upgraded standalone databases to 11g RAC environment.

Expert in Installation, Configuration and Maintenance of Oracle Standby/Data Guard.

Experience in migration/consolidation of databases using Oracle 12c multitenant.

Configuring Postgresql Streaming Replication and Pgpool for load balancing. Managing the monitoring tools for better performance like PgBadger, Kibana, Graphana, and Nagios.

Experience in upgrading and migrating various versions of PostgreSQL database on different platforms.

Responsible for all backup, recovery, and upgrading of all of the PostgreSQL databases.

Setup maintenance of Data Guard for disaster Recovery and reporting purpose with various modes.

Planned, Installed and Configured Golden Gate setup to achieve unidirectional replication.

Performed, developed and maintained database backup and recovery using RMAN.

Refreshing/Cloning databases for the testing/developing purpose

Planned disaster recovery scenarios with different recovery procedures and methods like Data Guard & Standby Database.

Cross platform migration/upgrade of databases from 10g to 11g, 12c using transportable tablespaces from Linux to HP-UX

Experience in install and support OEM Grid control 10G/11G/12c.

Executed and implemented user helpdesk tickets of various issues via REMEDY database from creating user accounts, read-only accounts on a database & table down to assisting them with logging into the database. Experienced in using 10g features like 10g RMAN, Data pump Flash-Back Recovery and ASM.

Expertise in maintaining Database Security using auditing.

performance-tuning services with Highly experienced in performance monitoring/tuning/troubleshooting.

Oracle Database EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE. Applying patches under UNIX platform.

Planned and implemented high availability solutions such as Real Application Cluster (RAC) in Oracle 11gR2 Grid and 10g on ASM and OCSF2 file systems.

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

Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Datapump, conventional Export/Import of Oracle 11g, 10g.

Developed Shell Scripts to Automate RMAN Backups, Hot/Cold backups, Imp/Exp, Datapump and Schema Refresh, and Production to Dev/Stage Sync up etc.

Migration of Data from Reports generated by various vendors into PostgreSQL Databases using PostgreSQL Export/Import Procedures.

Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 11g, 10g RAC servers for the purpose of disaster recovery procedures.

Manage the Space and Storage of the Databases through various Shell Scripts scheduled in the corncob periodically in regular intervals. Write Complex Shell Scripts that automate the Import of Reports to PostgreSQL Databases.

UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs.

Professional Experience

Marriott Vacations Worldwide - Lakeland, FL

April 2016– Present

Database Administrator

Providing database administrative support and 24x7 on call support for production, development oracle 12c/11g databases on Red Hat Linux 5.0 and oracle enterprise Linux 5.5

Experience with large databases (1.5 Tb) for OLTP and OLAP applications.

Strong experience in performance tuning and index maintenance in RDS VPCX and EC2 console.

DBA with experience in PostgreSQL. Ability to understand/modify command titles and server processes can be identified for potential related platforms AWS.

Administration and supporting of Oracle RAC 11g/12c Databases ranging from 100GB to 60TB.

Installation, configuration and troubleshooting unidirectional GoldenGate 11G/12C software.

Monitoring and Performance tuning of GoldenGate sessions at Database level and GGSCI level and investigate replication failures using LogDump utility.

Refreshing development/test database from production using Export/Import & RMAN backups.

Making structural changes to the databases. Sizing database objects for effective space management and optimal performance.

Managing database security.

Experience in administering large, multi-terabyte PostgreSQL databases.

Experience with DB clusters stored in a common file system location, Mapping using symbolic links from designated Tablespaces

Installed and configured Oracle (10g&11g R2) databases on Linux 5, HP-Unix 11.X.

Migrated the database from existing Oracle 10g to Oracle 11g and Upgradation of database (from 10.2.0.3 to 11.2.0.2)

Installation, Configuration and Maintenance of Oracle 11g/10g RAC with ASM and single instance database and Administrated Real Application Cluster (RAC) databases running on Cluster File system.

Applied Critical Patch Updates and Patch Set Update (CPU/PSU) on various platforms using Universal Installer and OPatch Utility.

Utilized Grid Control, ASM and Flashback tools to administer multi-node RAC database.

Defragmentation of tables and indexes for improved performance and effective space management.

Successfully upgraded the databases from 11g to non CDB 12c.

Successfully migrated 12c Non CDB databases to pluggable databases.

Created Oracle Wallets and implemented Tablespace level TDE security.

Configuration of Listener and Tnsnames.

Doing the regular activities like monitoring the alert logs, redo log status, listener. Log and checking the space for normal segments, rollback segments and tablespaces

Implemented Disaster Recovery database 10g/11gData Guard on physical standby database in maximum performance mode using LGWR ASYNC mode.

Monitored and optimized database performance using Oracle Enterprise Manager (OEM) 11g Grid control.

Data migration while upgrading database versions ranging from 8.2 to 9.5.

Extensive experience with Warm Standby (PostgreSQL 8.x and earlier), and Hot Standby (PostgreSQL 9. x and greater)

Installing and configuring Object level replication like Slony etc.

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

Installing and monitoring PostgreSQL database using the standard monitoring tools like Naigo's etc.

Performed database backups with RMAN incremental and cumulative backups by registering 10g/11g databases in recovery catalog.

Performed complete and incomplete database recovery, data file and table space point in time (TSPITR) recoveries using RMAN and user managed backups..

Planned database backups (operating system, full/partial backups, and export/import) using various types of backups and designed the backup methodology for the organization..

Performed database tuning using Explain plan, Stats Pack, TKPROF, SQL tuning advisor, SQL access advisor, SQL planned management tools and AWR (automatic workload repository), ADDM (automatic database diagnostic monitor) and ASH reports and performed database tuning based on the recommendations suggested by ADDM reports.

Experience in working with oracle support in resolving ORA 0600 / ORA-07445 errors and creating SR's.

Expertise in storage management by managing space, table spaces, segments and extents, Rollback segments and data dictionary.

Designed Logical and physical database for business transaction functionality.

Provide production support for the deployed project till it is stabilized.

Written SQL scripts to create database objects like tables, views and sequences.

Pragmatics, Inc - McLean, VA

Jan 2014 – April 2016

Oracle Database Administrator

Worked in an environment comprising 200 databases with the largest databases each of size 5 TB.

Disaster Recovery (DR) Plan Implemented using DATAGUARD (Physical Standby) for high availability/disaster recovery purpose on Oracle 11g.

Implemented 11g Database compression feature for Development and test Instances to reduce the size of databases which help the client to save huge disk space.

Performing DR switchover and failover operations.

Syncing of DR databases with the Primary Database for any archival gaps.

Applied PSU Patches (10.2.0.3, 10.2.0.4) as a part of maintenance activity.

Extensively used Datapump, conventional export/import utilities for loading data to & from databases, logical backups and migration of databases.

Fixed various database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM) and Active Session History (ASH).

Achieved optimal performance tuning by using explain plan, STATSPACK, SQL TRACE, TKPROF utilities.

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

Used Data pump for exporting and importing tables, schemas and table spaces.

Performed daily maintenance tasks like space management, rectified locking problems, managed quotas etc., configured network components like TNSNAMES, Names Server, Connection Manager, etc. for easy and effective management of Oracle networking. Configured listener for external procedure calls.

Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.

Capacity planning of tables, indexes, table spaces and databases to allow for growth potential.

Worked with application developers to address and clarify data requirements to resolve technical and functional issues.

Enforced corporate business rules through adequate user/resource/object management.

Creating database objects Tablespaces, Application Users, Database schemas, profiles, granting privileges and roles, and creating database links.

Education

University Degree: Bachelor of Arts (B.A.) in History with a Second Class Upper and Diploma in Sociology and Anthropology with a Cumulative (GPA) of 3.1 on a scale of 4.0 .

Technical Skills

Databases

Oracle 10g, 11g, 12c, PostgreSQL 9.x – 10.x

Database Tools

Oracle (Oracle Enterprise Manager, SQL*Plus, SQL Loader, DB Configuration Assistant) Toad, OEM Grid, RMAN, SQL*Loader, Exp/Imp/Data Pump, Log miner, Statspack/AWR, Top, DBCA, DBUA, ADDM, Remedy

Operating Systems

UNIX (Solaris 8/9/10, AIX, HP-UX), LINUX

Contact this candidate