SUMMARY:

• Over 15 years of Professional/Entrepreneur experience with Start - ups, Medium and Large Organizations in Professional Services Engagements, Pre-Sales, Solutions Architecture, Technical Leadership and Product Definition/Management/Strategy
• Design, Managed, Tuned and Implement Enterprise scale, highly transactional, complex, strategically important, business critical Database/Application.
• Hands on programming experience in multiple technologies, frameworks and methodologies and on varied platforms and technology stacks.
• Familiarity and practice of applying TOGAF.
• Developed and implemented an endpoint service center including a hot-swap program and in-house repair operation that reduced user-downtime from two weeks to 24 hours and generated $100,000 in revenue from warranty work.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, Java, Shell Scripting, Python, Scala, R

Rdbms:   Oracle 12c/11g/10g/9i/8i, SQL Server 2003/2005/2008/2012/2014 , MySQL, Postgres, NoSQL, Hbase, Cassandra, MongoDB, In-memory, Columnar

Database Tool:   Data Pump, SQL*Loader, RMAN, Data Guard, Grid Control (OEM), Oracle Streams, RMAN, Explain Plan, SharePlex, Hibernate, Swing

Build Systems:   Maven, Ant , Perl

Source Control Systems:   StarTeam, Svn, VSS, Git, Git Lab

Continuous Integration Systems:   Jenkins, Bamboo, Cruisecontrol

Config/Orchestration:   Zookeeper, Puppet, Salt, Ansible, Chef, Oozie, Pig  

Application Server:   Jboss, Tomcat, Web Logic, Websphere, Oracle Fusion Middleware

Case Tools:   ERwin 4 with SP2B

Monitoring Tool:   Site Scope, Instant Up, Nagios, Pager Duty, Zabbix, OPsGenie, Dynatrace

UI Forms & Reports:   JSP, HTML5, CSS

Microsoft Technology:   Word, Excel, PowerPoint, Visio, Microsoft Project

Operating Systems:   Red hat Linux4/5/6/7, Oracle Linux, Ksplice, Windows 2000/ 2003/2008/2012/2014

Reporting Tools:   Oracle Reports, Business Objects, Pentaho 3.8/5.0/6.1, SRS, SQL Server Reporting

CRM:   Siebel 7.7/ 7.5.3/ 7.0.4 , Assignment Manager, Siebel EIM Administration, Workflow Administration, Horizontal Siebel Call Center, Siebel Sales, Siebel Marketing.

Siebel Tools:   Siebel 7.5.3 Tools.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Solution Architect

Environment Oracle 11g/12c, ASM, Pentaho, RMAN, Solar Winds, PL/SQL,, TOAD 11,MySql 5.1, SQL Server 2003/2005/2008/2012/2014 , EMC SAN, Shell Scripting, Windows 2003/2008/2012/2014 , Java, Angular Js, Node js, Hibernate, Spring, REST, No Sql, Postgres, Hadoop, Hbase, Cassandra, MongoDB, In-memory, Mule, Map reduce, Pig Script, Hive queries, Nagios, Python, Perl, Hosted Graphite.

Responsibilities:

• Database creation/administration, Database and Application/SQL Tuning, Perform capacity monitoring, migration/upgrade of database, Automation monitoring Script, Scripts for building autonomous database implementations, database/application auditing.
• Develop and implement Backup and Recovery Strategies and refresh/clone database.
• Design, develop and implemented custom Fast refresh metalized table to store aggregate data which improve reporting performance by 1000%.
• Design and implemented 2 Node RAC using Oracle ACFS file system for Bfile sharing.
• Design, developed and maintained highly available Data ware house using Postgres, Pgpool, Kettle (ETL) to execute 90000 view objects delta refresh for day to day reporting.
• Design and develop custom java app which support oracle to SQL Server data conversion and load into SQL Server.
• Design, clustered and maintained MySQL database for state reporting and qualifacts.com.
• Maintained SQL Server reporting for custom reporting for customers.
• POC, Design and implementing next generation Service Oriented Architecture for Legacy application using Hadoop, Cassandra and Mule, Angular Js, Node Js, Postgres, Oracle.
• Writing Map reduce code, PIG scripts, Hive queries, MR Unit test cases for map reduce job, PIG Unit test cases for PIG scripts.
• Design and develop custom build tool using Perl to deploy database changes into production at runtime help improve application uptime as well as saved 2000 man hours in a year.
• POC and implemented SharePlex for run time replication for Standby database.
• Design, Setup and maintained Disaster Recovery site at EC2 cloud.
• Help tune Linux OS performance and wrote custom shell script for Oracle and Postgres database and application server.

