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 & Person Skills