JRD Systems
Website:
jrdsi.com
Job details:
Job Description – Database Architect (PostgreSQL & Cloud Architecture)
Overview
We are seeking an experienced Database Architect to design, develop, and maintain scalable, secure, high-performing, and maintainable database architectures that support current and future business needs for enterprise web applications and cloud-native platforms.
The ideal candidate will possess deep expertise in PostgreSQL database architecture, data modeling, performance optimization, scalability, high availability, security, and cloud-native database solution. This role will be responsible for designing enterprise-grade database systems with strong focus on data integrity, reliability, governance, disaster recovery, and modern web application architectures within GCP and cloud environments.
The Database Architect will collaborate closely with application architects, development team, DevOps engineer, and business stakeholders to deliver highly scalable and resilient database solution for mission-critical applications.
Key Responsibilities
- Design and implement scalable, secure, and high-performance PostgreSQL database architectures for enterprise web applications and cloud-native systems.
- Develop logical and physical database models, including relational schema design, normalization/denormalization strategies, indexing, partitioning, and data integrity enforcement.
- Architect highly available and fault-tolerant database environments using replication, clustering, failover, backup, and disaster recovery strategies.
- Optimize database performance through query tuning, indexing strategies, caching mechanisms, connection pooling, and workload optimization.
- Ensure data consistency, transactional integrity, and concurrency management using PostgreSQL best practices and ACID-compliant designs.
- Design and implement scalable database solutions supporting high-concurrency web applications and microservices-based architectures.
- Establish security, governance, and compliance frameworks including RBAC, encryption, masking, audit logging, GDPR/CCPA compliance, and secure access controls.
- Collaborate with DevOps team to implement CI/CD pipelines, Infrastructure-as-Code (IaC), automated deployments, and database version control.
- Implement backup, recovery, and disaster recovery solutions including Point-in-Time Recovery (PITR), replication recovery, and business continuity planning.
- Support cloud-native architectures and deployments on GCP and hybrid cloud environments.
- Design monitoring, observability, alerting, and database health management solutions for production systems.
- Work closely with application teams to optimize API/database interactions, ORM usage, transaction boundaries, and distributed system integrations.
Technical Environment
Database Technologies
- PostgreSQL
- PostgreSQL Replication & High Availability
- Google Cloud Platform (GCP)
- Cloud SQL for PostgreSQL
- GCP Networking & Security Services
- Database Normalization & Denormalization
- Scalability & High Availability Design
- Query Tuning and Indexing Strategies
- Database Monitoring & Observability
- Caching & Performance Engineering
- GitHub Actions and Docker / Kubernetes
- Backup & Disaster Recovery
- PostgreSQL Monitoring Tools
- Alerting & Logging Frameworks
Required Qualifications
- 10+ years of experience in Database Architecture, Database Engineering, or Enterprise Application Data Design.
- Strong hands-on expertise in PostgreSQL database design, administration, and performance optimization.
- Deep understanding of relational database concepts, schema design, normalization, indexing, partitioning, and query optimization.
- Proven experience designing scalable, highly available, and secure database architectures for enterprise web applications.
- Hands-on experience with PostgreSQL replication, failover strategies, backup/recovery, and disaster recovery planning.
- Strong understanding of database security, governance, compliance, and data integrity frameworks.
- Experience with GCP cloud services and cloud-native database deployments.
- Experience supporting microservices architectures, distributed systems, and modern web application platforms.
- Hands-on experience with CI/CD pipelines, Infrastructure-as-Code, and DevOps practices for database deployments.
- Strong problem-solving, communication, stakeholder management, and architectural leadership skills.
Preferred Qualifications
- Bachelor’s degree in Computer Science, Information Systems, or related field.
- GCP Cloud Certification or PostgreSQL Certification preferred.
- Experience with containerized deployments using Docker and Kubernetes.
- Familiarity with event-driven architectures, Kafka, or real-time streaming systems.
- Experience implementing enterprise-scale monitoring, observability, and database governance solutions.
- Strong understanding of modern cloud security and Zero Trust architecture principles.
Click on Apply to know more.