ORACLE DBA

EXPERIENCE SUMMARY

• Over 8 years of professional IT experience as Oracle DBA, Business Intelligence and
  Data Warehouse.
• Installed and configured of Real Application Clusters (Oracle 10, 11g RAC), Standby
  Databases (Data Guard), Automatic Storage Manager (ASM)for High Availability and
  Disaster Recovery.
• Updated databases from Oracle 10g to 11g, migrated databases from Windows to Linux,
  from Oracle database to SQL Server database, and from SQL Server database to Oracle
  database.
• Monitored and managed database instances of 2TB+ with 500 concurrent sessions, and various database components (logical & physical) like memory, table spaces. Set up, queried, and colon distributed database.
• Experience in using Dynamic SQL, PL/SQL, T-SQL, cursor, stored procedures, indexes,
  materialized views, combined shell scripting shell & SQL, partitioned/non-portioned tables,
  packages and triggers for ETL architecture to improved database performance.
• Intensive experience in identified and solved poor SQL and database statement using AWR report, Explain plan, TKPROF and 10046 Trace, OEM.
• Expertise in maintaining Database roles, users using Security Compliance Auditing,
  expertise in loading data from Flat Files and External Table using SQL*LOADER.
• Good experience in managing Very Large OLTP and Data Warehouse databases.
• Involved (evaluated) in Normalized Database/ De-normalized Data Warehouse (Data Mart) logical & physical database designs and dimension & fact table modelling.
• Experience in using logical, physical (cold, hot) backup with scripts, OEM Grid Control, RMAN, Data Guard (Data Replication).Golden Gate replication.
• Experience on Backup Methodologies (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.)
• Experience on Recovering (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption etc.).
• Well translating business requirements into creation of database objects: tables, indexes, constraints, packages, stored procedures and functions using Oracle tools.
• Extensive experience in BI Solutions (ETL & Reporting) using SQL Server Integration
  Services(SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS) and T-SQL Programming using DDL, DML, DCL commands for various business applications.
• Expert at developing ETL interfaces using SSIS, Data marts/cubes using SSAS and enterprise reports using SSRS utilizing latest versions (2005/2008/2012) & features.
• Business Intelligence cube, KPIs, dynamic dashboard, Power Pivot with MDX/ DMX.
• Experience in designing Database Models using MS Visio.
• Installed/configured SharePoint 2010 standalone/farm, Power Pivot Gallery.
• Worked as on-call support team member for administering OLTP/OLAP 24X7 production databases.
• Excellent communication skills, strong analytical & logical abilities, problem solving skills and fast learning.

TECHNICAL SKILLS:

Hardware & Operating Systems : Sun Solaris, RedHat linux, Windows Server 2008
Languages : SQL, PL/SQL, T-SQL, UNIX Shell Scripting, Visual Basic
Database/Applications/Tools : ORACLE 10g/11g/11gR2 RAC, Recovery Manager (RMAN),Oracle ,STATSPACK, AWR, ADDM, ASM, Developer 2000, SQL Loader, TOAD, OEM/Grid Control, Erwin, Golden Gate. SQL Server Management Studio 2005/2008/2012
Business Intelligence Tools : Erwin, SSIS, SSAS, SSRS, SharePoint
Engagement Experience : Installation, upgrade and Configuration, Performance Tuning, Backup, Database Migration, Database Maintenance, Test plan development

EDUCATION:
Bachelor of Arts in Economics

WORK EXPERIENCE

Confidential (March 2012 to Present)
San Jose, CA
Role: Oracle DBA
Responsibilities:

• 24 X 7 Production Oracle database support and administration
• Installed, configured and maintained Oracle Databases. Upgraded databases from Oracle
  10g to 11g. Install and configure Oracle Golden Gate.
• Evaluating, Supervise, plan, Installing Database servers, Database software, upgrading to
  new versions, co-coordinating with hardware changes and applying oracle database
  patches
• Involved in the implementation of High availability with Real Applications Clusters (Oracle
  11g RAC, 10g RAC), Disaster Recovery solutions with Standby Databases (Data Guard).
• Oracle Database and SQL tuning using SQL TRACE, STATSPACK, EXPLAIN PLAN, TKPROF,
  AWR, ADDM.
• Traced sessions using tkprof from the original trace file report with DBMS_STATS, 10046
  file to gather statistics and optimize query, reduced execute time from 3 hours to 6
  minutes.
• Identified performance problems using wait event statistics. Monitored session-level wait
  events and collected historical data for root cause analysis, and supported the
  development team at offshore in issue fixing, migrations of code & other support
  activities.
• Architecture different table space, manage data files.
• Scripted proactive & scheduled DBA related health analysis & monitoring including
  instance, index and log health, Maintenance (Partition tables, Materialized views refresh,
  Reorg, index), PDA alerts.
• Capturing the database statistics and metrics for proactive database management.
• Cloning of production database to the test environment using Recovery Manager (RMAN).
• Evaluated Relational Database Schema structure in OLTP, Star & Snow Flake Schema
  structure in Data Warehouse.
• Extracted, Transformed, Loaded large volume data into database/DW using SQL Loader.
• Resolving Oracle listener and TNS name problems
• Monitored the growth of the database objects for capacity planning.
• Developing a backup and recovery strategy and performed backups and recoveries.
• Re-organizing the tables for better response time.
• Partitioning tables by determining the suitable methodology to improve performance and
  manageability.
