Description

Manage and optimize PostgreSQL database environments to ensure maximum performance, security, and availability.

This role is on-site.

Responsibilities

• Manage PostgreSQL database administration, including upgrades, patching, recovery, and migrations.
• Implement and maintain high availability solutions and backup strategies for production databases.
• Design and develop PostgreSQL systems, including data modeling, tables, views, indexes, and configuration parameters.
• Optimize large, complex SQL statements, stored procedures, functions, joins, and subqueries.
• Execute ETL mapping conversions from Oracle to PostgreSQL.

Required Skills

• 10+ years of experience in PostgreSQL Administration.
• Extensive experience in PostgreSQL SQL and PL/SQL (PG/PLSQL) coding.
• Expertise in PostgreSQL performance tuning and query optimization.
• Hands-on experience with table partitioning.
• Proven ability to manage high availability and production backup strategies.
• Experience with ETL processes and Oracle to PostgreSQL conversions.
• Strong knowledge of relational database best practices.

Key Skills

Education

Any graduate