Oracle Manager

SHALENE FONJI

Oracle Database Administrator

*** * ******** ***, ********, VA 23223 240-***-**** ********@*****.***

PROFILE

A talented and resourceful Oracle DBA professional with over 5 years of experience who possess a solid experience in working with Oracle 10g, 11g, and 12c versions across a complete life cycle of SDLC. Areas of work include production support, installation and configuration, database migration, backup and recovery, performance monitoring and tuning, database cloning, security management, database upgrades, and patches.

SKILLS SUMMARY

Have ample knowledge in implementing policies, and procedures for data disaster recovery and archival processing to ensure data protection.

Efficient in performing database re-organizations as required in assisting performance and ensuring maximum uptime of the database; implemented SQL Access and SQL Tuning advisors recommendations.

Expert in delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, OEM Grid, monitoring database performance with custom scripts and troubleshooting oracle databases using SQL trace utilities.

Experience with SQL coding including DDL, DML and fine-tuning those SQL's for better performance.

Experience in using 10g features Flash-Back Recovery, Data Pump, AWR, ADDM, ASH, Recycle Bin. Expert in RMAN backups including full, incremental and cumulative.

Excellent knowledge in Flashback Recovery, Hot/Cold Backup and Cloning/Refresh of databases using RMAN.

Planned, installed and upgraded multiple Oracle databases from 11.2.0.4 to 12.2.0.

Experience in applying patches/ patch sets to the databases using OEM 12c and scripts.

Extensively worked on Import/Export and Data Pump Import/Export tools.

Expert in implementing High Availability solutions with Oracle 11g RAC, Oracle Data Guard and Real time replication using Golden gate.

High ability to interpret, analyse, understand the AWR reports, and fine-tune the databases for maximum performance.

Install, configure and upgrade to Oracle 12c; consolidate multiple databases into multi-tenant database containers; evaluate and implement latest database technology and new Oracle 12c features.

Performed database monitoring and tuning to ensure databases run at peak performance; troubleshooting production performance issues.

Extensively managed users, privileges, profiles, schemas using Oracle Enterprise Manager (OEM).

Proficient in complete, incomplete recovery of the database, Point in Time Recovery (PITR), and Tablespace Point in Time Recovery (TSPITR) using RMAN utility.

Expertise in implementing partitioning methodologies (Range partitioning, List partitioning, Hash partitioning, Composite partitioning) on tables and indexes for high performance.

Knowledge of Database Recovery Techniques and implementation of those recovery techniques to ensure business continuity.

Planned, implemented and maintained Database Security using auditing and High level Security using Transparent Data Encryption(TDE),

Equipped with excellent communication and interpersonal skills; a highly organized individual and team player who possesses strong analytical and problem solving skills, and is who is committed in delivering quality services

EDUCATION

Government High School (Advanced Level Certificate in Business Management)

Bachelor Degree in Business Management University of Buea.

WORK EXPERIENCE

CITY OF RICHMOND, Richmond VA April 2015 – Current

Information Technology Specialist III

Worked as a team member for 24x7 support with on call rotation in all prod, QA and dev environments.

Worked on Multitenant Databases (Oracle 12c Container and pluggable databases)

Worked with 12c new features like Redaction policy, adaptive query optimization, and Restore table through RMAN (PITR on a table) etc.

Hands on experience in cloning the non-multitenant container database to pluggable database in 12c using the PDB Metadata clone, PDB Remote Clone and PDB Snapshot cloning feature.

Performed database administration, production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, and cloning on 10g, 11g and 12c.

Performed database reorganizations and refresh schema(s) using Export/Import.

Created databases, tablespaces, and tables, indexes, setting privileges, rules and user logins per project request.

Configured and Managed Golden gate for Unidirectional and Bidirectional Replication.

Monitored and performed database sizing, tablespace management and rollback tablespace management, transaction management and security administration.

Used Oracle 12c Enterprise manager to monitor and report the Database health for over 500+ databases

Upgraded multiple databases ranging from 25GB to 23TB from 10g to 11g, 11g to 12c and minor version upgrades.

Installed, configured and created 11g databases for Testing and Development of applications on both IBM-AIX and Linux environment in OLTP, Decision Support System Data Warehousing environment (OLAP).

SQL tuning - AWR history of sql execution, index recommendations, SQL Tuning Advisor, SQL Access Advisor, Real Time SQL Monitoring, Interpreted Execution plans, Re-write more efficient SQLs.

