AddressSBCS India Pvt. Ltd is a leading global design & solution architecture firm that delivers deep expertise, objective insights, a tailored approach, and unparalleled collaboration to help leaders confidently face the future.
We are looking for Oracle Apps DBA (7+ hands on) -Pan India Loc with below mentioned skill sets and can join us immediately to 15 days.
Job Description:
- Must have minimum 7 years hands on experience in Oracle Apps DBA , experiencing in implementation, support, administrator and upgrade database version 12c and 19c.
- Support multiple instances (Production, Test, QA and Development ) of Oracle EBS 12.1.3 & R12.2
- Support and implement high availability environment using Oracle Real Application Clustering, Data Guard, RMAN, Parallel Concurrent Processing, ASM, OEM, Diagnostics, Tuning, Configuration and Provisioning Pack
- Ensure enterprise database environments are in optimal condition, manage production databases in Client environments, and support complex problem-solving challenges.
- Improve the quality and reduce defects in all database environments and Application server environments by providing performance and tuning.
- Perform backup and recovery procedures using RMAN.
- Follow back up procedures to ensure the recoverability of all production data for operational and business continuation needs.
- Provide Level 3 application database administration production support to resolve complex problems and change requests
- Communicate, manage and monitor production Service Level Agreements (SLA) with local and remote users
- Ensure sound database definitions, structures and documentation
- Must have good communication and collaboration skills
- Experienced in Golden Gate
- Experienced in Oracle RAC
- Experience in MongoDB Admin and/or Hadoop Admin is an added advantage.
- Fluency in Bash/Ksh shell scripting/Python scripting and experience in using it with RDBMS & N-Sql databases.
- Proven expertise in tuning Oracle for high transaction, multi-TB sized Databases.
- Proven expertise in optimization of Oracle SQL Queries.
- Thorough knowledge of Oracle Optimizer and clear understanding of Oracle architecture.
- Sound knowledge of business application development and support.
- Knowledge of Oracle Apps and Web Apps architecture is a big plus.
- Oracle management tools (Data Guard, RMAN, Data pump).
- Architecture design principles.
- Good problem solver, focused and dedicated developer with ability to work on your own as well as with team.
- Hands on experience with DB standards and end user applications-translating capacity requirements into infrastructure deployment technology.
- Strong practical experience of ORACLE in a production RAC (ASM) environment.
- Must be a self-starter with a strong attention to detail.
- Experience with an organization with a key reliance on 24x7 reliability on its database
