The company is looking to solve the problem of maintaining and securing its database systems.
Requirements
- Knowledge of database management systems such as Microsoft SQL and Oracle, experience with MySQL, PostgreSQL is an asset
- Experience with server clustering, such as SQL AlwaysOn Availability Groups, mirroring, and other high availability strategies
- Ability to use a scripting language (Python or Powershell, T-SQL) to automate database administration tasks
- Knowledge of reporting and analytic software such as MS Fabric, PowerBI, Databricks would be considered an asset
- Relevant database administration certificates, such as Oracle Certified Professional (OCP) or Microsoft Certified Database Administrator (MCDBA) are an asset
- Experience in cloud database technologies, like Microsoft Azure SQL, Cosmos DB
- Experience in database backup, disaster recovery planning, performance optimization and data security
Responsibilities
- Design, install, configure and maintain highly available database systems, including monitoring, tuning and troubleshooting issues
- Ensure data security and integrity, including implementation of access controls, backups and recovery plans
- Execute disaster recovery plans and procedures to ensure database availability during system outages or dysfunction
- Develop and maintain database documentation, including data standards, procedures and definitions for data elements and tables in the company
- Identify and implement database requirements for new or existing applications by working collaboratively with other teams
- Optimize database performance and efficiency by evaluating and recommending new database technologies
- Support users and developers by resolving data-related technical issues and troubleshooting queries by guiding them with best practices
Other
- Degree or diploma in a computer-related program or equivalent experience within IT
- 3-5 years of experience in database administration or in a similar role
- Proven analytical, evaluative, and problem-solving abilities
- Excellent written and oral communication skills with exceptional customer service
- Ability to present ideas in business-friendly and user-friendly language
- Highly self-motivated and directed
- Ability to effectively prioritize and execute tasks in a high performance environment
