Nora L. Brown ac2ft3@r.postjobfree.com
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.