We are looking for an Application Support Engineer to join a high-performing team in Newport Beach, California, supporting critical transaction-based systems within a fast-paced operational environment. This position combines hands-on database development, production support, and application maintenance, with a strong emphasis on solving data issues and improving system reliability. The ideal candidate brings deep experience with Microsoft SQL Server, solid C# and .NET development skills, and the ability to investigate complex processing exceptions with precision and urgency.
Responsibilities:
• Build, enhance, and maintain SQL Server database objects such as stored procedures, views, triggers, and complex queries to support business-critical applications.
• Investigate data inconsistencies across internal platforms and external sources, identifying root causes for missing, duplicated, or inaccurate transaction records.
• Create and refine database solutions designed to handle large transaction volumes while improving performance, scalability, and system stability.
• Provide ongoing support for backend applications and Windows Services, resolving production issues and restoring service in a timely manner.
• Develop application updates and defect corrections using C#, .NET Framework or .NET Core, and Visual Studio in alignment with established coding practices.
• Monitor transaction processing workflows, including authorization, validation, settlement, and invoicing activities, to ensure smooth end-to-end operations.
• Perform auditing, reconciliation, and exception management tasks to strengthen data integrity and operational accuracy.
• Partner with business teams, operations personnel, and external contacts to troubleshoot issues, resolve incidents, and recommend process improvements.
• Contribute to code reviews and maintain clear technical documentation to support long-term application support and knowledge sharing.
• Support secure and reliable 24/7 production operations by following organizational standards and established support procedures.• 5+ years of experience in application support, database development, or a similar technical support engineering role.
• Advanced proficiency with Microsoft SQL Server, including database design, query tuning, performance optimization, and architecture best practices.
• Strong programming experience with C# and .NET Framework or .NET Core for application enhancement and maintenance.
• Hands-on experience using Microsoft Visual Studio in a software development environment.
• Practical knowledge of supporting Windows Services and backend processing applications.
• Ability to analyze transaction data, investigate discrepancies, and resolve complex production issues with a high level of accuracy.
• Familiarity with object-oriented programming concepts and disciplined software development practices.
• Exposure to technologies such as Active Directory, Cisco environments, Dell systems, or related infrastructure support tools is beneficial.