database analyst (DBA)

Location

North York, ON | Canada

Job description

Overview

Languages

English

Education

• Bachelor's degree

Experience

3 years to less than 5 years

Asset languages

• Mandarin

Work setting

• Consulting firm
• Information technology (IT) service provider

Responsibilities

Tasks

• Collect and document user's requirements
• Design and develop database
• Design, construct, modify, implement and test data models and database management systems
• Conduct research and provide advice to other informatics professionals regarding the selection application and implementation of database management tools
• Operate database management systems to analyze data
• Conduct research and provide advice to other information systems professionals regarding the collection, availability and suitability of data
• Write scripts related to stored procedures and triggers
• Design, develop and implement information systems business solutions

Experience and specialization

Computer and technology knowledge

• Microsoft Visual Studio
• Shell script
• Data Warehouse
• Linux
• Unix
• Erwin
• Informix
• MS Access
• MS SQL Server
• Networking software
• Networking security
• Intranet
• Internet
• Servers
• Desktop applications
• Security software
• MySQL
• Oracle
• Word processing software
• Mail server software
• Project management software
• HTML editing software
• Database software
• Programming languages
• Software development
• Data analysis software
• MS Office
• MS Windows
• Spreadsheet
• C
• HTML
• Python
• SQL
• Visual Basic
• Unix Shell Scripting
• Business intelligence

Additional information

Work conditions and physical capabilities

• Fast-paced environment
• Work under pressure
• Tight deadlines

Personal suitability

• Accurate
• Client focus
• Efficient interpersonal skills
• Excellent oral communication
• Excellent written communication
• Initiative
• Judgement
• Organized
• Team player
• Adaptability
• Accountability
• Quick learner

Job tags

Salary

$57k per year