Oracle DBA with PostgreSQL

Signature IT World Inc; Austin (TX); On-site; USD 120,000 - 160,000; Full time

Job summary

Signature IT World Inc in Austin seeks an Oracle DBA with PostgreSQL Engineer to design, develop, and maintain PostgreSQL databases for production applications. You will optimize schemas, create partitions, and write efficient SQL, while ensuring reliability and security.

Collaborate with backend developers, DevOps, and SRE teams to integrate databases with applications, perform migrations, backups, and patching, and tune performance using EXPLAIN ANALYZE and indexing strategies.

Qualifications

• Experienced PostgreSQL administrator and developer.
• Advanced SQL and PLpgSQL programming.
• Proficient in query optimization and performance tuning with EXPLAIN ANALYZE.

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, 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 integration and design.

Skills

PostgreSQL administration

SQL / PLpgSQL

Query optimization

Indexing techniques

Backup & recovery

Replication

Linux admin & shell scripting

Database integration (Python/Go/Java/N

Tools

pg_dump

pg_restore

PITR

Streaming Replication

Logical Replication

EXPLAIN ANALYZE

EXPLAIN

Job description

A typical Oracle DBA with PostgreSQL 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.