Description

You will architect and implement highly available, scalable, and secure PostgreSQL database solutions.

This role is hybrid.

Responsibilities

• Design and optimize database schemas, indexing strategies, and partitioning techniques to enhance performance.
• Manage PostgreSQL installations, configurations, upgrades, and patching.
• Implement high availability and disaster recovery strategies, including replication, failover, and backup protocols.
• Lead complex database migrations from Oracle, MySQL, or SQL Server to PostgreSQL.
• Enforce database security through encryption, role-based access control (RBAC), and auditing to maintain GDPR, HIPAA, and PCI-DSS compliance.

Required Skills

• 5+ years of experience in database architecture and administration.
• Expertise in PostgreSQL database management and performance tuning.
• Hands-on experience with Oracle, MySQL, or SQL Server migration projects.
• Proficiency with AWS, Azure, or GCP cloud environments.
• Experience managing PostgreSQL on RDS, Aurora, or self-managed instances.
• Ability to perform query optimization, indexing, and partitioning.
• Knowledge of implementing high availability and disaster recovery.
• Experience with security assessments, vulnerability analysis, and penetration testing.
• Familiarity with monitoring tools such as pgAdmin, Nagios, or Prometheus.

Key Skills

Education

Any Gradute