No more applications are being accepted for this job
- 5-8 years of database design administration and data modelling with strong focus in all versions of SQL Server on both on premise and Azure cloud environments
- Excellent knowledge of T-SQL with minimum of 4+ years of experience
- Experience in writing Stored Procedures / Functions.
- Experience with Snowflake and analytical pipeline is valuable
- Experience with SSIS, SSAS and Good knowledge of DevOps
- Knowledge of programming language such as C# and/or understanding of the various application layers
- Knowledge of data warehousing is desirable, including ETL/ELT patterns
- Highly numerate, detail-oriented, and able to use complex data sets
- Experience applying DevOps practices, automated deployment and testing is desirable
- Possess a comprehensive knowledge of various database design techniques
- Provide database solutions for basic to complex projects.
- Perform DBA tasks (Indexing, Query Tuning, Manage Database security, etc.).
- Design, optimize and maintain database to meet business requirements
- Write stored procedure, functions and views to support application requirements
- SQL coding, debugging, and optimization on regular basis.
- Design data warehouse ETL patterns as well as implement the pipeline to data transformation.
- Design test cases to perform QA testing on applications being implemented.
- Write technical documents outlining the database set up as well as business requirements supported by the database design.
- Work with team to troubleshoot complex technical issues or business situations that involve critical database processes and hinder the achievement of service level requirements.
- Strong analytical and critical thinking skills.
- Able to understand the impact of decisions on other disciplines.
- Excellent written and verbal communication skills.
- Excellent organizational skills and attention to details
- A proactive, "service-first" attitude combined with ability to work independently on projects with tight deadlines and minimal supervision.
Database Engineer - Mississauga, Canada - SA Technologies
Description
Position: Database Engineer
Reporting To: Senior Director, Technology & Integration
Location : Mississauga, ON
The Ideal Candidate
Responsibilities
Soft Skills