Oracle Database Consultant

As an experienced Oracle Database Consultant at Growexx, you will be responsible for managing and optimizing Autonomous Data Warehouse (ADW), Autonomous Transaction Processing (ATP), and Database Cloud Service (DBCS) environments in the Oracle Cloud Infrastructure (OCI) ecosystem. Your expertise in working with JSON-based ADW or Oracle NoSQL databases will be crucial in ensuring high availability, scalability, and performance of mission-critical systems. Your key responsibilities will include creating, configuring, and maintaining ADW and ATP instances in OCI, optimizing DBCS for business-critical applications, designing scalable JSON-based data models, and implementing database performance tuning strategies. You will also be responsible for developing backup, recovery, and disaster recovery strategies, monitoring database health, implementing data security measures, and automating routine administration tasks using scripting and Infrastructure-as-Code. Collaboration with development and DevOps teams will be essential to ensure seamless deployment and integration of database components. Additionally, maintaining accurate documentation including architecture diagrams, configuration SOPs, and support playbooks will be part of your role. To excel in this position, you should have strong hands-on experience with Oracle ADW, ATP, and DBCS, proficiency in handling JSON-based data models, and a deep understanding of SQL, PL/SQL, database design principles, and performance tuning. Familiarity with Oracle Cloud Infrastructure (OCI), high availability, disaster recovery, and database replication concepts will also be valuable. Ideally, you should have a Bachelor's degree in Computer Science, Information Technology, or a related field, along with a minimum of 5 years of hands-on experience in Oracle database administration and cloud database solutions. Proven experience in managing mission-critical workloads using ADW, ATP, and DBCS will be advantageous for this role.,