Database Administrator

Yeah! Global; Vancouver; On-site; CAD 70,000 - 90,000; Full time

Job summary

A data-driven technology firm in Vancouver is seeking an experienced Database Administrator (DBA) to manage, optimize, and oversee database systems ensuring high performance, availability, and security. Ideal candidates will have a Bachelor's degree in Computer Science or related field, proven experience in database management, and proficiency in MySQL, PostgreSQL, Oracle, and MongoDB. Responsibilities include installing and configuring DBMS, ensuring data integrity, monitoring performance, and collaborating with developers on database solutions.

Qualifications

• Proven experience as a Database Administrator or in a similar role.
• Strong knowledge of SQL and database performance tuning.
• Experience with backup and recovery, replication, and high-availability configurations.

Responsibilities

• Install, configure, and maintain database management systems, including SQL and NoSQL databases.
• Ensure data integrity and security through backup and recovery processes, access controls, and data encryption.
• Monitor database performance, implement changes, and apply new patches and versions when required.

Skills

MySQL

PostgreSQL

Oracle

MongoDB

SQL performance tuning

Problem-solving

Teamwork

Education

Bachelor's degree in Computer Science, Information Technology, or related field

Tools

AWS RDS

Azure SQL Database

Job description

About the job Database Administrator (DBA) - Vancouver

Note: This position does not offer any Visa sponsorship. We are only looking for applicants who are either local to Vancouver, Canada, or ready to relocate to the employer's location.

Job Summary:Our Client is seeking an experienced Database Administrator to manage, optimize, and oversee their database systems, ensuring high performance, availability, and security. The ideal candidate will be adept at troubleshooting, performance tuning, and managing both production and development databases.

Key Responsibilities:

• Install, configure, and maintain database management systems (DBMS), including SQL and NoSQL databases.
• Ensure data integrity and security through backup and recovery processes, access controls, and data encryption.
• Monitor database performance, implement changes, and apply new patches and versions when required.
• Develop, manage, and test database backup and recovery plans.
• Conduct performance tuning and optimization of SQL queries and database objects.
• Design and implement database solutions, including data modeling, database design, and schema changes.
• Collaborate with developers to design and optimize database queries, indexes, and stored procedures.
• Ensure compliance with data governance and regulatory requirements.
• Maintain technical documentation and provide training to other team members on database management best practices.
• Troubleshoot and resolve database-related issues promptly.

Qualifications:

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• Proven experience as a Database Administrator or in a similar role.
• Proficiency in database management systems such as MySQL, PostgreSQL, Oracle, and MongoDB.
• Strong knowledge of SQL and database performance tuning.
• Experience with backup and recovery, replication, and high-availability configurations.
• Familiarity with cloud-based database services (e.g., AWS RDS, Azure SQL Database).
• Excellent problem-solving and analytical skills.
• Strong communication and teamwork abilities.

Preferred Skills:

• Experience with data warehousing and big data technologies.
• Knowledge of scripting languages (e.g., Python, Bash) for automation.