• Implemented data replication through materialized views, Golden Gate.
• Capacity planning and bench marking
• Developed PL/SQL functions, procedures, packages and triggers.

Environment: Oracle 11g RAC,10gRAC,9i, RedHat Linux, Sun Solaris, Grid Control, Data dump, RMAN, ASM, TOAD, ERWIN, Golden Gate.

Confidential (May 2010 to February 2012)
Des Moines, IA
Role: Oracle DBA
Responsibilities:

• Database Administration support for Production, Development and Test Databases
• Planned and performed database software installation, upgrade, patch from 10g to 11g.
• Configured environmental variables, parameters, and instance.
• Loaded large volume data from flat files to Oracle database using SQL Loader.
• Updated and wrote SQL query, view, sequence, and PL/SQL (T-SQL), dynamic procedure,
  dynamic SQL, function, cursor, Shell Scripts Combined scripts UNIX/Linux/ Windows (Dos)\'s
  Shell and SQL commands.
• Monitored/tuning database all databases using Oracle Enterprise Manager (OEM) for
  maximum uptime and optimal performance including space usage, alert log, archived redo
  log, CPU, memory usage, swap in/out, disk I/O, listener, pmon, users, index.
• Identify performance problems writing scripts to tuning top SQL adding hints.
• Recompiled P/L SQL, procedure, rebuild index; set file protection status.
• Implemented/monitored user/role/policy/profile/auditing on database/application
  security.
• Managed user accounts, password, roles, users, privileges, access, remote authentication;
• Audited sessions/indexes, as well as with trigger scripts.
• Cron to automate running a schedule job, solved lock conflict sessions.
• Captured the database statistics and metrics for proactive database management.
• Monitored session-level wait events and collected historical data for root cause analysis.
• Loaded data from flat files to Oracle database using SQL Loader.
• Logical backup recoveries database using export, import, and cloning of production
  database for test and development.
• Supported the development team at offshore in issue fixing, migrations of code & other
  support activities.
• 24x7 Oracle Production Database Supports.

Environment: Oracle 10g Sun Solaris, Windows, OEM, RMAN, SQL*Loader, SQL, PL/SQL, SQL Loader, Exp /Imp

Confidential
Alto Palo, CA (June 2006 to May 2010)
Role: Business Intelligence Analyst
Responsibilities:

• Involved as part-time in some of the project based on Business Intelligence.
• Designed de-normalized schemas (Logical/Physical Design) for Data Mart (Data
  Warehouse);
• Modelled and loaded data into different types of dimension (hierarchy) , fact tables
  (FK/numeric),
• Added primary/foreign/ surrogate/natural key (sequence), index
• Using different methods such like Scripts, SSIS, SSAS, BI wizard to generate Data Mart.
• Established SQL Server 2008 SSIS projects to extract data from local/remote database/ Flat
  files/others into staging tables, to reformat and insert the cleansed data into databases,
  deployed/scheduled SSIS packages & solutions into production system.
• Architected ETL packages (Transformation) with 21 functions including: slowly changing
  dimension, aggregate data, for each loop container, union all, send mail, error rows, check
  file exist, move back files, move file after loading.
• Tuned and optimized ETL and reporting using multiple methods.
• Built various multi-dimension models to analyze business opportunities by deriving Market
  Force from economy/ financial markets/ products markets data.
• Expertise knowledge on SSAS, SSRS and SharePoint.

Environment: SSAS, SSRS, SharePoint, SSIS ETL

Confidential (Oct 2003 – Apr 2006)
Role: Business Analyst
Qingdao, China

• Installed/configured SQL Server 2000, Logical designed Entity Relationship Diagram,
  physical designed created database tables with 5 constraints and indexes.
• Loaded financial market/economic data/financial reports data from different resources, and SQL Server
  2000 database using bcp, bulk insert, and table export/import Reload economic/ financial
  data into excel, using Power Pivot to analyze trend of market.
• Transformed data (de-duping duplicated rows, null values) using single-row functions,
  aggregate functions, multi-table joins, set operations, sub-queries.
• Generated daily/weekly/monthly portfolio/trading portfolios, strategies and reports using
  SQL scripts with SQL Server 2000 about these markets.
  

Confidential (March 2002 – September 2003)
Beijing, China
Role: Data Analyst
Responsibilities:

• Analyzed the exchange rate trends over 7 major currencies tied to economy entities and stock markets in these countries using financial information and database system.
• Generated daily/weekly/monthly portfolio/trading portfolios, strategies and reports Using SQL Server 2000 and faxed to the clients in banks, investment institutions, and import/export companies.
• Provided real-time trading consulting service to Platinum clients, based on client’s risk-taking preference, and traced their feedbacks to adjust clients’ trading strategy.
• Trained Workmates (Chinese Edition, “Technical Analysis Methods of Futures Markets” by John J. Murphy and “Japanese Candle Charting Techniques” by Steve Nison).

Confidential (January 2001 – February 2002)
Beijing, China
Role: Financial Data Analyst
Responsibilities:

• Downloaded, installed the information database applications, and created users’ account for clients. Extracted real-time data of real-time news from the remote database center to clients’ computers and backed up the data.
• Used most advanced technical functions to analyze the price trend of selected stocks in the finance market and generated reports for clients’ trading strategies.
• Discovered the most valuable company by parallel research on various financial reports using SQL Commands.
• Presented lectures and on-site technical support in Ten Cities of China to solve clients’ practical problems.