We are seeking an experienced Senior PostgreSQL Database Developer to design, develop, and optimize complex database systems. The ideal candidate will have deep expertise in PostgreSQL, with a proven track record of building scalable, high-performance database solutions to support enterprise-level applications.<br><br>Key Responsibilities<br><br>Design, develop, and maintain PostgreSQL database schemas, ensuring optimal performance, scalability, and reliability.<br><br>Write and optimize complex SQL queries, stored procedures, triggers, and functions to support business applications.<br><br>Implement advanced PostgreSQL features, including indexing strategies (e.g., B-tree, GIN, GiST), partitioning, and full-text search.<br><br>Ensure data integrity, security, and compliance with industry standards (e.g., GDPR, HIPAA) through robust access controls and encryption.<br><br>Perform database performance tuning, query optimization, and monitoring to minimize latency and maximize throughput.<br><br>Design and implement high-availability solutions, including replication (logical and physical), failover, and clustering.<br><br>Collaborate with software engineers, data architects, and DevOps teams to integrate databases with application ecosystems.<br><br>Develop and maintain ETL pipelines for data migration and integration with external systems.<br><br>Troubleshoot and resolve database-related issues, including performance bottlenecks and data inconsistencies.<br><br>Mentor junior developers and provide technical guidance on PostgreSQL best practices.<br><br>Required Skills and Qualifications<br><br>Bachelor’s degree in Computer Science, Engineering, or a related field (or equivalent experience).<br><br>7+ years of experience in database development, with at least 5 years focused on PostgreSQL.<br><br>Expert-level knowledge of PostgreSQL architecture, including query planning, MVCC, and WAL.<br><br>Proficiency in writing complex SQL queries, PL/pgSQL, and optimizing query execution plans.<br><br>Strong experience with PostgreSQL extensions (e.g., PostGIS, TimescaleDB) and advanced features like JSONB and window functions.<br><br>In-depth understanding of database indexing, partitioning, and performance tuning techniques.<br><br>Experience with high-availability setups, such as streaming replication, logical replication, and PgBouncer.<br><br>Familiarity with database security practices, including role-based access control (RBAC), SSL/TLS, and row-level security.<br><br>Hands-on experience with database monitoring tools (e.g., pg_stat_statements, Prometheus) and backup/recovery solutions (e.g., pgBackRest, Barman).<br><br>Knowledge of cloud-based PostgreSQL deployments (e.g., AWS RDS, Google Cloud SQL, Azure PostgreSQL).<br><br>Strong problem-solving skills and the ability to work in a fast-paced, collaborative environment.<br><br>Excellent communication skills to articulate technical concepts to non-technical stakeholders.<br><br>Preferred Qualifications<br><br>Experience with other databases (e.g., MySQL, Oracle, MongoDB) and data migration to PostgreSQL.<br><br>Familiarity with containerized database deployments using Docker or Kubernetes.<br><br>Knowledge of CI/CD pipelines and infrastructure-as-code tools (e.g., Terraform, Ansible).<br><br>Contributions to PostgreSQL open-source projects or community involvement.<br><br>Certifications such as PostgreSQL Certified Professional or AWS Certified Database Specialty.
