24/7 Oracle & PostgreSQL DBA – Production Support

Yochana IT Solutions Inc.; Atlanta (GA); On-site; USD 90,000 - 130,000; Full time

Benefits offered by this job

Benefits

24x7 shift coverage

Job summary

Yochana IT Solutions Inc. is seeking a hands-on Oracle DBA with PostgreSQL experience to join our 24x7 operations team in Atlanta. The role involves production and pre-production support, backups, maintenance, and performance monitoring.

You will work in a rotating shift pattern and collaborate with L3 DBAs to resolve escalations. Ideal candidates have strong experience in RMAN, health checks, and ITSM processes using ServiceNow, ensuring high availability and data integrity across Oracle

Qualifications

• Experience as Oracle DBA in production/pre-production environments.
• Proficient in RMAN backups, restores and validation.
• Knowledge of Oracle maintenance tasks and optimizer statistics.
• Ability to diagnose Oracle performance issues and monitor resources.
• Familiarity with ITSM processes using ServiceNow.
• Ability to work in 24x7 rotational shifts.

Responsibilities

• Assist in daily Oracle DB operations in production/pre-prod environments.
• Execute and validate RMAN backups, perform restores under supervision.
• Carry out preventive maintenance and health checks on Oracle databases.
• Monitor tablespace usage and growth trends; flag risks for escalation.
• Identify slow SQL and monitor CPU, memory, I/O utilization at a high level.
• Follow runbooks for patching, parameter changes, and controlled restarts.
• Log and track incidents/tickets in ServiceNow; coordinate with L3 DBAs.
• Provide escalation with logs and evidence to L3 Oracle DBAs.

Skills

Oracle DBA

PostgreSQL

RMAN backups

Health checks

Performance monitoring

Incident management

ServiceNow ITSM

24x7 support

Tools

Oracle SQL Developer

Oracle Enterprise Manager

Job description

Yochana IT Solutions Inc. is seeking a hands-on Oracle DBA with PostgreSQL experience to join our 24x7 operations team in Atlanta. The role involves production and pre-production support, backups, maintenance, and performance monitoring.

You will work in a rotating shift pattern and collaborate with L3 DBAs to resolve escalations. Ideal candidates have strong experience in RMAN, health checks, and ITSM processes using ServiceNow, ensuring high availability and data integrity across Oracle