Database Admin - Montreal - Jobs in Montréal East

Job Description

Note: This position does not offer any visa sponsorship. We are looking for applicants who are already living in Canada. Our client is seeking a skilled and experienced Database Administrator (DBA) to manage and maintain their database systems, ensuring their performance, availability, and security.Job Summary: As a Database Administrator, you will be responsible for the installation, configuration, maintenance, and performance of critical database systems. You will work closely with IT teams to support development, production, and reporting environments, ensuring optimal performance and reliability of database services.Key Responsibilities:

• Install, configure, and maintain database management systems (DBMS), including SQL Server, Oracle, MySQL, or PostgreSQL.
• Monitor database performance, implement changes, and apply new patches and versions when required.
• Perform database tuning and optimization to ensure high performance and availability of the databases.
• Develop, implement, and maintain database backup and recovery procedures.
• Ensure the security of databases, including data integrity, access controls, and audit trails.
• Troubleshoot and resolve database-related issues, ensuring minimal downtime.
• Design and implement database schemas, tables, views, indexes, and stored procedures.
• Collaborate with development teams to design and optimize database solutions that meet application requirements.
• Conduct capacity planning and performance analysis to anticipate future database needs.
• Implement and manage data replication, clustering, and other high availability solutions.
• Manage and monitor database storage, memory, and other resource usage.
• Prepare and maintain documentation, including data standards, procedures, and definitions for the data dictionary.
• Ensure compliance with industry regulations and company policies regarding data management.

Qualifications:

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• 5+ years of experience as a Database Administrator, with a strong understanding of database architecture, management, and performance tuning.
• Proficiency with one or more DBMS, such as SQL Server, Oracle, MySQL, or PostgreSQL.
• Experience with database backup, recovery, and security procedures.
• Strong knowledge of SQL and experience with writing complex queries, stored procedures, and triggers.
• Familiarity with database design, normalization, and data modeling techniques.
• Experience with database monitoring and performance tuning tools.
• Knowledge of scripting languages (e.g., Python, PowerShell) for automation tasks.
• Strong problem-solving and analytical skills.
• Excellent communication and collaboration skills, with the ability to work effectively in a team environment.

Preferred Qualifications:

• Experience with cloud-based database solutions (e.g., AWS RDS, Azure SQL Database).
• Familiarity with DevOps practices and tools related to database management.
• Relevant certifications (e.g., Microsoft Certified: Azure Database Administrator, Oracle DBA Certification).
• Experience with data warehousing, ETL processes, and big data technologies.