Job Description :
o Oracle databases
o Application performance
o Oracle PL/SQL
o Operating systems (i.e. Linux)
o Databases tuning parameters
o Operating system tuning parameters
o Key SQL statements
o Oracle OBI Foundation Suite and ODI
o Oracle Golden Gate
o Execution plans of key SQL statements
o Improved access (database indexes)
o Database and Schema statistics
o Monitoring of the databases
o Storage, network performance and other related services
2. Provide performance tuning assistance which may include, but are not limited to:
a. Assess critical performance issues and problems and establish numeric values that categorize acceptable behavior.
b. Identify and establish acceptable system performance metrics before system modification.
c. Identify single or multiple components of the system which may limit or affect performance or capacity. This is also known as “bottlenecks”.
d. Modify single or multiple components of the system to remove the bottleneck.
e. Measure the performance of the system after modification.
f. If the modification improves system performance then adopt the modification.
g. If the modification denigrates system performance even more then revert back to original state.
h. Perform code-optimization, load balancing, caching strategy, distributed computing and self-tuning as requested.
i. Other performance tuning activities as requested.
3. Contractor must provide on-going tuning services such as:
a. Upon Contract Execution
i. Review all Oracle database and establish performance baselines. This review must include current performance levels and must provide findings and recommendations for performance improvements.
ii. All findings and recommendations must be provided in written format.
iii. Contractor must provide findings and recommendations via remote and/or onsite presentation to District staff at District’s discretion.
b. Proactive and Ongoing Tuning Services
i. Contractor shall provide five (5) on-site visits (excluding Section 3.iii above) during the term of the agreement. On-site visits shall occur every 2 months. The actual schedule will be mutually agreed upon.
ii. During these tuning sessions, Contractor will work with applicable District staff for any tuning requirements.
iii. Monthly, Contractor shall review and analyze all Oracle databases in LAUSD to identify changes, trends, bottlenecks to proactively prevent issues.
iv. All findings and recommendations must be provided in written format.
v. Contractor must provide findings and recommendations via remote and/or onsite presentation to District staff at District’s discretion.