*SREE CHANDRA* * *
*SUMMARY:* Over 7* years* of experience as an IT professional as an *Oracle DBA* Had experience leading various projects in *11g/10g/9i/ *using *RAC for HA *and * * RMAN for Backup and recovery, Data guard for Disaster recovery, Installation, Configuration, Migration, upgrade, Capacity planning, cloning, patching, Performance Tuning. - Excellent experience in *Installation* and *configuration* of *Oracle* *11g*, *10g*, *9i*, on *Operating Systems UNIX*, *Linux* and *Windows platforms*. - *4+ years* of *RAC* with proficiency in setting up and administering *10g RAC and 11g RAC *with *Automatic Storage Management (ASM)*. - Expertise in *upgrading* the databases from *Oracle 9i* to *Oracle 10g / 11g*. · Extensive knowledge on database administration for Oracle *9i ,10g * and *11g* with experience within very large scale database environment and mission critical large *OLTP* and *OLA*P systems. · Experienced in using 10g and 11g features *Data pump*, *Flash-Back Recovery*, *AWR*, *ASM*, *ADDM*, *Grid Monitoring*, *Recycle Bin*. · Expert in SQL* Loader, *export/import* and *data pump* to load data in to tables. · Oracle Database capacity planning, *space management*, *storage allocation* and different type of storage structure *(SAN**/NAS)*. · Extensive experience *Real application Clusters (RAC), ASM, RMAN, Data Guard and maintain Standby database.* · *Data guard Broker *configuration and Managing* Physical Standby databases *using* Oracle *Data guard Broker*.* - *GoldenGate* replication implementation - GoldenGate* Unidirectional *and *Bidirectional* replication · Proficient knowledge in *RMAN* backup (Full, incremental and cumulative) and *recovery*, *Incomplete recovery* and *disaster recovery*. · Excellent knowledge in *SQL*, *PL/SQL*, *Partitioning*, *Data modeling* with utilities like *ER/Studio*, *OLAP*, *Logical and Physical Database Design*, *Procedures*, *Functions*, *Packages*, *Database Triggers. * ·Implemented development, testing, staging, production, *RAC* and standby databases for *OLTP*, *DSS* and *Data Warehousing* using *customized shell scripts* and stepwise · Expert in implementing *development, testing, staging, production*and *standby databases* for *OLTP*,* DSS* and *Data Warehousing* using customized *shell scripts* and stepwise. · Implementing *standby database* and *database replication* to provide high availability of database. ·Expert in implementing *oracle streams*, and two types of standby databases supported by *dataguard*, *logical standby* and *physical standby databases.* ·Expert in *Performance Tuning* i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms. · Expertise in performance-tuning, SQL tuning services with *EXPLAINS PLAN*, *TKPROF*, *STATSPACK*, *SQL TRACE*, *AWR*, *ADDM* to collect and maintain performance statistics and improve the database performance. · Extensive knowledge of Oracle *Architecture, SGA, PGA, Binary structure, Listener, TNS Names, SQL Net, V$ views, DBA views* and *Data modeling*, *Logical and Physical databases** design* using tools like *Erwin * and *Visio*. · Experience in working with *ETL* tools like *ODI (ORACLE DATA INTEGRATOR)* and other data ware housings transactions. - Worked with the application design team in developing a custom* ETL *application using built-in Oracle technology* (Oracle Replication, Materialized Views, Snapshot's, and PL/SQL) *as well as designing the Star Schema used to support the company's Enterprise Business Intelligence system. ·UNIX *shell scripts* for hot backups, SQL*Loader, export and import of database. *TECHNICAL SKILLS:* * * *Operating Systems* HP-UX 11.x, Sun Solaris 9, 10, AIX 5.1, 5.2, Red Hat Linux RHEL 4.x,5.x and Oracle Enterprise Linux 5,6 *RDBMS* Oracle 12c/11g/10g/10gRAC/9i/8i. *Languages* SQL, PL/SQL,UNIX Shell Scripting. *DB Management* TOAD 9.5, Enterprise Manager grid,* *OEM, Grid control (RAC) *Tools*/*Utilities* RMAN, OEM, Sql Navigator,, SQL*Loader, ASM, Export/Import, TOAD, Patch Management, ODBC, Data pump, Data guard, VERITAS Net Backup. *Tuning Tools * TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM. *Hardware Platforms* IBM Power Servers, CISCO Smart UCS Blade servers , HP UX 11.31 Itanium Servers *Suresh Gupta* *Sunmerge** **Systems Inc* *[image: cid:image001.jpg@01CBC2E5.A43C36A0]* 15 Corporate Place South Suite # 430, Piscataway, New Jersey 08854 Desk: 732-410-2100 Ext 206, Cell: 732-325-3618 Fax:732.981.0405 Email: sur...@sunmergesystems.com www.sunmergesystems.com -- You received this message because you are subscribed to the Google Groups "US_IT.Groups" group. To unsubscribe from this group and stop receiving emails from it, send an email to us_itgroups+unsubscr...@googlegroups.com. To post to this group, send email to us_itgroups@googlegroups.com. Visit this group at http://groups.google.com/group/us_itgroups. For more options, visit https://groups.google.com/groups/opt_out.