DBA (database administrator)

Overview

Languages

English

Education

• College/CEGEP
• or equivalent experience

Experience

Will train

On site

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

Work setting

• Private company, corporation or industry

Responsibilities

Tasks

• Collect data to identify areas for improvement within an organization’s IT infrastructure
• 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
• Develop and implement data administration policy, standards and models
• Research and document data requirements, data collection and administration policy, and data access rules
• Develop policies and procedures for network access and usage and for the backup and recovery of data
• Write scripts related to stored procedures and triggers

Experience and specialization

Computer and technology knowledge

• MS SQL Server
• MySQL
• Oracle
• SQL

Additional information

Work conditions and physical capabilities

• Handling heavy loads
• Attention to detail
• Sitting

Personal suitability

• Accurate
• Efficient interpersonal skills
• Excellent oral communication
• Excellent written communication
• Initiative
• Organized
• Team player
• Quick learner