Job Title
We are seeking a skilled Senior PostgreSQL Database Architect to design, optimize and maintain database platforms while contributing to backend application development.
This is a hands-on engineering role requiring expertise in both database operations and software development with a focus on scalability, performance and reliability.
Key Responsibilities:
* Design and implement scalable PostgreSQL database architectures for high availability partitioning replication and disaster recovery.
* Analyze and optimize complex queries indexing strategies and database configurations.
* Monitor performance and proactively address bottlenecks in queries and application data flows.
* Implement strong security standards including role-based access control encryption and security best practices and ensure compliance with organizational and regulatory requirements.
Software Development & Automation:
* Develop tools scripts and services to automate database provisioning monitoring backups migrations and deployments.
* Write backend services or APIs that integrate with PostgreSQL for application use cases.
* Implement PL/pgSQL functions triggers and procedures to support business logic.
Reliability Security & Compliance:
* Implement robust database security policies encryption and role-based access controls.
* Design and maintain high availability and disaster recovery strategies.
* Ensure compliance with industry regulations and internal security standards.
Collaboration & Leadership:
* Mentor developers and junior database engineers on SQL optimization schema design and performance tuning.
* Work closely with DevOps/SRE teams on CI/CD pipelines for database changes.
* Participate in incident response and root cause analysis for production database issues.
Required Qualifications:
* 7+ years of professional experience with PostgreSQL in large-scale production environments.
* Strong SQL and PL/pgSQL skills with a deep understanding of PostgreSQL internals.
* Proven experience in software development expert level C/C++ Python Go or Java.
Preferred Qualifications:
* Experience with microservices and REST API development.
* Familiarity with message queues event-driven architectures or streaming platforms.
Soft Skills:
* Strong analytical thinking and problem-solving skills.
* Excellent communication and cross-team collaboration abilities.