Senior Full Stack Engineer (Oracle ExaCC Primary)

Role Description

• We are seeking a Senior Full Stack Engineer with over 10 years of experience specializing in Oracle database development, ideally with Exadata Cloud at Customer (ExaCC).
• The ideal candidate will have a strong background in database design, development, and optimization, as well as knowledge of Java, Angular, OpenShift, and DevOps.
• The candidate should be proficient in building and deploying applications using standard build tools and have a mindset oriented towards observability and supportability. We value independence, drive, commitment to excellence, high standards of workmanship, and dedication to quality, as well as the ability to present work to both technical and non-technical audiences.

Your key responsibilities

• Design, develop, and maintain Oracle database schemas and applications
• Optimize database performance and ensure data integrity.
• Develop and implement database solutions to support business needs.
• Collaborate with application developers to integrate database solutions.
• Perform database tuning and troubleshooting.
• Manage and optimize containerized applications using OpenShift.
• Build and deploy applications using standard build tools.
• Implement/Maintain CI/CD pipelines using Jenkins/GitHub Actions and Maven/Gradle.
• Design and implement applications with a focus on observability and supportability.
• Present work effectively to both technical and non-technical audiences.

Your skills and experience

• 10+ years of experience in database development.
• Expertise in Oracle databases, including ExaCC. With at least 2 years production level exposure to 19c
• Strong SQL and PL/SQL programming skills including complex SQL analytics and bulk operations
• Comfortable responding quickly and decisively when dealing with production database issues; used to dealing with production DBAs and open to challenging their recommendations
• Indepth knowledge of the Oracle data dictionary, ASH and AWR but not a reliance on pre-canned reports to diagnose performance issues
• SME on the inner workings of the Oracle database and not just using the database as a black box
• Familiar with and practical experience of both OLTP and Datawarehouse platforms and how to design and tune accordingly; the difference approaches to coding etc.
• Confident talking to data modellers to talk through database design, critiquing and conveying new requirements
• Ability to analyse complex legacy code and propose solutions to streamline including implementation of reusable components
• Ability to code MVPs to help demonstrate concepts and approaches to others thinking about the advantages and disadvantages of their own solution
• Terms like context switching, bind variable peeking, cardinality feedback, data skews, histograms, cursor sharing, hard parsing and database waits are all part of your repertoire
• Authors like Tom Kyte, Steven Feuerstein, Christian Antognini and Jonathan Lewis are familiar to you
• Familiarity with version control systems (e.g., Git).
• Excellent analytical and problem-solving skills.
• Awareness of container bases deployment ideally OpenShift Container Platform 4.
• Experience with Jenkins/GitHub Actions and Maven/Gradle.
• Scripting with any scripting system such as Bash/Python/Perl
• Strong competency in building and deploying applications using standard build tools.
• DevOps mindset with a focus on observability and supportability.
• High emotional quotient and respect for diverse opinions.
• Independence, drive, commitment to excellence, high standards of workmanship, and dedication to quality.
• Proficiency with Test Driven Development and Behaviour Driven Development.
• Experience with Liquibase/Flyway
• Proficiency in advanced branching and merging concepts.
• Strong communication and teamwork skills.
• Orientation towards writing safe, secure code that avoids/remediates vulnerabilities early in the development cycle.

Preferred Qualifications

• Experience with other database technologies (e.g. Postgres, BigQuery).
• Familiarity with data warehousing concepts like SCDs, Fact tables, junk dimensions
• Familiarity with monitoring and logging tools (e.g., Prometheus, ELK stack, Splunk, Grafana).