SQL Developer Azure Data Factory

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

We are seeking a highly skilled and motivated SQL Developer to join our team in Ho Chi Minh City, Vietnam. This role offers an exciting opportunity to work with cutting-edge database technologies in a dynamic and collaborative environment, where you will design, build, and optimize relational databases, ensure high performance and reliability, and collaborate with cross-functional teams to deliver efficient data solutions.

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

Job Type

• Full-Time

Schedule

• Monday to Friday

Work Location

• The Six8 Building, 24-26 Phan Dinh Giot, 2 Ward, Tan Binh District, Ho Chi Minh City.
• VDB Tower, 74 Quang Trung, Hai Chau, Da Nang.
  

Requirements

• Strong experience in Azure Data Factory
• At least 3+ years of SQL Server Integration Services
• At least 3+ 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 use critical thinking to solve issues that arise
• Ability to troubleshoot database performance issues
• Fluent use of C# programming language (Console Applications)

Education or Certifications

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

• Highly competitive salary
• Full salary for probation & full coverage of social insurance.
• Premium healthcare for you and your beloved one.
• Monthly childcare support
• 13th-month salary.
• Annual Leave: 15 days; Paternity Leave: 6 weeks, Bereavement leave: 10 days.
• Flexible working time, focus on output (no checking time attendance)
• Various active sporty clubs: Football, Billiards, Badminton, E-sport clubs
• Frequent opportunities to travel to US headquarter from 3-6 months.