Oracle Database Consultant

Growexx is seeking an experienced Oracle Database Consultant with strong expertise in managing and optimizing Autonomous Data Warehouse (ADW), Autonomous Transaction Processing (ATP), and Database Cloud Service (DBCS) environments. The ideal candidate should also be proficient in working with JSON-based ADW or Oracle NoSQL databases, ensuring high availability, scalability, and performance of mission-critical systems in the Oracle Cloud Infrastructure (OCI) ecosystem.

Key Responsibilities

• Create, configure, and maintain Autonomous Data Warehouse (ADW) and Autonomous Transaction Processing (ATP) instances in OCI.
• Manage and optimize Oracle Database Cloud Service (DBCS) for various business-critical applications.
• Design and implement scalable JSON-based data models in ADW / NoSQL environments.
• Perform database performance tuning, query optimization, and indexing strategies.
• Develop and execute backup, recovery, and disaster recovery strategies for Oracle Cloud databases.
• Monitor database health using Oracle-native tools and proactively resolve issues.
• Implement data security, role-based access controls, and compliance standards.
• Automate routine database administration tasks using scripting and Infrastructure-as-Code (e.g., Terraform).
• Collaborate with development and DevOps teams to ensure seamless deployment and integration of database components.
• Maintain accurate documentation including architecture diagrams, configuration SOPs, and support playbooks.

Key Skills

Education and Experience

Analytical and Personal skills

Skills Required

Database Replication, Terraform, Sql