Signature IT World Inc
PostgreSQL Database Engineer
⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a PostgreSQL Database Engineer on a contract basis, offering a competitive pay rate. Key skills required include advanced PostgreSQL administration, SQL programming, performance tuning, and Linux scripting. Experience with Python, Go, Java, or Node.js is essential.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
Unknown
-
🗓️ - Date
July 25, 2026
🕒 - Duration
Unknown
-
🏝️ - Location
Unknown
-
📄 - Contract
Unknown
-
🔒 - Security
Unknown
-
📍 - Location detailed
Austin, TX
-
🧠 - Skills detailed
#GIT #Version Control #Databases #Scripting #Linux #Java #Triggers #Migration #Programming #Database Performance #Database Design #Indexing #PostgreSQL #SQL Queries #Python #Replication #Security #Shell Scripting #Database Migration #DevOps #Database Schema #SQL (Structured Query Language)
Role description
A typical PostgreSQL Database Engineer job description includes the following responsibilities and skills:
Responsibilities
• Design, develop, and maintain PostgreSQL databases for production applications.
• Create and optimize database schemas, tables, indexes, constraints, and partitions.
• Write efficient SQL queries, stored procedures, functions (PL/pgSQL), and triggers.
• Monitor and tune database performance using query analysis and indexing strategies.
• Configure replication, backup, recovery, and high-availability solutions.
• Perform database migrations, upgrades, and patching.
• Troubleshoot production issues and ensure database reliability and security.
• Collaborate with backend developers, DevOps, and SRE teams on application integration and database design.
Required Skills
• Strong experience with PostgreSQL administration and development.
• Advanced SQL and PL/pgSQL programming.
• Query optimization and performance tuning using EXPLAIN/EXPLAIN ANALYZE.
• Indexing techniques (B-tree, GIN, GiST, BRIN, Hash).
• Backup and recovery tools (pg_dump, pg_restore, PITR).
• Replication (Streaming Replication, Logical Replication).
• Linux administration and shell scripting.
• Experience with Python, Go, Java, or Node.js for database integration.
• Version control (Git).
A typical PostgreSQL Database Engineer job description includes the following responsibilities and skills:
Responsibilities
• Design, develop, and maintain PostgreSQL databases for production applications.
• Create and optimize database schemas, tables, indexes, constraints, and partitions.
• Write efficient SQL queries, stored procedures, functions (PL/pgSQL), and triggers.
• Monitor and tune database performance using query analysis and indexing strategies.
• Configure replication, backup, recovery, and high-availability solutions.
• Perform database migrations, upgrades, and patching.
• Troubleshoot production issues and ensure database reliability and security.
• Collaborate with backend developers, DevOps, and SRE teams on application integration and database design.
Required Skills
• Strong experience with PostgreSQL administration and development.
• Advanced SQL and PL/pgSQL programming.
• Query optimization and performance tuning using EXPLAIN/EXPLAIN ANALYZE.
• Indexing techniques (B-tree, GIN, GiST, BRIN, Hash).
• Backup and recovery tools (pg_dump, pg_restore, PITR).
• Replication (Streaming Replication, Logical Replication).
• Linux administration and shell scripting.
• Experience with Python, Go, Java, or Node.js for database integration.
• Version control (Git).
