SQL Developer

Primo Interactive Limited

Greater London, Manchester, Wrexham

Hybrid

GBP 60,000 - 85,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Primo Interactive Limited in the United Kingdom is seeking a senior database professional to own the data layer, design schemas, tune queries, and ensure data integrity across MySQL, PostgreSQL and SQL Server. You will collaborate with developers to implement migrations, maintain backups, user permissions, and documentation so teams can rely on consistent data systems across projects.

This role requires five years of hands-on experience and a disciplined approach to data governance, security,

Qualifications

  • Five+ years of commercial DB experience across MySQL/PostgreSQL/SQL Server.
  • Handwritten SQL in production across at least one engine.
  • Ability to read query plans and identify changes.
  • Experience planning, running and validating data migrations.
  • Care with data that belongs to others.

Responsibilities

  • Design schemas and migrations with developers, and review the ones they write.
  • Find and fix slow queries from the plan and the slow log.
  • Extract, clean and move data for reports and migrations.
  • Look after backups, users and permissions, and test that a restore works.
  • Write down how each database is set up, so nobody has to guess.

Skills

SQL
Performance tuning
Database design
Backup & recovery
Data migration

Tools

MySQL
PostgreSQL
SQL Server

Job description

Every system we build stands on a relational database, and many of the problems that reach a client start there: a slow query, a missing index, a migration that locked a table at the wrong moment. This role owns that layer.

You will design schemas with the developers, write and tune the queries that matter, extract data for reports and migrations, and keep backups, users and permissions in order across MySQL, PostgreSQL and SQL Server.

What you will be doing

  • Design schemas and migrations with the developers, and review the ones they write.
  • Find and fix slow queries from the plan and the slow log.
  • Extract, clean and move data for reports, imports and system migrations.
  • Look after backups, users and permissions, and test that a restore works.
  • Write down how each database is set up, so nobody has to guess.

What you will need

  • At least five years of commercial work in this field that you can show us. We promise clients that everyone on their project has that, so it is not negotiable.
  • SQL you write by hand, in production, on at least one of MySQL, PostgreSQL or SQL Server.
  • Reading a query plan and knowing what to change.
  • A migration or data move you planned, ran and checked afterwards.
  • Care with data that belongs to someone else.

Useful, not required

  • More than one of the three database engines.
  • Character sets and collations, and the trouble they cause in older tables.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

SQL Developer
SQL Developer

Stratacent • West Yorkshire

On-site
GBP 52,000 - 76,000
Senior SQL Developer: Schema Design, Tuning & Migrations
Senior SQL Developer: Schema Design, Tuning & Migrations

Primo Interactive Limited • Greater London, Manchester, Wrexham

Hybrid
GBP 60,000 - 85,000
Database Developer
Database Developer

Digital Waffle • Birmingham

On-site
GBP 52,000 - 78,000
Senior Software Engineer (Distributed Databases)
Senior Software Engineer (Distributed Databases)

Cloudflare, Inc. • United Kingdom

On-site
GBP 120,000 - 170,000
Stock ownership
Paid parental leave
Healthcare coverage
+2
SQL Server DBA/Engineer
SQL Server DBA/Engineer

ARM • Manor Park

On-site
GBP 60,000 - 90,000
SQL Server DBA/Engineer
SQL Server DBA/Engineer

Advanced Resource Managers Ltd • Greater London

Hybrid
GBP 83,000 - 129,000
SQL Developer
SQL Developer

Savant Recruitment • Greater London

On-site
GBP 55,000 - 75,000
Database Administrator
Database Administrator

Synergy Solutions International Limited • City Of London

On-site
GBP 35,000 - 50,000
SQL Server DBA/Engineer
SQL Server DBA/Engineer

ARM • City Of London

Hybrid
GBP 83,000 - 111,000
Senior Database Administrator
Senior Database Administrator

Ocean Red • Greater London

On-site
GBP 90,000 - 120,000