Senior Software Engineer - Oracle

Senior Software Engineer role focusing on Oracle RDS database support, developing high-quality code, providing technical guidance, and supporting business operations in an AWS environment.

• Develop high-quality code with good test coverage
• Actively participate in estimation and technical design discussions
• Review code produced by others
• Provide support to business operations
• Keep abreast of software technology change
• Build and maintain positive ongoing cooperative relationships with internal stakeholders
• Undertake professional development and research to maintain currency in software development
• Demonstrate commitment to teamwork and a collaborative work environment
• Communicate effectively, ensuring that emails are acknowledged within one business day
• Develop and maintain a comprehensive understanding of the system
• Communicate and support operation and engineering team members on the underlying system
• Ensure appropriate unit testing is applied to new or changed code with coverage of 70%+
• Ensure stories/defects are created soundly
• Monitor scheduled jobs and notifications
• Produce relative complexity estimates for User Stories in collaboration with the team
• Review merge requests of other team members for bugs or code quality improvement opportunities
• Ensure technical documentation is written and kept up to date
• Ensure web application security is considered in any product change
• Ensure accessibility is considered for any product change
• Ensure performance testing and tuning occur as required
• Provide support, troubleshooting, and incident resolution
• Assist QA/PO as required for acceptance tests
• Identify and suggest processes and procedures that promote better and faster results
• Identify and suggest new tools and technologies that improve results for end users, developer happiness and productivity
• Apply and promote common design patterns
• Take steps to improve the maintainability of the product codebase

• Bachelor's or Master's degree in IT, Computer Science, or relevant field
• At least three years of commercial experience in the role of Senior Software Engineer, with prior experience as a software engineer
• Deep knowledge of at least Oracle 19C
• High level of understanding in Oracle statement tuning
• Deep knowledge of Oracle objects: tables, indexes, normal views, materialized views, sequences, packages, triggers, pipeline functions, DDL and DML
• High level of knowledge in PL/SQL, including arrays, functions, procedures, pragmas, bulk processing and cursors
• Sound understanding of working with Oracle in an AWS environment
• Good Linux command line skills
• Github or similar version control
• Vue.js (advantageous)
• Node.js (advantageous)
• Amazon Web Services products such as EC2, S3, CloudFront, RDS, Route53 (advantageous)