For an international project in Chennai, we are urgently looking for a Full Remote Postgres DB Developer.
We are looking for a motivated contractor. Candidates need to be fluent in English.
Tasks and responsibilities:
- Design, implement, and optimize database schemas for performance and scalability;
- Expertise in PostgreSQL, including partitioning, indexing, and stored procedures;
- Optimize complex SQL queries for efficiency and performance;
- Design and manage robust backup and recovery strategies;
- Automate database operations, including backups and maintenance tasks;
- Develop data reporting and analytics solutions with SQL and BI tools;
- Constant awareness with the latest database trends and PostgreSQL features;
Profile:
- Bachelor or Master degree;
- +5/8 years of relevant experience as Postgres Database Developer;
- Proficiency with SQL and PL/pgSQL;
- Experience with PostgreSQL clustering, replication, and sharding;
- Familiarity with database backup tools (pg dump, pg basebackup) and high-availability techniques (replication, failover) tools like patroni, pgpool2 etc;
- Understanding of PostgreSQL performance tuning, indexing, and query optimization;
- Knowledge of containerization technologies and orchestrations such as Docker, kubernetes for PostgreSQL deployment is an advantage;
- Experience with Azure cloud platform and PostgreSQL in the cloud is an advantage;
- Fluent in English;