Post Job Free

Resume

Sign in

Database Administrator Oracle

Location:
Harrisburg, PA
Posted:
February 16, 2024

Contact this candidate

Resume:

E

Emmanuel Evina

1-717-***-****

ad3omp@r.postjobfree.com

*** **** ***** **

Harrisburg, PA

Summary

RESERVIST USARMY servicememberwhohas over 3 years of hands-on experience as an Oracle database administrator and has completed Life Cycle Knowledge including Installation. Some areas of expertise include Performance Tuning, Backup and Recovery, Database Security, Database Upgrades and patching, Database Refreshes, and Database Migrations across different platforms. designed and implemented Backup and Recovery strategies using RMAN

(full and incremental), Point in Time, Media Recovery, and Datapump

(Expdp/ Impdp) for logical database objects. Used crontab to automate some of them without any manual intervention. emote administration and support of production and development Databases sizing 10TB. involved in each phase of the life cycle (SDLC) including requirement gathering~technical design, development, system integration phase, quality assurance phase, development, and production support activities. I’m a great team leader and problem solver. Distinctly motivated Oracle Database Administrator with the ability to go beyond the limits to provide high-performance solutions to your company. Adept data Administrator known for maintaining reliable and consistent uptime figures. Dedicated to providing business continuity through system availability. Skilled controller of hardware, software, and security services for businesses of all sizes. Currently working with ARMY as a unit supply integrator in basic inventory control understanding of relevant technology. Capable of maintaining Oracle database applications using programming languages, developing data solutions, ensuring database security, integrity, and system availability, organizing database diagnostic testing, overseeing database backup and recovery infrastructure, and modeling and migrating data, knowledge of supervising operational activities of IT projects from install Oracle Database 11g & 12c

(Manual method and using DBCA

Experience with Windows Active Directory

Experience with Windows Active Directory Strong experience coding and scripting Bash.

● Tablespace management to manage space to store the data.

● UNDO Tablespace management to manage undo space.

● REDO Log file management to manage redo space.

● Manage users and security

● Networking (Configuring Listeners and TNS entries)

● Understand various Data dictionary tables/views

● Diagnose issues using Diagnose data and generate packages for Oracle Support.

● Backup and Recovery (User Managed)

● Backup and Recovery (RMAN)

● Materialized Views

● Table Partitioning

art to go live successfully. Elite communicator and troubleshooter. SKILLS

● SKILLS Monitoring/Data

● Troubleshooting

● Ansible/Bash Scripting

● Backup/Recovery

● AWS Cloud

● Database Upgrades &

Patching

● Performance Tuning

● Database Security

● Mysql/SQL

● VMware/Vsphere

● Linux/windows

● Directory/Domain controller

● working with Office 365

● knowledge withMicrosoftServe

● SQL Server Management

Studio

● Microsoft Excel

EXPERIENCE

Oracle Database Administrator

US Army reservists / November 2021 to Current

• Install andmaintaintheperformanceofdatabaseservers.

• Develop processes for optimizing database security.

• Set andmaintaindatabasestandards.

• Manage database access.

• Performance tuning of database systems.

• Install, upgrade, andmanagedatabaseapplications.

• Diagnose and troubleshoot database errors.

• Recommend and implement emerging database technologies.

• Create andmanagedatabasereports,visualizations, and dashboards.

• Create automation for repeating database tasks.

• Be available for on-call support as needed.

Developed semester outlines and instructional plans for each class session to comply with stated course objectives.

Delivered reliable support for server-class systems. Junior oracle ADMINISTRATOR

Hamilton, VA

Data Solution Consulting LLC/ nov 2019 to sept 2021

● Created andmanagedusersandserviceaccountsonLinuxandWindows.

● Performing housekeeping tasks like checking logs and trace files.

● Performed replication using materialized views with a complete refresh/Fast refresh

● troubleshooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory, and operating system.

● Monitoring scheduled backup procedures and Database refreshes

(from prod to DEV or TEST on a daily basis using crontab.

● Created and monitored user access rights and privileges through roles and profiles

● using Database Configuration Assistant(DBCA)~Database Upgrade Assistant (DBUA) for upgrading Oracle 11gR1 to11gR2 then latest Oracle 12c to 19c and applied patches

(CPU&PSU) as required using the Opatch utility.

● Installed 12c and 19c software on several Linux boxes then migrated and upgraded 11g g databases to 12c and 12c to 19c using data pump.

● upgraded from Oracle 12.1.0.2 to 19.3.0 and successfully implemented data Guard. Migrated CDB tonon~CDB

using data pump backup databases using RMAN.

● Cloning 11g~12c and 19c databases using RMAN duplication (with and without backup). rovided instance level performance monitoring and tuning for Wait Eventst Sessions~ Physical and Logical IO and Memory Usage with the help of AWR and ADDM

● Reports, Explain Plan, SQL DEVELOPER and Oracle Enterprise Manager.

● eveveloped PL/SQL packagesDML~DDL~OracletableseStored Proceduresefunctions~ cursors, triggers and UNIX shell scripts for reports.

● Performed database refreshes migration and performance tuning of PeopleSoft application

● Keep a smooth and respective relationship with customers as well as delivering project in time andmanner.

Self learned

Udemy

January 2019 to August 2019

● Install Oracle Database 11g & 12c (Manual method and using DBCA)

● Tablespace management to manage space to store the data.

● UNDO Tablespace management to manage undo space.

● REDO Log file management to manage redo space.

● Manage users and security

● Networking (Configuring Listeners and TNS entries)

● Understand various Data dictionary tables/views

● Diagnose issues using Diagnose data and generate packages for Oracle Support.

● Backup and Recovery (User Managed)

● Backup and Recovery (RMAN)

● Materialized Views

● Table Partitioning

EDUCATION AND TRAININGS

associate degree working onmybachelordegreeinComputerScience Harrisburg community college - Harrisburg, PA

November 2020 to Present

● Certifications: Secret Clearance

● CompTIA security+

● Oracle DBA certification in progress.

LANGUAGES

French:

Native/ Bilingual

English:

Full Professional



Contact this candidate