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 1,200 offices in 43 countries.
As a market leader, the talent and passion of our people is critical to our success. Together, we share a common set of values rooted in integrity, excellence and strong team ethic. Morgan Stanley can provide a superior foundation for building a professional career - a place for people to learn, to achieve and grow. A philosophy that balances personal lifestyles, perspectives and needs is an important part of our culture.
Morgan Stanley is an equal opportunities employer. We work to provide a supportive and inclusive environment where all individuals can maximize their full potential. Our skilled and creative workforce is comprised of individuals drawn from a broad cross section of the global communities in which we operate and who reflect a variety of backgrounds, talents, perspectives and experiences. Our strong commitment to a culture of inclusion is evident through our constant focus on recruiting, developing and advancing individuals based on their skills and talents.
This position is for a database developer role in the transactional data team. Among many other databases, our team manages the firm critical Institutional Trade Capture databases and is responsible for the OTC Derivatives Trades Internal Reporting.
We are a team of highly technical individuals who manage a large number of databases that include Big Data volumes. We deliver multiple projects for multiple business areas in parallel. The business owners and subject matter experts are globally distributed, making strong communication skills important to the position. The candidate will be expected to work closely with our IT partners in analyzing and delivering on business requirements.
Development will utilize an agile methodology, which is based on scrum (time boxing, daily scrum meetings, retrospectives, etc.), and XP (continuous integration, refactoring, unit testing, etc) best practices. Candidates must therefore be able to work collaboratively, demonstrate good ownership and be able to work well in teams.
Work will include designing, enhancing and developing databases across different database environments. The job will involve considering all aspects of the project life cycle and includes proof-of-concept evaluations, coding, designing, testing, implementing, deploying, and continued support of project releases as well as on-call Level 2 support. Collaboration with the Firm’s engineering teams is expected.
The role will be located at 700 Wellington, Suite 2000, Montreal, QC, H3C 3S4 and is a full-time role (40 hrs/wk)
Major Role & Responsibilities:
- Database Infrastructure Engineering for stability, scalability and capacity planning. - Application DBA functions: plan & execute database schema changes, bottleneck analysis, outage prevention/resolution, server/database performance improvements, database maintenance, database recovery, etc. - Database development (stored procedures, ETL, tools) and queries/stored procedures review and optimization. - Enforce database security, standards & guidelines.
- 3-5 years of experience of DB2 Linux (SQL, Temp tables, plan explains, MQTs, MDCs, referential integrity constraints, etc) and Sybase - The candidate must have advanced scripting knowledge such as: Python or Perl - The candidate must have advanced knowledge base of relational database performance and tuning such as: proper use of indices, database statistics/reorgs, de-normalization concepts, memory management, database configurations, etc. - The candidate must have knowledge of database modelling tool such as power designer - The candidate must have advanced knowledge base of relational database performance and tuning such as: proper use of indices, database statistics/reorgs, de-normalization concepts, memory management, database configurations, etc. - Basic knowledge of other databases is a plus. - The candidate must have advanced scripting knowledge such as: Python or Perl. - The candidate must have advanced knowledge base of relational database performance and tuning such as: proper use of indices, database statistics/reorgs, de-normalization concepts, memory management, database configurations, etc. - Knowledge of Database cloning tools such as Delphix - Versioning tools such as perforce and git is a plus, but not required. - Knowledge of financial instruments would be a great benefit
- Bachelor’s Degree or Master’s Degree in computer science, mathematics or related
Integrity & ownership, good team player, ability to work under time and resource dependencies and constraints, ability to find simple and effective solutions, high degree of motivation to expand technical and business knowledge.