Database Developer
Morgan Stanley
full-time
Posted on:
Location Type: Hybrid
Location: Montreal • Canada
Visit company websiteExplore more
Tech Stack
About the role
- Design and implement logical and physical data models to support business requirements
- Develop, optimize, and maintain database schemas, tables, views, and stored procedures
- Collaborate with stakeholders to gather and analyze data requirements
- Ensure database performance through query optimization and indexing strategies
- Implement and maintain ETL processes for data integration and transformation
- Perform data profiling, cleansing, and validation to ensure data quality
- Monitor and troubleshoot database performance, availability, and security
- Work with development teams to integrate databases with applications
- Document database designs, data dictionaries, and processes
Requirements
- 5+ years of strong hands-on work experience with relational databases (e.g., DB2, PostgreSQL)
- Proficiency in SQL and database programming (e.g., stored procedures, triggers)
- Expertise in data modelling tools (e.g., ERwin, PowerDesigner, or similar)
- Knowledge of ETL tools (e.g., Informatica, Talend, SSIS) is preferrable
- Strong understanding of normalization, de-normalization, and database design principles
- Experience with performance tuning and query optimization
- Knowledge of data warehousing concepts and star schema design
- Understanding and implementing job schedules, dependencies, and workflows (e.g. Autosys)
- Excellent problem-solving and communication skills
Benefits
- Comprehensive employee benefits and perks
- Flexible work arrangements
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
relational databasesSQLstored procedurestriggersdata modelingETLperformance tuningquery optimizationdata warehousingstar schema design
Soft Skills
problem-solvingcommunication