Oracle Database

Makati, National Capital Region

Posted 28 days ago


Company:: Nityo Infotech
Company Description:: Nityo is a global provider of IT services and end-to-end solutions designed to help clients improve their competitiveness and efficiency. Nityo has operations in 11 countries across the Globe (North America, Canada, United Kingdom, South Africa, Australia, Japan, Singapore, India, Malaysia, Thailand and Philippines). Its portfolio of solutions and services would include: Outsourcing; System Integration; Application Software Development; Consulting; Quality Assurance and Training.
Contract Type:: Full Time
Experience Required:: 5 to 10 years
Education Level:: Bachelor’s Degree
Number of vacancies:: 5

Job Description

-Salary: 180,000

-Set up: Hybrid set up (2x a week onsite)

-Location: Makati City

-Schedule: Night Shift (M-F)

-Employment Set up: Direct Hire

QUALIFICATIONS:

- Explain Plan and Query cost analysis
- SQL Hints and Partitioning § Oracle Performance monitoring, Spikes, active sessions
- Toad oracle Auto optimizer tool or any other similar tools which recommends
- Tuning of complex PL/SQL with Dynamic SQL
- Knowledge of Oracle - 12c and above
- Proficient in SQL and PL/SQL
- Deep Oracle tuning experience. o Understands how the Oracle Optimizer works at a deep level o Understands
Oracle Explain plans at a deep level
o Has clear method for measuring and improving query performance (method-r, etc.)
o Understands tools to improve and manage performance such as SQL Profiles, SQL Plan baselines
- Familiar with Data Modeling at a level to make recommendations of how model can be improved to support
optimal query execution
- Worked with large data volumes -our prod db is 100TB plus…. tuning in smaller databases is completely different
than tuning for large databases