Senior Support Engineer

Senior Support Engineer (3rd Line Support)

Location: Fort Mill, SC - Hybrid, 3 days a week onsite Shift: 11am – 7pm, flexibility required

Interview process: 5 rounds

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.

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.