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