Job ResponsibilitiesDatabase & PerformanceWork with project teams on driving better MS SQL schema design, to handle high pressure volume transactions on large wealth management platformsIdentify existing database design and performance issues for projects, and work towards solution for fixHelp create and test SQL statements for data presentation and further automationPerform as a code maintainer to review SQL schema changes from other developersPerformance tuning for WebAPI, webpages and batch process on wealth management platforms with large volume dataWork closely with analysts and other department personnel (in Shanghai solution centre or other regions) in advising best SQL coding practicesCreate technical documentation for training developers

Analysis & DesignWork within the constraints of the feature/user story to define the underlying schema design required to deliver these changesProvide 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 toolsAble to create/modify SQL store procedures to achieve functional target, while meeting the performance requirement

DevelopmentDevelop 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

QualityAdhere 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 / CommunicationCollaborate 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 projectsMentor new starters to ensure they understand both platform and SDLC.Provide solution centre-wide training, as required, on topics of personal expertise.

TechnologyKeep 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 requiredPrimary requirementsFirst 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, etcGood and professional English in both spoken and written;Willing to succeed in cross-region team.Preferred4+ 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 triggers2 + years of integrating SQL Server solutions in .NET environments, with working knowledge of C#, ASP.NET and SOA with web servicesExperience with platform with large volume data and high throughput transactions;Have experience with performance monitoring and analytic tools: SQL Execution Plan, New Relic, Foglight, etcUnderstanding 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.