Job Responsibilities
Database & Performance
Work with project teams on driving better MS SQL schema design, to handle high pressure volume transactions on large wealth management platforms
Identify existing database design and performance issues for projects, and work towards solution for fix
Help create and test SQL statements for data presentation and further automation
Perform as a code maintainer to review SQL schema changes from other developers
Performance tuning for WebAPI, webpages and batch process on wealth management platforms with large volume data
Work closely with analysts and other department personnel (in Shanghai solution centre or other regions) in advising best SQL coding practices
Create technical documentation for training developers
Analysis & Design
- Work within the constraints of the feature/user story to define the underlying schema design required to deliver these changes
- Provide solutions and recommendations for the resolution of technical issues that arise and ensure solutions meet the technical specs and design requirements;
- Understand the approaches to analyse and identify database level performance issue via utilizing relevant tools
- Able to create/modify SQL store procedures to achieve functional target, while meeting the performance requirement
Development
- Develop real-time transaction processing systems that support millions of trades every day in investment securities in multiple world markets;
- Collaborate with other developers to make sure that the solutions developed are robust and in-line with the requirements;
- Ensure code is designed and built in a reusable manner.
- Able to create/modify proper database schemas to meet the functional and non-functional requirement.
- Continually develop an understanding of the business functionality of FNZ platforms
Quality
- Adhere to the defined procedures for code management, code reviews, coding standards, naming conventions and security standards;
- Perform manual testing to ensure any changes made to the system are of a high standard and the system hasn’t regressed.
- Perform code reviews for other developers, when required, to ensure that proposed changes meet quality and best practice standards.
Collaboration / Communication
- Collaborate with other developers to share knowledge, best practices, useful technology, and opportunities for cross-project system design / solutions.
- Able to manage priorities and efficient communication when working with multiple projects
- Mentor new starters to ensure they understand both platform and SDLC.
- Provide solution centre-wide training, as required, on topics of personal expertise.
Technology
- Keep abreast of latest and/or relevant technologies, tools and methods. Identify adoption of technology, tools and methods best suited to FNZ;
- Proactively resolve technical (environmental, coding and testing) issues that impede development progress. Assist in the resolution of technical issues when requested by other developers; and
Experience required
Primary requirements
First class bachelors degree or higher and/or equivalent experience;
Familiar with T-SQL database, including MS SQL Server or MySQL;
Experience with platform database performance tuning;
Have experience with performance monitoring and analytic tools: SQL Execution Plan, New Relic, Foglight, etc
Good and professional English in both spoken and written;
Willing to succeed in cross-region team.
Preferred
- 4+ years of implementing database systems, with at least 3 years using MS SQL (or MySQL), data modeling, including an understanding of all normalized forms, design and development of stored procedures, views and triggers
- 2 + years of integrating SQL Server solutions in .NET environments, with working knowledge of C#, ASP.NET and SOA with web services
- Experience with platform with large volume data and high throughput transactions;
- Have experience with performance monitoring and analytic tools: SQL Execution Plan, New Relic, Foglight, etc
- Understanding of web services;
- Confident, and able to take initiative in a delivery-focused environment;
- Some experience with one or more programming languages.
About FNZ
FNZ is committed to opening up wealth so that everyone, everywhere can invest in their future on their terms. We know the foundation to do that already exists in the wealth management industry, but complexity holds firms back.
We created wealth’s growth platform to help. We provide a global, end-to-end wealth management platform that integrates modern technology with business and investment operations. All in a regulated financial institution.
We partner with over 650 financial institutions and 12,000 wealth managers, with US$1.5 trillion in assets under administration (AUA).
Together with our customers, we help over 20 million people from all wealth segments to invest in their future.