Remote Oracle/Postgres DBA (AWS) — On-Call

SBS Creatix LLC; United States; Remote; USD 120,000 - 180,000; Full time

Job summary

SBS Creatix LLC is seeking an experienced Oracle DBA to maintain production and non-prod databases, write efficient SQL, and design data dictionaries. This fully remote role welcomes candidates across the United States.

The ideal candidate will have strong SQL/PLSQL skills, hands-on Oracle and Postgres, AWS cloud database experience, and comfort with on-call rotations and production releases. Strong documentation and troubleshooting abilities are required.

Qualifications

• 3+ years of Oracle database development and administration in a fast-moving production environment.
• Hands-on experience with Oracle and Postgres.
• Cloud database experience on AWS (Postgres, Snowflake, and/or DynamoDB).
• Expert-level SQL tuning and query plan optimization.
• Development mindset with strong SQL, PL/SQL, and PL/pgSQL skills.
• Experience with backup and recovery using Oracle RMAN.
• Experience with Oracle Enterprise Manager (OEM).
• Experience building and maintaining SQL reports and UNIX shell scripts.
• Willingness to join the on-call rotation, including after-hours coverage (7am–7pm Central).

Responsibilities

• Find poorly performing SQL and optimize queries and database design.
• Design, develop, test, implement, maintain, and document production and non-prod databases and data dictionaries.
• Support application releases, including SQL changes tied to each release.
• Work a queue of data-change tickets submitted by tier support.
• Monitor daily database activity, including performance, tuning, growth, patching, and security configurations.
• Handle routine operational work like job dispatching, backup and recovery, and disk storage allocation.
• Take part in an on-call rotation (about 1 week in 7), plus night and weekend maintenance as needed.

Skills

Oracle DB

PostgreSQL

SQL tuning

PL/SQL

PL/pgSQL

AWS

RMAN

OEM

SQL reports

UNIX shell

Tools

Oracle RMAN

Oracle OEM

UNIX shell

Job description

SBS Creatix LLC is seeking an experienced Oracle DBA to maintain production and non-prod databases, write efficient SQL, and design data dictionaries. This fully remote role welcomes candidates across the United States.

The ideal candidate will have strong SQL/PLSQL skills, hands-on Oracle and Postgres, AWS cloud database experience, and comfort with on-call rotations and production releases. Strong documentation and troubleshooting abilities are required.