PROFESSIONAL SUMMARY:

• Accomplished Database Administrator with 15 Years Experience in IT industry as SAP Hana DBA, Oracle DBA specialized in very large database administration, Confidential - commerce B2B/B2C development and production support in 12c/11g/10g/9i
• Migrating Oracle DBs from data centers to Cloud
• Experienced in Oracle software Install / upgrade and patching; Database creation, performance tuning, backup and recovery
• Experienced in Oracle advanced configurations RAC, Golden Gate, Data Guard, ASM and partitions
• Experienced in Oracle Application R12 administration, cloning and patching
• Working knowledge of Hadoop/Hbase/Cloudera

TECHNICAL SKILLS:

Database /Tools: SAP Hana 1.x and 2.x, Hana Studio, Hana CockPit, Hadoop/Hbase, Oracle 9i, 10g, 11g and 12c. GRID Control, RMAN, OEM, TOAD. Exp/Imp, DataPump, Dataguard broker DGMGRL, 12cLanguages SQL, PL/SQL, UNIX Shell Scripts SQL, PL/SQL, UNIX Shell Scripts

Advanced Technology: Oracle Grid Infrastructure, High Availability Options (RAC and Standby database), ASM, Golden Gate Replication, Ansible, Cloud Azure

Operating Systems: UNIX (IBM AIX, HP UX, Sun Solaris), Linux, MS-WINDOWS

EXPERIENCE:

Confidential, CA

Responsibilities:

• Installed configured SAP Hana databases in scaled out and scaled up systems
• Upgraded Hana database to various versions including from scale out to scale up
• Performed backup and restore of Hana databases cross platforms and Data centers
• Used Hana Studio, CockPit, hdbsql and sapcontrol to administrate Hana databases
• Worked on full life cycle implementations of SAP Hana, system landscape, performance tuning, load balancing and also providing production support in some projects on multiple platforms including GCP, Azure and AWS.
• Participated the on-call rotations to monitoring / trouble shooting Hana, Hadoop/Hbase Cloudera, Postgres database issues
• Effective team player with excellent communication and interpersonal skills and ability to work with multiple functional and technical teams to drive the implementation of project to its completion
• Supported Ariba Network database migration from Oracle to Hana project
• Worked in 24/7 environments extensively to monitor and provide required services

Confidential, CA

Consultant DBA

Responsibilities:

• Researched and evaluated methods to migrate large Oracle databases from AIX to Azure Cloud: TTS, Golden Gate replication and expdp / impdp.
• Successfully carried out Oracle migration project from premises to Azure Cloud smoothly with no downtime
• Setup Dataguard databases, configured multiple listeners, DB links.
• Setup Golden Gate for multi-directional replications
• Performed I/O stress test using SLOB.
• Configured and tested RMAN backup to virtual tapes, image copies to disk and recovery scenarios with timing info.
• Performed PCI data cleanup tasks.
• Maintained and scripted monitoring scripts to alert replication when process abended / stopped processed or big lag.
• Automated change processes using Ansible
• Provided day to day support and implemented DB changes for application development
• Generated scripts to load data into Oracle and MySQL.

Confidential, San Ramon, CA

Oracle Database administrator

Responsibilities:

• Implement database changes / support day to day operations including SOX envs
• Troubleshooting database issues related to space, long run jobs and etc in 8 node RAC and dataguard environments
• Upgraded OEM to 12c and configured Templates and rman jobs

Confidential, NJ

Oracle Application Database administrator

Responsibilities:

• Installed and applied database software / patches and participated on-call rotation for production support
• Implemented / setup data warehouse schemas for real estate decision making system
• Performed / improved database cloning process and setup Grid Control for database monitoring / performance / diagnostics.
• Performed database monitoring/tuning, concurrent manager administration, Oracle Apps SYSADMIN functions R12
• Performed database creation, wallet creation/manipulation, capacity planning, table reorganization, and SQL statement tuning, backup / recovery strategies / implementations (IBM NetBackup).
• Tested and evaluated Exadata environment for parallel processing feature to improve long running daily batch jobs.

