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. Equiliem