Database Administrator

Seattle, WA, United States

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

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

Flywheel is committed to fair and equitable compensation practices. Actual compensation packages are based on several factors that are unique to each candidate, including but not limited to skill set, depth of experience, certifications, and specific work location.

Salary Range

$125,000-$125,000 USD

Flywheel is committed to fair and equitable compensation practices. Actual compensation packages are based on several factors that are unique to each candidate, including but not limited to skill set, depth of experience, certifications, and specific work location.

Salary Range

$125,000-$125,000 USD

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 and identity, chances are there's an ERG for that.

Learn more about us here: Life at Flywheel

The Interview 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.

Inclusive Workforce

At Flywheel, our goal is to create a culture where individuals of all backgrounds feel comfortable in bringing their authentic selves to work. We want all Flywheel people to feel included and truly empowered to contribute fully to our vision and goals.

Flywheel is an Equal Opportunity Employer and participates in E-Verify. Everyone who applies will receive fair consideration for employment. We do not discriminate based upon race, colour, religion, sex, sexual orientation, age, marital status, gender identity, national origin, disability, or any other applicable legally protected characteristics in the location in which the candidate is applying.

If you have any accessibility requirements that would make you more comfortable during the application and interview process, please let us know at [email protected] so that we can support you.

Please note, we do not accept unsolicited resumes from 3rd party Recruitment Firms.

For more information about what data we collect and how we use it, please refer to our Privacy Policy.

IMPORTANT ALERT: Please beware of fraudulent job communications from individuals falsely claiming to be from Flywheel. We've identified fraudulent activity through social media and messaging services purporting to be from Flywheel requesting payments for job- and recruitment-related expenses. Flywheel never asks candidates for personal information such as bank account data or tax IDs nor payments via social media or chat-based applications. Report suspected fraud to local authorities immediately. To learn more, click here.

#LI-HYBRID