Oracle Database Administrator at Opass Limited

Job Overview

Location
Lagos, Lagos
Job Type
Full Time
Date Posted
2 years ago

Additional Details

Job ID
57844
Job Views
93

Job Description



What you’ll be doing:


As an Oracle Database Administrator, you should have extensive experience in the following:



  • Good knowledge of Windows Server and Linus OS

  • Oracle database/E Business suite architecture and components.

  • Auditing oracle databases.

  • Installing and maintaining the Oracle database software

  • Patching and upgrading of database

  • Supporting and administration of RAC database

  • Back up of database using RMAN, data guard and oracle golden gate.

  • Creating autonomous database backups.

  • Managing data security.

  • Experience in all routine DBA tasks including health checks, troubleshooting issues and installations.

  • Good knowledge of PLSQL, and SQL

  • Knowledge of traces, tkprof and find poorly performing SQL. Rewrite poorly performing SQL.

  • Good understanding of logical and physical Oracle database architecture

  • Creating Data Definition Language (DDL) scripts and implement physical schemas in accordance with the clients Data Administration Metadata Standards

  • Ability to use change management software (for example, HP Service Manager) to create and manage change requests for database modifications

  • Ability to communicate interact with the Application Development Teams

  • Ability to communicate and interact effectively with the corporate Database Administration community and Data Management group

  • Ability to consult with corporate Database Management group when recommending and implementing database security best practices

  • Ability to work with the corporate Database Management group to ensure the security of the databases

  • Ability to deal with multiple projects and deadlines

  • Ability to conduct application performance tuning

  • Ability to rebuild database LOB indexes to improve on database query performance.

  • Ability to perform patch analysis for applying Oracle Critical Patch Update in Oracle WebLogic servers and database servers.

  • Good knowledge of Unix Shell.

  • Ability to monitor daily backups and perform Oracle database clone using RMAN duplicate database concept to refresh UAT, Training databases from production backups.

  • Ability to provide technical support to the developers and functional teams.


What you’ll need:



  • Bachelor’s degree in computer engineering or computer science.

  • Proven work experience as a Database administrator.

  • Working experience in Oracle 11g, 12c and 19c versions.

  • Experience in OEM like Agents, configuring targets and thresholds.

  • Familiarity with Oracle database design, coding, and documentation.

  • Knowledge of database backup procedures, and recovery systems.

  • Knowledge of programming languages, SQL and API.

  • Excellent communication and problem-solving skills.

  • Certification in Oracle Database Administration a plus


Compensation


Salary up to 400k depending on your experience.


Location: Ikeja, Lagos


Similar Jobs

Cookies

This website uses cookies to ensure you get the best experience on our website. Cookie Policy

Accept