Senior Oracle DBA

  • Westlake, TX
  • Posted 37 days ago | Updated 9 days ago

Overview

On Site
$110,000 - $115,000
Full Time

Skills

SQL
PL/SQL
Oracle 12c
Oracle DB
Shell Scripting

Job Details

Role:- Senior Oracle DBA
Type:- FTE
Location:- Westlake, TX/ Southlake, TX (Onsite)
Salary:- $110 to $115K

Technical Skills:

  • Seven or more years of experience in database Operational experience using Oracle 12c R1 and 19c versions.
  • Strong experience in oracle DB related consultancy & procedure
  • Expert /well versed with Oracle DB architecture.
  • Strong performance tuning skills in a very large database environment.
  • Proactively monitoring the database's health and taking preventive or corrective action as required
  • Experience in Manage/co-ordinate in User Role and Privileges and provide report for Database Audit
  • Real time exposure on High availability in Oracle Environment RAC, Data guard, Clustering, Golden Gate, ASM, Replication
  • Should have worked on Disaster Recovery Plan, Shell Scripting knowledge, Database Migration / Upgrades
  • Troubleshooting knowledge on SQL, PL/SQL programs, Packages, Stored procedures, Functions and Triggers to automate the interface processes for daily/incremental loads.
  • Ability to use SQL Trace and AWR reports to analyze results, then to recommend options for problem resolution.
  • Expert level knowledge in writing/troubleshooting PL/SQL queries, shell scripting.
  • Strong experience with Oracle RMAN backup/recovery methodologies.
  • Must be able to organize work efficiently and work well under stress, changing priorities, and time constraints.
  • Familiarity with Splunk and Fog light tools /OEM tools
  • Should be able to guide /recommend DB developers as needed.
  • Co-ordinate with I&O DB team for any DR activity, patching, performance issues etc..
  • Lead and co-ordinate with various Infra and Apps teams during Techlines or any major releases.
  • Should act as point of contact for any DB related information from an Apps perspective. ( go to guy for any DB related info for developers)
  • Recommend database tuning and performance monitoring as needed.
  • Perform general technical trouble shooting and give consultation to development teams
  • Assist developers with database activities.
  • Troubleshooting and monitoring of any Apps specific batch jobs , services etc..
  • Experience with Linux/Unix/AIX operating systems

Thanks