Job Responsibilities 1.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 2.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 3.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 4.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. 5.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. 6.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 1.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. 2.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; -Confident, and able to take initiative in a delivery-focused environment; Some experience with one or more programming languages.