Close X

Database Administrator

Montreal - 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.