Technical Support Oracle

Location:

Hyattsville, MD

Salary:

85000/year

Posted:

June 06, 2016

Contact this candidate

Resume:

COMFORT AMBE NJIKO

ORACLE DATABASE ADMINISTRATOR

***********@*****.*** TEL : 240-***-****

PROFESSIONAL SUMMARY:

Over 5 Years of total Oracle Database Administration experience in implementing, Design, Development, Testing and Production support in all industry verticals exclusively Energy, Financials and Insurance Industries.

Installation, upgrade, patching and management of oracle 12c database. Management of container databases

Experienced with Unix, Solaris, AIX, NT, RedHat, Windows

Installed, configured, migrated and maintained RAC databases with ASM

Expert in systems analysis, architecture and capacity planning

Implement backup/recovery procedures with RMAN, Netapp and other third party tools.

Database Installation configuration and troubleshooting, including Performance monitoring and Tuning.

Design, development, and testing of backup and recovery to ensure complete recoverability.

Installation and configuration of Service Now for business requirements and flow.

Unix Shell scripts for hot backups, SQL*Loader, export and import of database.

Perform Daily Monitoring of Oracle instances using Oracle Enterprise Manager, ADDM, TOAD, monitor users, table spaces, memory structures, rollback segments, logs, and alerts.

Extensive experience in 7*24 production database support.

Security management for database, network, and operating systems.

Solid experience in disaster recovery, routine maintenance for Oracle databases.

Experienced in Installing, maintaining Standby DR servers using Dataguard

Design and implement of database backup strategy and performed full, incremental and Cumulative backups using RMAN. Troubleshooting with RMAN backup problem.

Performance monitoring/tuning/troubleshooting on for systems: Oracle, UNIX, Linux.

System resource management including bottleneck detection, contention tuning on SGA, CPU, Memory and I/O etc.

Ability to prioritize and meet operational deadlines in fast paced environment with good stress management skills.

