Senior Database Engineer, Partnerize

Salary not provided
MongoDB
Docker
Kubernetes
Python
Bash
Postgres
Ansible
MySQL
Puppet
Chef
Prometheus
Grafana
CouchDB
JIRA
Confluence
Senior and Expert level
Remote from UK
Partnerize

Partnership management software

Job no longer available

Partnerize

Partnership management software

201-500 employees

B2BArtificial IntelligenceEnterpriseSaaS

Job no longer available

Salary not provided
MongoDB
Docker
Kubernetes
Python
Bash
Postgres
Ansible
MySQL
Puppet
Chef
Prometheus
Grafana
CouchDB
JIRA
Confluence
Senior and Expert level
Remote from UK

201-500 employees

B2BArtificial IntelligenceEnterpriseSaaS

Company mission

To turn partnerships into a profit center.

Role

Who you are

  • Proficiency in MySQL replication (master-slave, master-master) and high availability configurations
  • Experience in query performance optimisation, including slow query analysis, indexing strategies, and troubleshooting
  • Strong understanding of schema optimisation (e.g., normalisation, denormalisation, partitioning) to enhance database performance
  • Experience in managing MySQL upgrades and schema migrations in production environments, ensuring minimal downtime and data integrity
  • In-depth knowledge of replication techniques across the various database technologies to ensure high availability, data consistency, and fault tolerance
  • Experience in setting up and maintaining multi-master replication, geo-replication, GTID and disaster recovery strategies
  • Proficient in resolving replication lag, failover issues, and ensuring data integrity across different database platforms
  • Expertise in PostgreSQL replication (synchronous, asynchronous), logical replication, and managing replication lag
  • Ability to troubleshoot and resolve slow queries
  • Experience in PostgreSQL schema optimisation (indexing, partitioning, query rewrites) to ensure efficient data retrieval
  • Solid understanding of upgrades and migrations, including handling major and minor version upgrades, and managing extension compatibility
  • Demonstrated experience in performing database upgrades (both major and minor versions) with minimal downtime, ensuring compatibility across systems, and handling post-upgrade issues
  • Expertise in managing database migrations, including:
  • In-place migrations (within the same database platform)
  • Cross-database migrations (e.g., migrating from MySQL to PostgreSQL or MongoDB to CouchDB)
  • Migrating between cloud providers or on-prem to cloud for various database platforms
  • Automating and scripting the migration process where possible
  • Experience in versioning and testing migration scripts to ensure smooth transitions with minimal service interruption
  • Strong experience with database monitoring tools (e.g., Prometheus, Grafana, New Relic, Percona Monitoring and Management) for tracking performance metrics and ensuring database health
  • Expertise in diagnosing and resolving performance issues related to replication, slow queries, schema design, and database migrations
  • Knowledge of setting up alerting systems and responding to database issues proactively

Desirable

  • Proficiency in scripting languages (e.g., Python, Shell, Bash) to automate routine DBA tasks such as backups, monitoring, upgrades, and migrations
  • Experience with automation tools such as Ansible, Chef, or Puppet to manage database configurations across multiple environments
  • Familiarity with CI/CD pipelines for database schema changes and migrations to ensure controlled and tested deployments
  • Familiarity with setting up and managing replication across Druid clusters, including data availability and data sharding strategies
  • Experience with query optimisation in Druid, especially for long-running queries in OLAP workloads
  • Understanding of schema design and optimisation for Druid’s columnar data format
  • Knowledge of managing Druid upgrades and migrations within distributed environments to ensure zero-downtime or minimal disruption
  • Expertise in MongoDB replication (ReplicaSets, Sharded Clusters) to ensure data redundancy, fault tolerance, and scalability
  • Experience with slow query troubleshooting using tools like the MongoDB Profiler and Aggregation Framework optimization
  • Proficient in schema design for MongoDB, with a focus on denormalisation, indexing strategies, and sharding to improve query performance
  • Hands-on experience with upgrading MongoDB versions and migrating data between MongoDB clusters or from on-premises to cloud environments
  • Experience with monitoring systems (Zabbix, Prometheus)
  • Containerisation and Orchestration: Familiarity with deploying and managing databases in containerized environments (e.g., Docker, Kubernetes)
  • Experience of JIRA and Confluence
  • Openness to learn the required technologies
  • An interest in development, new technologies and innovation
  • Supporting development teams into the refactoring of technical debt

What the job involves

  • As a Senior Database Engineer - Databases you will be part of the Partnerize Technical Operations team, they work with the business, development, and IT functions. You will be working within a team of Infrastructure Engineers responsible for designing, building and implementing solutions for the platform and providing the required training to support the solution
  • You will also be responsible for ensuring all issues/problems are addressed in a timely manner by the team
  • You should have a keen interest in problem-solving accompanied with experience in networking, linux systems and an experience in system designs, analysing what is currently implemented and offering improvements as well as ensuring the supporting documentation is in place
  • You’ll be supporting and maintaining the network, infrastructure, delivering projects and processes required to ensure we remain available, scalable, and secure. Involved in support, project delivery and maintenance activities completed by the Operational Team
  • We’re looking for a Senior Database Engineer - Databases with a desire to learn. For us, it's more about the person and the character than the role. We need people that will get excited about taking us to the next stage of our evolution helping us with their specific skills and experience but learning new ones along the way
  • Scoping the work coming into the Infrastructure Solutions team and delegating to the team members appropriately
  • Provide primary operational support and engineering for multiple large Databases servicing distributed software applications
  • Measure and optimise new implemented systems performance, with an eye toward pushing our capabilities forward
  • Build software and systems to manage platform infrastructure and applications
  • Improve reliability, quality, and time-to-market of our suite of software solutions
  • Partner with development teams to improve services through rigorous testing and release procedures
  • Ability to document procedures, best practices, and troubleshooting steps for knowledge sharing and team collaboration
  • Strong communication skills to work with development teams, product owners, and other stakeholders to ensure database needs are met
  • Deliver large technical projects
  • Act as an escalation for other support teams within TechOps
  • Plan, prioritise, and estimate tasks using Jira
  • Experience in mentoring junior DBAs and providing technical leadership on database design, optimisation, and migration strategies

Share this job

View 2 more jobs at Partnerize

Insights

Top investors

7% employee growth in 12 months

Company

Company benefits

  • Incentives
  • Generous wellness benefits and paid time off
  • Robust parental leave
  • Competitive retirement savings benefits
  • Employee learning & development opportunities

Funding (last 2 of 5 rounds)

Jan 2020

$50m

GROWTH EQUITY VC

Nov 2018

$9m

LATE VC

Total funding: $87.5m

Our take

Partnerize is a SaaS company offering a Partner Management Platform that helps businesses form, manage, analyze, and predict the outcomes of their partner marketing programs. Leveraging the power of AI, it streamlines the entire process, making it easier for companies to maximize their partner relationships.

As the world of partnerships evolves, Partnerize has positioned itself at the forefront of this dynamic field. With a growing range of sectors such as channel partnerships, influencer collaborations, loyalty programs, referral networks, and brand-to-brand alliances, the company has adapted to meet the complex needs of modern partner marketing, in addition to traditional affiliate marketing.

Partnerize is focused on providing its clients with an edge over the competition by automating as much of the partnership management process as possible. This commitment to efficiency, combined with its ability to leverage economies of scale, enables the company to address some of the industry's toughest challenges, including payments, ensuring that clients remain loyal to its platform.

Steph headshot

Steph

Company Specialist at Welcome to the Jungle