At a Glance
- Tasks: Optimise Oracle databases and SQL queries for impactful equity research.
- Company: Dynamic financial firm in London with a focus on innovation.
- Benefits: Competitive pay, flexible hours, and opportunities for skill development.
- Other info: Collaborative environment with potential for career advancement.
- Why this job: Join a team that shapes the future of equity models with your coding skills.
- Qualifications: Experience in PL/SQL and understanding of financial markets required.
The predicted salary is between 50000 - 70000 £ per year.
We are looking for a database Developer who will be responsible for optimizing the Oracle database tables, SQL queries, and recommending new data models for mission critical empirical research database. The work involves working closely with Equity quantitative research analysts in developing new sources of information for the development of equity models in line with business requirements.
Role responsibilities:
- Using their proficiency in PL/SQL, the ideal candidate should be able to understand complex queries, look into their execution plan and come up with a combination of alternatives to the tables, the indices and the code to optimize performance or meet other objectives as required.
- The candidate should be able to take a large/ complicated codebase of SQL statements, understand the patterns in it and be able to modularize and optimise the code using parameterized cursors, stored procedures and scripting languages.
Technical Requirements:
- An Oracle database developer specialising in optimising Oracle database and SQL queries.
- We are moving some of the data processing from SQL to Python; the ideal candidate should be at least able to call SQL procedures from a Python program.
Business Requirements:
In order for the successful candidate to be productive from day one they will require knowledge and understanding of financial and equity markets. Specifically:
- A variety of equity source feeds such as Compustat, IBES, MSCI, FTSE, S&P, etc.
- Characteristics/issues related to fundamental equity data i.e. basic equity accounting metrics such as EBITDA, Revenue, Free Cashflow, Operating Margin, etc.
Database Developer, Contract, London in West End employer: Proxime Limited
Contact Detail:
Proxime Limited Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Database Developer, Contract, London in West End
✨Tip Number 1
Network like a pro! Reach out to folks in the finance and tech sectors, especially those who work with databases. A friendly chat can lead to insider info about job openings that aren't even advertised yet.
✨Tip Number 2
Show off your skills! If you’ve got a portfolio or GitHub with examples of your SQL queries or database optimisations, share it during interviews. It’s a great way to demonstrate your expertise and passion for the role.
✨Tip Number 3
Prepare for technical interviews by brushing up on PL/SQL and Oracle database concepts. Practise explaining your thought process when solving complex queries, as interviewers love to see how you tackle challenges.
✨Tip Number 4
Don’t forget to apply through our website! We’re always on the lookout for talented individuals like you. Plus, it shows you’re genuinely interested in joining our team.
We think you need these skills to ace Database Developer, Contract, London in West End
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Database Developer role. Highlight your experience with Oracle databases, PL/SQL, and any relevant projects that showcase your skills in optimising SQL queries. We want to see how you can bring value to our team!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're passionate about database development and how your background aligns with our needs. Don’t forget to mention your understanding of financial and equity markets – it’s a big plus for us!
Showcase Your Technical Skills: In your application, be sure to highlight your technical skills, especially in PL/SQL and any experience with Python. If you've worked on optimising complex queries or have experience with equity data sources, let us know! We love seeing real examples of your work.
Apply Through Our Website: We encourage you to apply through our website for a smoother process. It helps us keep track of applications and ensures you get all the updates directly from us. Plus, it shows you’re keen on joining StudySmarter!
How to prepare for a job interview at Proxime Limited
✨Know Your SQL Inside Out
Make sure you brush up on your PL/SQL skills before the interview. Be prepared to discuss complex queries and execution plans, as well as how you would optimise them. Practising with real-world scenarios can help you articulate your thought process during the interview.
✨Familiarise Yourself with Financial Data
Since the role involves working with equity markets, it’s crucial to understand key financial metrics like EBITDA and Free Cashflow. Research the various equity source feeds mentioned in the job description, so you can confidently discuss how they relate to database optimisation.
✨Showcase Your Problem-Solving Skills
Be ready to tackle hypothetical problems during the interview. Think about how you would modularise a complicated SQL codebase or optimise performance using stored procedures. Demonstrating your analytical skills will impress the interviewers.
✨Connect SQL with Python
As the company is moving some data processing from SQL to Python, it’s beneficial to show that you can bridge the gap between the two. Brush up on how to call SQL procedures from Python and be prepared to discuss any relevant projects you've worked on.