Responsible for performance tuning, troubleshooting, monitoring, and resolving technical issues. Provided 24x7 support for mission critical systems that are up to 10TB in size. Performed RDBMS upgrades from 9i/10g/11g to 12c, others in the past are - 8i to 9i and 10g, 9i to 10g, 10gR2 to 11gR2. Implemented RAC, ASM - Grid Infrastructure, Data Guard. Streamlined custom cloning of Oracle databases using perl and OEM. In the past leveraged technologies like NetApp Snap Manager for Oracle (SMO). Monitored using OEM Grid control. Created logical and physical standby databases with Dataguard. Managed database in various platforms such as Unix, Linux and Windows and SAN storage systems such as Hitachi, EMC and NetApp and Exadata. Puppet,ZooKeeper,Chef,Rapid Application Testing, HP Quality Center. Responsible for installation, upgrades, patches, TAR support, database tuning, concurrent manager administration, cloning and Oracle Apps SYSADMIN functions. Duties included database creation, database tuning/reorganization, SQL statement tuning, backup/recovery, general troubleshooting, proactive fire fighting, developer/integrator relations, script development, documentation and DBA . Specific Oracle Applications modules installed include AP, GL, AR, FA, PO, PA, QA, INV, OE/ONT, HR/Payroll, BOM, MRP, WIP, BIS, FII, I Procurement, CRM, Isupplier and Istore. Leverage rapidwiz and adclone,adpatch etc..
Software: Oracle Database 7.x,8.0.x, 8.1.X,9.x,10.1.x,10.2.x10G AS,9iAS,10g AS,9i RAC,10g,11gR2/18.104.22.168C Grid infrastructure, Oracle ASM. - OEM 12c (22.214.171.124) GRID/RAC,Dataguard,10g ASM, Oracle Web Server 12c/9ias,10gas, 3 .x. and 4.x, Webdb 2.5. Oracle Applications 11i (11.5.1-126.96.36.199 ), older versions -10.5, 10.6 SC (Prod 14/15), 10.7 (Prod 16/16.1), 10.7 NCA, 11.0.X NCA, Radley Caras (V5 and V6). I2 Factory Planner and Rythymnlink (2.x). PL/SQL, SQLPLUS, C, UNIX SHELL (KORN, BORNE, CSHELL). Patrol, Chain Link. Sun Solaris (2.5,2.6,2.8,2.9),HP/UX (10.20,11.0,11i), AIX (4.3 and 5.x), Redhat Linux (7.1,188.8.131.52 - ES 3.0,4.5,5.x,6.x),DataGuard - logical and physical standby.Supporting custom database designed with Hibernate/Jboss - Oracle APEX 3.x and 4.x CSS Layouts and PDF design webforms with java containers. - Oracle replication 9i/10g/11g - Golden Gate from IBM DB2 to Oracle 11G and SQL Server 2008R2 to 12c.:
Hardware: HP Linux Servers, IBM Linux Servers, Dell Linux Servers, HP Blades, IBM Blades. Oracle Exadata, Oracle/Sun Sparc and X86,, Sun Netra 12, E6500, E5500, E4500, E450, E250, Ultra 2. HP SuperDome, V Class, N ClassL Class, K370, K460: . Storage TEK 9370, Hitachi 9xxxx,EMC, MTI Storage, Sun T3, A5000, A7000, A1000 disk arrays, HP AutoRaid, FC60 - EVA. Viking SAN storage and Netapps.PROFESSIONAL
Tech Lead of Database Services
Confidential, Palo Alto, CA
- 24x7 DBA support to mission critical business systems for home health monitoring system. Oracle 10g and 12c dataguard. Oracle golden gate 12c. Oracle Enterprise manager 12c(184.108.40.206).
- Modernized aging 9i Oracle RDBMS via 220.127.116.11 RAC deployment including custom Health Hero product conversion, introduced Oracle Golden Gate for replication of 9i production databases to the new 12c 3 node RAC, performed comprehensive application optimization including interval partitions on key tables that amassed several trillion rows and several terabytes in size, achieved throughput rate of 100 billion transactions per minute.
- Customized OBIEE 18.104.22.168 solution for internal billing and customer facing dashboards and business defined key performance measures. Developed centralized customized data warehouse with RAC pluggable databases and obiee with ODI, Hadoop and big Data.
- Led the database team through the development of custom databases for Veterans Affairs as well as other commercial products, coordinated teams internationally to deploy world wide data centers with custom bi-directional replication.
- Integrated Oracle identity management with OBIEE,Oracle 12c along with LDAP.
- Led SQL migrations from 2000,2005, to 2012 and Management Studio.
- MySql replication and cluster integration with OEM. Managed replication for 4 data centers.