We are seeking a highly skilled Senior PostgreSQL Architect to design, implement, and maintain scalable, secure, and efficient database solutions. This role involves leading database architecture strategy, optimizing performance, ensuring data security, and collaborating across teams to support business needs. The ideal candidate has extensive expertise in PostgreSQL, database design principles, and a strong understanding of cloud-based and on-premises environments.
Key Responsibilities:
1. Database Architecture and Design: • Design and implement scalable, high-performance PostgreSQL database architectures. • Develop schema designs that balance performance, scalability, and reliability. • Ensure database solutions align with business goals and technical requirements.
2. Performance Tuning and Optimization: • Analyze and optimize complex SQL queries, indexes, and database performance. • Identify and resolve performance bottlenecks in existing systems. • Implement partitioning, sharding, and other techniques to handle large-scale data sets.
3. Database Security and Compliance: • Ensure compliance with security standards and data protection regulations. • Implement database access controls, encryption, and backup strategies. • Perform regular security audits and vulnerability assessments.
4. Cloud Integration and Management: • Design and manage PostgreSQL databases in cloud environments (AWS, Azure, GCP). • Leverage cloud-native tools for scaling, monitoring, and disaster recovery.
5. Team Leadership and Collaboration: • Collaborate with development teams to design and implement database solutions. • Provide guidance and mentorship to junior database engineers and administrators. • Work closely with DevOps teams to automate database deployment and maintenance.
6. Documentation and Best Practices: • Develop and maintain comprehensive database documentation. • Promote best practices in database development and management.
Qualifications:
Education:Bachelor's or Master's degree in Computer Science, Information Systems, or a related field.
Experience:
8+ years of experience in database architecture, with a focus on PostgreSQL.
Proven expertise in designing and managing large-scale PostgreSQL databases.
Experience in cloud-based database management and tools (AWS RDS, Aurora, etc.).
Technical Skills:
Deep understanding of PostgreSQL internals, performance tuning, and optimization.
Proficient in SQL, PL/pgSQL, and database modeling.
Familiarity with tools like pgAdmin, pgBouncer, and replication techniques.
Experience with ETL processes and integrating PostgreSQL with data pipelines.
Knowledge of high availability, clustering, and disaster recovery solutions.
Soft Skills:
Strong problem-solving skills and attention to detail.
Excellent communication and ability to translate technical concepts to stakeholders.
Leadership and mentoring experience in a technical setting.
Preferred Qualifications: • Experience with NoSQL and hybrid database solutions. • Certifications in PostgreSQL or cloud platforms (e.g., AWS Certified Database - Specialty). • Knowledge of containerization (Docker, Kubernetes) and Infrastructure-as-Code tools.