DB developer

This role is semi functional and semi technical, where the developer will need to verify correct behavior on the proprietary CRD UI using their tooling which uses XML and SQL to source control it.

We're looking for someone who can help with converting Oracle SQL queries to MS SQL and CRD proprietary "SQL-like" queries. They will need to test out behavior to the CRD Thick Client UI.

There will also involve scripting to streamline setup of the configs (i.e. setup repeatable deployments of the UI configs, organization of our components in source control).

You may also have to help modify other UI components that don't involve much SQL and requires using their proprietary tool, which is maintained using CRD's XML.

As usual the role assumes the candidate to:

Provide analytical, operational and strategic support

Analyse the business need and provide recommendations

Map the business requirements to the application

Design of application database: structure, content and processes of data population;

Validate the solution with the end users;

Design the reports and extraction: SQL statement, layout formatting, and report publication;

Apply correspondent methodology and tools, the elaboration and implementation of consistent work plans, project and program documents, and achievement of results;

Ensure proper reporting on implementation and achievement of outputs, as well as contribute to reporting on progress towards outcomes and impact.

Functional knowledge:

Basic knowledge of financial products;

Technical knowledge

Expert Oracle Database knowledge

SQL and PL/SQL (views, joins, stored procedures, packages etc)

Experience with database performance analysis and troubleshooting

Experience with Oracle database optimization & performance tuning

Experience with MS SQL database or willing to learn how to translate queries from Oracle to MS SQL with subsequent troubleshooting and performance tuning

Unix/Linux/Windows basic command line knowledge, shell scripting (bash, PowerShell)

Vocational competencies:

Fluent in English

Strong analytical & problem-solving skills.

Autonomy, adaptability and ability to meet deadlines.

Rigorous and precise.

Strong sense of dedication & teamwork.

Previous experience (as plus) on capital markets (either Front, Middle or Back office experience)

Experience with Informatica PowerCenter ETL tools