Job Description

Morgan Stanley is looking for an experienced Database Infrastructure Engineer to develop, test, and manage multiple databases globally. The role requires expertise in Snowflake and Postgres, along with proficiency in Python and UNIX/Linux scripting for automation and infrastructure projects.

Requirements

5+ years of Strong Developer Experience with ANSI compliant databases such as Postgres and Snowflake using Python and/or Perl
Thorough Knowledge of SQL
Strong development skills in Python using database interfaces such as SQLAlchemy/ODBC
Experience with Agile and DevOps
Experience with Linux and Windows, Scripting
Good understanding of Azure and/or AWS CSP (CLI based application design and implementation)
Strong communication and written skills

Responsibilities

Responsible for monitoring and optimization of Snowflake and PostgreSQL databases, ensuring high availability and top performance across diverse cloud environments
Responsible for unit and integration testing of REST framework
Automate database management tasks using Python and UNIX/Linux scripting to enhance infrastructure provisioning and deployment efficiency
Monitor and ensure data security by configuring encryption, access control, and compliance measures to protect sensitive data in Snowflake and other databases/systems
Review and improve system performance through query optimization, result caching, and clustering, reducing query times and enhancing system reliability
Collaborate across teams within the firm to resolve critical issues or any potential outages