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