Post Trade Engineering - Postgres Database Lead

Employer: LSEG Romania
  • Internet - eCommerce
  • IT Hardware
  • IT Software
  • Job type: full-time
    Job level: 1 - 5 years of experience
  • Updated at: 19.09.2021

    LSEG Post Trade is a key division of the London Stock Exchange Group consisting of London Clearing House (LCH) and UnaVista. Post Trade supports our customers' clearing and regulatory reporting obligations, providing risk, balance sheet and financial resource management solutions. LCH operates a group of multinational clearing houses, providing counterparty risk mitigation across multiple asset classes for sell-side clearing members and buy-side clients in conjunction with trading venues globally. UnaVista provides regulatory reporting services help clients align with multiple global reporting regimes all through one platform.

    This role is part of the Post Trade engineering team which is a central group focussed on improving the engineering practices, experience and technology usage. The team is also a key part of realising Post Trades' strategy of moving technology platform to cloud provided services - particularly AWS and Azure. As a part of that strategy LSEG Post Trade is intending to migrate to use Postgres as the database of choice.

    This role is intended as the Postgres lead in the Post Trade division working with application teams to develop or migrate solutions based on Postgres. The successful candidate will be responsible for defining best practices and standards for Postgres solutions across the division. This will be a hands-on role, developing database code for resolving complex Postgres issues that are beyond the capabilities of application teams.

    Key responsibilities of the role:
    • Provide expert skills on the development of solutions using Postgres technology

    • Implement database code for resolving issues or application tuning

    • Assist teams in their migration to Postgres - particularly from Oracle

    • Provide oversight and assurance over Cloud Service Providers and their support of Postgres

    • Implement and maintain database code in the form of stored procedures, scripts, queries, views, triggers, etc.

    • Work with application teams to ensure efficiency of database code, integrity of data structures and quality of data content

    • Review database application design and application code

    • Participate as a member in Agile teams, and work with other team members to review user stories, estimate effort to build functionality supporting user stories, and participate in sprint reviews

    • 5+ years working as a database developer - including at least 2+ years working with Postgres

    • Experienced Level SQL, PL/pgSQL, including stored procedures, functions, triggers, and views

    • Knowledge of XML and JSON and Postgres support for complex data types

    • Ability to efficiently write database code without compromising data quality, privacy or security

    • Knowledge of database design principles, query optimization, index management, integrity checks, statistics and isolation levels

    • Demonstrable experience working with huge, interdependent, complex datasets and data structures

    • Ideally experience of Postgres deployments provided by cloud service providers - particularly Postgres Aurora

    • Experience with other database technologies - particularly Oracle and Snowflake - would also be useful

    Behavioural skills
    • Able to handle multiple tasks in a fast paced environment

    • Excellent verbal, written, and interpersonal communication skills

    • Ability to evaluate alternative solutions and/or workarounds

    • Work with people across multiple locations as part of a global team

    • Experience in working in an agile environment

    We are looking for intellectually curious people, interested in the bigger picture of how technology industry is evolving, ready to ask difficult questions and deal with complicated scenarios. If you a forward thinker and problem solver, this is the place to be as will be supporting you to fast forward your career.

    We maximise each employee's potential through personal development through a wide range of learning tools both formal and informal. We believe in remunerating our people with competitive salaries and a range of attractive benefits such as:

    • 25 days' holiday per year

    • Share Purchase Plan

    • Private Medical Insurance

    • Dental Coverage

    • Life insurance

    • Pillar 3 Private Pension Plan

    • Meal Vouchers

    • Flexible Benefits

    • Bookster

    • Volunteering Events

    • Team Buildings

    People are at the heart of what we do and drive the success of our business. Our culture of connecting, creating opportunity and delivering excellence shape how we think, how we do things and how we help our people fulfil their potential.

    At LSEG we embrace diversity and actively seek to attract individuals with unique backgrounds and perspectives. We break down barriers and encourage collaboration, enabling innovation and rapid development of solutions that make a difference. Our workplace generates an enriching and rewarding experience for our people and customers alike. Our vision is to build an inclusive culture in which everyone feels driven to reach their potential.

    We know that real personal growth cannot be achieved by simply climbing a career ladder - which is why we encourage and enable a wealth of avenues and interesting opportunities for everyone to broaden and deepen their skills and expertise.

    LSEG are committed to supporting emotional, physical, financial and societal wellbeing. Our tailored benefits are a key part of this commitment and we offer colleagues a range of support from healthcare and retirement planning to paid volunteering days and consumer discounts.

    We also make reasonable accommodations for applicants and employees with disabilities. If an accommodation is needed to participate in the job application or interview process, to perform essential job functions, and/or to receive other benefits and privileges of employment, please make your recruiter aware, we want to ensure you perform at your best.

    As a global organisation spanning 70 countries and one rooted in a culture of growth, opportunity, diversity and innovation, LSEG is a place where everyone can grow, develop and fulfil your potential with purposeful careers.

    Please take a moment to read this privacy notice carefully, as it describes what personal information the London Stock Exchange Group (LSEG) ("We") may hold about you, what it's used for, and how it's obtained, your rights and how to contact us as a data subject .

    If you are submitting as a Recruitment Agency Partner, it is essential and your responsibility to ensure that candidates applying to LSEG are aware of this privacy notice.