About client : A global, FTSE 250-listed company made up of a collection of progressive fintech brands in the world of online trading and investing. Headquartered in London, UK with a presence in 18+ countries and five continents.
Your role in the Team :
As an expert Oracle Developer, you will be responsible for the development, maintenance and support of Database Objects.
You will be responsible for the database uptime, performance management, data access management and provide L1/L2/L3
Support for the critical schemas owned in OLTP database.
You will guide application development teams with Data Modeling best Practices and Oracle performance tuning guidelines.
You will be responsible for investigation of performance issues with stored procedures and any SQL query issues.
What you ll do :
Responsible for OLTP Database Maintenance and Support.
Responsible for Impact Analysis, Performance tuning of database Objects.
Responsible for Modifying Stored procedures, database Packages etc.
Provide Level 1,2 and 3 support for the database.
Handle critical Incidents and Problems raised due to the database related issues.
Handle database updates(DML and DDL) operations.
Analyze Splunk logs and find Root causes and assist Incident Managers.
What you ll need for this role
7+ years of experience as a Oracle Developer.
Excellent skills in Oracle SQL/PLSQL programming.
Expert in using log monitoring tools like splunk.
Expert in Oracle Performance Tuning
Expert in understanding Physical design aspects like partitioning, clustering, indexing etc.
Expert in reading Explain plan, TKProf outputs etc and recommend performance tuning options.
Good Knowledge of Unix and Shell Scripting.
Basic understanding of Java.
Good Knowledge of Cloud Platforms like AWS/GCP.
Good knowledge of Git and CI/CD pipelines.
Good knowledge of Unit testing using UTPLSQL or any other frameworks.