SQL Database Engineer
Role details
Job location
Tech stack
Job description
-
Develop and maintain SSRS reports using SQL Server Reporting Services and SQL Server database objects.
-
Design, develop, and maintain SSIS packages for data integration and ETL processes.
-
Develop and support data warehouse solutions using SQL Server technologies, including T-SQL, stored procedures, and CTEs.
-
Investigate and support new technology initiatives aimed at improving or enhancing current database capabilities.
-
Monitor and improve the performance of SSRS reports and database processes.
-
Maintain and manage programming source code using GitHub.
-
Use Jira or Azure DevOps (ADO) to manage projects, tasks, and issues assigned to the Data Team.
-
Execute unit testing and QA testing, including writing and maintaining test scripts and test cases.
-
Collaborate with database engineers, front-end developers, and customer support teams as needed.
-
Provide support and troubleshooting in case of critical software or database issues.
-
Create and maintain technical documentation and standard operating procedures (SOPs).
-
Continuously learn and apply new programming techniques and database technologies as needed.
Requirements
We are looking for a collaborative team player who can support critical priorities and take ownership of the following responsibilities.
Requirements
-
5+ years of experience in designing, developing, and maintaining complex database solutions.
-
Hands-on experience in developing and maintaining SSRS reports using SSRS and SQL Server database objects.
-
Experience in developing and maintaining SSIS packages using SSIS and SQL Server database objects.
-
Proven ability to develop and maintain a data warehouse using SQL Server technologies, including T-SQL, stored procedures, CTEs, etc.
-
Ability to investigate and support new technology initiatives to enhance current database capabilities.
-
Strong skills in improving SSRS reports and optimizing database process performance.
-
Experience in version control and maintaining all programming source code using GitHub.
-
Proficient in using JIRA or Azure DevOps (ADO) for managing projects, tasks, and issues assigned to the data team.
-
Excellent communication skills, capable of interacting with a wide range of clients, from technical to non-technical, and from management to clerical staff.
-
Experience in executing unit and QA testing, including writing test scripts and test cases.
-
Willingness and ability to learn new programming techniques as required.
-
Collaborative experience working with other database personnel, front-end developers, and customer support teams.
-
Availability to address critical software issues as needed.
-
Ability to write clear documentation and standard operating procedures (SOPs) for future use.