SUMMARY

• More than 10 years of experience in Oracle administration versions 7, 8i,9i,10g,11g, and 12c combined with good development skill.
• Solid knowledge of data modelling and Logical and Physical database design; performance tuning of SQL and PL/SQL.
• Working knowledge and programming experience with various Oracle features: external tables, XML DB, bulk load, analytical functions.

PROFESSIONAL EXPERIENCE

Confidential - Los Angeles CA

Database Engineer

Responsibilities:

• Support for Data warehouse and ETL Team. Java procedures, PL/SQL, triggers, materialize views, shell scripting for implementation of new ETL features and maintenance.
• Installation of Oracle 12c database on AIX, migrations of databases from version 11g to 12c. Tuning and adjustments of related performance issues.
• Cloning of Oracle 11g and 12c databases and schemas of Prod/Dev/Test environments for testing. Loading of initial data sets (> 1bil records), use of transportable tablespaces.
• Data modeling, Logic and Physical design of new tables and processes. Partitioning, compression, performance tuning of SQL, PL/SQL and Business Objects. Materialize view for external databases. Monitoring of ETL processes, fixes and adjustments.

Confidential

Database Engineer

Responsibilities:

• Support for implementation of JAVA / Oracle 11g based OLTP application for release into Production. Debugging of errors from application server and database. PL/SQL, functions, procedures, triggers, shell scripting programming.
• Maintenance of Oracle 11g databases on Linux. Cloning of databases and schemas of Prod/Dev/Test environments. Monitoring of system events and proactive adjustments. Performance tuning of SQL, PL/SQL, partitioning and system parameters/
• Automation of comparison of Schemas in same database and different databases. Reporting differences.

Confidential

Oracle DBA

Responsibilities:

• Support of Credit Card processing system.
• DBA support of legacy 11g2 system: patching, code reviews and installations, performance tuning.
• Support of Oracle 11g2 RAC on Linux and upgrade to 12c version. Upgrade 12c databases to patchset 2.
• Routine administration, Golden Gate for table replication, Data Guard standby for reporting. Grid Control for AWR and ADDM.
• Code reviews, installations, performance tuning of SQL and system parameters, SQL outlines.

Confidential - San Ramon CA

Application Architect, DBA

Responsibilities:

• Started with: flowcharts expressing Inputs, desirable outputs and requirement, like: 6-10 hours daily processing cycle. In 3 months ended with: implementation of Gas Smart Meter Hourly Foundational Repository for PGE with max 1.5 hours daily processing and Aggregation Engine.
• Design of Oracle 10g database on Windows server. Heavy use of partitioning, compression, parallel executions and analytical functions. Coding, sizing to fit on a laptop, tuning, implementation, documentation and training of client’s users and DBA.
• Close interactions with Electrical and Gas Engineers and provided support after project completion.

Confidential - Woodland Hills CA

Oracle Developer

Responsibilities:

• Documentation and research of Application tracking Releases and Repertoire for Confidential . VPD (Virtual Private Database), nested triggers, XML.

Confidential - Southern CA

Oracle Engineer

Responsibilities:

• Managing online Advertisement system, which contained 8 Oracle 11 (3.5TB) for web clicks and 2 Oracle 11 (5.5T) databases for aggregations on Linux Servers using NetApps storage.
• Support of Oracle 11g RAC 2 node system.
• Moving databases from raw devices to NetApps NFS.
• Materialized views data replication. Data Guard standby for reporting database. On going system monitoring of database and SQL performance. Heavy use of hints and partitioning.

Confidential

Oracle DBA

Responsibilities:

• Oracle 9i, 10g, 11gr1, 11gr2 database administration. OEM for 9i, Grid Control for 10g and 11g. Assisting in installations of new versions of JD Edwards, Dementia, Hyperion and real-time support. Oracle 9i and 10g on AIX, Oracle 10g on Windows server and Oracle 11g under Linux. VMWare or stand alone server’s setup working with UNIX and Storage admins.
• SQL optimization; automation of database administration tasks. Statspack, AWR setup and ADDM reporting and analysis.
• Installations of new Oracle databases directly and using Grid Control.
• Setup, checkups and support of RMAN backups on Tivoli platform for Oracle databases and 50+ SQL server databases.

Confidential

Database Administrator / Data Architect

Responsibilities:

• Oracle 9i, 10g, 11gr1, 11gr2 database administration. Installation of Oracle One Node 11g RAC on HP and migration to 2 nodes RAC. Patches, upgrades. Performance tuning, capacity planning, on-going maintenance and RMAN backups.
• Migrating legacy Public Works (PW) accounting data into Countywide Accounting and Purchasing System (eCAPS). Implementation of PW accounting Operational Data Store (ODS). Logical and physical database. Shell scripts / PL/SQL / Perl ETL processes from eCAPS to ODS and backward. Performed capacity planning and on going maintenance.
• Participated in creation of Data Mart for PW purchasing using PL/SQL / UNIX shell scripts / COGNOS and working closely with COGNOS developers. Support of ColdFusion, .NET development. COBOL reverse engineering.
• Creation and altering of Oracle objects: packages, procedures, tables, indexes, triggers, etc., using PL/SQL for web application developers. Data modeling. SQL tuning. Security and Auditing.

Confidential

Oracle DBA

Responsibilities:

• Supported Media Asset Repository System.
• Migration of Oracle databases from 9i to 10g. Installations, patches, upgrades and other database tasks. Coordination of activities and down times.
• Set up of backups and testing of database recoveries in SUN Solaris, EMC BCV, Veritas Cluster and Tivoli environment. Close work with UNIX Admins, Storage Admins and Application developers.
• Implemented Oracle Text for efficiently querying of free texts and tables. Developed sudo-code requirements for GUI implementation by 3rd-party Company for minimal application code changes.
• Data modeling. Performance tuning of database and SQL. Code reviews.