SQL Server Developer / Application Support Engineer

About the role

We are seeking a highly analytical and detail-oriented SQL Server Developer / Application Support Engineer to support and maintain mission-critical transaction processing systems. This role is primarily focused on Microsoft SQL Server development, data analysis, troubleshooting, and production support, with additional responsibilities involving .NET application development and maintenance.

Responsibilities

• Develop, maintain, and optimize Microsoft SQL Server databases, stored procedures, views, triggers, and queries.
• Analyze and troubleshoot data discrepancies between internal systems and third-party data sources.
• Perform root cause analysis for missing, duplicate, or mismatched transaction records.
• Design and implement database solutions that support high-volume transaction processing environments.
• Monitor database performance and recommend improvements to ensure reliability and scalability.
• Support data auditing, reconciliation, and exception management processes.
• Develop and maintain applications and services using C#, .NET Framework/.NET Core, and Microsoft Visual Studio.
• Support and troubleshoot Windows Services and backend application processes.
• Implement software enhancements and bug fixes following established development standards and best practices.
• Participate in code reviews and maintain technical documentation.
• Support end-to-end financial transaction processing workflows, including:
• Card authorization and card swipe processing
• Transaction validation and customer/site resolution
• Settlement and invoicing processes
• Investigate transaction exceptions and system anomalies.
• Ensure compliance with PCI standards and security best practices.
• Provide production support for 24/7 operational environments.
• Collaborate with business stakeholders, operations teams, and external partners to resolve issues and improve processes.

Qualifications

• Advanced experience with Microsoft SQL Server, including: Database design and architecture Query optimization and performance tuning.
• Experience with Microsoft Visual Studio.
• Strong programming skills in C# and .NET Framework/.NET Core.
• Experience developing and supporting Windows Services.
• Knowledge of object-oriented programming principles and software development best practices.
• Experience supporting high-volume transaction processing systems.
• Understanding of financial transaction lifecycle and processing workflows.
• Knowledge of card authorization, transaction processing, settlement, and invoicing.
• Experience with exception handling and data reconciliation processes.
• Familiarity with PCI Compliance standards and security requirements.
• Knowledge of fleet management and fuel card operations is highly desirable.

Professional Skills

• Strong analytical, auditing, debugging, and problem-solving abilities.
• Excellent attention to detail and accuracy.
• Ability to work independently and within cross-functional teams.
• Strong written and verbal communication skills.
• Technical documentation and technical writing experience.

Education and/or Experience

• Bachelor's degree in Computer Science, Information Systems, Engineering, or related field (or equivalent work experience).
• 5+ years of experience in SQL Server development, database support, or application support roles.
• Experience working within financial transaction processing, payment systems, fleet management, or related industries preferred.