PostgreSQL DBA Architect
Position: PostgreSQL DBA ArchitectLocation: Pasadena, CA (Only Locals)
Job type: ContractKey Responsibilities:
Database Architecture & Design:
Architect and implementhighly available, scalable, and securePostgreSQL database solutions.
Design and optimizedatabase schemas, indexing strategies, and partitioning techniquesfor performance enhancement.
Definebest practices, standards, and governancefor database architecture and administration.
Database Administration & Performance Tuning: Performinstallation, configuration, upgrades, and patchingof PostgreSQL databases.
Conductperformance tuning, query optimization, indexing, and partitioning.
Implement and managehigh availability (HA) and disaster recovery (DR) strategies(e.g., replication, failover, and backup strategies).
Monitor and analyze database health using tools such aspgAdmin, Nagios, or Prometheus.
Migration & Cloud Integration: Lead complexdatabase migration projectsfrom Oracle, MySQL, or SQL Server to PostgreSQL.
Work withcloud platforms (AWS, Azure, GCP)and implement PostgreSQL onRDS, Aurora, or self-managed instances.
Design and implementcloud-native database solutionsusing PostgreSQL.
Security & Compliance: Ensure database security by implementingencryption, role-based access control (RBAC), and auditing.
Maintain compliance withindustry standards (e.g., GDPR, HIPAA, PCI-DSS).
Conduct regularsecurity assessments, vulnerability analysis, and penetration testingfor database systems.