![Công Ty TNHH Aperia Solutions (Việt Nam)](https://i-vn.joboko.com/images/logo/201804/cong_ty_tnhh_aperia_solutions_viet_nam.jpg)
Database Developer
Công Ty TNHH Aperia Solutions (Việt Nam)
Địa điểm làm việc: Hồ Chí Minh, Đà Nẵng
Hết hạn: 29/08/2024
- Chi tiết công việc
- Giới thiệu công ty
Vị trí công việc này hiện tại đã hết hạn nộp hồ sơ, bạn có thể tham khảo thêm một số công việc liên quan phía dưới
Mô tả công việc
Top 3 Reasons To Join Us
Premium Healthcare program for you and your family
Monthly childcare support, Paternity Leave
Frequent US working opportunities
The Job
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
Designs, builds and implements relational databases.
Reviews T-SQL code and performances optimization.
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.
Works with onshore development teams and report.
Completes documentation on all assigned systems and databases, including business rules, logic, and processes.
Functional Responsibilities
Implement a viable system that can survive and adapt changes demonstrated through delivered projects.
Ability to troubleshoot database performance issues.
Ability to deliver successfully tasks and projects independently.
Ability to do performance tuning: query optimization (avoid coding loop and correlated subqueries), applying indexes and partition functions.
Ability to write, debug and test stored procedures, functions, triggers.
Your Skills and Experience
Technical Skills
3+ years' experience with Extraction, Transformation and Loading (ETL) process using SSIS application tools.
3+ years' experience with MS SQL Server 20[protected info] including SQL Server Management, Integration Services, Analysis Services, and Reporting Services.
Hands-on experienced in data modeling in all phases (conceptual, logical, and physical).
Hands-on experienced in Transact-SQL (advanced queries, complex joins, indexes, pagination in SQL Server, TRY-CATCH blocks, CASE & PIVOT, etc.).
Hands-on experienced in MS SQL Server database design and coding techniques work with NoSQL datatype (JSON).
Advanced knowledge of SSIS and Data Extraction and Transformations.
Hands-on experienced in performing database unit tests to ensure code quality using SSDT.
Things that will separate you from the rest
Practical knowledge of API and Web development.
Well grasp of how to connect different applications and systems together demonstrated through delivered projects.
Knowledge of Azure Data Factory.
Education or Certifications
Bachelor's degree in Computer Science, Computer Information Systems or equivalent.
Why You'll Love Working Here
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.
Premium Healthcare program for you and your family
Monthly childcare support, Paternity Leave
Frequent US working opportunities
The Job
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
Designs, builds and implements relational databases.
Reviews T-SQL code and performances optimization.
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.
Works with onshore development teams and report.
Completes documentation on all assigned systems and databases, including business rules, logic, and processes.
Functional Responsibilities
Implement a viable system that can survive and adapt changes demonstrated through delivered projects.
Ability to troubleshoot database performance issues.
Ability to deliver successfully tasks and projects independently.
Ability to do performance tuning: query optimization (avoid coding loop and correlated subqueries), applying indexes and partition functions.
Ability to write, debug and test stored procedures, functions, triggers.
Your Skills and Experience
Technical Skills
3+ years' experience with Extraction, Transformation and Loading (ETL) process using SSIS application tools.
3+ years' experience with MS SQL Server 20[protected info] including SQL Server Management, Integration Services, Analysis Services, and Reporting Services.
Hands-on experienced in data modeling in all phases (conceptual, logical, and physical).
Hands-on experienced in Transact-SQL (advanced queries, complex joins, indexes, pagination in SQL Server, TRY-CATCH blocks, CASE & PIVOT, etc.).
Hands-on experienced in MS SQL Server database design and coding techniques work with NoSQL datatype (JSON).
Advanced knowledge of SSIS and Data Extraction and Transformations.
Hands-on experienced in performing database unit tests to ensure code quality using SSDT.
Things that will separate you from the rest
Practical knowledge of API and Web development.
Well grasp of how to connect different applications and systems together demonstrated through delivered projects.
Knowledge of Azure Data Factory.
Education or Certifications
Bachelor's degree in Computer Science, Computer Information Systems or equivalent.
Why You'll Love Working Here
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.
Yêu cầu công việc
SQL, English, Azure
Quyền lợi được hưởng
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.
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.
Thông tin chung
- Ngày hết hạn: 29/08/2024
- Mức lương: Thỏa thuận
Giới thiệu công ty
Xem trang công ty
Join Aperia Solutions, a leader in SaaS solutions for the Payments and Compliance industries. Aperia has been developing and hosting complex, data intensive business applications for more than a decade. The company's management team has extensive experience in finance, data security, compliance,...
Quy mô công ty
Từ 101 - 500 nhân viên
Việc làm tương tự
Công ty Cổ phần Tập đoàn Sen Tài Thu
10 Triệu - 15 Triệu VNĐ + KPI
13/09/2024
Hồ Chí Minh
Công ty TNHH Dịch Vụ Công Nghệ Giao DỊch
You'll love it
09/10/2024
Hồ Chí Minh
Vina Daewoo Information Systems Co., Ltd
You'll love it
30/09/2024
Hồ Chí Minh, Điện Biên
Công ty Cổ phần Giải pháp Chuyên gia Star Global
Lương thỏa thuận
10/09/2024
Hồ Chí Minh
hỗ trợ doanh nghiệp
Giải thưởng
của chúng tôi
Top 3
Nền tảng số tiêu biểu của Bộ
TT&TT 2022.
Top 15
Startup Việt xuất sắc 2019 do VNExpress tổ chức.
Top 10
Doanh nghiệp khởi nghiệp sáng tạo Việt Nam - Hội đồng tư vấn kinh doanh ASEAN bình chọn.
Giải Đồng
Sản phẩm công nghệ số Make In Viet Nam 2023.