PostgreSQL DBA Architect

Position: PostgreSQL DBA Architect

Location: Pasadena, CA (Only Locals)

Job type: Contract

Key Responsibilities:

Database Architecture & Design: Architect and implement

highly available, scalable, and secure

PostgreSQL database solutions. Design and optimize

database schemas, indexing strategies, and partitioning techniques

for performance enhancement. Define

best practices, standards, and governance

for database architecture and administration. Database Administration & Performance Tuning:

Perform

installation, configuration, upgrades, and patching

of PostgreSQL databases. Conduct

performance tuning, query optimization, indexing, and partitioning . Implement and manage

high availability (HA) and disaster recovery (DR) strategies

(e.g., replication, failover, and backup strategies). Monitor and analyze database health using tools such as

pgAdmin, Nagios, or Prometheus . Migration & Cloud Integration:

Lead complex

database migration projects

from Oracle, MySQL, or SQL Server to PostgreSQL. Work with

cloud platforms (AWS, Azure, GCP)

and implement PostgreSQL on

RDS, Aurora, or self-managed instances . Design and implement

cloud-native database solutions

using PostgreSQL. Security & Compliance:

Ensure database security by implementing

encryption, role-based access control (RBAC), and auditing . Maintain compliance with

industry standards (e.g., GDPR, HIPAA, PCI-DSS) . Conduct regular

security assessments, vulnerability analysis, and penetration testing

for database systems.