We provide IT Staff Augmentation Services!

Sr. Oracle Database Consultant Resume

5.00/5 (Submit Your Rating)

Sunnyvale, CA

Hire Now

SUMMARY

  • Proven DBA/management skills and information technology experience.
  • Twenty plus years of database management (Oracle, MS SQL server, MySQL…), performance tuning, data warehouse, replication, ERP implementation, logical/physical design and system development experience.
  • A highly motivated professional and team player.

TECHNICAL SKILLS

Database: Oracle RAC/Oracle, Oracle Data guard, Sybase, MS SQL, MySQL - Cluster, Galera Mysql-Cluster, PostgreSql, MongoDB, HP Vertica.

ERP System: Oracle Financials 10.7/11.0.3 , SAP, BAAN.

Platform: SUN/Solaris, HP/UX, IBM RS6000/AIX, PC/Window, Linux, Hadoop.

Language and Tools: SQL, PL/SQL, C, PRO C, JDBC, PERL, UNIX Shell, Java, JavaScript, HTML, Hadoop Hive, Pig, Hbase, Mongo, SILVERRUN, ERWIN, Business Objects. Wherescape RED (a data warehouse development tool).

PROFESSIONAL EXPERIENCE

Manager of Database Technology

Confidential, Sunnyvale CA

Responsibilities:

  • Oversee design and maintenance of Oracle database environment focusing on database administration, performance tuning, data warehousing, reporting, business intelligence, disaster recovery and 7x24 environments.
  • Manage local and offshore data service team which involves database application architect, DBA, data warehouse developer, report/BI developers.
  • Set up Oracle development guideline and operation standards.
  • Design and implement multi-dimensional (star schema) data warehousing system using Wherescape RED
  • Deploy Business Intelligence Solution using MS Sqlserver Reporting Service (SSRS), Analysis Service (SSAS), Performance Point and PowerPivot, Hadoop Hive, Pig, Hbase.
  • Lead SOX, PCI and HIPPA database related compliance activities.
  • Support weekly database release processes.

Sr. Oracle Database Consultant

Confidential, Fremont CA

Responsibilities:

  • Provided senior level Oracle consulting service focusing on database administration, backup/recovery, performance tuning, data warehousing, ERP system implementation and migration.
  • Provided DBA support for BAAN production, development systems and all home grown Oracle applications. Installed and upgraded Oracle HR10.7 to 11.0.2.
  • Implemented Oracle Financial 10.7 and provided production support.
  • Provided Oracle DBA support for both production, development and Intranet application development (JavaScript, Oracle Web Server and PL/SQL, perl). Helped to implement SAP BASIS, Vantive CRM and SAP data warehouse.

Sr. Oracle Database Administrator

Confidential, San Jose CA

Responsibilities:

  • Oversaw Conner's worldwide database activities. Played the lead DBA role.
  • Involved in architecture design, performance benchmark, SQL tuning, tool selection, data warehouse architecture.
  • Supported and tuned Oracle Financials

Database Administrator

Confidential, San Jose CA

Responsibilities:

  • Assigned to TDS data access software development team.
  • Developed ETL tools for data extraction, mapping, conversion, loading and meta data management from TDS legacy mainframe database to Oracle.
  • Played consulting role for all R&D Oracle development issues.
  • Administered R&D UNIX AIX servers and department network.

Database Administrator/Programmer Analyst

Confidential, Mountain View, CA

Responsibilities:

  • Instituted logical and physical database designs that enhanced ability to support Interop Registration System.
  • Tuned application performance up to 400% increase.
  • Delivered corporate report using GQL and T-SQL.
  • Administered Sybase and UNIX servers.

Programmer Analyst

Confidential, Milipitas, CA

Responsibilities:

  • Implemented new dynamic software packaging processes to improve LSI software shipping accuracy and productivity.
  • Played key role in downsizing software shipping/tracking/packaging application from mainframe to client/server architecture using Sybase.
  • Involved all system development life cycle using CASE method (logical/physical/tuning ).
  • Administered Sun UNIX servers and department local network.
Environment: Oracle RAC, DataGuard, ASM, Oracle ASO, Linux, EMC SAN, remote Disaster Recovery Center, MS Sqlserver, MS Report Server, MS Analysis Server, PowerPivot Service, MySQL, MySQL-Cluster, Galera Cluster, PostGreSQL, ERWIN, Oracle Enterprise manager, MongoDB, Mongo MMS, HP Vertica, Hadoop, HBASE, Hive, Impala.

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship