Database Administrator

3 weeks ago

Old Toronto, Canada Flywheel Digital Full time

Opportunity

As a Database Administrator on our team you will be responsible for maintaining Flywheel's data ingestion, transformation, transactional and data warehousing needs. This role is essential to help support Flywheel’s exponential growth. Responsiveness and willingness to solution new ideas is a key to the success of this position. Willingness to own an issue and see it through to completion is a core competency that will make you successful within Flywheel. This position will require a highly energetic, quick learner, who is looking to be challenged.

What You'll Do

  • Management of Tools: Manage/Install/Upgrade database systems(RedShift, SQL Server, MySQL,PostgreSQL ) to ensure that all systems are patched, configured and running optimallyLead the technology strategies from a database perspective to align to the Flywheel technology standards
  • Manage the backup and recovery procedures for all systems to protect client information
  • Manage and mentor team of DBA’s on and off-shore to ensure timelines are met and quality is measured
  • Oversee the data board within JIRA and provide proper estimates for ideation through execution
  • Drive secure solutions that perform well and scale with the organization, with a strong point of view on how things should get done
  • Drive standardization on software solutions being implemented for data storage for all ETL processing. Eliminate the redundancy in tools(ie R, Python, SSIS, Glue, Knime, Data pipeline) and bring the right solutions for the right capabilityUtilize Athena for query execution and analysis on data stored in various formats in S3, optimize data retrieval and processing
  • Implement/ troubleshoot for Glue automated ETL workflows, streamlining data integration process and improving efficiency
  • Familiar with how airflow works and able to Orchestrate or monitor the DAGs that are running in different environments
  • Familiar with Docker and how the architecture works, to facilitate consistent deployment and scalability across different infrastructures
  • Familiar with Advance features of Redshift, specially WLM, AQUA node, Unload optimization and query optimization
  • Experience with DMS and how it works, to be able to configure or troubleshoot any issue.
  • Experience with Advance SQL server clustering concepts like Always on replication, Replication groups, seeding data between replication, troubleshoot replication issues
  • Technical Leadership/Architecture: Mentor and manage junior resources
  • Tasking resources to drive completion to tasks
  • Determine the right data strategy for loading data efficiently and accurately
  • Determine the right place for a data source to be stored to be used optimally
  • Determine where data sets should be loaded for application use or reporting use. Architect the proper data model for Application performance and reporting visualization
  • Document the data model/Dictionary to enable a team of analysts
  • Oversee data security and best in class data access protection procedures are in place
  • Development: Identify poorly running SQL and made changes to SQL or business process to correct issuesCreate custom monitoring jobs to keep database performance statistics and project future growth
  • Lead team for creation of ETL to integrate disparate data sources into S3 and then into either Mysql or into Redshift.Establish KPIS that drive proactive monitoring across all systems
  • Determine an archive strategy for all data that will encompass a hot, warm, cold data strategy
  • As it becomes costlier to store data in RedShift, we need to determine what data should be kept there for fast retrieval and then determine what data needs to be available at a more cost-effective option
  • Troubleshoot and root cause all data delays and inaccuracies to provide proactive monitoring and automation is in place

Who You Are

  • Bachelor’s Degree, preferably in IT-related field
  • 8-12 years of database administration experience
  • Database Administration
  • Cloud based technologies
  • Data modelling
  • Data Security/Governance
  • Big Data Concepts
  • AWS technologies
  • Sprint Planning/Development using JIRA

#LI-AD

