Description

Design, develop, and manage production-grade PostgreSQL systems for a Texas-based role.

Responsibilities

• Design and develop PostgreSQL systems including data modeling, tables, views, indexes, and configuration parameters.
• Manage high availability, backup strategies, recovery, patching, and database migrations.
• Optimize large, complex SQL statements, stored procedures, functions, joins, and subqueries.
• Execute ETL mapping conversions from Oracle to PostgreSQL.
• Ensure database performance, security, and availability through proactive tuning and partitioning.

Required Skills

• 10+ years of experience in PostgreSQL Administration.
• In-depth hands-on experience with PostgreSQL DBA activities.
• Expertise in PostgreSQL SQL and PL/pgSQL coding.
• Deep knowledge of PostgreSQL High Availability solutions.
• Proven ability in performance tuning and SQL query optimization.
• Experience implementing table partitions.
• Strong understanding of relational database best practices.
• Ability to handle database upgrades and recovery procedures.

Preferred Skills

• Experience with Oracle to PostgreSQL migrations.

Key Skills

Education

Any Graduate