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
-*** 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.