Cloud Database Administrator - Ottawa, Canada - Thales DIS CPL Canada, Inc

Description

Location:
Ottawa, Canada

Thales people architect identity management and data protection solutions at the heart of digital security. Business and governments rely on us to bring trust to the billons of digital interactions they have with people. Our technologies and services help banks exchange funds, people cross borders, energy become smarter and much more.

More than 30,000 organizations already rely on us to verify the identities of people and things, grant access to digital services, analyze vast quantities of information and encrypt data to make the connected world more secure.

We are currently recruiting for a talented Cloud Database Administrator to provide support of this complex state-of-art solution.

This role will provide you with the opportunity to learn the latest IT solutions and security concepts, within a like-minded supportive talented team.

Thales offers global cloud-based authentication services for high-profile customers with the most versatile and highest security practices implemented. We provide identity and access management services to thousands of customers worldwide

Key Responsibility

• Analyze product requirements and identify the best database solution, technology, and tool.
• Ensure database consistency of the projects by resolving any constraints.
• Develop database installation and upgrade script, which is part of CI/CD.
• Provide workload estimation of customization, features, and component level.
• Forecast, inform risk/concern on task, team, or project level, and propose mitigation plans.
• Provide technical solutions, support, and perform several activities for a new or customized database of products/components used in the project which includes but is not limited to database design, installation, upgrade, migration, backup, recovery, failover, HA, hardening, monitoring, etc.
• Review other DevOps code as necessary.
• Orchestrate and optimize the database activities of several databases, schemas, and components in one project or solution.
• Manage system/network configuration and monitoring.
• Strategize and plan for data migration, and develop data migration script if required by the project.
• Support, investigate and propose solutions/workarounds for production issues related to the database.
• Provide documentation as appropriate including design documentation, comments in code, and enduser documentation
• Consult with other technical team members and management on industry best practices.
• Maintain and enhance internal tools
• Provide input to improve the scalability and reliability of infrastructure to our Automation Architects
• Deploy and assist with the maintenance of automation technologies
• Participate in the oncall schedule & Provide L2/L3 Support to our Services desk and R&D teams
• Document all build and run procedures when implementing new automation technologies.

Required Skills and Exerience

• 5+ years experience in deploying, supporting and managing databases including MSSQL, MySQL, MongoDB, etc.
• 5+ years experience in SQL programming, bash scripting, performance tuning of SQL etc.
• Experience in configuring and maintaining different database replication methodologies.
• Understanding of operational concepts like change management, oncall rotations, escalations, uptime, etc
• Experience in managing production systems on a very large scale
• Experience with securityrelevant protocols
• Deep understanding of one of the major OS families (Linux or Windows)
• Adhere to security best practices from design to implementation and operations
• Ability to work in an extremely geographically distributed company
• Excellent communication skills across multiple mediums

Preferred Qualifications

• 5+ years experience in Cloud Native database technologies including RDS,MSSQL, CloudSQL, Cloud Spanner, etc.
• 5+ years must have experience with orchestration and Automations tools (Helmcharts, Ansible, Terraforms, Yaml, Python, Json)
• Experience with PaaS technologies (K8s, OpenShift, etc.)
• Experience with building pipelines for Infrastructure as a code using Terraform

hybrid