We are seeking a highly skilled and experienced Database Administrator to join our dynamic team. As a key player, you will manage our PostgreSQL databases, ensure optimal performance, and drive the automation and monitoring of our database systems. Your expertise will be crucial in resolving incidents and enhancing our database infrastructure to support high-load environments. Join us to help shape the future of our data management and contribute to our innovative solutions!

Responsibilities

• Administer PostgreSQL Databases: You will manage and maintain our PostgreSQL databases, ensuring their optimal performance and availability.
• Administer Non-Relational Databases: You will handle the administration of non-relational databases such as Elasticsearch, ClickHouse, etc.
• Analyze Performance Issues: You will identify performance bottlenecks and propose effective solutions to resolve them.
• Automate and Monitor: You will automate maintenance tasks and monitor database systems to ensure smooth operations.
• Conduct Load Testing: You will perform load testing to evaluate and enhance the performance and scalability of our databases.
• Resolve DBA Incidents: You will address and resolve database-related incidents promptly and efficiently.
• Configure PgBouncer: You will configure PgBouncer to manage database connections and improve performance.
  
  

Required Experience and Skills

• Database Administration: At least 5 years of experience as a database administrator, including working with high-load systems.
• PostgreSQL Expertise: Deep understanding of PostgreSQL internals, including index types (b-tree, sp-gist, gist, gin, rum) and maintenance tasks (indexes, statistics, scripting).
• Performance Tuning: Proven experience in identifying and resolving performance issues in databases.
• Configuration Management: Ability to modify PostgreSQL configuration files (postgresql.conf) and manage PostgreSQL database roles (user management).
• SQL Proficiency: Strong knowledge of SQL, including working with stored procedures, functions, and views.
• Data Warehousing: Experience in creating and managing data warehouses (DWH).
• Backup and Recovery: Understanding of backup principles, including types of backups, automation of backup processes, and recovery techniques.
• High Availability: Knowledge of high availability principles, including clustering and database replication setup.
• Airflow and Spark: Experience working with Airflow and Apache Spark.
  
  

Preferred Qualifications

• Linux Systems: Knowledge of Linux-based operating systems.
• Cloud Databases: Experience working with cloud-based database management systems.
  
  

What We Expect from You

• Experience: At least 5 years of experience as a database administrator, particularly with high-load systems.
• PostgreSQL Knowledge: In-depth understanding of PostgreSQL internals and performance tuning.
• Problem Solving: Ability to analyze performance issues and implement effective solutions.
• Technical Proficiency: Strong skills in SQL, database configuration, and user management.
• Automation and Monitoring: Expertise in automating database maintenance and monitoring systems.
  
  

Join us to leverage your database expertise and play a crucial role in enhancing our data infrastructure, ensuring high performance, and contributing to the success of our innovative projects!