Database Administrator (Oracle/Postgres/AWS)

SBS Creatix; United States; Remoto; USD 120.000 - 180.000; Tempo pieno

Descrizione del lavoro

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.

Competenze

• 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).

Mansioni

• 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.

Conoscenze

Oracle DB

PostgreSQL

SQL tuning

PL/SQL

PL/pgSQL

AWS

RMAN

OEM

SQL reports

UNIX shell

Strumenti

Oracle RMAN

Oracle OEM

UNIX shell

Descrizione del lavoro

Fully Remote- Local candidates preferred

Responsibilities

• Find poorly performing SQL and recommend or make query and database-level improvements
• 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

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
• A 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 (business hours are 7am to 7pm Central)

Preferred Qualifications

• Oracle ASM experience
• Exposure to vector databases
• Strong customer service and problem-solving skills
• Highly organized and detail-oriented, with clear written and verbal communication, including documentation