Post Job Free

Resume

Sign in

Oracle Certified Database Administrator

Location:
Washington, DC
Posted:
September 23, 2017

Contact this candidate

Resume:

Nora L. Brown ac2ft3@r.postjobfree.com

202-***-****

Summary of Qualifications

Achievement-driven and results-oriented professional offering well-rounded skills as an entry-level database administrator and technical lead. Well-trained and versatile information technology professional with advanced coursework in Oracle RAC (Real Application Clusters) and Data Guard as well as industry-leading Oracle certifications. Creative problem solver with the ability to multi-task, resolve issues, and perform work with little or no supervision. Recognized as a resourceful and technical individual with strong understanding of various storage, network, and hardware requirements in Oracle RAC. Experience in performing common administration operations in RAC databases such as the use of the cluster verify utility for performing health checks in Oracle RAC.

Performance Tuning and Troubleshooting

Flashback, Backup and Recovery

User Management and Locks

SQL Loader and EXPDP/IMPDP

AWR/ADDM Tuning

Remote Connections

RAC and Dataguard Basics

Oracle DBMS and Structure Basics

Education

Loyola University of New Orleans New Orleans, LA

Bachelor of Science in Psychology – Candidate September 2014 – May 2015

Training

Neway IT Solutions – Oracle DBA Training – Oracle Database Administration – Oracle Database OCA

Advanced Coursework in Oracle RAC (Real Application Clusters) and Data Guard

Certifications

Passed SQL 11g, Oracle 11g, and Admin 1 Certifications; Preparing for OCP Certification

Skills Matrix – Oracle Database Administration (DBA)

Neway I.T Solutions – Oracle DBA Training

5 Years of Experience in Skills Gained:

Knowledge of Oracle Installations

Knowledge of Oracle Database Architecture (10G/11G)

Knowledge of User Management

Knowledge of Table Space Management

Knowledge of Control Files Management, Redo Log Files, and Archive Log Files Management

Knowledge of User Management and Oracle Flashback Technology

Knowledge of Oracle Networking (Configuring Listener.ora, Tnsnames.ora File)

Knowledge of Oracle Backup/Recovery using both user-based and RMAN (physical as well as logical)

Configuring and managing Physical Standby Database Server

Cloning the Database Server

Managing Automatic Storage Management via instance and command line utility like ASMCMD

Patching and upgrading of Oracle Database Server using patch sets (from 10G to 11G)

Configuring and administrating instance manually and through OEM

Project summaries:

Project 1: Linux command line, shell commands.

Projects 2+3: Basic SQL*Plus queries.

Project 4: Creating and dropping tables, indexes, and sequences. Joins.

Project 5: Managing parameter files, tablespaces. User management and privileges. Query data dictionary tables and dynamic performance views. Managing parameters and database status. Rebuilding indexes.

Project 6: Database security revoking execute from public. Auditing and fine-grain auditing. Listener and tnsnames, remote connections. Database maintenance, AWR/ADDM, gathering db stats. Archivelog, switch logfile. Backup and flash recovery area.

Project 7: Backup parameters, recovery catalog. Recovery of spfile, control file, and data file. Flashback recovery. Datapump import and export. Password reset. SQLLDR.

Project 8: Database upgrade with patchset. 10g to 11g. Critical patch allocation. Relocating data files.



Contact this candidate