Director, Python Database Infrastructure Engineer

Morgan Stanley•Alpharetta, GA

About The Position

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 5+ years of Strong Developer Experience with ANSI complaint 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 Hands-on experience with Azure and/or AWS CLI based application design and implementation Knowledge of security controls for the Public cloud (encryption of data in motion/rest and key management ) Developing monitoring architecture and implementing monitoring agents, dashboards, escalations and alerts Experience with architecting and maintaining high availability production systems Snowflake certification a plus We do it in a way that's differentiated - and we've done that for 90 years. Our values - putting clients first, doing the right thing, leading with exceptional ideas, committing to diversity and inclusion, and giving back - aren't just beliefs, they guide the decisions we make every day to do what's best for our clients, communities and more than 80,000 employees in 1,200 offices across 42 countries. Our teams are relentless collaborators and creative thinkers, fueled by their diverse backgrounds and experiences. We are proud to support our employees and their families at every point along their work-life journey, offering some of the most attractive and comprehensive employee benefits and perks in the industry. There's also ample opportunity to move about the business for those who show passion and grit in their work. To learn more about our offices across the globe, please copy and paste https://www.morganstanley.com/about-us/global-offices into your browser. Consequently, our recruiting efforts reflect our desire to attract and retain the best and brightest from all talent pools. We want to be the first choice for prospective employees. It is the policy of the Firm to ensure equal employment opportunity without discrimination or harassment on the basis of race, color, religion, creed, age, sex, sex stereotype, gender, gender identity or expression, transgender, sexual orientation, national origin, citizenship, disability, marital and civil partnership/union status, pregnancy, veteran or military service status, genetic information, or any other characteristic protected by law.

Requirements

5+ years of Strong Developer Experience with ANSI complaint 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
Hands-on experience with Azure and/or AWS CLI based application design and implementation
Knowledge of security controls for the Public cloud (encryption of data in motion/rest and key management )

Nice To Haves

Snowflake certification a plus

Responsibilities

monitoring and optimization of Snowflake and PostgreSQL databases
ensuring high availability and top performance across diverse cloud environments
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
developing monitoring architecture and implementing monitoring agents, dashboards, escalations and alerts
architecting and maintaining high availability production systems

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume