Oracle Database Administrator

Responsibilities:

1. Maintain Oracle Databases on Oracle Cloud Infrastructure (OCI), in terms of patching, migration, upgrade, duplication, data export, and do periodical refreshes
2. Manage Oracle DataGuard on Oracle Cloud and Monitor the status of the DB systems on OCI.
3. Implement and maintain database security protocols and access controls to ensure data integrity and confidentiality.
4. Monitor database systems to identify and resolve performance issues, bottlenecks, and data inconsistencies.
5. Collaborate with software developers, data analysts, and system administrators to integrate database solutions into applications and systems, and document database designs, configurations, and processes for knowledge sharing and future reference.
6. Conduct regular backups, disaster recovery planning, and database maintenance activities, stay updated with emerging database technologies and best practices to drive continuous
7. Utilize Oracle Cloud Infrastructure (OCI) in managing databases on Oracle Cloud, including provisioning, monitoring, and scaling resources in OCI.
8. Manage access and user access to the database, along with housekeeping (cleanup) when required.
9. Be involved in Oracle Integration Cloud maintenance and debugging.
10. Assist team lead on the following activities:

• ITDR activities
• Routinely monitor Oracle Cloud Infrastructure (OCI) assets, health checks, and consumptions
• Routinely monitor and Debug Oracle Integration Cloud (OIC) issues
• Exploring automation opportunities with Jenkins, Ansible or other tools.

1. Assist the Azure Database Administrator for Databases in Azure

• MSSQL, MySQL, PostgreSQL, Cosmos DB

Requirements:

1. Bachelor's degree in computer science, Information Technology, or a related field.
2. Proven work experience as Database Administrator, and database management systems.
3. Experience with Oracle specific Backup and Recovery: DataGuard (dgmgrl), Data Pump (expdp), Oracle Recovery Manager (RMAN), especially for DB hosted on Oracle Cloud.
4. Familiarity with database monitoring tools and performance tuning methodologies.
5. Familiarity with Oracle Database Networking concept, tns, tnsnames.ora, tnsping etc Oracle Net Services.
6. Linux knowledge running commands, understanding Linux basics commands and file structure. Knowledge of using Oracle Database on Windows is also a requirement.
7. Understanding of Database Architecture: Oracle database architecture, including memory structure, storage structure, tablespaces, datafiles, Oracle ASM, and process architecture.