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
At Aperia, we rely on a dynamic team of software developers. We’re seeking a Database Developer who is ready to work with new technologies and architectures in a forward- thinking organization that’s always pushing boundaries. This person will have SQL development background and SSIS/ETL development experience.
Core Responsibilities

Reviews T- SQL code and performances optimization.
Works with onshore development teams and report.
Completes documentation on all assigned systems and databases, including business rules, logic, and processes.
Designs, builds and implements relational databases.
Works closely with other members of the business analyst, database administrator and software development, and database development teams, sharing knowledge and making recommendations as needed.

Functional Responsibilities

Ability to do performance tuning: query optimization (avoid coding loop and correlated subqueries), applying indexes and partition functions.
Implement a viable system that can survive and adapt changes demonstrated through delivered projects.
Ability to troubleshoot database performance issues.
Ability to write, debug and test stored procedures, functions, triggers.
Ability to deliver successfully tasks and projects independently.

Yêu cầu công việc

Technical Skills

3+ years’ experience with MS SQL Server 2008/2012/2017 including SQL Server Management, Integration Services, Analysis Services, and Reporting Services.
Hands- on experienced in MS SQL Server database design and coding techniques work with NoSQL datatype (JSON).
Hands- on experienced in Transact- SQL (advanced queries, complex joins, indexes, pagination in SQL Server, TRY- CATCH blocks, CASE & PIVOT, etc.).
3+ years’ experience with Extraction, Transformation and Loading (ETL) process using SSIS application tools.
Hands- on experienced in performing database unit tests to ensure code quality using SSDT.
Hands- on experienced in data modeling in all phases (conceptual, logical, and physical).
Advanced knowledge of SSIS and Data Extraction and Transformations.

Things that will separate you from the rest

Practical knowledge of API and Web development.
Knowledge of Azure Data Factory.
Well grasp of how to connect different applications and systems together demonstrated through delivered projects.

Education or Certifications

Bachelor’s degree in Computer Science, Computer Information Systems or equivalent.

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

Cập nhật gần nhất lúc: 2024-08-07 17:55:03