Technology - PostgreSQL Database Engineer, Associate, Shanghai
Morgan Stanley is a leading global financial services firm providing a wide range of investment banking, securities, investment management and wealth management services. The Firm's employees serve clients worldwide including corporations, governments and individuals from more than 747 offices in 42 countries.
In Morgan Stanley, Technology works as a strategic partner with Morgan Stanley business units and the world's leading technology companies to redefine how we do business in ever more global, complex, and dynamic financial markets. Morgan Stanley's sizeable investment in technology results in quantitative trading systems, cutting-edge modelling and simulation software, comprehensive risk and security systems, and robust client-relationship capabilities, plus the worldwide infrastructure that forms the backbone of these systems and tools. Our insights, our applications and infrastructure give a competitive edge to clients' businesses-and to our own.
The Enterprise Tech & Services division is looking for an experienced PostgreSQL Database Engineer to design and engineer a new PostgreSQL DB platform for our China business. The successful candidate individual will be responsible for overseeing all aspects of database architecture/administration, including DB plant design, replication setup, backup & restore design, performance tuning, regular maintenance and the creation of specialized jobs, depending on what needs may arise.
Work with application/infrastructure teams to provide a reference design and automation for the deployment and configuration of PostgreSQL databases.
Oversee the monitoring, alerting and capacity management functions for PostgreSQL databases.
Identify areas for improvement and propose best practices for our database plant.
Automate the provision and maintenance of PostgreSQL databases.
Ensure best practices on security configurations.
Acting as a top-level escalation point to perform complex troubleshoots, working with other infrastructure & application owners to resolve issues including performance tuning.