Planned and implemented Oracle High Availability features like RAC, DATA GUARD, GRID CONTROL and Oracle Performance Tuning Utilities like ADDM, AWR, ASH, SQL-Tuning Advisor, EXPLAIN PLAN, TKPROF.

Performed Data file recovery for both critical and non-critical data file using RMAN, also performed logical recovery using DATA DUMP and traditional EXP/IMP utilities.

Continuous monitoring of performance during peak and non-peak loads using AWR reports, ASH, ADDM and Optimization SQL code using SQL Trace, tkpof, Explain plan.

Partitioned very large tables to improve database performance, Implemented Range, List, Hash Partitions, Create and schedule refresh for materialized views.

Work with Oracle Data Pump (expdp and impdp) which provides high-speed, parallel slaves, and metadata movement of Oracle database contents.

Monitoring growth of tables and undertaking necessary re-organization of database, capacity planning.

Provide support to developers to enhance their SQL, PL/SQL code and responsible for setting up of new user accounts, schema Deployments and related user administrative tasks.

Successful in installation/maintenance of Physical Standby database using Oracle Data Guard for Oracle 11.2.0.3 databases.

Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.

Experienced using GOLDEN GATE for UNIDIRECTIONAL AND BI DIRECTIONAL Replication.

Environment: Oracle 11g/11g RAC, VMS, Sun Solaris, Windows Server 2008, 2012 R2, Red Hat Linux, TOAD, RMAN, SQL server, OEM.

AT&T - Dallas, TX March 2013 – Jan 2015

Oracle Database Administrator

Supported multiple databases for production, development, and test and staging purposes.

Applied CPU patches to multiple Oracle databases using the Opatch utility.

Refreshed Dev and Test instances with data from Production per request.

Created Materialized views and Materialized View Logs for Data Replication.

Worked with optimizer Hints and Explain Plan estimated performance and to generate optimal solutions for slow running queries.

Worked on building and rolling out new 12c databases for TEST/DEV/QA environments.

Implemented oracle 12c active standby database for test database environment

Tuned database performance and optimized slow running queries using Explain-Plan, SQL-Trace, STATS PACK reports and AWR Reports. Provided recommendations using ADDM reports. Analyzed the trace files Using TKPROF utility.

Diagnosed Oracle bugs and coordinated with Oracle support to resolve them in timely manner.

Performed various tasks like Administering RAC using SRVCTL, adding nodes and instances, Administering Storage Components, Parameter Management, and Configuring High Availability Features for RAC.

Developed compliance reports and performed auditing at higher levels.

Scheduling repetitive activities like gathering schema statistics, exports, tablespace usage report using crontab.

Applied PSU Patches (10.2.0.3, 10.2.0.4) as a part of maintenance activity.

Extensively used Data pump, conventional export/import utilities for loading data to and from databases, for logical backups and migration of databases.

Monitored and optimized the performance of the database/application using OEM along with customize shell scripts.

Capacity planning: Allocate system storage and plan future storage requirements.

Worked on SQL tuning using SQL Tuning Advisor, SQL Access Advisor, SQL Profiler and SQL Optimizer.

Installation and configuration of Oracle databases environments (10/11g), upgrades, patching for security vulnerabilities (CPU and PSU).

Performed monthly and annual performance reports for trend analysis and capacity planning.

Assisted in SQL tuning and providing consultation such as creating Materialized views, adding indices, dropping unnecessary indices, using hints wherever possible, amongst others.

Worked on both Nutrinax VMs, RHEL and UNIX environments.

Troubleshot various database performances by proper diagnosis at all levels.

Knowledge in Oracle Data warehouse DBA skills relating to administration and management Oracle OLAP.

Experienced in writing basic UNIX/SHELL scripts for providing the backup and service failure reports via emails.

Environment: Oracle 11g/11g RAC/10g, VMS, Sun Solaris, Windows Server 2008, Red Hat Linux, TOAD, RMAN, SQL server, OEM.

TECHNICAL PROFICIENCIES

Operating Systems

Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1

RHEL 5.11, RHEL 6.7, RHEL 7.3, Nutrinax VMs

Windows Server 2008, 2012 R2

RDBMS

Oracle 10g, 11g, 12c

Languages

SQL, PL/SQL, UNIX Shell Scripting, PERL.

Tools

TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM Toad, Putty, NX client, WinSCP.

Database Utilities

SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, DataPump, Export, Import.

APPLICATIONS

PEOPLESOFT, Tomcat, Jamf Pro

Contact this candidate