Cake Job Search

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.