SQL DBA

2 weeks ago

Markham, Canada Adastra Full time
Overview

Are you a skilled SQL Database Administrator (DBA) eager to take on new challenges? Adastra is looking for a dedicated professional to join our team and to play a pivotal role in designing, configuring, and managing database solutions. In this role, you will ensure data integrity, security, and accessibility, driving operational excellence and supporting our organization’s success.

Location: Within GTA

Status: Contract

Responsibilities:

  • Build and maintain database systems of high availability and quality, depending on users' requirements
  • Define standards for physical data storage, maintenance, access, and security administration
  • Use high-speed transaction recovery techniques and back up databases
  • Diagnose, troubleshoot, and resolve data issues
  • Analyze database access patterns, data model problems, and other bottlenecks
  • Configure database parameters and define data repository requirements, data dictionaries, and warehousing needs
  • Develop data models for all production schemas
  • Protect the safety and integrity of the database platform through database design changes, backups, and securing of database instances
  • Responsible for database operations such as data retention, health reports, and backup management
  • Proactively develop scripts and tools
  • Design, architect, implement, and support the data platform, including testing, improving, and maintaining new and existing databases

Qualifications, Skills & Experience:

  • Excellent knowledge of MS SQL, MySQL, and SQL data backup, recovery, and security
  • Proven experience working as a Database Administrator
  • Deep understanding of the SQL Server architecture
  • Strong experience with Fivetran HVR (High Volume Replication)
  • Experience with SSIS, SSAS, SSRS
  • Knowledge of VSTS (Azure DevOps)
  • Strong analytical and problem-solving abilities
  • Good scripting experience
  • Troubleshooting experience, including knowledge of backups, restores, and recovery models
  • Experience in database performance monitoring and performance bottleneck remediation

About Adastra

For more than 20 years, Adastra Corporation has been hyper-focused on data and the infrastructures to support it. We are an international consulting company working with businesses and IT Leaders to extract value through data and analytic solutions in the domains of Cloud, Data Management, Analytics, AI and ML, Governance, Hyper Automation, and Enterprise Application Development.

What We Offer

  • Opportunity for advancement and career progression
  • Competitive compensation package
  • Comprehensive benefits plan
  • Successful referral program
  • Satisfaction of working for a reputable company
  • A flexible, dynamic, and diverse workplace

Equal Opportunity Employer

In our commitment to promote fair and equitable treatment of all employees and applicants, Adastra Corporation provides equal employment opportunities for all individuals regardless of age, sex, disability, race, ethnic origin, citizenship, creed, sexual orientation, marital status, or any other ground as described in the Ontario Human Rights Code.

