Database Developer (SQL, SSIS, English)

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.