Dba-database Administrator

3 months ago


Vancouver, Canada LGM Financial Services Inc. Full time

**The Organization**:
LGM is a national leader in providing warranty, finance and insurance services to the Canadian automotive industry. Since 1998, LGM has been successfully supplying quality products and leading training solutions with strategic partnerships with automotive manufacturing brands, which include BMW/MINI, Kia, Mazda, Volvo, Jaguar, LandRover, Mitsubishi Motors, Polestar and Motorrad.

Reporting to the Data Engineering Team Lead, the Database Administrator (DBA) is primarily responsible for the performance, availability, security, and recovery of local and cloud-based solutions for data storage, management, and retrieval. The DBA will focus extensively on managing databases in Azure SQL Managed Instances, On-premises SQL servers and Azure Data Factories, ensuring high availability and robust data pipeline architectures.

**The Work**:
**Responsibilities**:

- 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.

Desirable Technical Skills:

- 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.

**Education**:

- Post-secondary education in Computer Science or related discipline.

Required Experience:

- Minimum of 5 years’ experience in a DBA role.

Required Experience
- Minimum of 5 years’ experience in DBA role


  • Database Administrator

    22 hours ago


    Vancouver, Canada Yeah! Global Full time

    Note: This position does not offer any Visa sponsorship. We are only looking for applicants who are either local to Vancouver, Canada, or ready to relocate to the employer's location. Job Summary: Our Client is seeking an experienced Database Administrator to manage, optimize, and oversee their database systems, ensuring high performance, availability, and...

  • MySQL Dba

    6 months ago


    Vancouver, Canada AstraNorth Full time

    **Experience (Years)**:8-10 **Essential Skills**: - **SQL Server Database Administration**: - **My SQL DBA - AZ-900, Redgate, SQL Server, HA, Replication, Indexing, Fiserv DNA, Indexing, performance tuning, familiarity with Service**: - MS SQL DBA - Good knowledge on DB health checkup, backup and restore, high availability set up, replication set up,...

  • Database Administrator

    5 months ago


    Vancouver, Canada Colton’s Couture International Full time

    Education: College/CEGEP - Experience: 2 years to less than 3 years **Tasks**: - Collect and document user's requirements - Design and develop database - Design, construct, modify, implement and test data models and database management systems - Develop and implement data administration policy, standards and models - Research and document data requirements,...


  • North Vancouver, Canada AVIS Full time

    Education: College/CEGEP - Experience: 2 years to less than 3 years **Tasks**: - Design and develop database - Design, construct, modify, implement and test data models and database management systems - Develop and implement data administration policy, standards and models - Research and document data requirements, data collection and administration policy,...


  • Vancouver, Canada Breakdown Services, Ltd. Full time

    **Internet Development Services,** a subsidiary of **Breakdown Services Ltd**, is seeking an experienced **SQL Database Administrator **to design, implement and maintain the database infrastructure (servers, clusters etc.) behind several high traffic, high availability web sites. This position works together with the Production DBA and the Senior Software...


  • Vancouver, Canada Breakdown Services, Ltd. Full time

    **Internet Development Services,** a subsidiary of **Breakdown Services Ltd**, is seeking an experienced **SQL Database Administrator **to design, implement and maintain the database infrastructure (servers, clusters etc.) behind several high traffic, high availability web sites. This position works together with the Production DBA and the Senior Software...


  • North Vancouver, Canada AAB TRANSPORT LTD Full time

    Education: Bachelor's degree - Experience: 2 years to less than 3 years **Work setting**: - Help desk **Tasks**: - Collect and document user's requirements - Design and develop database - Design, construct, modify, implement and test data models and database management systems - Operate database management systems to analyze data - Research and document...


  • Vancouver, British Columbia, Canada Royal Bank of Canada Full time

    Job Title: Technical Systems Analyst – Database Activity MonitoringJob Description:As a member of the Data Protection team, you will be part of a team of security experts passionate about solving complex problems and developing innovative security solutions. Your role will be to implement and manage database activity monitoring (DAM) solutions to track and...


  • Vancouver, Canada MMC Corporate Full time

    **MongoDB Database Administrator**: **What can you expect**: - This position is for an established and productive professional individual contributor in Information Technology, who works independently with mínimal supervision. - We are a large team who together, across the AUS, UK, Canada & US are responsible for significant databases & project related to...

  • Database Admin

    2 months ago


    Vancouver, Canada Yeah! Global Full time

    Note: Thisposition does not offer any visasponsorships.We areseeking a skilled and experienced Database Administrator (DBA) tomanage and maintain our database systems ensuring their performanceavailability andsecurity.JobSummary: As a DatabaseAdministrator you will be responsible for the installationconfiguration maintenance and performance of critical...


  • Vancouver, British Columbia, Canada BC Assessment Full time

    About the Role:We are seeking a skilled Database Administrator to join our team at BC Assessment. As a key member of our IT department, you will be responsible for designing, implementing, and maintaining our database systems to ensure efficient data management and storage.Key Responsibilities:Design and implement database systems to meet business...


  • Vancouver, British Columbia, Canada Global Relay Full time

    About the Role:We are seeking a skilled and experienced relational database administrator to join our Infrastructure and Platform team to play a key role in managing our diverse database infrastructure.As a Database Administrator, you will be responsible for the design, implementation, administration, and optimization of our SQL Server, Postgres, MySQL, or...


  • Vancouver, British Columbia, Canada Global Relay Full time

    About Global RelayWe are a leading provider of enterprise information archiving solutions, with over 20 years of experience in the industry. Our cloud archiving, surveillance, eDiscovery, and analytics solutions are designed to help highly regulated firms capture and preserve their communications data, ensuring compliance with stringent regulations.Your...


  • Vancouver, British Columbia, Canada BC Assessment Full time

    About the Role:We are seeking a highly skilled Senior Database Administrator to join our team at BC Assessment. As a key member of our IT department, you will be responsible for designing, implementing, and maintaining our database systems to ensure optimal performance and security.Key Responsibilities:Design and implement database systems to meet business...


  • Vancouver, British Columbia, Canada Broadridge Full time

    At Broadridge, we empower our employees to achieve their goals by providing a supportive and collaborative work environment.We are seeking a highly skilled SQL Server and related DB technologies Operations specialist to join our global Database Operations team. The selected candidate will be responsible for ensuring the performance reliability, availability,...


  • Vancouver, Canada Ntirety Full time

    **COMPANY OVERVIEW**: When it comes to a cybersecurity crisis, the question is not if, but when it will happen - that's why Ntirety's mission to provide proactive compliant security is crucial in today's business landscape. No matter what role or department you work in, being a part of Ntirety means supporting all of our different teams to help keep our...


  • Vancouver, British Columbia, Canada THAKKAR HOSPITALITY BC-LM INC. DBA TIM HORTONS Full time

    We are seeking an Administrative Support Specialist to join our team at THAKKAR HOSPITALITY BC-LM INC. DBA TIM HORTONS. As an Administrative Support Specialist, you will be responsible for determining and establishing office procedures and routines, scheduling and confirming appointments, and answering telephone and relay telephone calls and messages.The...

  • Finance Administrator

    2 weeks ago


    Vancouver, Canada Pimlico Performance Apparel Ltd. dba DUER Full time

    Full-time, Permanent· Wage: $28.85/hour (depending on experience)· Number of Positions: 1· 15 days paid vacation per year· Extended Health BenefitsJob Duties:Establish work priorities and ensure adherence to deadlines and protocolsManage financial administrative operationsAdminister policies and procedures concerning the release of records under...


  • Vancouver, British Columbia, Canada THAKKAR HOSPITALITY BC-LM INC. DBA TIM HORTONS Full time

    We are seeking an organized and detail-oriented Administrative Assistant to support our team at THAKKAR HOSPITALITY BC-LM INC. DBA TIM HORTONS. The successful candidate will be responsible for determining and establishing office procedures and routines, scheduling and confirming appointments, and answering telephone and electronic enquiries.The ideal...

  • Database Analyst

    4 weeks ago


    Vancouver, British Columbia, Canada Cascadia Skincare Full time

    Cascadia Skincare is seeking a skilled Database Analyst to join our team. As a key member of our data management team, you will be responsible for collecting data to identify areas for improvement within our IT infrastructure, developing and implementing a strategic blueprint for database deployment, and maintaining computer databases.The ideal candidate...