AWS Enterpise Solutions Architect @ From April 2015 to Present (9 months) Consulting Technical Manager , System Performance and Architecture Group @ + Delivering Maximum Availability Architecture solutions - Client Engagements + Leading 12c Database Academy Pillar initiative ( Oracle Consulting ) + Reviewing all MAA related Client Engagement Summary Reports. Member of the review committee. + Leading 12c Business Platform Services initiative ( Oracle Consulting and Sales ) + Collaborating with Solutions Architects and Project Managers to scope out new and existing deals + Teaming with Sales Consultants and performing POCs to facilitate future sales. + Delivering 5 days Deep Dive trainings ( Oracle Consulting ) Trainings delivered: 12.1.0.2 Database Deep Dive (classroom) - Oct 2014 12c DBaaS Clould Framework Level 0 (virtual) – Sep 2014 12c Database Level 1 (virtual) – Dec 2013 12.1.0.1 Database Deep Dive (classroom) – Nov 2013 12c OEM Deep Dive (classroom) – Jul 2013 From November 2014 to April 2015 (6 months) New York, New YorkSenior Principal Technical Consultant , System Performance and Architecture Group @ Insurance Sector , Portland,OR- 10/12 - 12/12 Project Details ( Database Configuration and SQL Performance Tuning ) + Assisting with review of Oracle 10g production database configuration. + Assisting with review of Oracle 10g database performance from batch and application workloads. + Assisting with review of SQL performance of batch and application workloads. + Providing recommendations on Oracle 10g database configuration. + Providing recommendations on tuning Oracle 10g database. + Providing recommendations on tuning SQL. Financial Sector , Jersey City,NJ - 08/12 - 10/12 Project Details ( Exadata X2-2 Migration ) : + Devised Migration strategy for 15 TB single instance 9.2.0.8 OLTP database to 11.2.0.3 RAC on X2-8 Exadata + Operational Readiness – Setup Data Guard,RAC Readiness, Backup and Recovery Strategies + Setup Sun ZFS Storage Appliance with Exadata for Backup Performance + Automated Backup and Recovery Scripts - RMAN (Shell Scripting) + Duplicated database with TDE (Encryption) enabled + Handled Production Issues: Node Eviction (XD), ORA-600 and system hang ,ORA-4031 errors, duplicate db with TDE issue + Diagnosed and addressed potential post migration Exadata performance issues (RAT replay testing) – AWR/ASH/ADDM reports Energy & Utilities Sector ,Burlington, VT 02/12 – 05/12 Project Details ( RAC and 11g New Features Implementation ) : + 2 node 11.2.0.2 CRS/RAC Setup and Configuration with dNFS + RAC Performance Analysis + 11gR2 Partitioning New Features Implementation + 11gR2 Advanced Compression Implmentation – OLTP & LOBs as Securefile + Extensive shell scripting and PL/SQL coding Internal Trainings attended so far : 12c Database Upgrade and Migration ( 2 days ) ;Exadata Boot Camp Level 1 and 2 (5;5 days ) ; OU - Data Guard ( 4 days ) ; OU Oracle Certified Expert – RAC training ( 5 days ) ; OEM 12c Deep Dive ( 5 days ) Trainings Delivered : RAC 11gR2 Deep Dive ( 5 days ) ; RAC 11gR2 Troubleshooting From February 2012 to November 2014 (2 years 10 months) Senior Principal Technical Consultant , System Performance and Architecture Group @ Web Applications Sector , Phoenix, AZ ( 04/13 - Present ) Project Details ( OEM 12c Implementation ) + Implemented and deployed L3 level OEM 12c High Availability Solution. + Designed Administrative group , dynamic groups , metric extensions , templates, incident rule sets, customized dashboards and reports. + Troubleshooting OMS startup issues and presented on basic diagnostics + Provided guidance on configuration management , change management , incident management , compliance management , patching and provisioning. Workforce Solutions Sector , Troy , MI ( 03/13 - 04/13 ) Project Details ( Data Guard FSFO troubleshooting ) + Provided guidance related to configuration ,performance and management of Oracle Data Guard environment; + Validated the failover process to identify failover issues and provide guidance related to addressing issues ( FSFO );Developed test cases and troubleshooted existing FSFO configuration issues. Medical Research Sector , Houston , TX ( 01/13 - 02/13 ) Project Details ( Exadata X3-2 Implementation ) + Provided operational readiness and patching recommendations + Assisted with developing an Exadata future-state database architecture + Assisted with developing Systems and Operations Management Strategy based on Oracle's best practices + Reviewed and develop Backup and Recovery Strategy based on Oracle's best practices + Devised Capacity planning requirements and provide recommendations + Reviewed data migration and testing requirements and provide recommendations + Assisted with Exadata Engineering and Implementation Services including but not limited to: + Configured the Oracle Database for use with ODB and CE Health Science Data Models + Installed and configured Oracle Enterprise Manager 12c ("OEM") Exadata plugins and the Oracle Management Service ("OMS") + Assisted with backup and recovery configuration and integration to Exadata + Provided Exadata and Systems Administration implementation mentoring to the team From January 2013 to December 2013 (1 year) Senior Technical Support Engineer ,Real Application Clusters Group @ + Troubleshooting complex and escalated RAC related issues – 9i, 10g, 11gR1 and 11gR2 RAC : CRS install, configuration,patching, management;Node evictions;Instance evictions;RAC Performance;Database hangs and deadlocks- system state dump and hang analysis + Building RAC cluster with Openfiler storage and simulating customer cases inhouse . 2 node 10gR2 RAC with openfiler – OCFS2 2 node 11gR2 RAC with openfiler – ASM (upgraded from 10gR2) 11.2.0.1 RAC upgraded to 11.2.0.2 RAC on Linux + Handling rotational responsibility of a Cluster Technical Coordinator + Coordinating with bug development engineers for potential bugs in the product + Authoring knowledge articles Trainings attended : 10gR2 CRS training (5 days) ; 10gR2 RAC Performance training ( 5 days ) ; 11gR2 RAC New Features ( 2/5 days) From March 2009 to February 2012 (3 years) Technical Analyst ( Architecture and Engineering ) @ Projects led in Cross Platform Engineering : + Intergrated OEM – Tivoli - for sending alerts from OEM server to IBM’s Tivoli server (Shell Script) + Integrated Fog light – Tivoli– for sending alerts from Fog light server to Tivoli (Perl) + Automated Big Fix Software Inventory Data Migration (SQL server to Oracle) + Wrote test units for Server Build Automation (Java) + Created customized web reports (JavaScript) From September 2008 to March 2009 (7 months) Database Engineer @ + Shell scripting – ksh , bash + Performance analysis : Application query tuning , load analysis, OS level tuning ,database tuning + Maintenance tasks : cloning databases, renaming instances, performing switch over + Oracle Data Guard implementation + Handled On-Call DBA responsibilities From April 2008 to September 2008 (6 months) Database Engineer - College Intern @ + Prepared customized shell scripts for upgrade activities, capacity planning, Oracle Applications R12, RAC environment monitoring. Integrated shell scripts with JSP for intranet portal. + 10g upgrade project: Involved in planning, preparation and implementation of 10g upgrade for over 200+ 8i/9i databases. + Implemented OEM Grid Control Setup + Handled Performance Tuning and Troubleshooting issue + Implemented and tested 8i/9i – 10g Database Migration tool From May 2007 to March 2008 (11 months) Associate Support Engineer ( Oracle Apps ) @ + Installed Oracle Apps Releases from 11.5.1 to 11.5.10 CU2 on Linux, Solaris Platforms. + Upgraded and Migrated from 11.5.9 HP-UX to 11.5.10 CU2 on Linux. + Cloned Multi-node setup to Single-node, Single-node to single node + Patched Developer, iAS, Database and Oracle apps + Implemented RAC with Oracle Applications with ASM storage + Handled OATM Migration (Oracle Application Tablespace Model). From December 2005 to August 2006 (9 months) Junior Database Administrator @ + Installated,upgraded and applied Patches on Db versions 8i,9i + Looked into Performance Tuning and Troubleshooting + Implemented One Way Replication and Physical Standby Db Creation + Migrated from Oracle 8i versions to 9i versions + Handled periodic security audit of the databases From July 2005 to December 2005 (6 months) Mumbai Area, IndiaCollege Intern @ From 2003 to 2004 (1 year)

M.S., Computer Science @ New Jersey Institute of Technology From 2006 to 2007 B.Tech, Computer Science @ Punjab Technical University From 2001 to 2005 Delhi Public School, Noida From 1995 to 2001 SPSEC , Kanpur From 1991 to 1994 GA BEWD-23 Janisha Anand is skilled in: High Availability, Patch Management, Performance Tuning, Server Architecture, Automation, Scalability, Relational Databases, Clustering, Unix, Database Administration, Shell Scripting, Linux