Senior Technical Support Analyst - SQL
London Stock Exchange Group is a global markets infrastructure business, sitting at the heart of the world’s financial community. We provide valuable services for a wide range of customers, focusing on Intellectual Property, Risk and Balance Sheet Management and Capital Formation.
UnaVista is a software and data solutions business, offering global sell-side and buy-side clients a wide variety of products to assist with operational risk and trade processing (e.g. reconciliations, data solutions, regulatory reporting and trade confirmation services). You will be responsible for support and maintenance of the UnaVista’s operational application architecture resolving issues reactively as well as implementing proactive solutions to prevent reoccurrence of issues.
Candidate Profile / Key Skills
Availability to work in shifts (9PM – 6PM , 5PM – 1AM , 1AM – 9AM)
Good financial services industry experience with post trade knowledge, ideally in regulatory reporting
Demonstrate strong intellect, coupled with strategic thinking and analytical skills.
A proven technologist from a hands-on IT background, with strong technical understanding, appreciation of modern systems architecture, security and high availability.
Very strong knowledge of SQL (ideally Microsoft SQL Server) is crucial ideally with experience working with very large databases
Good knowledge of Windows server system administration, clustering and related technology operations tasks
Understanding and experience of incident & problem management
Understanding and experience of application and infrastructure monitoring
Good written and verbal communication skills with ability to clearly document technical work
Flexible, team player, “get-it-done” personality
Ability to organise and plan work independently
Ability to work in a rapidly changing environment
Ability to multi-task and context-switch effectively between different activities and teams
Bachelor Degree or equivalent experience.
Monitor Production systems for potential issues
Dealing with live service issues (P1 incidents) and helping to restore service as quickly as possible
Troubleshooting UnaVista systems using SQL and where required Windows server skills
Resolve performance and capacity issues using advanced SQL skills
Refine and automate regular processes, track issues, and document changes
Ensure proper recording, documentation and closure of issues
Manage several maintenance and operational tasks such as patching, cluster failovers and DR testing
Handle disk expansions and liaise with internal technical resources
Backup management and monitoring
Handle and maintain the UnaVista event monitoring tool
Contribute to the Incident & Problem Management process
Work with Development, Professional Services, QA and Solution Architects to ensure that business solutions are delivered to plan and customers are satisfied
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 are 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:
Pillar 3 Supplemental Pension;
25 days’ holiday a year;
Private medical insurance;
Group life insurance policy;
Share Purchase Plan;