About the job
Central Bank of Oman is seeking to recruit competent, committed, self-motivated and enthusiastic Omani candidate to work as Database Administrator
Purpose:
The role should have the technical skills and knowledge that extends across application/OS/storage and network technologies to administer complex production DB’s environments, troubleshoot, and provide system-level guidance/solutions.
Job Responsibilities:
• Installing and configuring database software.
• Monitoring performance and optimizing query execution.
• Managing user access and security.
• troubleshooting database issues.
• collaborating with development teams to support application integration
• capacity planning, data migration, and ensuring data integrity and availability.
• Manage the environment of multiple DB and Oracle application instances at the Primary and DR Sites and ensure high availability.
• Perform all the necessary preventive maintenance and daily health check related to the databases.
• Responsible for all the Database’s disaster recovery-related activities.
• Execution of data migration jobs and scripts as required and perform cloning of production to the TEST/DEV instance.
• Ability to support applications technical team whenever required.
• Apply all periodical patches for bug fixes and upgrade the DB and applications.
• Prepare functional and technical specification documents related to the application/database architecture.
• To participate as a technical expert for any new implementation of Oracle DB/Application.
• Approving or defining database performance and data ownership, archiving, purging, integrity, security requirements.
• Defining and developing physical and logical database structures.
• Encouraging the use of structured techniques, data dictionaries, data flow diagrams, entity relationship diagrams, and new technological tools such as prototyping and other productivity improvement tools in application system development.
• Develop procedures for regular database back-ups and restore from back-ups when required.
• Create and maintain separate database environments as required by the project team (e.g.: Test, Production, etc.).
• Upgrade database as and when required.
• Support the project team/end users with all database-related issues.
Position Requirements:
Bachelor’s degree in computer engineering / information technology.
Knowledge and Experience:
Minimum of 5 years of relevant experience as a Database administrator.
Working experience in Oracle Linux/ RedHat Linux.
Experienced in developing PL/SQL
Experience in writing SQL procedures
Exposure of doing single node to multi-node architecture
Aware of RAC configuration.
Oracle certifications (e.g., OCP) are desirable.
Please Submit your application before 24th August 2024.
