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.

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.