#J-18808-Ljbffr

  • Database Administrator

    3 weeks ago

    Old Toronto, Canada Momentum Financial Services Group Full time

    Momentum Financial Services is a leading provider of financial services in North America. For 40 years, we've been committed to providing financial solutions that meet the evolving needs of consumers and business owners. Through our retail network of over 400 locations, known as Moneymart, Insta Cheques and the Cheque Cashing store, we provide access to cash...

  • Database Administrator

    3 weeks ago

    Old Toronto, Canada Momentum Financial Services Group Full time

    Momentum Financial Services is a leading provider of financial services in North America. For 40 years, we've been committed to providing financial solutions that meet the evolving needs of consumers and business owners. Through our retail network of over 400 locations, known as Moneymart, Insta Cheques and the Cheque Cashing store, we provide access to cash...

  • Database Administrator

    1 month ago

    Old Toronto, Canada CareRx Integrated Pharmacy Full time

    CareRx is actively seeking a highly experienced and committed Database Administrator (DBA) to manage a portfolio of applications and various integrations, architect Data Warehouse. This position plays a pivotal role in constructing an innovative, adaptable, and scalable IT function to drive our business forward. We require a multifaceted professional who is...

  • Database Administrator

    1 month ago

    Old Toronto, Canada CareRx Integrated Pharmacy Full time

    CareRx is actively seeking a highly experienced and committed Database Administrator (DBA) to manage a portfolio of applications and various integrations, architect Data Warehouse. This position plays a pivotal role in constructing an innovative, adaptable, and scalable IT function to drive our business forward. We require a multifaceted professional who is...

  • Database Administrator

    1 month ago

    Old Toronto, Canada CareRx Integrated Pharmacy Full time

    CareRx is actively seeking a highly experienced and committed Database Administrator (DBA) to manage a portfolio of applications and various integrations, architect Data Warehouse. This position plays a pivotal role in constructing an innovative, adaptable, and scalable IT function to drive our business forward. We require a multifaceted professional who is...

  • Database Administrator

    4 weeks ago

    Old Toronto, Canada CareRx Integrated Pharmacy Full time

    CareRx is actively seeking a highly experienced and committed Database Administrator (DBA) to manage a portfolio of applications and various integrations, architect Data Warehouse. This position plays a pivotal role in constructing an innovative, adaptable, and scalable IT function to drive our business forward. We require a multifaceted professional who is...

  • Database Administrator

    4 weeks ago

    Old Toronto, Canada CareRx Integrated Pharmacy Full time

    CareRx is actively seeking a highly experienced and committed Database Administrator (DBA) to manage a portfolio of applications and various integrations, architect Data Warehouse. This position plays a pivotal role in constructing an innovative, adaptable, and scalable IT function to drive our business forward. We require a multifaceted professional who is...

  • Database Administrator

    2 weeks ago

    Old Toronto, Ontario, Canada ProViso Staffing Full time

    Story Behind the Need:• The Global Technology Services (GTS) Tools and Monitoring group's mandate is to provide insight to critical applications through the integration of real-time monitoring tools for our key Business Platforms with the goal of improving mean time to detect, automating response coordination, preventing impacts, and reducing mean time to...

  • Database Administrator

    2 weeks ago

    Old Toronto, Ontario, Canada Tundra Technical Solutions Inc. Full time

    Story Behind The NeedThe Global Technology Services (GTS) Tools and Monitoring group's mandate is to provide insight to critical applications through the integration of real-time monitoring tools for our key Business Platforms with the goal of improving mean time to detect, automating response coordination, preventing impacts, and reducing mean time to...

  • Database Administrator

    2 weeks ago

    Old Toronto, Ontario, Canada Flywheel Digital Full time

    OpportunityAs a Database Administrator on our team you will be responsible for maintaining Flywheel's data ingestion, transformation, transactional and data warehousing needs. This role is essential to help support Flywheel's exponential growth. Responsiveness and willingness to solution new ideas is a key to the success of this position. Willingness to own...

  • Database Administrator

    6 days ago

    Old Toronto, Canada Interac Corp. Full time

    At Interac, we design and deliver products and solutions that give Canadians control over their money so they can get more out of life. But that’s not all. Whether we’re leading real-time money movement, driving innovative commerce solutions like open payments for transit systems, or making advancements in new areas like verification and open banking, we...

  • Database Administrator

    6 days ago

    Old Toronto, Canada Interac Corp. Full time

    At Interac, we design and deliver products and solutions that give Canadians control over their money so they can get more out of life. But that’s not all. Whether we’re leading real-time money movement, driving innovative commerce solutions like open payments for transit systems, or making advancements in new areas like verification and open banking, we...

  • Cloud Database Administrator

    4 weeks ago

    Old Toronto, Canada Workathome-Jobboard Full time

    This is a fantastic opportunity to become a Member of our CGI-Halifax team providing leading information technology services to our clients. We are seeking a skilled Cloud Database Administrator with a minimum 6 years experience, to join our team and oversee the management and optimization of our cloud-based database systems. The ideal candidate will have...

  • Cloud Database Administrator

    4 weeks ago

    Old Toronto, Canada Workathome-Jobboard Full time

    This is a fantastic opportunity to become a Member of our CGI-Halifax team providing leading information technology services to our clients. We are seeking a skilled Cloud Database Administrator with a minimum 6 years experience, to join our team and oversee the management and optimization of our cloud-based database systems. The ideal candidate will have...

  • Cloud Database Administrator

    4 weeks ago

    Old Toronto, Canada Workathome-Jobboard Full time

    This is a fantastic opportunity to become a Member of our CGI-Halifax team providing leading information technology services to our clients. We are seeking a skilled Cloud Database Administrator with a minimum 6 years experience, to join our team and oversee the management and optimization of our cloud-based database systems. The ideal candidate will have...

  • Cloud Database Administrator

    4 weeks ago

    Old Toronto, Canada Workathome-Jobboard Full time

    This is a fantastic opportunity to become a Member of our CGI-Halifax team providing leading information technology services to our clients. We are seeking a skilled Cloud Database Administrator with a minimum 6 years experience, to join our team and oversee the management and optimization of our cloud-based database systems. The ideal candidate will have...

  • Cloud Database Administrator

    4 weeks ago

    Old Toronto, Canada Workathome-Jobboard Full time

    This is a fantastic opportunity to become a Member of our CGI-Halifax team providing leading information technology services to our clients. We are seeking a skilled Cloud Database Administrator with a minimum 6 years experience, to join our team and oversee the management and optimization of our cloud-based database systems. The ideal candidate will have...

  • Database Administrator

    2 weeks ago

    Old Toronto, Ontario, Canada Alcohol and Gaming Commission of Ontario Full time

    Apply By: Friday, May 24, :59 pm EDT Alcohol and Gaming Commission of Ontario Division: Information and Information Technology (IIT) Division / Digital Platforms and Cybersecurity Branch The Alcohol and Gaming Commission of Ontario (AGCO) is a regulatory agency that reports to the Ministry of the Attorney General. The AGCO is responsible for regulating...

  • Database Administrator – Oracle

    1 week ago

    Old Toronto, Canada ProViso Staffing Full time

    Story Behind the Need: • The Global Technology Services (GTS) Tools and Monitoring group’s mandate is to provide insight to critical applications through the integration of real-time monitoring tools for our key Business Platforms with the goal of improving mean time to detect, automating response coordination, preventing impacts, and reducing mean time...

  • Database Administrator – Oracle

    1 week ago

    Old Toronto, Canada ProViso Staffing Full time

    Story Behind the Need: • The Global Technology Services (GTS) Tools and Monitoring group’s mandate is to provide insight to critical applications through the integration of real-time monitoring tools for our key Business Platforms with the goal of improving mean time to detect, automating response coordination, preventing impacts, and reducing mean time...