Senior Software Engineer (3rd line support)

Job Title: Senior Software Engineer (3rd line support)

Contract Length: 6 months

Location: Fort Mill, SC - Hybrid, 3 days a week onsite

Shift: 11am 7pm, flexibility required

Interview process: 5 rounds (please note this is mandated for all jobs at LSEG in the engineering division, there is not an opportunity for a shorter interview cycle, so ensure expectations of a long interview cycle are set with candidates upfront. They MUST be willing to do a Codility assessment to be submitted to this role.)

1. Codility assessment
2. Technical interview
3. Technical/Behavioral with hiring manager
4. Interview with principal
5. Interview with Senior Leadership

Absolute Must Have Role Requirements:

• 8-10 years of experience required C # and .net and backend SQL
• 8-10+ years of solid experience in database application support across multiple databases (SQL Server, Sybase, PostgreSQL).

Role Requirements:

• Extensive experience providing 3rd line support, including diagnosing, solving, and resolving complex technical issues related to database systems and integrations, ensuring high availability and performance.
• Prior experience working in data-intensive applications, demonstrating a capacity to handle, analyze, and optimize large datasets and complex database structures.
• Solid experience in debugging sophisticated SQL queries, stored procedures, triggers, scripts, cursors, and views, with a focus on SQL code tuning, consolidating views, and supervising database performance metrics.
• Solid experience in C#.NET, showcasing proficiency in programming and application development within .NET frameworks to support database operations and integrations.
• Familiarity with PostgreSQL Aurora, queues, elastic search, indicating a broad understanding of database technologies and the ability to use these tools for improved data processing and search capabilities.
• Good experience with cloud services (AWS or Azure preferred), demonstrating a capability to use cloud-based resources and services for database hosting, scaling, and management.
• Some experience in Business and Technical Analysis, Quality Assurance, Delivery Management, and/or Emerging Technology and Governance, reflecting well-rounded abilities that support project management, quality assurance practices, and the exploration of new technologies.
• Strong verbal and written communication skills, essential for effective collaboration with internal and external collaborators, clear documentation, and the ability to convey complex technical information to non-technical audiences.

Preferred Requirements:

• Application support background

Key Functions and Responsibilities

• As a Senior Support Engineer specializing in SQL within FTSE Engineering, the individual will be expected to lead and supervise day to day activities surrounding production support of critical systems. The candidate must be an authority in diagnosing, solving, and resolving complex technical issues that advance beyond first and second-line support, ensuring the stability and reliability of our production systems.
• The ideal candidate will collaborate with other technology teams and business users to deeply understand the complex user journeys, workflows, and data interactions involved in the Index business lifecycle. This understanding is crucial for effectively addressing and resolving high-level technical support issues.
• This role works with the FTSE Engineering 3rd Line Support Manager and will require close collaboration with both internal and external index business collaborators, including Full Stack Developers, Product Owners, Business Analysts, and technology teams. The Senior Support Engineer will also work directly with users and technical teams to manage, diagnose, and resolve technical issues within our key Index Platforms, which embrace innovative technologies and AWS cloud-native architecture.
• We are looking for an enthusiastic and hard-working software engineer who is adept in , long-term fixes for database applications across multiple databases (SQL Server, Sybase, PostgreSQL) and possesses solid experience in providing 3rd line support, including incident management, and collaborating closely with business collaborators.