Database Administrator, Flywheel Digital

Salary not provided
SQL
AWS
Docker
Python
R
Postgres
Airflow
MySQL
Athena
Redshift
JIRA
Senior and Expert level
Dublin

3 days a week in office

Flywheel Digital

Simplified digital commerce solutions

Be an early applicant

Flywheel Digital

Simplified digital commerce solutions

1001+ employees

B2BMarketingAnalyticsMarket researchBusiness IntelligenceSaaS

Be an early applicant

Salary not provided
SQL
AWS
Docker
Python
R
Postgres
Airflow
MySQL
Athena
Redshift
JIRA
Senior and Expert level
Dublin

3 days a week in office

1001+ employees

B2BMarketingAnalyticsMarket researchBusiness IntelligenceSaaS

Company mission

To redefine a future where all businesses can seamlessly navigate the rapid change of digital commerce and drive growth.

Role

Who you are

  • This position will require a highly energetic, quick learner, who is looking to be challenged
  • 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

What the job involves

  • As the 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
  • Manage/Install/Upgrade database systems such as RedShift, SQL Server, MySQL, PostgreSQL to ensure that all systems are patched, configured and running optimally
  • Lead 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
  • Oversee the data board within JIRA and provide proper estimates for ideation through execution
  • Drive secure solutions that perform well and scale with the organisation, with a strong point of view on how things should get done
  • Drive standardisation on software solutions being implemented for data storage for all ETL processing. Eliminate the redundancy in tools such as R, Python, SSIS, Glue, Knime, Data pipelines and bring the right solutions for the right capability
  • Utilise Athena for query execution and analysis on data stored in various formats in S3, optimise 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/K8s 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
  • 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 visualisation
  • 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
  • Identify poorly running SQL and made changes to SQL or business process to correct issues
  • Create 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, Postgres or 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

Application process

  • Every role starts the same, an introductory call with someone from our Talent Acquisition team
  • We will be looking for company and values-fit as well as your professional experience; there may be some technical role-specific questions during this call
  • Every role is different after the initial call, but you can expect to meet several people from the team 1:1 and there might be further skill assessments in the form of a Take Home Assignment/Case Study Presentation or Pair Programming/Live Coding exercise depending on the role
  • In your initial call, we will walk you through exactly what to expect the process to be

Share this job

View 20 more jobs at Flywheel Digital

Company

Company benefits

  • Comprehensive medical coverage
  • Paid vacation and holidays
  • Country-specific savings and benefits plans

Our take

Flywheel is a digital commerce solution company that provides tools for retail commerce ops, media execution and market intelligence. Its real-time insights and decision making is aimed at boosting eCommerce sales, helping companies grow faster, smarter and more efficiently.

Founded in 2014, Flywheel amalgamated a number of digital commerce tools into a proprietary cloud platform that manages tens of billions in product sales and billions in advertising spend every year. It serves over 4500 brands internationally, a sure sign that it has solidified a presence in the space.

In 2023, New York-based Omnicom Group acquired Flywheel for $835 million. The company will continue to operate under its own name, but now as a "Practice Area" within Omnicom. Flywheel’s products will be connected to Omnicom’s audience and behavioural data, elevating both companies' analytics and insights power.

Kirsty headshot

Kirsty

Company Specialist at Welcome to the Jungle