Oracle Consultant Resume San Jose - Hire IT People

SUMMARY:

EXPERIENCE:

Confidential, San Jose

Oracle Consultant

Responsibilities:

Provide technical advise for mission critical Tier 1 database systems for Confidential through Service Requests involving RAC, Goldengate, Dataguard, Performance tuning etc.
Perform Oracle 12c new features POC and share the testing results and the associated statistics with the customer and also work with product development to share any additional requirements customers might provide to match their business.
Perform end-to-end Confidential and the MLR patches testing for any new Confidential and the MLRs released for Confidential . The testing includes performance and install testing.
Work with Confidential Engineering teams to in corporate multiple Oracle features that suits Confidential ’s business requirement.

Confidential, Chicago

Oracle Consultant

Responsibilities:

The project was to lead the team for the Confidential Migration Project for the OLTP/OLAP 50+ databases with the size of 40TB+ to the Confidential X4-2 Mixed RACK as an Confidential expert.
Proposed a best design/practices for migrating databases to an Confidential platoform.
Designed a best practices for monitoring the Confidential systems using OEM/UNIX shell scripts and also for capacity design.
Provided Onsite support for the Confidential database systems.

Confidential, Newark, DE

Oracle Consultant

Responsibilities:

Manage Large databases of size greater than 50 TB and providing day-to-day operational support starting from Pre-production through Go-Live and production support.
Working with Customer representatives on different POC projects testing the performance of some key queries and provide support for any issues during POC.
Upgrade the entire system, including patching of storage servers, DB servers, Switches, RDBMS, Grid Infrastructure Homes.
Patching DB Nodes, Storage server and infiniband switches.
Discover and add targets onto OEM 12c, prepare and apply monitoring templates to various targets to monitor metrics like availability, any ora errors, long running open transactions etc.
Participate in preparing the tasks to be done on the various Confidential clusters before/after Data center maintenance activities
Perform periodical switchovers on the dataguard systems, along with troubleshooting any issues during switchover.
Working on performance issues resulting from sql plan instabilities, parallel server issues and Resource managers.
Co-ordinate with Oracle Field task engineer to replace any faulty hardware.
Provide support for all the issues on Confidential system, 24*7, including but not limited to RAC, ASM, DataGuard, Performance tuning, etc.
Progressive experience on Golden Gate and ZFS issues.

Confidential

Senior Advanced Support Engineer

Responsibilities:

Provide support for various Confidential customers on all RDBMS issues including RAC, Data guard, RMAN, Performance tuning etc.
Provide Performance, patch and configuration assessments every month for Confidential customers.
Participate in Confidential patching activities for Confidential customers.

Confidential

Senior Advanced Support Engineer

Responsibilities:

Primary DBA for the 12 Critical databases and providing DBA support for the 150+ VLDB databases including OLTP and Datawarehousing databases.
Primary DBA for enabling database audit for all the mission critical databases and primary responsibility for the audit reports to deliver ontime to the financial security team.
Prepare the roadmap and implementation plan for the migration of applications currently on AIX,Solaris,Linux to different platforms. Advice the best practices of data migration using enhanced techniques available like 10g Cross Platform Transportable Tablespaces and Data Pump
Monitoring closely batch jobs during off-shore hours and reposnsible for the data warehousing batch jobs to complete as per SLA.
Member of precise team(Database performance team with team of 4 members) and tuning the instances in a pre-production environment and working with the application team to tune the batch queries to reduce the response time.
Worked on data refresh projects using RMAN Cloning,Datapump,export/import.