Oracle Database Administrator at Opass Limited

⏲ Jul 28, 2023, 7:22 PM
⋕ View all ICT & Telecommunications jobs

Opass Limited - Our aim is to ensure sustained growth by providing a range of unique services to our diverse clients. Our area of expertise is Human Capital Development. Our assurance is to satisfy our clients wholly and devise solutions to their people needs. Established in 1982 as Olgreen Personnel and Secretarial Services, the company name changed to OPASS Limited, a limited liability in 1987. Accredited by the Centre for Management Development, OPASS Limited has been involved in Training, Recruitment and Manpower Development since 1982.

We are recruiting to fill the position below:

Job Title: Oracle Database Administrator

Location: Lagos

Responsibilities

Knowledge of Windows Server and Linus OS
Installing and maintaining the Oracle database software
Patching and upgrading of the 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.
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 knowledge of PLSQL, and SQL
Knowledge of traces, tkprof and finding poorly performing SQL. Rewrite poorly performing SQL.
Knowledge of auditing oracle databases.
Good understanding of logical and physical Oracle database architecture
Creating Data Definition Language (DDL) scripts and implementing physical schemas in accordance with the client's 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.