Senior Software Engineer - Oracle

The Senior Developer required should have a core strength in Oracle RDS to support the existing Oracle database. The Senior Developer focuses on translating designs, User Stories and non-functional requirements into maintainable and performant software solutions, providing technical guidance to the team, ensuring high-quality code, and supporting business operations. Primary Responsibilities

• 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.

General Responsibilities

• Build and maintain positive on-going 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.
• Undertake duties normally associated with the role.

System Knowledge

• Develop and maintain a comprehensive understanding of the system.
• Communicate and support operation and engineering team members on the underlying system.
• Have deep knowledge of at least Oracle 19C.
• Have high level of understanding in Oracle statement tuning.
• Have deep knowledge of Oracle objects and items such as tables, indexes and all types, normal views and materialized views, sequences, packages, triggers, pipeline functions, DDL and DML.
• Have high level of knowledge in PL/SQL, including arrays, functions, procedures, pragmas, bulk processing and cursors.
• Have a sound understanding of working with Oracle in an AWS environment.

Reporting & Support

• 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/CS, * Bachelor's or Master's degree in IT, Computer Science, or relevant field.

Experience

• At least three years of commercial experience in the role of Senior Software Engineer, with prior experience as a software engineer.

Technical Expertise

• Vue.js (advantageous)
• Node.js (advantageous)
• Github or similar version control
• Good Linux command line skills
• Amazon Web Services products such as EC2, S3, CloudFront, RDS, Route53 (advantageous)