PostgreSQL Database Engineer
Signature IT World Inc · Austin, TX · 1 mo ago
HybridInformation TechnologyContract
About the role
We are seeking a PostgreSQL Database Engineer to design, develop, and maintain PostgreSQL databases for our production applications.
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.
Requirements
- 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).