职位详情

登录

数据库开发工程师
2.5-5万
人 · 本科 · 5年及以上工作经验 · 性别不限2024/11/08发布
五险一金补充医疗保险补充公积金出国机会弹性工作定期体检

浦东新区

低价好房出租>>

世纪大道1196号世纪汇办公楼2座20楼

公司信息
富谙智(上海)信息技术有限公司

外资(欧美)/1000-5000人

该公司所有职位
职位描述
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.

相关职位
数据库内核开发工程师(中高级)2.5-5万
数仓开发工程师2-3.5万·15薪
高级数仓工程师2.5-3.5万·15薪
做五休二蚂蚁控股
CIM工程师20-40万/年
数仓开发工程师2-3万·13薪
查看所有职位
51米多多提醒你:在招聘、录用期间要求你支付费用的行为都必须提高警惕。 以招聘为名的培训、招生,许诺推荐其他工作机会,甚至提供培训贷款,或者支付体检 、服装、押金和培训等费用后才能录用工作的,都属于违法行为,应当提高警惕。一经发现,请立即举报,并向当地公安机关报案。

举报

招聘信息 > 上海招聘 > 后端开发招聘 > 上海数据开发招聘

收藏

热门职位热门城市周边城市