database analyst (DBA)

Overview

Languages

English

Education

• Bachelor's degree

Experience

2 years to less than 3 years

On site

Work must be completed at the physical location. There is no option to work remotely.

Responsibilities

Tasks

• Collect data to identify areas for improvement within an organization’s IT infrastructure
• Data Science
• Develop and implement a strategic blueprint to follow when deploying databases within their organization
• Develop and maintain computer databases
• Document customers’ requirements for projects
• Document reporting needs, queries, logic, results and recommendations to other information systems professionals
• Enact measures to make sure unauthorized users cannot access the data
• Liaise with staff on data requirements, collection and availability
• Provide advice to other informatics professionals regarding database management tools
• Setup the IT infrastructure to allow applications to access databases
• Test data models and database management systems
• Design and develop database
• 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
• Write scripts related to stored procedures and triggers

Experience and specialization

Computer and technology knowledge

• Excel Visual Basic for Applications (VBA)
• Machine Learning
• Microsoft Visual Studio
• Data Warehouse
• Internet
• Desktop applications
• File management software
• Multimedia software
• Word processing software
• Presentation software
• Mail server software
• Communication software
• Programming software
• Mapping and data visualization software
• Database software
• Programming languages
• Enterprise resource planning (ERP) software
• Data analysis software
• MS Office
• MS Windows
• Spreadsheet
• Big data
• Python
• SQL
• Business intelligence
• Electronic mail

Area of specialization

• E-commerce

Additional information

Work conditions and physical capabilities

• Work under pressure
• Attention to detail
• Sitting

Personal suitability

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

Benefits

Health benefits

• Dental plan
• Disability benefits
• Health care plan
• Paramedical services coverage
• Vision care benefits

Financial benefits

• Bonus
• Life insurance

Other benefits

• Free parking available