PostgreSQL Database Architect

Design scalable and robust PostgreSQL database architectures for enterprise-grade applications. Develop logical and physical data models aligned with business requirements. Create and maintain best practices for database design, coding, performance tuning, and security. Perform capacity planning, data partitioning, and replication strategies. Implement and manage high availability, disaster recovery, and backup strategies. Work closely with software developers, DevOps, and system architects to integrate database solutions with applications. Develop database deployment pipelines and automation scripts using tools such as Ansible, Terraform, or CI/CD. Conduct performance monitoring, query optimization, and troubleshooting for slow-running SQLs. Establish and enforce database access controls, user roles, and data protection protocols. Migrate legacy databases (e.g., Oracle, MySQL) to PostgreSQL when required. Provide mentorship to developers and DBAs on PostgreSQL usage and tuning Preferred candidate profile Proven experience with high-availability architecture (Patroni, Streaming Replication, etc.). Strong expertise in performance tuning, indexing strategies, and complex query analysis. Familiarity with JSONB, GIS data types, full-text search, and PostgreSQL extensions. Experience in Linux-based environments (preferably Ubuntu/CentOS/RHEL). Experience in designing databases for microservices and event-driven architectures. Knowledge of PostgreSQL monitoring tools (pgAdmin, pg_stat_statements, Prometheus, etc.). Hands-on experience with database automation and DevOps pipelines. Experience in database security, encryption, auditing, and compliance. Experience in cloud-native PostgreSQL deployments (e.g., AWS RDS/Aurora, GCP Cloud SQL, Azure Database for PostgreSQL). Certification in PostgreSQL or relevant database technologies. Experience with NoSQL integrations or hybrid data architectures.