SQL Net installation/configuration/troubleshooting (Server and Client side

Storage Management including fragmentation detection, tablespace growth ratio.

Excellent interpersonal and strong analytical, problem-solving skills.

Monitored the alert logs and troubleshot the errors.

PROFESSIONAL EXPERIENCE:

USCIS – McLean, VA Jan 2016 – present

Oracle DBA

Responsibilities:

Backup / Recovery methodology specification for mission critical databases.

Installation and configuration of Oracle 10g and 11g and 12C, OEM with Oracle Diagnostic and Tuning packs.

Configuration and management of ServiceNow for business requirement analysis

Data migration between databases using both Oracle 10g and 11g export/import utility and Oracle 11g exp/imp data pump.

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

Created the database objects such as Tables, Indexes, Views, Database Triggers, Procedures, Functions, etc..

Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using Toad, Oracle 12c Grid Control & SQL*Plus, as well as UNIX shell scripts.

Performed hot and cold Backups.

Implementing Oracle ASM and resolving ASM related issues

Set up and configured SQL*Net and on servers and client machines.

Administration of RAC and DATAGUARD databases in Oracle 11g.

State University of Wisconsin (UWCX) CITS – Madison, WI May 2015 – Jan 2016

Oracle DBA

Responsibilities:

Worked on large databases in Oracle 11g with multiple instances using Veritas Cluster.

Database Patching with Opatch and upgrade from 11.2.0.1 to 11.2.0.4 and 11.2.0.3 to 12.1.0.2

Performed cold and hot backup using RMAN.

Produce complex sql to query the database for client reports.

Managed datafiles and database storage to support data loads for testing.

Supported application by managing app schemas and diagnosing jdbc connection pool connectivity issues

Refreshed tables and Schemas across environments for testing and other purposes using Data Pump.

Provided remote technical support using SSH and terminal services

Troubleshooting, Restructuring and tuning for optimal performance of existing databases that were poorly designed for heavy hits.

Design of databases following OFA: Creating Databases schemas, profiles, database links, Snapshots and Synonyms of objects as required to ensure data quality and security to comply with company's business rules. Oracle scripting in Windows/ Solaris and UNIX platform.

Backup / Recovery methodology specification for mission critical databases

Performed hot and cold Backups.

Scheduled daily Exports/Imports to serve as logical backups.

Installation and configuration of Oracle 10g and 11g and 12C, OEM with Oracle Diagnostic and Tuning packs.

Install client/server Oracle and MS SQL Server database Software

Wrote scripts to create tables, views, indexes and synonyms required meeting developer needs.

Supporting offshore developers by running scripts from the developers to create tables, schemas,

Working with Java J2EE developers to develop and formulate capacity planning for 11g databases.

Cloned databases using scripts as well as RMAN. Installation, setup and configuration of Data guard

Involved in design and enforcing of standards in place to ensure that all application design and code is produced with proper integrity, security and performance

Refreshed schema using Export/Import. Created the database, tablespace, tables, indexes, set privileges and user logins

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

Data migration between databases using both Oracle 10g and 11g export/import utility and Oracle 11g exp/imp data pump.

Exadata: Using Exadata to support ACFS running Grid Infrastructure version 12.1.0.2

Resizing and reorganization of database objects: Tables, Indexes, Rollback segments and Redo log files of existing production and development systems. Resizing Tablespaces, Tables, indexes, Rollback segments.

Worked on in house installation of Oracle on different platforms, loaded user data to reproduce the problem, applied new Oracle patch, managed database backup using RMAN, upgraded Oracle database 10.2.0.4 to 11.2.0.1 and to 12c, creating the 12c container database and plug on the pluggable databases. Using cloud control 12c to monitor databases/ database management.

Database reorganizations and refresh schema-using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins. Performed cold and hot backup using Oracle's Data pump.

Provided remote technical support using SSH and terminal services

Troubleshooting, Restructuring and tuning for optimal performance of existing databases that were poorly designed for heavy hits.

Backup / Recovery methodology specification for mission critical databases

Performed hot and cold Backups.

Scheduled daily Exports/Imports to serve as temporary backups.

Alliant Energy-Madison, WI March 2011 – April 2015

Oracle DBA

Responsibilities:

Worked on large databases in Oracle 11g with multiple instances using Veritas Cluster.

Performed cold and hot backup using Oracle's Data pump.

Provided remote technical support using SSH and terminal services

Troubleshooting, Restructuring and tuning for optimal performance of existing databases that were poorly designed for heavy hits.

Backup / Recovery methodology specification for mission critical databases

Performed hot and cold Backups.

Scheduled daily Exports/Imports to serve as temporary backups.

Installation and configuration of Oracle 10g and 11g Enterprise Editions, OEM with Oracle Diagnostic and Tuning packs.

Install client/server Oracle and MS SQL Server database Software

Wrote scripts to create tables, views, indexes and synonyms required meeting developer needs. Working with Java J2EE developers to develop and formulate capacity planning for 11g databases.

Cloned databases using scripts as well as RMAN. Installation, setup and configuration of Data guard

Involved in design and enforcing of standards in place to ensure that all application design and code is produced with proper integrity, security and performance

Refreshed schema using Export/Import. Created the database, tablespace, tables, indexes, set privileges and user logins

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

Data migration between databases using both Oracle 10g and 11g export/import utility and Oracle 11g exp/imp data pump.

Used Exadata: Using Exadata to support ACFS running Grid Infrastructure version 12.1.0.2

Database reorganizations and refresh schema-using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins.

Creating physical databases with multiple table spaces from logical and physical data model

Prepared scripts to tune developer SQL codes to maximize result return time

Worked on large databases in Oracle 11g with multiple instances using Veritas Cluster.

Performed cold and hot backup using Oracle's Data pump.

Provided remote technical support using SSH and terminal services

Troubleshooting, Restructuring and tuning for optimal performance of existing databases that were poorly designed for heavy hits.

Backup / Recovery methodology specification for mission critical databases

Performed hot and cold Backups.

Scheduled daily Exports/Imports to serve as temporary backups.

Installation and configuration of Oracle 10g and 11g Enterprise Editions, OEM with Oracle Diagnostic and Tuning packs.

Capacity planning and creating databases for development, staging and production.

Database and Data Migration using Export/Import, Migration Utility.

Performed bulk data loads using SQL Loader.

Performed proactive and reactive tuning/managing database space utilization and growth

Implementing Oracle ASM and resolving ASM related issues

Set up and configured SQL*Net and on servers and client machines.

Administration of RAC and DATAGUARD databases in Oracle 11g.

Oracle DB System Development Life Cycle (SDLC) planning and Oracle DB 3-Tier

Architecture.

Experience Golden Gate, for data replication.

Experience in WebLogic Applications.

Designed, tested and documented Oracle RAC database procedures

Created, relocated and removed Services as needed in an Oracle RAC configuration

Adding and removing nodes to existing Oracle database RAC configurations

Resolving RAC specific issues such as node evictions

Detailed analysis of the business and users requirements by doing various information gathering techniques.

Environment: Oracle RMAN, Oracle 11g (11.2.0.2), DBMS STATS, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN

Aetna Health Care-Hartford, CT. Jun 2010 – March 2011

Jr Oracle DBA

Responsibilities:

Managed Oracle Databases on Windows and Linux platforms.

Performed activities like monitoring the database and provide maximum uptime.

Scheduled the backup jobs such as export through cron job in UNIX environment.

Rebuilt indexes and analyzed tables to ensure good performance of database.

Installed Oracle 9i and 10g on multiple platforms.

Performed up-gradation of 9i to 10g.

Created and granted users the privileges and roles and resizing the datafiles to manage database growth.

Defined and implemented database backup and security strategies, tested the backups periodically for consistency and reliability

Identified long-running database queries, refining queries for better performance, and working with end- users to implement changes

Created primary database objects (tables, views, indexes) once application developers have designed an application

Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both Oracle 10g Grid Control & SQL*Plus, as well as UNIX shell scripts.

Monitored the alert logs and troubleshot the errors.

Performed traditional Cold backup in appropriate environments via OS commands as well as logical exports.

Created the database objects such as Tables, Indexes, Views, Database Triggers, Procedures, Functions, etc…

Environment: Oracle 10.2.0.1, Oracle 9i (9.2.0.8), RMAN, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN, HP-UX 11, Sun Solaris 10.0

TECHNICAL SKILLS:

Database:

Oracle 10g, 11g

Operating Systems:

Windows NT /2000/XP, RHEL (RedHat Linux), UNIX, Solaris

Database languages & Tools:

TOAD9.0.1.8/9.0/8.6.1/7.2, Pl/SQL Developer, SQL*PLUS, SQL* LOADER,VBA,JAVA, SQL, SQL*Loader, Database Links Utilities, RMAN,

OAM, OEM, EXP, IMP, expdp, impdp, TOAD, SQL*Loader,

EMC, Veritas NetBackup

EDUCATION:

BS Health Administration, Stratford University, Fairfax VA

Diploma Human Resource Management, British College, Cameroon.

CERTIFICATIONS:

Public Trust Clearance

OCA - Oracle 11g

Contact this candidate