Confidential, Cupertino, CA

Senior DBA/Design Engineer

Environment Oracle 11g/10g, Oracle 11g/10g RAC, Oracle Apps 11i/12, SQL, RMAN, Grid Control, PL/SQL, Unix/Linux Like OS,TOAD 8.6.1/9.2.5 , MySQL 5.1, Oracle Streams, HP SAN, Shell Scripting, Windows 2000/2003/2008 , AIX, ANT 1.6, Cruise Control, Star Team, Java, JSP, Hibernate, Spring, Struts, JUnit, GWT, Instant up.

Responsibilities:

• Database creation/administration, Database and Application Tuning, Perform capacity monitoring, migration/upgrading of database, Automation monitoring Script, Scripts for building autonomous database implementations, Backup and Recovery Strategies, cloning, SQL tuning database auditing technology.
• Designing, implementing and scaling partitioned table solutions including partition management (creation, management, deletion), search optimization (maintenance of local and global indexes) and data management (loading, unloading and archive/restore).
• Design and implemented real time reporting solution for small and medium size customer.
• Implement and maintain bi-directional oracle streams for high availability and failover.
• Good understanding of Oracle Applications 11i and Rel 12 technical architecture.
• Lead Configuration and release management team
• Configured integrated build using Cruise Control and Hudson.
• Involved designing and developing Instant-Up tool using Spring, Hibernate and Struts, this help save us 1000 man hour for sandbox instances.
• Created RAC 10g/11g database with Sun & HP Storage using OCFS2 File system.
• Design and implemented High Availability and Disaster Recovery solutions using Data Guard and OEM for grid control and monitoring

ECM Tech Inc Senior Database Engineer

Confidential, San Francisco, USA

Environment Oracle10g/9i/8i,Oracle 10G RAC, Sql, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), Real Application Clusters (RAC), PL/SQL, Windows XP, TOAD 8.6.1,Web logic, Oracle Applications 11i,Sun Solaris 8/9/10, RMAN, Shell Scripting, Windows 2000, SQL Loader.

• Database creation/administration, Database and Application Tuning, Perform capacity monitoring, migration/upgrading of database, Automation monitoring Script.
• Implemented Oracle10g RAC environment on ASM Lib with OCFS2 file system.
• Support and maintain 16 Oracle Data Base instances including production and perform code migration to production.
• Perform 2-tier and 3-tier clones of Oracle Applications 11i instances.
• Install Oracle database 8.1.7, 9.0.1.8., 10g and Apply database and applications patches.
• Coordinating between development groups and more than 15 other groups (CSOPS, EACO, SDS, EHS, PQC, WPQC, OSS, UPS, IA, Intel Level 2 Support…)
• Middleware/DBA: Support Web Logic, Oracle products, etc
• Troubleshoot problems with concurrent managers, Apache and database performance.
• Upgraded 9.0.5 database to 10.1.2 and implemented sever partitioning with 8.0.6 to enable Oracle Applications 11.0.3 to work with 8.1.7.

Team Lead / Sr DBA

Confidential

Environment Siebel 7.5.3, Tools, Siebel EIM, Siebel Marketing, Siebel Call Center, Oracle 10g/9i, SQL, PL/SQL, ETL, Unix Like, Data Guard, TOAD 8.6.1, RMAN, SAN, Shell Scripting, Windows 2000, SQL * Loader.

• Database creations/ administration, 10g RAC implementations, Database and Application Tuning, Perform capacity monitoring, migration/upgrading of database.
• Design and implemented High Availability and Disaster Recovery solutions using Data Guard and OEM for grid control and monitoring.
• Provided support to EMEA, Americas and APAC regions.
• Implement Batch Execution processes for executing the steps for importing data in to interface tables and kick off the EIM tasks for heavy data loading from external databases for informatics extract to Siebel database using EIM.
• Designed and drafted the TDS (Technical Design Specification) document.