Oracle Database Administrator

[Type the date]

JOSUE STILL

EBENE

Phone number: 737-***-****

EMAIL: ***********@*******.***

Objectives

Over 8 years of experience as an Oracle Database Administrator - performing various tasks like database installation, administration, configuration, upgrades, patching, backup and recovery, performance monitoring, performance tuning, cloning, space management, database security and production support.

Professional Summary

Over 8 years of experience as an Oracle DBA (19c, 18c, 12c, 11g, and 10g) in IT industry.

Expertise in Oracle, 10g /11g/12c/18c/19c on various Unix platforms (Linux, HP-UX, Solaris, AIX), windows NT 4.0/2000/2003 in the areas of database creation, refreshing database, user management, RMAN, Export and Import utility.

Experience Perl and shell scripting and other Oracle tools and utilities like Oracle OEM (12c/13c), SQL Developer and TOAD.

Involved in Installation, Performance Tuning, Backup and Recovery, RDBMS Patching, Security, Oracle Enterprise Manager (OEM), Standby Database, Database Upgrade from 11g to 12c and 18c and 19c, troubleshooting and basic knowledge of networking and security.

Experienced in Performance Tuning using EXPLAIN PLAN, TKPROF, STATSPACK

Creating tables, indexes, synonyms, views, sequences, profiles, constraints, triggers and procedures.

Migrated database from Oracle to AWS instances, using the SCT

Migrated from oracle to PostgreSQL

Migrated from Oracle to Microsoft SQL server

Created and administered databases running on SQL server 2012 edition

Design and implementation of Backup & Recovery using RMAN and SQL scripts.

Proficiency in using Log miner, SQL *Loader and Export/Import utilities.

Handling day-to-day DBA activities using Oracle utilities and tools, monitoring space and memory requirements and Memory tuning. Checking Alert Logs, Trace files and backup verifications.

Setting up Standby Database / Oracle DataGuard to protect against failures. Configured the Standby Database in such a way that the database is kept synchronized with the Production Database by regularly transferring archived log files from the Production Server to the Standby Database Server.

Experience in installation and configuration of Oracle RAC (3 nodes)

Upgrade from 10g to 11g, 12c, 18c, and 19c

Experience as 24x7 on call Production DBA as well as application (development) DBA.

Good Knowledge in Golden Gate installation, configuration and troubleshooting

Login and User Management: Adding logins, roles, groups to the Window NT and MS SQL Server and maintaining proper security procedures

Scheduling Jobs and Alerting using SQL Server Agent

Installing and Configuring SQL Server 2005 successfully. Transforming data from various data sources using OLEDB connection by creating various DTS packages.

Backing up and restoring database, Backup and recovery plan using Dump and Load command, Creating Logical Device names, using backup server for backup and recovery, Step by step recovery of database after crash.

Experience on installation and implementing OEM 12C and 13c

Setting database options, Tuning Queries and Stored Procedures, Monitoring SQL server activity, Setting and resetting the configuration variables

Proactive and efficient in timely delivery of all assignments, always enthusiast to take up new challenges.

Motivated team player and an adaptable individual with good analytical and strong interpersonal skills.

Excellent written and verbal communication skills.

Education

DOUALA UNIVERSITY

2009 - 2012 Bachelor of Business Administration

Certifications

COMPTIA Security +

Experience

ORACLE DATABASE ADMINISTRATOR/, MAY 2017 – Present

UnitedHealth Group Austin /Texas

Responsibilities

Perform installation, configuration and of Oracle databases on Solaris, Linux, windows, HP-UX and VMware.

Determined and implemented best practices for Oracle Setup, Installation, Configuration, Monitoring, Sizing, Capacity Planning, Backup and Recovery strategies

Created Database objects like Tables, Tablespaces, Rollback Segments, Multiplexing Control files, Data files, Redo log files, Partition tables, Views, Indexes, Clusters, Synonyms, Materialized views. Audited, implemented scripts/tools to help rollout and manage Oracle in a global distributed environment

