Senior Database Administrator
Start Date: ASAP Job Type : Permanent
Location : Montreal, QC (Hybrid position; 3 days on-site per week) Number of Positions: 1
Language Skills: Excellent English skills
Benefits: Work for a multinational, award-winning and socially responsible company, with an operational presence in many countries for over 75 years. It is a culturally diverse environment, employing thousands of people worldwide, with beautiful downtown offices. As a Senior Database Administrator, you are responsible for administering, monitoring and troubleshooting a 24x7 production environment's database servers and associated infrastructure. You will work with other team members to ensure 100% uptime, plan for future capacity needs, maintain security and apply updates. You will also solve exciting technical challenges by analyzing, troubleshooting and designing mission-critical services, platforms and infrastructure, while always thinking about reliability, scalability, resilience, security and performance.
Main tasks and responsibilities:
Extensive and demonstrable experience as a database administrator in large scale MSSQL environments
Hands-on experience managing high volume instances of highly available PostgreSQL configurations
Develop and establish policies and procedures related to data security and integrity; monitor and limit access to the database as necessary
Document the company's database environment
Knowledge of database storage engines and master-slave replication principles and practices
Good communication and coordination skills, and ability to work effectively under pressure
Education: University degree, preferably in computer science, computer engineering, mathematics or similar field.
Required skills:
Strong and demonstrable experience as a database administrator in large-scale PostgreSQL or MSSQL environments
Site reliability experience
Experience with VMware, as well as cloud (Azure, AWS)
Documented hands-on expertise in managing high volume instances of PostgreSQL configurations with high availability
Advanced problem-solving skills, with the ability to quickly identify the root cause of a problem
Develop and establish policies and procedures related to data security and integrity; monitor and limit access to the database as necessary
Ensure all database servers are managed according to Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO)
Document the company's database environment
Experience in writing automation scripts, creating application dashboards for proactive monitoring using Ruby, PowerShell, Python or similar technologies, ability to debug and optimize code and automate common tasks
Experience with database storage engines and master-slave replication principles and practices
Experience as a Linux system administrator (e.g. CentOS, RedHat) and in command line system administration such as Bash, VIM, SSH.
Experience with CI/CD in cloud environments and container technology, Docker and Kubernetes, Docker Swarm
Good communication and coordination skills, and ability to work effectively under pressure.