database analyst

Additional Information

• Work Term: Permanent
• Work Language: English
• Hours: 35 hours per week
• Education: Bachelor's degree
• Experience: 3 years to less than 5 years

Work setting

• Consulting firm

Tasks

• Collect and document user's requirements
• Design and develop database
• Design, construct, modify, implement and test data models and database management systems
• Operate database management systems to analyze data
• Develop and implement data administration policy, standards and models
• Research and document data requirements, data collection and administration policy, and data access rules
• Lead and co-ordinate teams of data administrators in the development and implementation of data policies, standards and models
• Write scripts related to stored procedures and triggers

Supervision

• 5-10 people

Computer and technology knowledge

• Android
• Eclipse
• Microsoft Visual Studio
• Model-View-Controller (MVC)
• Shell script
• Data Warehouse
• MS SQL Server
• Desktop applications
• File management software
• MySQL
• Word processing software
• Presentation software
• Communication software
• Programming software
• HTML editing software
• Website creation and management software
• Web service design
• Business diagram software
• Mapping and data visualization software
• Database software
• Programming languages
• Software development
• MS Office
• MS Windows
• Spreadsheet
• .NET
• ADA
• ASP.NET
• Ajax
• Angular.js
• C#
• CSS
• Git
• HTML
• JQuery
• Java
• JavaScript
• Object-Oriented programming languages
• PHP
• Python
• React Native
• React.js
• SASS
• SQL
• Soap
• XML

Work conditions and physical capabilities

• Fast-paced environment
• Tight deadlines
• Repetitive tasks
• Handling heavy loads
• Physically demanding
• Manual dexterity
• Attention to detail
• Ability to distinguish between colours
• Sound discrimination
• Sitting
• Combination of sitting, standing, walking
• Standing for extended periods
• Bending, crouching, kneeling