Description :

As a Senior Oracle Database Engineer on the Plugin Team, you will be at the intersection of database administration and software development.

You'll leverage your deep Oracle expertise to design and implement automation scripts, enhance database provisioning workflows, and build robust backup/recovery solutions.

You will work closely with engineering, SRE, and product teams to deliver enterprise-grade Oracle database capabilities on our cloud-native platform.

This is a high-impact role where you'll contribute to the core engine that powers Oracle database operations for Tessell customers, working with cutting-edge cloud technologies and modern DevOps practices.

Responsibilities :

- Design and implement automation for Oracle Database provisioning, cloning, backup, recovery, and lifecycle operations across multi-cloud environments (AWS, Azure, GCP).

- Develop and maintain Oracle plugin scripts using Python, Bash, and Jinja2 templates for RMAN backup/restore, DBCA operations, Data Guard configuration, and database administration tasks.

- Build and enhance automation for Oracle Multitenant architecture (CDB/PDB), including PDB lifecycle operations, cloning, and refresh workflows.

- Implement and troubleshoot Oracle RAC, Data Guard, and high-availability configurations in cloud environments.

- Optimize RMAN backup strategies, including incremental backups, snapshot-based backups, and point-in-time recovery (PITR) solutions.

- Collaborate with development teams to integrate Oracle automation into Tessell's orchestration framework (Kubernetes, Argo Workflows).

- Debug and resolve complex Oracle database issues, including performance tuning, memory management (SGA, PGA, HugePages), and storage optimization.

- Develop and maintain SSL/TLS configurations, Oracle Wallet management, and network encryption for secure database connectivity.

- Write unit tests and integration tests for database automation scripts to ensure reliability and correctness.

- Create technical documentation for database operations, troubleshooting guides, and runbooks.

- Stay current with Oracle database releases, patches, and best practices, and incorporate them into the plugin.

Requirements :

- Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent experience).

- 6+ years of experience as an Oracle Database Administrator with hands-on production experience.

- Strong expertise in Oracle Database 12c, 19c, and 21c, including Multitenant Architecture (CDB/PDB).

- Deep knowledge of RMAN backup and recovery, including incremental backups, duplicate databases, and point-in-time recovery.

- Hands-on experience with Oracle Data Guard (physical and logical standby), switchover, and failover operations.

- Experience with Oracle RAC configuration, administration, and troubleshooting.

- Proficiency in Python and Bash scripting for database automation.

- Strong Linux/Unix administration skills (RHEL, OEL, Ubuntu).

- Knowledge of Oracle networking (listener configuration, TNS, TCP/SSL).

- Understanding of Oracle TDE, wallet management, and database encryption.

- Experience with at least one public cloud platform (AWS, Azure, or GCP).

- Strong troubleshooting skills for Oracle errors (ORA-xxxxx), performance issues, and storage problems.

- Excellent communication skills and ability to collaborate with cross-functional teams.

Preferred Qualifications :

- Experience with Oracle on Cloud (AWS RDS for Oracle, Azure Database, OCI).

- Experience with containerization (Docker) and orchestration (Kubernetes).

- Knowledge of Infrastructure-as-Code tools (Terraform, Ansible).

- Experience with CI/CD pipelines and DevOps practices.

- Oracle certifications (OCP, OCM) are a plus.

- Familiarity with Oracle Exadata or Exadata Cloud Service