Database Modeler / Modélisateur de base de données

LocationMontreal
Job CategoryInformation Technology
SP-ID25184
Position TypeContract
Application Deadline October 1, 2020
Experience Required5+ years
Job Duration1 year
Education RequiredBachelors

Job Description:
Top 3 skills:
• Analyze and provide database schema and data flow design for OLTP and OLAP data model
• Work with application owner, analyst and developers and oversee end to end solution implementation
• Strong experience ER data modeling tools and with SQL (design and profiling)
RESPONSIBILITIES
• Gather business requirement and translate into logical and physical data model design
• Reverse engineer current applications design and provide enhanced model and data flow architecture
• Design application relational model (OLTP), Star schema model (OLAP) and ETL documentation (STM)
• Work with application owner, analyst and developers and oversee end to end solution implementation
• Data profiling current RDBMS application and related system to assure model and data quality
• Work in a prototyping and development environment, test your solution with developers and produce database DDL for production
• Optimize design to prevent application bottlenecks and implement data archiving strategy
• Provide estimate, work breakdown structure (WBS) and progress status
• Conduct and create scenarios for functional and integration unit testing in different environment
• Post deployment application support, fix and enhancement to data model
REQUIREMENTS
• Strong experience with SQL language
• Strong experience with ER data modeling tool (ex: Erwin, Oracle Data Modeler, etc.)
• Experience with SQL server
• Experience with Git and Team Foundation
• Experience with Word, Excel and PowerPoint
• Experience in both data warehouse and OLTP databases architecture
• Communication skills and team collaboration
• At least 5 years of experience in data modeling
• Bachelor degree in computer science, engineering, or equivalent related project experience.
Other beneficial skills:
• Programming knowledge on ASP, VB.NET, C# and JAVA
 
 
resumes to:
r.jeon@maxsys.ca
 
*MST