Informations principales
Database Administrator/DBA
Poste: Non spécifié
Début: Dès que possible
End: Non spécifié
Lieu: Vancouver, Canada
Type de collaboration: Projet seulement
Taux horaire: Non spécifié
Dernière mise à jour: 5 sept. 2024
Description et exigences de la tâche
The Work:
- Plan, build, and maintain cloud-based, relational and unstructured, high availability, and high-quality database management systems and warehouses with a strong emphasis on SQL Managed Instances and on-premises SQL servers.
- Develop and manage Azure Data Factories, creating and optimizing data pipelines for efficient ETL processes and data ingestion from external sources.
- Implement continuous security, performance, and issues monitoring processes across all data platforms and recommend, develop, and implement preventative actions.
- Plan, maintain, and regularly test high availability and disaster recovery architecture, particularly for SQL Managed Instances.
- Collaborate with Data Engineers to ensure the effective implementation and maintenance of standards, tools, and processes for data management and ETL.
- Balance resources and scheduling to maintain and improve database and process performance within established resource limits.
- Automate repetitive database tasks and develop centralized monitoring of all database environments and processes.
- Engage in all aspects of the Agile process, proactively contributing to improvements to minimize rework/waste and increase quality and velocity.
- Stay abreast of software industry best practices, processes, and technologies, and actively encourage their adoption within the Sprint Team and LGM
- Champion continuous improvement to facilitate and ensure the modernization of LGM’s data systems.
- Strong database management skills in a SQL Server cloud database environment, with extensive experience with Azure SQL Managed Instances.
- Extensive and proven T-SQL scripting skills.
- Experience using PowerShell in Azure and manage certain data administration tasks.
- Experience with always-on high availability technology.
- Good knowledge of IaaS, SaaS, and PaaS.
- Proficiency in managing and optimizing Azure Data Factories and developing data pipelines.
- Demonstrated working knowledge of unstructured data management principles.
- Experience with cloud infrastructure.
- Experience managing Azure resources is a plus.
- Experience monitoring database instances.