Job title: Oracle Database Administrator Job at Opass Limited

Company:

Job description: Opass Limited – Our client, a multi-solution consulting firm with a passion for quality, honesty and excellence, is recruiting suitable candidates to fill the position below:

Job Position: Oracle Database Administrator

Job Location: Ikeja, Lagos

Reporting To: Managing Director

Responsibilities

• Knowledge of Windows Server and Linus OS
• Installing and maintaining the Oracle database software
• Back up of database using RMAN, data guard and oracle golden gate.
• Creating autonomous database backups.
• Managing data security.
• Patching and upgrading of database
• Supporting and administration of RAC database
• Good knowledge in Oracle database/E Business suite architecture and components.
• Experience in all routine DBA tasks including health checks, troubleshooting issues and installations.
• 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
• Good knowledge of PLSQL, and SQL
• Knowledge of traces, tkprof and find poorly performing SQL. Rewrite poorly performing SQL.
• Knowledge of auditing oracle databases.
• 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.

Expected salary: 300000 – 400000 per month

Location: Ikeja, Lagos State

Job date: Wed, 27 Sep 2023 06:21:06 GMT

Apply for the job now!

#Oracle #Database #Administrator #Job #Opass #Limited