Database Administrator

Tabby

Descrição da oferta:

Department: Infrastructure

Employment Type: Full Time

Location: Remote

Reporting To: Viacheslav Kolesnikov

Description

We are seeking a skilled and experienced Database Administrator to join our dynamic team. The ideal candidate will be responsible for the design, implementation, maintenance and repair of the organization's database. The DBA will ensure the performance, security, and availability of databases.

Key Responsibilities

  • Design, construct, install, and maintain large relational databases.
  • Maintain the integrity and security of the database, including backups and recovery procedures.
  • Implement and manage disaster recovery and failover systems.
  • Monitor database performance, implement changes and apply new patches and versions when required.
  • Optimize queries for performance.
  • Collaborate with development teams to optimize database usage.
  • Setup and maintain database replication, clustering, mirroring, and other high availability strategies.
  • Use and understand tools like pgbouncer and modern monitoring systems.
  • Stay updated with the latest database technologies and best practices.

Skills, Knowledge & Expertise

  • Proficiency in PostgreSQL setup, replication, upgrade, monitoring and performance tuning.
  • Can read and write complex and very complex queries.
  • Experience with backup and recovery procedures, as well as PITR.
  • Strong knowledge of database design, documentation, and coding.
  • Familiarity with database management tools and performance tuning techniques.
  • Strong problem-solving and communication skills.
  • Familiarity with programming/scripting languages like bash, Python, go, etc.
  • Experience with DbaaS on cloud platforms such as GCP or AWS (would be a plus).

Desired Skills:

  • Certification in database management or equivalent training (would be a plus).
  • Experience in migrating large databases between cloud platforms.
  • Experience with Clickhouse/Qdrant.
  • Knowledge of the latest trends in database administration.
  • Familiarity with modern DevOps practices such as Kubernetes, terraform, helm.
  • Experience in real-time data streaming technologies such as Debezium/Flink.