Description

You will lead the design, implementation, and management of high-availability PostgreSQL database environments.

This role is remote.

Responsibilities

• Design and develop PostgreSQL systems, including data modeling, tables, views, indexes, and configuration parameters.
• Manage database lifecycle operations including upgrades, patching, recovery, and migrations.
• Optimize performance by tuning complex SQL statements, stored procedures, functions, joins, and subqueries.
• Implement and maintain high availability solutions, backup strategies, and table partitioning to ensure data security and availability.
• Execute ETL mapping conversions from Oracle to PostgreSQL.

Required Skills

• 10+ years of experience in PostgreSQL Administration.
• Extensive experience with PostgreSQL SQL and PL/pgSQL coding.
• Hands-on expertise in PostgreSQL high availability solutions and production backup strategies.
• Deep knowledge of performance tuning for large, complicated SQL statements.
• Proven ability in data modeling and relational database best practices.
• Experience with ETL mappings and Oracle to PostgreSQL conversions.
• Strong analytical skills for designing, creating, and testing database programs.

Preferred Skills

• Ability to provide technical guidance and expertise to team members and management.

Key Skills

Education

Any Graduate