Position Oracle Database Developer
Aptitude Software is a finance software specialist focused on equipping Chief Financial Officers to achieve their strategies and ambitions. With our team of 200, we continue to win against the big technology mega-vendors at many of the world's leading banking, insurance and telecom companies.
Many CFOs, financial controllers and finance change specialists firms see the opportunity to help drive profitable growth at their companies. Uniquely, we bring together finance domain expertise, innovative software products and laser-sharp focus on the CFO's needs to solve problems that our competitors can't..
Uniquely, Aptitude Software brings together finance domain expertise, innovative software products and laser-sharp focus on CFO's needs to solve problems that our competitors can't.
We're growing rapidly and need a Oracle Database Developer to join us.
Position Oracle Database Developer
We are looking for a Oracle Database Developer to design and develop our financial application products and perform tuning of the database instances and queries.
You will be involved in the full application development lifecycle working within an agile team environment
- Design, develop, implement and maintain SQL and PL/SQL stored program units/packages and maintain coding standards
- Write and perform unit tests for the PL/SQL stored program units/packages
- Develop business logic and complex calculation rules
- Conduct performance analysis and tuning of the processes and database
- Diagnose performance issues using AWR, Staspack, Enterprise Manager
- Identify and analyze performance issues and provide solutions
- Collaborate with key business and technology stakeholders to define functional and technical design
- Lead and/or participate in delivery activities using an Agile development methodology, working as part of a multi discipline team
- Participate and present at formal and informal design reviews, playbacks, and retrospectives
- Collaborate with Testers to develop comprehensive and appropriate test strategies for each release
The ideal candidate will have the following skills, attributes & experience:
- Experience in application development and design
- High proficiency with SQL and PL/SQL
- Expert level understanding of Oracle database architecture
- Knowledge of both database and program code performance tuning
- Understanding of execution plans, use of statistics
- Good skills in all Oracle tools including Oracle Enterprise Manager
- Strong interpersonal, teamwork and problem-solving skills
- Motivated, adaptable, results-focused, and accountable for delivering accurate and timely results
- Educated to degree level or higher, preferably in Computer Science, Mathematics or Economics
- Good spoken and written English
Advantageous Skills
- Familiar with Oracle 12c, RAC and Exadata
- Knowledge of UNIX and Windows operating systems and tools
- Experience with Teradata database
- Experience with DevOps, Continuous Delivery, Continuous Integration
- Working knowledge of Jira
- Experience of designing Financial Systems / General Ledger
- Knowledge of accounting and regulatory compliance
- Head of Development
What you'll get
- Profit related bonus
- Private healthcare (for employee and family)
- Life and disability insurance
- Social Fund (multisport card, gift card for Christmas & Easter)
- English lessons