PostgreSQL Database Engineer

As a fast-growing company dedicated to data management, Tessell is at the forefront of developing cutting-edge products poised to revolutionize the data management industry. We pride ourselves on our team of talented individuals who are deeply passionate about pushing the boundaries of technology and innovation. Joining our engineering team means you will play a pivotal role in driving significant impact right from the get-go. In the role of an Open Source PostgreSQL Database Engineer at Tessell, you will be entrusted with the crucial task of conceptualizing, crafting, and optimizing our PostgreSQL infrastructure. Your responsibilities will extend to shaping the future of PostgreSQL, ensuring that our database solutions are not only highly scalable and reliable but also remarkably performant. This position presents an exciting opportunity to engage with the forefront of database technology while collaborating with a diverse, global open-source community. You will have the privilege of making meaningful contributions to one of the most extensively utilized databases worldwide. Your key responsibilities will include designing and implementing scalable, high-performance PostgreSQL database solutions for intricate, large-scale applications. You will conduct database tuning, optimization, and troubleshooting to guarantee high availability, fault tolerance, and performance at scale. Moreover, you will collaborate closely with product and engineering teams to seamlessly integrate PostgreSQL into existing systems, offering insights and solutions for data architecture and storage challenges. Advanced features like replication, clustering, partitioning, and sharding will also fall within your ambit to support data-intensive applications. Ensuring that security best practices are rigorously adhered to, managing roles, encryption, auditing, and compliance requirements will form an integral part of your role. You will be responsible for monitoring and maintaining PostgreSQL instances in production environments, safeguarding their stability, availability, and uptime. Additionally, you will contribute to the creation and upkeep of internal tools for automation and database management. Staying abreast of the latest PostgreSQL developments, emerging database trends, and actively contributing to the open-source community by sharing knowledge will also be expected from you. **Required Qualifications:** - Extensive experience in PostgreSQL, encompassing setup, configuration, and tuning. - Deep understanding of PostgreSQL internals, including storage engines, query planners, optimizers, and indexing. - Proficiency in implementing high availability solutions for PostgreSQL like replication, clustering, and failover. - Adept at performance tuning and optimization techniques for PostgreSQL databases at scale. - Familiarity with cloud-based PostgreSQL solutions such as AWS RDS, Google Cloud SQL, etc. - Proficiency in SQL and scripting languages like Python, Bash. - Knowledge of database security principles, encompassing encryption, access control, and auditing. - Prior experience in contributing to or working with open-source projects is advantageous. - Strong problem-solving abilities and adeptness in troubleshooting complex database issues. - Excellent communication skills, enabling effective collaboration with global teams and the open-source community. **Preferred Qualifications:** - Familiarity with PostgreSQL extensions such as PostGIS and TimescaleDB. - Experience with database migration, backup, and recovery strategies. - Knowledge of containerization technologies like Docker, Kubernetes, and orchestration tools. - Familiarity with DevOps practices and CI/CD pipelines. - Contribution to the PostgreSQL codebase or other open-source database projects. **Why Join Us:** - Engage in a high-energy, collaborative startup environment that prioritizes innovation. - Avail opportunities for professional growth and career advancement. - Be a part of a flexible, inclusive, and transparent culture where your ideas are valued. - Directly influence our product, customers, and the overall success of the company.,