SQL Solution Developer (XML)
SQL Solution Developer
UnaVista is the London Stock Exchange's matching, reconciliation and data integration service, our customers being tier 1 investment banks, hedge funds, brokers and other financial institutions.
The UnaVista team is run along similar lines to a software company: our culture is dynamic, and requires each individual to adapt rapidly to change, contribute fully and think on their feet. This role involves on-going interaction with all other areas (sales, pre-sales, professional services, development and QA, customer support, technical writing, marketing), as well as with customers.
At least 2-3 years (junior/mid level) or 4+ years (senior) of T- SQL development on Microsoft SQL Server 2008/2017 (preferably).
Skilled at creating and optimising large complicated T-SQL transactional statements
Be proficient in database architecture design and performance tuning
Demonstrated proficiency in working with large data sets (billions of records)
Understanding Business requirements and translating them into technical solutions
Experience in troubleshooting and resolving database issues (integrity, performance, workflows and deadlocking issues, etc.)
Develop, implement and optimise stored procedures, functions and batch jobs
Proficiency in data manipulation, remediation and processing (backup restore, data validation/cleaning, historical replays and validation against multiple XML schemas in SQL native language)
XML processing in SQL, Schema validation, develop XML transformations and maintain/manage XML schemas in SQL.
Preferably/Nice to have:
Worked within an Agile/Scrum environment using tools like Jira, Confluence etc.
Financial/Banking/Insurance background preferred
Java knowledge is a plus, XML certification is a plus
To build new solutions on the UnaVista platform in accordance with requirements prioritised by product management and regulators
To deliver optimised and scalable solutions ensuring on-going support requirements are minimised
To work with related teams (development, professional services, QA and support) to ensure that business solutions are delivered on time and with high quality standards
To translate business requirements into actual technical solutions and document system features / functionalities
Communicate effectively with project stakeholder to report on progress against agreed deliverables and escalate any critical issues/blockers.
Data extraction, remediation, manipulation and validation against various XML schemas (including but not limited to backup/restore databases from tapes, data import and XML mapping).
We are looking for intellectually curious people, passionate about the bigger picture of how technology industry is evolving, ready to ask difficult questions and deal with complicated scenarios. If you are creative and a 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 and through a wide range of learning tools both formal and informal. We believe that remunerating our people with competitive salaries and a range of attractive benefits such as:
Pillar 3 Supplemental Pension
25 days' holiday a year
Private medical insurance
Group life insurance policy
Share Purchase Plan
At LSEG, we believe that creating a diverse and inclusive organisation is fundamental to the way we deliver on our promise - and our purpose. You'll be part of an organisation of over 25,000 people, spanning 70 countries. We recognise the individual perspectives each of our colleagues brings, and our diverse workforce is one of our greatest strengths. In supporting collaboration and creativity and encouraging new ideas across a diverse and inclusive workforce, we can improve how we are driving financial stability, empowering economies and enabling customers to create sustainable growth.
LSEG offers a range of tailored benefits and support from healthcare and retirement planning to paid volunteering days and wellbeing initiatives.
We are an equal opportunities employer. We do not discriminate on the basis of race, religion, colour, national origin, gender, sexual orientation, gender identity, gender expression, age, marital or veteran status, pregnancy or disability, or any other basis protected under applicable law. In accordance with applicable law, we make reasonable accommodations for applicants' and employees' religious practices and beliefs, as well as any mental health or physical disability needs.
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.