Design, develop, and optimize complex SQL queries, stored procedures, and data models for Oracle-based systems
- Create and maintain efficient data pipelines for extract, transform, and load (ETL) processes
- Design and implement data quality controls and validation processes to ensure data integrity
- Collaborate with cross-functional teams to understand business requirements and translate them into technical specifications
- Establish documentation standards and ensure comprehensive system documentation
- Lead troubleshooting efforts and resolve complex database performance issues
- Design and implement integrations between Oracle systems and cloud services, particularly AWS S3
- Lead code reviews and establish best practices for database development
- Design and implement data migration strategies from legacy systems to modern cloud-based solutions
- Work within an Agile framework, taking a leadership role in sprint planning and technical discussions
About you
Required Qualifications :
5-10 years of experience with Oracle databases, including advanced SQL and PL / SQL developmentStrong knowledge of data modelling principles and database design patternsProficiency with Python for data processing and automationExtensive experience implementing and maintaining data quality controlsProven ability to reverse engineer existing database schemas and understand complex data relationshipsStrong experience with version control systems, preferably Git / GitHubExcellent written communication skills for technical documentationDemonstrated ability to work within and help guide Agile development methodologiesStrong knowledge of investment management industry concepts, particularly security reference data, fund reference data, transactions, orders, holdings, and fund accountingAdditional Qualifications :
Knowledge of SQL Server developmentExperience with ETL tools like Informatica and Control-MUnix shell scripting skills for data processingExperience with CI / CD pipelines for database codeFamiliarity with AWS services, particularly S3, Lambda, and Step FunctionsKnowledge of database security best practicesExperience with data visualization tools (Tableau, Power BI)Experience mentoring junior developersRole & responsibilities