Database Architect PostgreSQL

As a seasoned Database Architect specializing in PostgreSQL, your main role will be to lead enterprise-level database design, optimization, and performance engineering. You should have extensive experience in architecting and managing large-scale, mission-critical database systems with high performance, scalability, and security standards. - **Database Architecture & Design** - Architect and design scalable PostgreSQL database solutions for enterprise-grade applications. - Develop database strategies for data modeling, storage, and performance optimization. - Define database design standards, documentation, and governance models. - **Performance & Optimization** - Conduct query tuning, indexing strategies, and database optimization for large datasets. - Establish monitoring, alerting, and capacity planning mechanisms. - Optimize schema design and database operations for performance and scalability. - **Data Management & Security** - Implement high-availability and disaster recovery (HA/DR) solutions. - Manage data replication, partitioning, and clustering. - Enforce database security, access control, and compliance policies. - **Leadership & Collaboration** - Mentor DBA and developer teams in best practices. - Collaborate with development, DevOps, and cloud teams on architecture and deployment. - Lead database migration and modernization initiatives. **Qualifications Required:** - 15-20 years of overall IT experience with 10+ years in database architecture and PostgreSQL. - Deep expertise in PostgreSQL internals, replication, partitioning, and performance tuning. - Strong knowledge of database design patterns, data modeling, and normalization. - Hands-on experience with cloud-based PostgreSQL (AWS RDS, Azure Database, or GCP SQL). - Advanced understanding of HA/DR tools (Patroni, Pgpool-II, repmgr). - Proficiency in SQL, PL/pgSQL, and scripting (Bash/Python). - Experience in data governance, audit compliance, and large-scale data environments. - Excellent leadership, communication, and documentation skills.,