Job Description :

Role: SR. ORACLE OPS DBA
Location: Westlake, TX (Onsite)
Hire Type: Fulltime
Must-Have: DB from On-prem AWS migration exp, Oracle 19c, Data Guard - FSFO (Fast-Start Failover), DR solutions, container databases, GitHub.
Need a write-up/answer on the below pointers -

  • Please describe your experience with DB migration from On-Prem to AWS cloud.
  • Please describe your Experience in DR solutions.
  • Please describe your Experience in container databases.
  • What is the DB Size managed at an enterprise level?
  • How soon you can start upon Offer acceptance?


Job Description
Who are we looking for?
A mid-senior level Oracle DB Ops lead for managing a critical project for one of our biggest clients in BFSI domain. The Individual should be passionate about technology, experienced in developing and managing cutting edge technology applications.
Technical Skills:

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


Other Skills requirement:

  • Responsible for planning and designing Oracle database specifications, understanding database definition, structure, etc.
  • Support customer troubleshooting and problem-solving during data verification.
  • Define, track, and maintain standard baselines and configuration sets of all managed and/or monitored database instances.
  • Performance problem identification and resolution assistance
  • Data security and recovery
  • Data and database health practices
  • Participate in currency patching ( OS & DB patch) and System capacity planning.
  • Familiar with Aduit and compliance guidelines and procedures.
  • Having sound knowledge of ITIL practices like Change Management, Incident Management etc.
  • Develop and maintain storage strategies, establishing system documentation and database recovery processing.
  • Identify and initiate resolutions to user problems associated with database performance and database capacity, utilizing best practices to maximize up time and server utilization.
  • Review and deploy the database components for new versions of web applications/products to test and production environments using release management practices.
  • Willingness to provide support in non-business hours, weekend bi-weekly on-call rotation for support.
    Responsible for DR tests on regular basis.


Behavioral Skills :

  • Must have superior problem-solving skills with extremely high levels of initiative and assertiveness.
  • Effective interpersonal, team building and communication skills.


Qualification:

  • Bachelor s degree preferably in Computer Science or Information Systems and /or equivalent formal training or work experience.
  • 7-10 years of relevant experience in relational database management systems..


Client : Tanisha Systems

             

Similar Jobs you may be interested in ..