Description

You will own the development and administration of mission-critical PostgreSQL databases. This role is on-site.

Responsibilities

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

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.
• Experience managing mission-critical database disaster recovery.
• Strong communication skills for interacting with technical peers and executives in the US and India.
• Degree in any graduate field.

Key Skills

Education

ANY GRADUATE