The Role
Provides database-level and Level 2 application support for financial transaction processing. Monitors payments, settlements, reconciliations, scheduled jobs, ETL processes, and batch executions; validates data, resolves exceptions, performs approved corrections, and investigates discrepancies. Develops and optimizes SQL queries, stored procedures, functions, and views; analyzes datasets, supports deployments and migrations, conducts root cause analysis, maintains documentation, and assists with testing, incident management, and audit controls.
Summary Generated by Built In
The ideal candidate will possess strong Microsoft SQL Server skills, a solid understanding of data validation and transaction processing workflows, and basic knowledge of .NET applications. This role is responsible for ensuring the accuracy, integrity, and successful execution of financial transaction processes while providing database-level support to internal stakeholders and business operations teams.
What will you do:
- Monitor and support daily transaction processing activities, including payment processing, settlements, and reconciliation workflows.
- Validate transaction data before and after processing to ensure accuracy and completeness.
- Investigate and resolve transaction failures, exceptions, and data discrepancies.
- Execute database scripts and perform data corrections in accordance with approved procedures.
- Monitor scheduled jobs, stored procedures, ETL processes, and batch executions.
- Support end-of-day and periodic transaction processing activities.
- Develop, modify, and optimize SQL queries, stored procedures, functions, and views.
- Perform data extraction, transformation, validation, and reporting activities.
- Analyze large datasets to identify anomalies, inconsistencies, and processing issues.
- Conduct root cause analysis for transaction and application-related database issues.
- Support database deployments, releases, and data migration activities.
- Maintain database documentation, process logs, and support records.
- Work closely with Development, Product, Operations, and Business teams to resolve production issues.
- Assist in troubleshooting application issues by analyzing logs, SQL queries, and database performance.
- Provide Level 2 support for transaction-processing applications.
- Participate in incident management and problem-resolution activities.
- Support system testing and validation during application releases.
- Ensure data accuracy and integrity across transaction systems.
- Follow established controls and audit requirements for financial transaction processing.
- Maintain proper documentation for production fixes, database changes, and operational procedures.
Requirements
What we expect you to possess:
- Strong experience with Microsoft SQL Server (MSSQL).
- Excellent SQL query-writing and troubleshooting skills.
- Strong understanding of:
- Joins, Subqueries, CTEs
- Stored Procedures
- Functions
- Views
- Triggers
- Indexes
- Query Optimization
- Experience in data validation, reconciliation, and troubleshooting.
- Ability to analyze large datasets and identify data inconsistencies.
- Basic understanding of application architecture and database interactions.
Skills Required
- Strong experience with Microsoft SQL Server (MSSQL)
- Excellent SQL query-writing and troubleshooting skills
- Understanding of joins, subqueries, and common table expressions (CTEs)
- Understanding of stored procedures
- Understanding of functions
- Understanding of views
- Understanding of triggers
- Understanding of indexes
- Understanding of query optimization
- Experience in data validation, reconciliation, and troubleshooting
- Ability to analyze large datasets and identify data inconsistencies
- Basic understanding of application architecture and database interactions
Similar Jobs
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
TekFriday is a nascent technology solution company founded last year by individuals who have a collated total of 50 years' experience delivering quality products and services in the Alternative Financial Services domain The company, having footprints in both Miami, FL and Hyderabad, India is founded by professionals in the Short-Terms loan industry. TekFriday is, a dynamic and young company, on an aggressive growth path to expand from its core team of 200+ people having a diverse skills, backgrounds but united in its goal to put a mark on the Alternative Financial Services domain and be the best. TekFriday is building solutions which are geared towards being industry leaders and pioneering ground-breaking solutions to the Short-Term Loan Industry in North America
