Below is the job description for the position:

Job Title: Senior Oracle DBA

Location: Downey, California (Onsite)

Duration: 6+ Months (with Possible extension)

Minimum Qualifications

• 7+ years of experience as an Oracle Database Administrator with demonstrated expertise in Oracle 19c in a multitenant architecture (CDB/PDB).
• Proven experience performing hardware refreshes, including database migration and reconfiguration across environments.
• Implement Oracle DataGuard configuration using Active DataGuard and Physical Standby
• Hands-on experience with Oracle Enterprise Manager (OEM), including upgrade and configuration—must have completed or supported upgrade to OEM 24AI or similar recent version.
• Experience configuring Active Directory (AD) Authentication for Oracle databases using tools like Oracle Directory Services or Kerberos.
• Strong skills in performance monitoring and troubleshooting, including use of AWR/ASH reports, SQL tuning, and diagnostics tools.
• Solid understanding of Oracle backup and recovery (RMAN/Data Pump), patching, and high availability configurations (e.g., Data Guard, RAC is a plus).
• Proficient in Linux/Unix environments, including shell scripting and automation tools.

Environment & Workload Assessment

• Analyze current Oracle 19c database workloads with emphasis on I/O-intensive SQL queries and large tables.
• Review execution plans, table/index statistics, and storage usage.
• Identify performance bottlenecks due to full table scans, large table joins, and high-latency disk operations.

Thanks & Regards

Infojini Consulting

Website: https://www.infojiniconsulting.com

Address: 10015 Old Columbia Road, Suite B 215, Columbia, MD 21046