Role Overview:The PostgreSQL Developer / Database Engineer will be responsible for designing, developing, optimizing, and supporting enterprise-scale PostgreSQL database solutions. The role requires expertise in database architecture, performance tuning, high availability, data integration, cloud database platforms, and database security.
Key Responsibilities:- Design and maintain scalable PostgreSQL database solutions.
- Develop logical and physical data models, including normalization, denormalization, and partitioning strategies.
- Develop and optimize complex SQL and PL/pgSQL code.
- Analyze execution plans and troubleshoot database performance issues.
- Implement indexing strategies and database performance tuning.
- Design and support high availability, replication, backup, recovery, and disaster recovery solutions.
- Administer and monitor PostgreSQL environments using standard PostgreSQL tools.
- Support data quality, governance, metadata management, and data lineage initiatives.
- Develop and support ETL/ELT processes, CDC solutions, and event-driven data pipelines.
- Integrate PostgreSQL with applications, APIs, and microservices.
- Support cloud-hosted PostgreSQL environments and infrastructure automation.
- Implement database security, auditing, encryption, and compliance controls.
Required Skills:- PostgreSQL
- Data Modeling
- SQL
- PL/pgSQL
- Common Table Expressions (CTEs)
- Window Functions
- Stored Procedures
- Views
- Materialized Views
- Execution Plan Analysis
- Performance Tuning
- B-Tree Indexes
- Hash Indexes
- GIN Indexes
- GiST Indexes
- BRIN Indexes
- VACUUM Optimization
- Statistics Management
- Memory Tuning
- Streaming Replication
- Logical Replication
- Failover
- Disaster Recovery
- Read Replicas
- Backup and Recovery
- pgAdmin
- psql
- pg_dump
- pg_restore
- WAL Management
- Metadata Management
- Data Lineage
- Data Profiling
- Data Validation
- Data Reconciliation
Qualifications:- 8-10 years of experience in PostgreSQL database development and engineering.