Setup jobs and events using Enterprise Manager (OEM) console, enrolled users and maintained system security by controlling and monitoring user access to the database

Migrated from Oracle to AWS and hosted some databases on the RDS instance

Migrated from Oracle to SQL Server

Troubleshooted and performed performance tuning on SQL server, PostgreSQL and AWS.

Responsible for developing different databases at various stages of implementation of Projects (Databases for conversion of data, interfaces, training and development)

Used Import/Export and SQL * Loader utilities to move data and objects

Monitored and maintained database growth and tablespace utilization

Devised backup/recovery strategies and implemented it in line with Business requirements (RMAN)

Configured and Tested Backups for Oracle Databases by restoration and recovery

Involved in the performance tuning and query optimization

Experience in Performance Tuning by using tools/utilities by Automated Workload Repository (AWR)

Installed and Configured Oracle 11g, 12c and 19c Real Application Cluster (RAC) Instances with stand by database (DataGuard) using CRS and ASM.

Upgraded Oracle Databases from 11g to 12c, 18c and 19c

Code reviews of host and interface applications to ensure optimum database connections, resource usages, locks, query response times

Designed and Implemented Oracle Disaster Recovery Solutions for customers

Applied patches in production and test instances

Managing Database (User management, Table space management, Performance related issues).

Knowledge on basic architecture and functioning of Golden Gate technology.

Strong hands-on partitioning and performance tuning skills

Configure data replication with Oracle Golden Gate on 12c and 19c.

24X7 support for databases and production operations teams

Assisting Developers in writing and tuning their queries

ORACLE DATABASE ADMINISTRATOR, June 2013 – April 2017

Universal Cargo Los Angeles, CA

Responsibilities

Installed, configured, and maintained oracle databases on Linux and Solaris environment.

Created Database as per requirements using DBCA and scripts.

Startup and Shutdown of individual instance on RAC 2 node environments.

Implemented and supported two node RAC environments.

Managed ASM diskgroups via asmcmd, asmca and database control.

Worked on replication technologies such as Shareplex and Dataguard.

Created Database objects like Tables, Tablespaces, Rollback Segments, Multiplexing Control files, Data files, Redo log files, Partition tables, Views, Indexes, Clusters, Synonyms, Materialized views. Audited, implemented scripts/tools to help rollout and manage Oracle in a global distributed environment.

Migrated and upgraded oracle database from 9i to 10g on Veritas Cluster environment.

Setup jobs and events using Enterprise Manager (OEM 12c/13c) console.

Implemented Dataguard (physical) for high availability/disaster recovery solution.

Used Import/Export and SQL * Loader utilities to move data and objects Configured and Tested Backups for Oracle Databases by restoration and recovery

Wrote shell scripts and scheduled them in CRON for monitoring and health checks of database

Monitoring Database growth and space administration.

Frequent analysis of objects and schemas.

Experience in developing, maintaining and debugging procedures, packages and functions using sql developer.

Export & import at full, schema, tablespace and object level.

Responsible for Online/Offline database backups and managing Database recovery with RMAN

Worked on backup and recovery strategies using RMAN.

Performed database tape backups using netbackup and RMAN.

Installed, configured and resolved issues on golden gate replication technology.

Refreshing or cloning databases from production to development using RMAN and OS level scripts

24X7 support for databases and production operations teams

Interacted with Functional & Technical experts, system administrators, security analysts and other members of the project team to ensure optimum operation of the database

Skills

Oracle database

AWS (EC2, ELB, RDS, S3, Cloudwatch)

PostgreSQL

Meticulous attention to detail

A logical approach to work

The ability to prioritize tasks

Problem-solving skills

Good organizational skills

Communication and interpersonal skills

Familiarity with computer operating systems and database technology (design, software and structure)

Strong work ethic

Positive attitude

Strong time management skills.

Contact this candidate