SQL Server Developer / Application Support Engineer
Role details
Job location
Tech stack
Job description
Database Development & Support 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.
Application Development & Maintenance:
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.
Transaction Processing & Operations Support:
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.
Requirements
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. The ideal candidate will have strong database expertise, experience working with financial transaction systems, and the ability to identify, investigate, and resolve complex data discrepancies., 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.
Functional Knowledge:
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.
Language Skills: Possess excellent communications and customer service skills. Ability to read and comprehend simple instructions, short correspondence, and memos. Ability to write simple correspondence. Ability to effectively present information in one-on-one and small group situations to customers, clients, and other employees of the organization.
Mathematical Skills: Ability to add, subtract, multiply, and divide in all units of measure, using whole numbers, common fractions, and decimals. Ability to compute rate, ratio, and percent and to draw and interpret bar graphs.
Reasoning Ability: Ability to apply common sense understanding to carry out detailed but uninvolved written or oral instructions. Ability to deal with problems involving a few concrete variables in standardized situations.
Computer Skills: Experience with Python for scripting, automation, and data analysis.
Experience working in enterprise production environments with 24/7 support requirements.
Experience integrating with third-party data providers and external transaction systems.
Certificates, Licenses, Registrations: None Required.
Competencies: To perform the job successfully, an individual should demonstrate the following behaviors:
Quality: Consistently produces high quality work (accurate, neat, and thorough). Strives to improve productivity, processes and quality. Demonstrates strong knowledge and skills related to the job. Presents a professional image with dress, demeanor, and manners. Maintains clean workspace, company equipment and company vehicles. Safety is a high priority; performs job safely.
Communication: Communicates clearly, concisely, effectively, professionally and timely. Exhibits good listening and comprehension skills. Keeps others appropriately informed and shares ideas even when unpopular. Listens to what others have to say. Maintains open and active communication with colleagues. Effectively uses knowledge and experience in asking, probing, and anticipating issues to ensure quality is provided.
Teamwork: Fosters the spirit of working with each other. Displays respect, courtesy, politeness, tact, and openness. Handles conflict in an appropriate and professional manner. Builds relationships, promotes cohesiveness, models collaboration with others. Considers impact and issues for our customer and other departments. Engages other impacted departments early for solutions.
Persistence: Develops workable alternatives and solutions. Exhibits persistence in following assignments through to completion. Promotes process improvements.
Reliable: Responds in a timely manner. Is honest, ethical, value-driven and trustworthy. Keeps commitments made, completes assignments and meets deadlines. Accountable--Takes responsibility for own actions and performance. Meets attendance and punctuality guidelines. Available and accessible.
Entrepreneurial: Takes initiative and appropriate action. Is engaged and committed to achieving the company's mission. Pursues better ways to get things done and takes appropriate risks. Keeps up to date with competitor information and market trends. Controls costs and thinks in terms of profit, loss and added value. Is committed to the satisfaction of customers.
Leadership: Provides clear direction around a vision. Creates actionable plans and is proactive & anticipatory. Demonstrates innovative approaches and solutions. Is an example for employees and others. Accepts responsibility for individual and team performance. Makes appropriate and timely decisions and takes action on decisions. Sets clear and reasonable performance expectations. Motivates and empowers others. Delegates tasks appropriately. Recruits high caliber staff. Provides feedback to subordinates that is timely and direct. Recognizes subordinates for their contributions and effort. Encourages continuous growth and learning in others. Shows respect for others and their ideas. Helps others manage through change.