Oracle Database Administrator

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

Support Model: 24/7 Operations

Job Type: Full Time with Benefits

Skills and Experience: Candidate must have the Oracle dba and Postgre (Mandatory)

• Hands on experience assisting in the administration of Oracle databases in production or pre-production environments, including basic instance startup/shutdown and routine operational tasks under guidance.
• Working knowledge of Oracle backup and recovery fundamentals, including RMAN backup execution, restore operations under supervision, and validation of backup success.
• Familiarity with Oracle preventive maintenance activities, including optimizer statistics gathering, basic health checks, and execution of scheduled maintenance tasks.
• Ability to perform basic Oracle health diagnostics, including monitoring tablespace usage, identifying storage growth trends, and flagging common availability risks for escalation.
• Basic exposure to Oracle performance monitoring, including identifying slow SQL, observing wait events at a high level, and monitoring CPU, memory, and I/O utilization.
• Ability to follow approved runbooks and procedures to support Oracle changes such as patching assistance, parameter updates, and controlled restarts with supervision.
• Working understanding of ITSM processes using ServiceNow, including logging, updating, and tracking Incident and Request tickets with proper documentation.
• Experience supporting request fulfillment activities, such as access changes, schema refresh support, and routine operational requests using defined processes.
• Familiarity with Oracle administration tools, such as Oracle SQL Developer and basic exposure to Oracle Enterprise Manager for daily monitoring activities.
• Demonstrated ability to escalation issues promptly and accurately to L3 Oracle DBAs with relevant logs, observations, and collected evidence.
• This role requires providing 24x7 operational support and working in rotational shifts

Recommended Certifications