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 multidatabase environments including PostgreSQL MSSQL Cassandra Clickhouse 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 techniquesImplement handson SQL NoSQL timeseries and columnstore 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 etcDevelop 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