Resume

Sign in

Manager Data

Location:
Clifton, NJ, 07014
Salary:
90000
Posted:
March 17, 2020

Contact this candidate

Resume:

Bell Njiomegni

Oracle Database Administrator

Location: IL Mobile: 702-***-**** Email: adcce8@r.postjobfree.com

Summary

6+ years of experience as an Oracle DBA, database administration, production support, installation, upgrades, patches, performance tuning, backup and recovery, troubleshooting database design and documentation.

Extensive experience in using T-SQL for developing complex stored procedures, triggers, tables, views, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.

Responsible for database maintenance, backups, recovery, patching, upgrades and performance tuning, user access control.

Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.

Performed backups and tested crash recoveries using Cold, Hot backups and RMAN and also tested various recovery procedures.

Monitoring the ASM instances on the multiple nodes and adding the disk to the disk group when required.

Extensively implemented Data pump, conventional Export/Import for migration and logical backup of database.

Experience with Oracle Supplied Packages such as DBMS.

Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.

Knowledge of planning disaster recovery scenarios with different recovery procedures and methods like Data Guard & Standby Database.

Good experience in configuring Grid OEM and Oracle Enterprise Manager (OEM) for maintaining and monitoring databases.

Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.

Starting/Shutting down the RAC databases and Creating and Relocating RAC database services to instances.

Expertise concerning migration/consolidation of databases using Oracle multitenant.

Implementing Best Practices for migration regular databases to Oracle Exadata.

Hands on experience in OEM Grid Control and Installed OEM Cloud Control for database Monitoring/Performance/Diagnostics.

Used TOAD for ERWIN as tools to manage databases.

Experienced in Performance Tuning of SQL Server Databases Using Explain Plan, ADDM, TKPROF, STATSPACK and AWR.

Experienced in Database optimization and developing stored procedures, Triggers, Cursors, Joins, Views, Cursors and SQL on databases: MySQL, Oracle and DB2.

Experienced in Administration of Production, Development and Test environments carrying different operating system platforms like Windows, Linux.

Good Interpersonal Skills, team-working attitude, takes initiatives and very proactive in solving problems and providing best solutions.

Skills

SQL, PL/SQL, T-SQL, DB2, MS SQL Server, MySQL, MS Office, Oracle, RMAN, Golden gate, Oracle Exadata, OEM, TOAD, ERWIN, ASM, AWR, Explain Plan, ADDM, Data Pump, TKPROF, STATSPACK, Data Guard, Backup Recovery, Migration, RAC, Windows, Linux

Education

Bachelor in Computer Science

University of Douala, Douala, Cameroon

Experience

Piper Jaffray, IL March 2018 – Current

Oracle Database Administrator

Roles & Responsibilities:

Develop database Backup and Recovery and Disaster recovery strategies scheduling full and incremental backups using RMAN.

Trouble shooting performance issues using Explain Plan and TKprof.

Worked on Database Migrations from one datacenter to another datacenter on Quarter Rack on oracle Exadata.

Used Export/Import, Data Pump Utilities to move the data between different databases and for backups.

Managing databases and instances using Data Guard, RAC in a real time production, testing, and Development environment.

Experience in implementation of Golden Gate features to extract and replicate the data between various topologies

Implementing Oracle ASM and resolving ASM related issues.

Analyze data requirements, application and processing architectures, data dictionaries and database schemas.

Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).

Performed database migration from DB2 to Oracle database.

Set up and administered tablespaces, data files, tables, indexes, views and sequences Configured and managed users, security and Redo logs.

Created and maintained read-only users for non-dev databases and scheduled jobs to set read-only access for new tables.

Fifth third bank, GA Jan 2016 - Feb 2018

Oracle Database Administrator

Roles & Responsibilities

Extensively used AWR, ADDM and Explain plan for periodic performance tuning.

Creating logical and physical database design as per application requirement with E/R models and normalization using Erwin Data Modeler.

Responsible for setting and managing user management, space management Granting required privileges to users.

Knowledge in Oracle Data warehouse DBA skills relating to administration and management of VLDB environments Oracle.

Translated business requirements into creation and alteration of database objects: tables, indexes, constraints, triggers and stored procedures.

Configure Oracle Advanced Security on databases to implement Transparent Data Encryption at tablespace, table and column levels. Also configured Redaction using OEM's Policy expression builder

Exported the data required information to RDBMS using database to make the data available for the claims processing team to assist in processing a claim based on the data.

Made performance improvements to the database by building Partitioned tables, Index Organized Tables, Materialized Views.

Involved in requirement gathering and data analysis and Interacted with Business users to understand the reporting requirements.

Use tools as SQL developer and custom scripts; while creating users and maintaining password rights.

Experienced in debugging the stored procedures, and modifying them as per the business needs.

Maintained all documents of Oracle Database operations. Prepared documentation of database backup and recovery standards.

Implementing Data pump, conventional export/import utility of Oracle for re-organizing Databases/Schemas/Tables to improve the performance.

Performing the daily Maintenance tasks and interacting with Oracle Customer service when required

UnitedHealth Group, VT July 2013 to Dec 2015

Oracle Database Administrator

Roles & Responsibilities

Creation or modification of custom tables, views, sequences, procedures, functions, indexes, tablespaces and other DDL requests.

Involved in Configuration and maintenance of Standby databases for High availability using Oracle Data Guard for one of critical application at Enterprise level.

Worked with application teams in preparing database design using TOAD Data Modeler.

Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).

Developing, Testing and Implementing Sound Backup and Recovery Strategy.

Creating and managing schema objects such as Tables, Views, Indexes, Stored Procedures and User-Defined Functions depending on the Requirements Using T- SQL.

Proficient in developing and maintaining of functions, procedures, triggers, indexes using MYSQL database.

Involved in Performance tuning, database monitoring activities using STATSPACK.

Performed database cloning from old system to new system.

Implemented Flashback technology of the Oracle along with Recyclebin for a faster recovery of the databases and database objects.

Responsible for setting and managing user accounts, Granting required privileges to users.

Other duties include applying oracle database patches, creation of database users, monitoring, tuning, troubleshooting, and backup and recoveries, monitoring and optimizing database performance.

Active Participation in the System Study Created tables, indexes and views.



Contact this candidate