PostgreSQL & Oracle DBA — High-Performance DB Engineer

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

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.