Description

Lead PostgreSQL development and administration for mission-critical databases.

Responsibilities

• Optimize database performance through advanced indexing, query fine-tuning, and rewriting complex joins.
• Manage incident and problem management duties, including troubleshooting and security patching.
• Design and implement disaster recovery strategies and conduct regular DR availability practice tests.
• Configure and maintain high-availability architectures using clustering, mirroring, log shipping, and replication.
• Model PostgreSQL schemas and implement complex workflows and scheduled jobs.

Required Skills

• 8+ years of experience in PostgreSQL development and administration.
• Expertise in RDBMS administration, security, and performance tuning.
• Deep knowledge of complex joins, indexing, and query optimization.
• Experience implementing high-availability concepts such as clustering and replication.
• Proven ability to manage security updates, patches, and hotfixes.
• Strong communication skills for interacting with technical peers and executives in the US and India.
• Experience managing mission-critical database disaster recovery.
• Degree in any graduate field.

Key Skills

Education

ANY GRADUATE