Database Administrator

6 months ago

Toronto, Canada Flywheel Digital Full time

**About Flywheel**:
Flywheel's suite of digital commerce solutions accelerate growth across all major digital marketplaces for the world's leading brands. We give clients access to near real-time performance measurement and improve sales, share, and profit. With teams across the Americas, Europe and APAC, we offer a career with real impact, endless growth opportunities and the support you need to be the best you can be.

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

**Working at Flywheel**:

- We are proud to offer all Flywheelers a competitive rewards package and unparalleled career growth opportunities and a supportive, fun and engaging culture.
- We have office hubs across the globe where team members can go to feel productive, inspired, and connected to others - team members go into Hub Offices 3x a week
- Flexible vacation time
- Great learning and development opportunities
- Benefits that help you live your best life
- Parental leave and benefits
- Volunteering opportunities
- If you're looking to connect with teammates on a topic of inclusion an

  • Database Administrator

    6 months ago

    Toronto, Canada Rang Healthcare Full time

    Job Title: Database Administrator Duration: 04 Month Contract Location: 125 Sir William Hearst, Toronto, ON M3M 0B5 (Position is 3 days onsite in a week) Must haves: Expert Database administration experience, e.g., IMS, DB2, Oracle, Microsoft Azure SQL database and Synapse database Experience with database development, e.g., stored procedure, PL/SQL,...

  • Database Administrator

    2 weeks ago

    Toronto, Canada Atlantis IT group Full time

    Location - Toronto Hybrid Position **Role name**: Database Administrator **Role Description**: Database Admin **Competencies**: Digital : Mongo DB, System I - DB2 400 **Experience (Years)**: 8-10 **Essential Skills**: Database Admin **Desirable Skills**: Database Admin **Country**: Canada

  • Database Administrator

    1 month ago

    Toronto, Canada Sync.com Full time

    **About the company** Since 2011, Sync has been on a mission to provide a safe space for the world to collaborate through its award-winning cloud apps and ground-breaking privacy protection features to share big ideas, store important information and collaborate on game-changing projects, making the world a better place. Our core values are constant - four...

  • Database Administrator

    3 months ago

    Toronto, Canada CareRx Full time

    Key Responsibilities:_ - Oversee and manage all aspects of our MS SQL, PostgreSQL and other databases. - Monitor and improve database performance and capacity proactively, anticipate and prevent any potential database issues for data accuracy and security. - Utilize extensive experience with Data Warehouse and SQL to develop and maintain database structures,...

  • Database Administrator

    6 months ago

    Toronto, Canada Sunwing Travel Group Full time

    **Join us in making vacation dreams come true** **!** Are you searching for a fun, passionate, travel loving team? -Sunwing has the EPIC work culture you have been searching for. We are currently looking for a **Database Administrator** to join us in making vacation dreams come true. As the Database Administrator, you are responsible for the installation,...

  • Database Administrator

    2 months ago

    Toronto, Ontario, Canada CB Canada Full time

    Senior SQL DBA RoleAt CB Canada, we are seeking a highly skilled Senior SQL DBA to join our team. The ideal candidate will have a strong background in database administration, with a focus on Microsoft SQL, Postgres, and Oracle databases.Key ResponsibilitiesEnsure system availability 7/24 to critical Enterprise Application database(s) abiding by ITSM...

  • Database Administrator

    4 weeks ago

    Toronto, Canada Raise Full time

    Database Administrator SpecialistLocation: Toronto, On - Hybrid - (In office every Tuesday for the time being)Contract Length: 6 months with Possibility of extension.We at Raise are hiring a Database Administrator Specialist for one of our top clients. After establishing themselves as an industry leader, they’re now expanding their team to meet rising...

  • Database Administrator

    6 months ago

    Toronto, Canada Cloudvital Technologies Full time

    We are hiring Mainframe DB2 for one of the fast growing dynamic company Job Title: Database Administrator Job Location: Montreal **Job Type**: Hybrid - **This is a Hybrid role with 3 days in office and 2 days remote **_ **Required skills**: - Extensive hands-on experience in the use of z/OS and related software packages and tools - Extensive experience...

  • Database Administrator

    6 months ago

    Toronto, Canada Rogers Communications Full time

     Our Technology team wakes up every day with one goal in mind - connecting Canadians to the people and things that matter most. Together, we are proud to support 30 million Canadians each month through managing a robust portfolio that champions leading-edge technology. We drive large-scale, complex, and high-visibility technology projects and programs that...

  • Database Administrator

    1 week ago

    Toronto, Canada Tata Consultancy Services Full time

    Tata Consultancy Services is a leading IT services, consulting, and business solutions organization that has been partnering with many of the world's largest businesses in their transformation journeys for over 55 years.As a Database Administrator, you will be responsible for building, deploying, and administering distributed Oracle DBMS, Oracle Exadata...

  • Database Administrator

    6 months ago

    Toronto, Canada Arthur Grand Technologies Inc Full time

    Arthur Grand Technologies is currently seeking a highly motivated and skilled **Database Administrator - Senior** for one of our clients. **Job Title: Database Administrator - Senior** **Location: Toronto, Ontario (Onsite)** **Duration: Long Term Contract** **MUST HAVES**: **MANDATORY REQUIREMENTS**: At least 5 years of experience with: - Oracle RDBMS...

  • Database Administrator

    6 months ago

    Toronto, Canada Atlantis IT group Full time

    **JD**: **Role - Database Administrator** **Location-** **Toronto, ON(Hybrid)** **Duration - Contract** Desirable Skills: Experience in Agile product development in Scrum or Kanban would be an assetAWS certification(s) such as AWS Certified Database Specialty would be an asset. Thanks & regards, Jack **Apptoza Inc.** Phone: (678)-869-5418 Ext 5003

  • Database Administrator

    6 months ago

    Toronto, Canada Arthur Grand Technologies Inc Full time

    **Position: Database Administrator - Senior** **Location: 595 Bay Street,, Toronto, Ontario** **Duration: Long Term Contract** **MUST HAVES**: **MANDATORY REQUIREMENTS**: At least 5 years of experience with: - Oracle RDBMS 11-12 in a Windows environment and SQL Server RDBMS 2008-2019 - Database installation, upgrade, monitoring, troubleshooting,...

  • Database Administrator

    1 week ago

    Toronto, Canada SmartTrade Full time

    smartTrade Technologies is a software publisher specializing in the trading and finance sector. Its clients primarily include investment banks, stock exchanges, brokers, and pension funds. smartTrade enables real-time computerized management of financial flows among these different stakeholders. Joining smartTrade means becoming a part of an innovative and...

  • Database Administrator

    2 months ago

    Toronto, Canada Atlantis IT group Full time

    **Role name:Database Administrator** **Location: Toronto, ON | Hybrid** Role Description: **Solid Experience in Snowflake, Python, AWS, Database management and query writing.** **Competencies: Digital : Amazon Web Service(AWS) Cloud Computing, Digital : Python for Data Science, Digital : Snowflake, Database Technology** **Experience (Years):...

  • Database Administrator

    6 months ago

    Toronto, Canada Arthur Grand Technologies Inc Full time

    **Position: Database Administrator - Intermediate** **Location: Toronto, Ontario** **Duration: Long Term Contract** **Must Haves**: - Experience with one or more database technologies - Experience designing data architecture for new databases - Experience in monitoring and enforcing database rules - Experience in developing documentation on data...

  • Database Administrator

    1 month ago

    Toronto, Canada SmartTrade Full time

    smartTrade Technologies is a software publisher specializing in the trading and finance sector. Its clients primarily include investment banks, stock exchanges, brokers, and pension funds. smartTrade enables real-time computerized management of financial flows among these different stakeholders. Joining smartTrade means becoming a part of an innovative and...

  • Database Administrator

    6 months ago

    Toronto, Canada YouthCare Full time

    Most Important - At least 10 years of experience - Experience in database replication / Real-Time data delivery with either MSSQL or Oracle - products (5+ years)RequirementsGeneral Skills - Experience administering database management systems (i.e. ORACLE, Exadata, Microsoft SQL - Create, test and implement safeguards to maintain data integrity and protect...

  • Database Administrator

    6 months ago

    Toronto, 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 Database...

  • Database Administrator

    4 weeks ago

    Toronto, Canada Raise Full time

    Database Administrator SpecialistLocation: Toronto, On - Hybrid - (In office every Tuesday for the time being)Contract Length: 6 months with Possibility of extension.We at Raise are hiring a Database Administrator Specialist for one of our top clients. After establishing themselves as an industry leader, they’re now expanding their team to meet rising...