Senior SQL Developer

About this role

Summary

Join Aperia Solutions, a leader in SaaS solutions for the Payments and Compliance industries. Aperia is a Texas-based fintech and managed consultancy firm that creates custom SaaS applications and other software-based solutions for the payments, banking, and processing industry. Founded in 1999, Aperia offers business intelligence, risk management, compliance, and customer intelligence platforms. With offices in Dallas, Washington DC, and Vietnam, Aperia is a fast-paced, global organization that strives to improve efficiency in compliance, risk, and customer service operations. Aperia’s clients include banks, processors, payment facilitators, merchant service providers, independent sales organizations, and government entities. A career at Aperia promises a great challenge, culture, and opportunities to forge your own path.

Job Description

Aperia offers a competitive salary package and a great work environment. We have an immediate need for a Senior SQL Developer to join our team. The SQL team is responsible for not only database applications and procedures but also analysis and application development.

Core Responsibilities

• Designs, builds and implements relational databases

• Tests databases for performance, fine-tuning when necessary

• Completes documentation on all assigned systems and databases, including business rules, logic,and processes

• Tests documents and implements developed programs

• Works closely with other members of the BA, DBA and IS teams, sharing knowledge and makingrecommendations as needed

Requirements

• At least 5 years’ experience with Extraction, Transformation and Loading (ETL) process using DTS/SSIS application tools

• Good Transact-SQL (advanced queries, complex joins and indexes)

• Advanced knowledge of DTS/SSIS and Data Extraction and Transformations

• Ability to write, debug and test stored procedures, functions, triggers

• Ability to optimize stored procedures written by others

• Ability to troubleshoot database performance issues

• Experience in Azure Data Factory (preferred)

Education or Certifications

• Bachelor's degree in Computer Science, Information Technology, or a related field.

Job Type

• Full-Time

Schedule

• Monday to Friday

Work Location

• Ho Chi Minh City: The Six8 Building - 24-26 Phan Dinh…