#J-18808-Ljbffr

  • SQL DBA

    2 weeks ago

    Markham, Ontario, Canada Adastra Full time

    OverviewAre you a skilled SQL Database Administrator (DBA) eager to take on new challenges? Adastra is looking for a dedicated professional to join our team and to play a pivotal role in designing, configuring, and managing database solutions. In this role, you will ensure data integrity, security, and accessibility, driving operational excellence and...

  • SQL DBA

    3 weeks ago

    Markham, Canada Adastra Full time

    Overview Are you a skilled SQL Database Administrator (DBA) eager to take on new challenges? Adastra is looking for a dedicated professional to join our team and to play a pivotal role in designing, configuring, and managing database solutions. In this role, you will ensure data integrity, security, and accessibility, driving operational excellence and...

  • Enterprise Database Architect DBA

    2 weeks ago

    Markham, Canada Computer Talk Technology Inc. Full time

    Role:Enterprise Database Architect DBA Location: Markham, ON About us: ComputerTalk is growing at a rapid rate and we are looking for exceptional talent to add to our team. The environment is dynamic, challenging, exciting, and rewarding. We attribute our success to the quality of the staff we bring on board. We have designed, deployed, and supported...

  • Enterprise Database Architect DBA

    1 week ago

    Markham, Ontario, Canada Computer Talk Technology Inc. Full time

    Role:Enterprise Database Architect DBALocation: Markham, ONAbout us:ComputerTalk is growing at a rapid rate and we are looking for exceptional talent to add to our team. The environment is dynamic, challenging, exciting, and rewarding. We attribute our success to the quality of the staff we bring on board. We have designed, deployed, and supported contact...

  • Enterprise Database Architect DBA

    2 weeks ago

    Markham, Canada Computer Talk Technology Inc. Full time

    Role:Enterprise Database Architect DBALocation: Markham, ONAbout us:ComputerTalk is growing at a rapid rate and we are looking for exceptional talent to add to our team. The environment is dynamic, challenging, exciting, and rewarding. We attribute our success to the quality of the staff we bring on board. We have designed, deployed, and supported contact...

  • High Availability DBA

    4 days ago

    Markham, Ontario, Canada Adastra Full time

    **Unlock Data Potential with Adastra's Expert Database Solutions**We are looking for a highly skilled SQL Database Administrator to join our team at Adastra and contribute to the development of innovative database solutions. As a key member of our team, you will design, configure, and manage high-availability database systems that meet the evolving needs of...

  • Database Administrator

    4 weeks ago

    Markham, Canada Pinnacle Tech Solutions Inc Full time

    Education: College/CEGEP - Experience: 1 year to less than 2 years - **Work setting**: - Telecommunications industry - Consulting firm - Information technology (IT) service provider - ** Tasks**: - Collect data to identify areas for improvement within an organization's IT infrastructure - Develop and implement a strategic blueprint to follow when deploying...

  • Database Administrator

    4 weeks ago

    Markham, Canada BGIS Full time

    BGIS is a leading provider of customized facility management and real estate services. With our combined team of over 6,500 globally, we relentlessly focus on enabling innovation through the services we deliver, while actively looking for new opportunities that will enable innovation for our clients’ businesses. Globally, we manage over 320 million square...

  • Data Infrastructure Specialist

    3 days ago

    Markham, Ontario, Canada The Nationwide Group Full time

    TNG is a leading provider of outsourced financial services software, delivering comprehensive solutions for the real estate industry through its affiliated organizations.Our data-driven approach enables efficient data management and supports informed decision-making across the organization.This Senior Technical Data Advisor role will be reporting to the CTO....

  • Senior Technical Data Advisor

    3 days ago

    Markham, Ontario, Canada The Nationwide Group Full time

    The Nationwide Group (TNG) is a pioneer in the financial services software industry, providing innovative solutions for the real estate industry.We utilize cutting-edge technology to deliver solutions to the entire mortgage life cycle, transforming the home purchase, sale, mortgage, and refinance process for consumers, lenders, realtors, and mortgage...

  • Database Architect

    3 days ago

    Markham, Ontario, Canada Adastra Full time

    Job DescriptionAdastra Corporation is seeking a skilled SQL DBA to join our team. As a key member of our IT department, you will play a pivotal role in designing, configuring, and managing database solutions.Responsibilities:Build and maintain high-availability database systems that meet users' requirements.Define standards for physical data storage,...

  • Enterprise Data Architect Leader

    3 days ago

    Markham, Ontario, Canada The Nationwide Group Full time

    The Nationwide Group (TNG) is a leader in the financial services software industry, providing comprehensive and customizable solutions for the real estate industry.We utilize cutting-edge technology to deliver solutions to the entire mortgage life cycle, transforming the home purchase, sale, mortgage, and refinance process for consumers, lenders, realtors,...

  • Chief Data Strategist

    3 days ago

    Markham, Ontario, Canada The Nationwide Group Full time

    The Nationwide Group (TNG) is a pioneer in designing and developing outsourced financial services software, exclusively focused on creating comprehensive and customizable solutions for the real estate industry.Utilizing world-class technology, TNG delivers solutions to the entire mortgage life cycle through its affiliated organizations. Our innovative...

  • Lead Data Architect

    2 weeks ago

    Markham, Canada The Nationwide Group Full time

    Lead Data ArchitectJOB DESCRIPTION The Nationwide Group (TNG) is a pioneer in designing and developing outsourced financial services software, exclusively focused on creating comprehensive and customizable solutions for the real estate industry. Utilizing world-class technology, TNG delivers solutions to the entire mortgage life cycle through its affiliated...

  • Lead Data Architect

    2 weeks ago

    Markham, Canada The Nationwide Group Full time

    Lead Data ArchitectJOB DESCRIPTION The Nationwide Group (TNG) is a pioneer in designing and developing outsourced financial services software, exclusively focused on creating comprehensive and customizable solutions for the real estate industry. Utilizing world-class technology, TNG delivers solutions to the entire mortgage life cycle through its affiliated...

  • Lead Data Architect

    2 weeks ago

    markham, Canada The Nationwide Group Full time

    Lead Data ArchitectJOB DESCRIPTIONThe Nationwide Group (TNG) is a pioneer in designing and developing outsourced financial services software, exclusively focused on creating comprehensive and customizable solutions for the real estate industry. Utilizing world-class technology, TNG delivers solutions to the entire mortgage life cycle through its affiliated...

  • Lead Data Architect

    2 weeks ago

    markham, Canada The Nationwide Group Full time

    Lead Data ArchitectJOB DESCRIPTIONThe Nationwide Group (TNG) is a pioneer in designing and developing outsourced financial services software, exclusively focused on creating comprehensive and customizable solutions for the real estate industry. Utilizing world-class technology, TNG delivers solutions to the entire mortgage life cycle through its affiliated...

  • Lead Data Architect

    2 weeks ago

    markham, Canada The Nationwide Group Full time

    Lead Data ArchitectJOB DESCRIPTIONThe Nationwide Group (TNG) is a pioneer in designing and developing outsourced financial services software, exclusively focused on creating comprehensive and customizable solutions for the real estate industry. Utilizing world-class technology, TNG delivers solutions to the entire mortgage life cycle through its affiliated...

  • Lead Data Architect

    2 weeks ago

    Markham, Ontario, Canada The Nationwide Group Full time

    Lead Data ArchitectJOB DESCRIPTIONThe Nationwide Group (TNG) is a pioneer in designing and developing outsourced financial services software, exclusively focused on creating comprehensive and customizable solutions for the real estate industry. Utilizing world-class technology, TNG delivers solutions to the entire mortgage life cycle through its affiliated...

  • Lead Data Architect

    3 days ago

    Markham, Ontario, Canada The Nationwide Group Full time

    Lead Data ArchitectJOB DESCRIPTIONThe Nationwide Group (TNG) is a pioneer in designing and developing outsourced financial services software, exclusively focused on creating comprehensive and customizable solutions for the real estate industry. Utilizing world-class technology, TNG delivers solutions to the entire mortgage life cycle through its affiliated...