Database Administrator

1 week ago

Old Toronto, Ontario, 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

    1 week 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

    1 week 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

    1 week 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

    1 week ago

    Toronto, Ontario, Canada Infotek Consulting Services Full time

    Support on preparation, installation, configuration and user test of mainframe z/OS, IMS and DB2 version upgrade:Participate in the review of project and maintenance release artefacts Use Case, System Requirement Specification, etc.; Prepare and implement database changes according to design; Promote database changes through Development, Integration Testing,...

  • Database Administrator Analyst

    1 week ago

    Old Toronto, Ontario, Canada Havergal College Full time

    We are seeking an individual who is inspired by our mission and whose beliefs align with our core values of integrity, compassion, inquiry and courage, and reflects our core competencies to join Havergal College as a Database Administrator Analyst. This is a full-time position. Why Havergal is the Place to Be Founded in 1894 and located on a beautiful...

  • Senior Oracle Database Administrator

    1 week ago

    Old Toronto, Ontario, Canada CorGTA Inc. Full time

    Senior Oracle Database Administrator - 6 month contract - up to $63.00 p/h INC. $55–$63 an hour - Temporary, Full-time, Fixed term contract Job details Here's how the job details align with yourprofile . PayJob type Temporary Full-time Fixed term contract Shift and schedule Monday to Friday Location CorGTA Inc. in Toronto, ON Full job...

  • Database Administrator

    1 week ago

    Toronto, Ontario, Canada IBI Group Full time

    Company DescriptionWe are a global architecture, engineering, planning, and technology firm defining the cities of tomorrow.By connecting design and technology, we change how people experience their built environment. We work across disciplines to create the intelligent systems, sustainable buildings, and efficient infrastructure that shapes the way people...

  • Senior Database Administrator

    1 week ago

    Old Toronto, Ontario, Canada Motorola Solutions Full time

    Senior Database Administrator (Canada Remote) page is loaded Senior Database Administrator (Canada Remote) Apply locations Toronto, Canada (ONT40) Ontario Remote Work time type Full time posted on Posted 3 Days Ago job requisition id R46746 Company Overview At Motorola Solutions, we're guided by a shared purpose – helping people be their best in the...

  • Database Administrator

    1 week ago

    Toronto, Ontario, Canada Momentum Financial Services Group_new Full time

    Job DescriptionThis is an excellent opportunity for a seasoned database administrator with expertise in Azure cloud technologies, advanced SQL features, Qlik, and Azure Data Factory (ADF) to join a dynamic team and contribute to the success of our cloud-based data initiatives. If you meet the above qualifications and are passionate about database...

  • Database Administrator

    1 week ago

    Toronto, Ontario, Canada The Mabin School Full time

    Database Administrator / IT HelpdeskDuration: 20 hrs / week over 3-4 days / weekLocation: Toronto, ONPlease note this is a hybrid role. About The Mabin School:The Mabin School is a small, co-educational JK to Grade 6 progressive school with a strong commitment to inquiry, integration, and reflection. We are Canada's first independent Ashoka Changemaker...

  • Database Administrator

    1 week ago

    Toronto, Ontario, Canada Dawn InfoTek Inc. Full time

    Dawn InfoTek Inc. is a professional IT consulting team that partners with major financial institutions, investment firms and government sectors. We have been dedicated to delivering cutting-edge consulting services and recruiting all levels of IT positions for our clients.We are currently seeking competent individuals to fulfill the role of DBA to join our...

  • Database Administrator

    1 week ago

    Toronto, Ontario, Canada AGCO Full time

    Term: Permanent, Full-TimeDivision/Branch: Information and Information Technology (IIT) Division / Digital Platforms and Cybersecurity BranchApplication Deadline: May 24, 2024Level: Level 10Salary Range: Min: $92,902 to Max: $116,123Work Location: Head Office, Toronto, ON; HybridThe Alcohol and Gaming Commission of Ontario (AGCO) is a regulatory agency that...

  • Database Administrator

    1 month ago

    Toronto, Ontario, Canada Ombudsman Ontario Full time

    Alcohol and Gaming Commission of Ontario (AGCO) is a regulatory agency under the Ministry of the Attorney General, responsible for overseeing alcohol, gaming, horseracing, and cannabis retail in Ontario, guided by honesty, integrity, and public interest.Position: Database AdministratorReporting to: Senior Manager of IT Infrastructure and OperationsLocation:...

  • Database Administrator

    3 weeks ago

    Toronto, Ontario, Canada Ombudsman Ontario Full time

    Alcohol and Gaming Commission of Ontario (AGCO) is a regulatory agency under the Ministry of the Attorney General, responsible for overseeing alcohol, gaming, horseracing, and cannabis retail in Ontario, guided by honesty, integrity, and public interest.Position: Database AdministratorReporting to: Senior Manager of IT Infrastructure and OperationsLocation:...

  • Database Administrator

    1 week ago

    Toronto, Ontario, Canada Capleo Global Full time

    Position: Database Administrator IntermediateLocation: Toronto, ON (Hybrid) Duration: 240 Business Days + Possible Extension Job Description:Experience with one or more database technologies. Proficiency with SQL and experience writing SQL scripts. Experience designing data architecture for new databases. Experience in monitoring and enforcing database...

  • Database Administrator

    1 week ago

    Toronto, Ontario, Canada Canadian Institute for Health Information Full time

    Category Data GovernanceCity Toronto, Ottawa, Ontario, Canada Database Administrator Who we are We are an organization comprised of industry thought leaders who are passionate about health data and want to make a difference in the health care field. We are an independent, notforprofit organization and together with our partners we provide essential...

  • Database Administrator

    1 week ago

    Toronto, Ontario, Canada Drake International Full time

    Title: Database AdministratorLocation: Toronto, ON, Canada (Hybrid)Type: Long Term ContractIntroduction:Join a rock-solid organization as our client's next Database Administrator and sit at the center of projects that drives decisions. You'll help one of Canada's most trusted government organizations work on the latest project, and be rewarded with great...

  • Database Administrator

    1 week ago

    Toronto, Ontario, Canada TekStaff IT Solutions Full time

    This is a 6 month contract located in Toronto, ON/ Hybrid Candidate Requirements/Must-Have skills: years of working experience as a Database Administrator years of hands-on experience with Oracle Installation - Database upgrades/migrations years of hands-on experience wit

  • Senior Database Administrator

    1 week ago

    Old Toronto, Ontario, Canada ALLTECH CONSULTING SVC INC Full time

    Work with EFP technical team to plan/prepare and execute migration of e-Business Suite and TPE (Transfer Payment Extension) application from On-Prem Supercluster to Oracle Cloud Infrastructure. Performance tuning of e-Business Suite R12.2/19c in multi-node RAC environment. Configure, deploy Oracle Access Manager, Oracle Universal Directory (OUD), Oracle...

  • Database Administrator

    1 week ago

    Toronto, Ontario, Canada Arthur Grand Technologies Inc Full time

    Arthur Grand Technologies is currently seeking a highly motivated of Database Administrator - Intermediate one of our client.Position: Database Administrator - IntermediateLocation: Toronto, Ontario (Hybrid)Hybrid - 3 days on site and 2 remoteDuration: Long Term ContractMust Haves: Experience with one or more database technologies Experience designing data...