- Expertise in Database designs, implementation, Support, DB & Cluster Installation on single/multi nodes on various platforms (Windows/Linux)
- Expertise in Fusion Middleware, WebLogic, SOA Suite, SSO, IDM, EPM, ODI, Content Management and BI implementations etc.
- Extensive familiarity with Tuning Tools like Oracle Enterprise
Managers (OEMs), Oracle cost optimizer, SQL analyzer, top session, top SQL, Performance Manager, etc., Stats pack, TOAD. For SQL tuning using Explain plan, TKPROF, SQL_TRACE, Optimizer modes, using Optimizer hints, Gathering statistics, Stats pack etc.
- Create database maintenance plans, including updating statistics,
re indexing, structure modifications, Capacity plans, and index analysis.
- Security User Management, Privileges, Roles, Auditing, Profiling,