Confidential, NJ

Software Engineer / DBA

Responsibilities:

• Installed and developed Oracle software installation scripts as part of in-house developed products.
• Setup and supported stand alone, RAC and RAC with Dataguard configuration.
• Improved import/export and monitoring scripts. Resolved CQs created by users and developers.
• Ported Oracle related scripts from Solaris to Linux systems.

Confidential, NJ

Sr. Database administrator

Responsibilities:

• Installed Oracle 11g Enterprise edition on AIX database servers and Oracle clients on application servers.
• Created development, integration, QA and production databases and configured/setup database monitoring and backup related jobs.
• Created physical standby databases for QA and production serving environment utilizing Maximum Availability / synchronous mode. Configured and setup Standby Fast Start Failover / observing process / service name with FAN.
• Supported WebSphere Commerce setup / deployments.
• Implemented data pump script using database link to sync up secondary staging database.
• Diagnosed and tested switchover and various failover scenarios.
• Modified Startup and Shutdown scripts to accommodate the data guard databases on the servers.
• Implemented gap, database (primary) role change, blocking session and etc monitoring scripts.
• Proactively monitoring production databases through GRID and regularly generated AWR reports to be compared with baselines.
• Provided database technology and design necessary to achieve the objectives and plans of every year strategic project portfolio; ensure the production deployment of the database

Confidential

Responsibilities:

• Installed Oracle 11g software on Linux servers.
• Created development, integration, QA and acceptance databases.
• Reviewed and modified data model and created schemas, roles and users with proper privileges
• Implemented change management process. Supported many development teams located in different countries and managed / coordinated massive database change requests from various teams in an efficient way.
• Worked many off hours to have provided quick turnaround and therefore sped up the development process.
• Provided solutions for issues related to DATE, Language (English vs German) used in SQL statements of application code written by the development teams
• Generated DMP files and prepared step-by-step documentation for Germany site installation and later on monthly releases.
• Reviewed and tuned SQL reports for better performance.

Confidential

Responsibilities:

• Installed Oracle software and created database instances on HP/UX servers.
• Studied and proposed High Availability and load balance solutions. Created and configured Oracle Advanced Replication databases for Active-Active production environment.
• Supported the middle tier BroadVision, PlumTree, IBM WebSphere, and Pega software installation, setup and upgrade.
• Programmed various database monitoring scripts including backup, invalid objects, alert log errors, deferred transactions using Unix Shell and scheduled cron jobs.
• Managed BV database changes following middle tier vendor procedures.
• Performed troubleshooting and resolved conflicts and restored databases to most current data available.
• Prepared documentation, tested procedures and coordinated with application teams for database upgrade projects. Upgraded databases from 8i to 9i and from 9i to 10g.
• Setup and configured Grid control for production databases.
• Performed diagnosis and analysis when websites experienced slow down based statspack/AWR reports/performance advisor.

Confidential

Responsibilities:

• Installed Oracle software, created database instances and setup backup and other alert monitoring jobs in cron.
• Created, configured Materialized views (snapshots) for all remote Pharmacies. Managed content updates and daily refreshes. Programmed monitoring script to send pages out if remote site not refreshing within the time limit.
• Supported Alpha system development and releases. Consolidated three pharmacies into one centralized Pharmacy database system.
• Performed meta data (logical) restorations when releases backed out.
• Studied and evaluated database tools and chose DBArtisen and in-house developed monitoring scripts.
• Implemented capacity planning process/procedure to prevent production outages.

Confidential

Responsibilities:

• Participated on-call rotations to support 24*7 critical production database systems including databases in RAC, ASM, or Data guard configuration.
• Performed off Hour database maintenance work including production database upgrade, primary and secondary database swap, optimizing database parameters.