Senior Database Engineer /SQL Optimization Expert

As a Senior Database Engineer, you will be working on state-of-the-art solutions, involving:

  • PostgreSQL SQL optimization methodologies and tools,
  • machine learning,
  • cloud technologies.

Requirements:

  • Strong optimization skills of large and heavily loaded databases (>1TiB, >10k QpS).

  • 3+ years of experience running PostgreSQL in large production environments.

  • Advanced SQL and PL/pgSQL knowledge.

  • Knowledge of PostgreSQL internals.

  • A history of increasing responsibility in the field of databases.

  • Experience and skills in the field of systems performance (PostgreSQL and Linux monitoring, troubleshooting, tuning).

  • Self-motivation and strong desire to achieve the highest levels of expertise.

Nice-to-have:

  • Advanced topics (partitioning, queues in database, time series, window functions, denormalization, efficient work with arrays, JSON).

  • Experience of implementation of SQL optimization workflow, involving pg_stat_statements, log-based analysis.

  • Go and/or C.

  • Python and/or Ruby.

  • Oracle SQL optimization experience.

  • Knowledge of basic machine learning algorithms and experience/with popular machine learning frameworks.

  • Cloud experience (AWS, GCP).

  • Experience working in a distributed team.

Responsibilities:

  • SQL performance troubleshooting and optimization.

  • DB schema design to store data securely and efficiently.

  • Code reviews and interaction with development teams.

  • Setting up SQL optimization workflow in various development teams.

  • Development of new open-source cloud-friendly ML-backed solutions to automate:

    • database experiments,

    • PostgreSQL configuration tuning, and

    • SQL query optimization.

  • Direct work with our clients to implement our methodologies and tools.

Benefits:

  • Interesting and challenging work.

  • Team of professionals and supportive atmosphere.

  • Extremely competitive pay depending on experience and skills.

  • Flexible working hours/home-office.

  • Medical insurance.

  • Online IT /Business English course.

Send us your CV to join@postgres.ai