Senior Database Engineer

The ideal candidate will have extensive experience with a variety of database systems, both SQL and NoSQL, and will be responsible for the development, administration, and optimization of our database infrastructure. This role requires a deep understanding of database performance enhancement techniques, data replication, and high availability systems.

Key Responsibilities:

• Design, implement, and manage multi-database environments, including PostgreSQL, MSSQL, Cassandra, Click-house, Kafka KSQL, H2 database, and others.
• Manage high transactional OLTP (Online Transaction Processing) and OLAP (Online Analytical Processing) databases.
• Highly experienced in Query Optimization and DB Performance enhancements techniques
• Implement hands-on SQL, NoSQL, time-series and column-store DB solutions.
• Extensive experience in Database installation, configuration, version Upgrades and Migrations.
• Set up and manage streaming and logical database replication.
• Configure and maintain high availability and scalable clusters using tools like Patroni, Etcd, HAProxy, Pgpool, and Pgbackrest.
• Utilize PostgreSQL extensions such as PostGIS and TimescaleDB, etc
• Develop and maintain data archiving lifecycle processes.
• Implement data compression, partitioning and sharding strategies.
• Apply data engineering skills, including Python and shell scripting, to streamline and automate database operations.
• Establish and manage robust database backup policies.
• Ensure database security management and auditing.
•