PROFESSIONAL SUMMARY:

• Graduate Engineer from Confidential, with 10G OCP and approximately 17 years experience in the Oracle database technologies as Senior Database architect/developer/engineer/DBA using Oracle 7.x, 8.x, 9i, 10G,11G,12c Developer 6i, PL/SQL, SQL, UNIX, LINUX, Java, c#, Scala, Oracle APEX 5.x
• Approx. 17 Years of Oracle Database model, design, development and .
• Approx. 5 years as DB Architect on Oracle 7.x, 8i, 9i,10G,11G, Teradata, Hadoop/Hive
• Tuning (VLDB - 6TB) OLTP databases/queries in 24x7 Production environments and for data warehouse needs.
• Monitor and troubleshot various database remotely for database located in the US, Europe & Asia-Pacific
• Very good in tuning database, PL/SQL and SQL codes, using dynamic SQL, trace, hints, SQL access path, profiler and AWR / ADDM, Tuning sets and Advisers.
• Good knowledge Oracle ERP Quote to Cash (OM/AR) on ORACLE EBS R11i.
• Proficient in designing and developing custom solutions to complex business processes using PL/SQL packages, procedures, functions, triggers, Forms 6i and Reports 6i
• Extensive experience in Project Leadership, Estimation, Planning and Source Code management.
• Exposure and practice of client business standards, quality processes, release management and compliance of Sarbanes-Oxley Act (SOX).
• Understanding of Oracle application servers, OC4J, Oracle Application Framework and ADF.
• Prepared system documentation and maintenance/recovery/backup plan.
• Train and develop other developers, DBAs
• Working knowledge of Java, C#, Python
• Implement Oracle Text functionality.
• Developed Oracle APEX solution for web.
• Develop solution based on Oracle XML APIs
• Used AWR Advisers for the status, performance and Space Management of the Database.
• Install and configure Database using Oracle’s Optimal Flexible Architecture (OFA). Created standby database, staging database, testing database, etc.
• Implemented Block recovery using RMAN block recover.
• Done periodical Incremental, Full, Hot, Consistent backup and Incomplete/Complete recovery using RMAN.
• Done incomplete recovery using Flashback Database and have good knowledge of Flashback technology.
• Implemented use of Materialized views, Index Organized tables, partitions, etc.
• Model ERD for 400 plus tables and maintain the same.
• Wrote scripts to automate database functions, and scripts to maintain database editions.
• Worked on in-house data warehouse, architecture, data modeling and Globalization.
• Independently develop complete online archive solution using recursive hierarchic code.
• Worked on DW KPI using Scoop to transfer data from Oracle to hadoop and hive/spark for further ETL.

TECHNICAL SKILLS:

RDBMS/Languages: Oracle 12c, 11g, 10g, 9i, 8i, 7.x, Oracle Developer (Forms6i, Reports6i), PLSQL, SQL*Plus, SQL*Loader, Data Pump, RMAN, ASM,Python,OEM - Database Console, C#

OS: Sun Solaris, HP-UX, Windows

Reporting Tools: Discoverer 3i/4i, Jasper reports.

Tools: TOAD, SQL Developer, Mercury IT governance (Kintana), Unix RCS, ETL, Meriant, VSS, CVS,PVCS, SVN, Jdeveloper, etc.

ERP: Oracle 11i (11.5.7, 11.5.9, 11.5.10)

Data Modeler: Erwin/Toad Data Modeler

Web/Mobile Builder: Oracle APEX 4.2, 5.x, .NET Entity Framework

WORK EXPERIENCE:

Sr Database engineer then Architect

Confidential

Responsibilities:

• Design, Model, Develop and Manage and tune 6TB Order Management System as Cloud solution. Evaluate AWS/Oracle Cloud solution and implement the same. Model and Develop DW for KPIs on AWS using Hadoop, Hive and Spark. Implement CDC and develop archive strategy and solution to archive 17+ years of data. Implement Oracle Text search. Extensive tuning implemented. Implemented process of TDD/FRD, peer code review, etc.

CTO/Co-founder

Confidential

Responsibilities:

• Designed and Developed complete solution for sourcing shipment need using social platform.
• Developed team of twelve engineers from UI/Mobile to DB, Java. Exited successfully.

Sr Database Developer and later Manager

Confidential

Responsibilities:

• Tuning, model, ERD, design and develop insurance products. Develop WH solution on Oracle.
• Implement TWILIO API in DB. Worked on .net entity framework/c# also. Managed team of six developers and two business systems analyst.

Sr Database Architect/Engineer/Non-prod DBA

Confidential

Responsibilities:

• Modeled and developed Database application code for Wholesale group merger of Wachovia with WellsFargo. Lead group of six developers and was the SME on all things database.

Sr. Database Architect

Confidential, Santa Clara

Responsibilities:

• Job included data modeling and framing the optimal solution that involved various technology stacks.

Confidential

Responsibilities:

• This is a 24x 7 Application Support/Enhancement projects where Oracle ERP applications are integrated with Vendavo and other third party and in house applications. It involved developing Data models, application design, pl/sql, sql tuning and other regular DBA tasks and supporting all issues at various severity levels based on SLA on a 24x7 basis. The main focus of the project was to handle large number of transactions (approx. 100,000 transactions per day) with 3000 users accessing the application with database of size 1.5 Terabytes.

EBS Developer

Confidential, San Jose

Responsibilities:

• This is a 24x7 Application Support and enhancement project integration with Vendavo, Nextlinx, Matrix, Connectship and other third party and in house applications. Develop and support Nextlinx trade compliance, Matrix and UPS Connectship issues and upgrades. Database was spread out in Ireland
• This project involved planning, upgrade, migration of data, and customization of interface programs for Oracle Applications 11.0.3 to Oracle Applications 11.5.9 and database migration from 8i and 9i to 10G
• This is a pricing system, where the different quotes and price-list are maintained. These pricing are validated and re-priced every quarter and published to OM.
• This project consists of migration of data, and customization of interface programs for Oracle Applications 10.7 to Oracle Applications 11.0.3 NCA upgrade.

Oracle Developer/Team Lead

Confidential, San Jose

Responsibilities:

• Data warehousing Custom ETL development