Travis Plummer Email & Phone Number

Montreal, Quebec, Ca

ORACLE DBA | October 2017-Present Develop new databases; maintain existing databases; and install, configure, and manage Oracle 18c/12c/11g/10g/ databases. Create users and allocate the proper roles and privileges to maintain database security. Complete a wide array of daily tasks as a system administrator working in Oracle & SQL Server databases (non-production environments). Author and maintain documentation on deployments and system administration activities. Collaborate with the team and client in comprehending requirements. Maximize database stability and uptime through system monitoring, performance tuning, and routine maintenance.Notable Accomplishments: Inherited multiple outdated Oracle 11g databases. Worked closely with other IT resources to immediately schedule maintenance to upgraded databases to 18c. Was instrumental in pushing these key infrastructure projects through to completion so the databases were updated and compliant with Oracle support standards. Conducted a data security risk assessment on how to schedule and accomplish the implementation of database patches. Constructed plan and updated patches. As a result of applying the proper patches (going back years), the databases were upgraded to a safe and secure patch level. Additionally, maintained the databases with current patches, identifying and mitigating data security risks.

Reston, Virginia, Us

 Owned the installation, configuration, and management of Oracle 12c/11g/10g/ databases. Provided technical leadership in migration of Oracle 11g databases to Oracle 12c as well as exposure to RAC installation. Leveraged VMware tools to test SQL code in a non-production environment before it was delivered to production. Successfully maintained RAC environments of 2 nodes with ASM file system using cluster ware.Notable Accomplishments: Onboarded 4 new hires who were inexperienced DBAs in need of training. Developed, revised, and implemented training, policies, standards, procedures, and guidelines necessary for new DBAs to become self-sufficient in administering database environments within special requirements of Department of Veterans Affairs IT infrastructure. Inherited databases that needed to be refreshed to an earlier RMAN back up. Modified Linux scripts to be able to refresh databases to an earlier state. Used shell scripting for automation of job scripts, for startup and shutdown and Health check of databases. Refresh was successful and the management team was very pleased.

 Use Oracle Enterprise Manager (OEM) as an interface to manage the Oracle databases Performing ETL jobs Install, configure and maintain oracle 10g and 11g databases in test and development environments Use SQL*Loader as an ETL tool to load data into the staging tables Ensure that daily cold and hot RMAN backups are successfully made and valid for restore and recovery Administer Oracle database, including design and creation of schema objects and integrity constraints Create tablespaces, manage storage allocations by adding datafiles, create redo log files to reduce I/O from frequent checkpoints to achieve optimal performance for transactions Ensure that daily exports are successfully made and valid for small table level restores Create database users, roles and privileges. Manages passwords and resolve connectivity issues Develop RMAN scripts for backup and recovery of databases Migrate databases/schemas from development to production using export/import  Create database objects including indexes, tables, views, sequences, and procedures. Used TOAD and Oracle SQL Developer to create tables, and add new columns to the existing tablePerformed excellent communication skills and good corporate etiquette