Close X

Database Administrator

Montreal, Canada - Full-time - Senior

We are seeking a Database administrator with excellent problem-solving and communication skills

Your responsibility as a database administrator (DBA) will be the performance, integrity and security of a database. You'll be involved in the planning and development of the database, as well as in troubleshooting any issues on behalf of the users.

Responsibilities

Establish the needs of users and monitoring user access and security

Monitor performance and manage parameters in order to provide fast responses to front-end users

Map out the conceptual design for a planned database

Consider both back-end organization of data and front-end accessibility for end-users

Refine the logical design so that it can be translated into a specific data model

Further refining the physical design to meet system storage requirements

Install and test new versions of the database management system (DBMS)

Maintain data standards, including adherence to the Data Protection Act

Write database documentation, including data standards, procedures and definitions for the data dictionary (metadata)

Control access permissions and privileges

Develop, manage and test back-up and recovery plans

Ensure that storage and archiving procedures are functioning correctly

Carry out capacity planning

Work closely with IT project managers, architecture and developers

Communicate regularly with technical, applications and operational staff to ensure database integrity and security

Commission and install new applications and customize existing applications in order to make them fit for purpose

Minimum qualifications

Bachelor’s Degree in Computer Science or Computer Engineering

2+ years’ professional experience or internship

Advanced knowledge of database structure and theory

Experience with MySQL and NoSQL database type

Experience in large distributed databases in a cloud environment

Basic understanding of disaster recovery and database backup procedures

Preferred qualifications

Familiarity with reporting tools

Ability to work independently with minimal supervision and assistance

Skills and technologies

Problem-solving and good analytical skills

Communication and teamwork skills

Familiarity with the main data manipulation languages and the principles of database design

The ability to work to tight deadlines under pressure

Good organisational skills

Flexibility and adaptability

The ability to create and maintain strong working relationships with colleagues and customers

Business awareness and understanding of business requirements of IT

A willingness to keep up to date with developments in new technology

A commitment to continuing professional development (CPD)

An understanding of information legislation, such as the Data Protection Act.