Database Engineer – OTC Database Team - Associate
Morgan Stanley
London, United Kingdom, United Kingdom
30d ago

Description

Team Profile : Morgan Stanley’s OTC Database team is looking for a Database Engineer to join their business critical team.

The team is tasked with producing business critical transactional database systems as well as large Data Warehouses / Data Marts to meet scalability, stability and performance requirements.

  • Database Infrastructure Engineering for stability and scalability, capacity planning
  • Application DBA functions : plan & execute database schema changes, bottlenecks analysis, outage prevention / resolution, server / database performance improvements, database maintenance, database recovery
  • Database development (stored procedures, ETL, tools) and queries / stored procedures review and optimization
  • Enforce database security, standards & guidelines
  • Act as a leader in outage resolutions and multi-team global turnovers.
  • Be the escalation point for major issues.
  • Required Skills :

  • Established experience in DB2 Linux relational database work and must have exceptional hands-on application DBA skills.
  • Previous experience of DB2 Linux version 9 and above (SQL, Temp tables, plan explains, MQTs, MDCs, referential integrity constraints, etc)
  • You must be familiar Power Designer / Erwin or some similar modeling tool
  • You must be previous experience with scripting language such as Perl and Unix / K-Shell .
  • You will have strong knowledge base of relational database performance and tuning such as : proper use of indices, database statistics / reorgs, de-
  • normalization concepts.

  • You will have the ability to propose / review innovative solutions and implement them in production to achieve significant improvements.
  • You will be an expert in performance optimization on server, database, query, data structures and data flow levels, with advanced database architecture knowledge and hands on expertise in OLTP and Datamart design, Federated database systems.
  • As a successful candidate you will also have excellent Database Administration skills including in depth knowledge of new and existing features to provide effective solutions for critical systems.
  • Personal skills : 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.

    Company Profile : 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 maximise 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.#LI-RJ1

    Apply
    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form