Specifications for a typical Oracle Expert engagement project
People often ask me, “what is it do you do”? Are you a DBA? Are you a data architect? or Are you a developer?
Below is an example of specifications of a typical engagement that I am involved with.
Objective of Role
- Provide Oracle consultancy to the Risk IT team to ensure that the business is getting the best value out of their Oracle investment.
- Actively assist in the identification of problems, performance tuning and implementation of improvements to maximise the use of oracle system across the Risk IT
- Work closely with the development team to ensure best practices are followed and implemented, as well as provide tutoring to the development staff
- Work closely with the strategic and operational leaders in the Risk IT team to develop programs of work and business improvement.
Required Skills
- At least 10 years of experience with Oracle administration and development (with in-depth experience with Oracle 9i and 10g) , preferably with Oracle Certification (OCP)
- Whilst the candidate will be an Oracle expert, it is desired that the candidate will have had exposure to various risk project implementations for large financial institutions
- Experience in business analysis and process architecting experience
- In-depth experience with VLDB, including knowledge on data warehousing design, data modelling and implementation, familiarity with Kimball or Inmon methods is desirable.
- In-depth experience with Oracle development to include PL/SQL and implementation using Java and C#
- A sound knowledge of both database and system performance tuning, not only from DBA perspective, but also from application design perspective
- Good understanding of Risk business
- Experience in coaching, leading and supporting diverse project teams, both functionally and culturally