Senior Oracle Database Developer

Overview

The aim of the Sr. Oracle Developer is to work within a team of developers in the delivery of current and emerging business requirements. You will bring your knowledge, expertise and work ethic in the fast paced environment using Agile/Scrum methodology. This is a hands-on role requiring in-depth knowledge in Oracle Database Server development, project experience and project life cycle

• Specific emphasis will be on: - Solution Development

  • Oracle Server Database technology

  • Effective team & communication skills

Key Accountabilities and main responsibilities

Strategic Focus

• To strive for continuous improvement of both technical and business knowledge

• To assist with the development of new team standards, methodologies and processes to increase both the quality and efficiency of the development work

 

Operational Management

• Responsibility to develop quick to market, high quality IT solutions within an agile environment

• This will require full project exposure from start up to completion

• Extremely adaptable and quick to pick up new business concepts within a unique business environment

• Engage proactively with stakeholders and other cross-functional team members in the development of IT solutions

People Leadership

• Work within a team of developers assisting in:

• time estimates

• task allocations

• problem solving

• Provision of regular feedback, mentoring, coaching and assistance to the team’s development needs

Governance & Risk

• Ensure adherence to legal and regulatory requirements

• Support Link Group assurance programs that deliver effective risk management and compliance practices

Experience & Personal Attributes

• 6 to 9 years development experience with Oracle Database version 9i /10g / 11g /12c

• Manage all phases of the SDLC from analysis, design, development, testing, implementation and maintenance

• Primary Skills: - Create and maintain indexes, constraints, tables, PL/SQL store procedures & packages and produce queries to answer business questions.

  • Create numerous simple to complex queries involving self joins, correlate sub-queries, functions, cursors, dynamic SQL.

  • Strong knowledge of T-SQL / PL-SQL

  • Package creation and maintenance

  • Using system-supplied packages

  • Database triggers

  • Networking

  • Tablespace management

  • Oracle database tools

  • Database backup and recovery

  • DECLARE, BEGIN & EXCEPTION clause

  • Designing databases and ensuring their stability, reliability, and performance. 

  • Design, create, and implement database systems based on the end user's requirements. 

  • Improve application's performances. 

  • Prepare documentations for database applications. 

  • Memory management for database systems.

  • Develop database schemas, tables and dictionaries. 

  • Ensure the data quality and integrity in databases. 

  • Fix any issues related to database performance and provide corrective measures. 

  • Create complex functions, scripts, stored procedures and triggers to support application development.

  • Take regular database backup.

  • Test databases and perform bug fixes.

  • Provide authentication and authorizations for Database

  • Develop best practices for database design and development activities.

  • Good understanding of data modelling and database schema design principals

  • Data normalization

  • Knowledge of database optimization techniques

  • Exceptional analytical skills in order to analyse and interpret business needs, and to provide constructive input into the development and technology solutions

  • Experience with Agile/Scrum methodology

Secondary Skills:

• Exposure to cloud technologies, e.g. Microsoft Azure, AWS

• Excellent interpersonal skills with the ability to develop effective inter-departmental and organisational relationships

• Sound organisational skills, with the ability to prioritise conflicting tasks in order to meet strict deadlines

• Self-motivated with a strong team spirit. Strong work ethic