Aperia Solutions Vietnam ★ 4.0

3 Lý do để gia nhập công ty

• Premium Healthcare program for you and your family
• Monthly childcare support, Paternity Leave
• Frequent US working opportunities

Mô tả công việc

At Aperia, we rely on a dynamic database team. 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. The ideal candidate has experience in SQL development, SSRS, SSIS, ETL, Power BI, and Azure Data Factory.

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 offshore development teams and reports.
• Completes documentation on all assigned systems and databases, including business rules, logic, processes

Functional Responsibilities

• Implement a viable system that can survive and adapt changes demonstrated through delivered projects.
• Ability to use critical thinking to solve issues that arise.
• Ability to troubleshoot database performance issues.
• Ability to deliver successfully tasks and projects independently and be a consultant for others.
• 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.

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

Technical Skills

• Good English communication (verbal & written)
• 3+ years’ experience with Extraction, Transformation, Loading (ETL) process using DTS/SSIS application tools.
• 3+ years’ experience with MS SQL Server 2008/2012/2017 including SQL Server Management, Integration Services, Analysis Services, and Reporting Services.
• Hands on experience with Power BI, Azure Data Factory, Azure Pipelines.
• 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 MSSQL Server database design, 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.

Education or Certifications

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

Tại sao bạn sẽ yêu thích làm việc tại đây

• Highly competitive salary (plus attractive monthly project bonus)
• Full salary for probation & full coverage of social insurance.
• Premium healthcare for you and your beloved one.
• Monthly childcare support
• 13th-month salary.
• Premium package at top Gym service provider.
• 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.