SUMMARY:

• Over 20 years of experience managing data, including 17 years as Database Administrator in production environments, including architecting solutions
• Implemented Oracle database setup with RAC 8+ nodes (Real Application Clusters) with segregated services; and data guard standby databases, handling all aspects of administration including oracle upgrades, patches, migrations, performance tuning, and maintenance.
• OCP certified with deep expertise with RAC and database technologies.
• Implemented 50+ multiple RAC setup which handles over a petabyte of data, few with FSFO setup to handle transparent failover, TDE and standby databases.
• Managed 200+ production instances with additional stack of QA and Dev environments.
• Migrated to LAMP stack, open source RDBMS to reduce license cost and increase ROI.
• Migrated and implemented multiple NOSQL/ BigData / Hadoop systems for analytics.
• In - depth understanding of performance tuning and implementing security procedures to ensure database integrity and compliance with Sarbanes Oxley requirements.
• Strong background in developing backup and disaster recovery plans and proactive monitoring to business processes to meet all client service and operational level agreements.
• Familiar and practiced with ITIL, SCRUM, Agile and DevOps.

TECHNICAL SKILLS:

DBA: Primarily with Oracle, PostgreSQL, MS SQL Server and MySQL.

Oracle Confidential Skills: OCP, Oracle RAC, Oracle 12c, 11gR2, 10g/9i/8i on IBM AIX, Linux, Oracle Linux, Oracle VM, VMware, Sun Solaris and Windows. Real Application Clusters (RAC), Data Guard, Audit Vault, IAM, OIM,OAM, Golden Gate, Streams, SCAN, Change Data Capture (CDC), Exadata, Performance Tuning, Security Administration, Disaster Recovery Solutions, Design and Architecture Database Systems, Data Modeling, Recovery Manager (RMAN), OEM Grid Control, Standby/Active dataguard solutions, OEM, Shell Scripting, PL/SQL, AUDIT/ SOX implementation.

Database Appliances: POC experience with Oracle ODA X5, Oracle Exadata and Teradata.

ERP: SAP, SAP HANA, GIS, Oracle EBS Applications 10.x/ 11.x, R12, Oracle CC&B Utilities

NOSQL: Cassandra, MongoDB, HPE Vertica, CouchDB, Riak, Redis, RedShift, DynamoDB,VoltDB, MemSQL

BigData: Architected parallel Intelligence/Analytics setup on NOSQL, Hadoop HDFS, Hbase with M/R, Hive, Pig, Spark, Storm, Hadoop Stack, Kafka.

Analytics: R, SAS, Pipeline Pilot,Tableau, Business Objects, Informatica, ArcGIS.

DataWarehouse: Oracle, ODI, Exadata, Teradata, Informatica, Pentaho, PDI/Kettle, ETL

Cloud: Oracle Cloud, Internal Cloud, Salesforce, AWS Stack, SaaS, PaaS

Automation: UC4, Ansible,Chef, Informatica, OEM, Pipeline Pilot, HP Operations Orchestration, Project Management, Unix Shell tools

Virtualization: VMware, Virtual Box, Lpar

Languages: LAMP Stack, Python, Perl, PHP, C, Java, XML, HTML, JavaScript, SQL, PL/SQL, Scripting languages, Unix Shell Scripts and custom scripting.

PROFESSIONAL EXPERIENCE:

Lead Consultant

Confidential,San Francisco, CA

Responsibilities:

• Setup, manage and implement features on database servers.
• Architected solutions with compliances with internal standards and regulations.
• Architected SmartMeter, Revenue Reporting, Customer Data Warehouse databases
• Managing upgrades, PSU patching oracle databases at regular intervals.
• Monitor alerts and follow up on incidents by RCA, follow up with oracle support.
• Architecture team member for High Availability and physical design with RAC, ASM, Data Guard and Observer technologies.
• Implemented and or upgraded RAC 12c, 11gR2, 10 with ASM and standby databases.
• Implementation team member of Golden-Gate replication along with its precursor Change Data Capture (CDC) Streams.
• Implemented Oracle Identity and Access Management modules including Oracle Adaptive Access Manager (OAAM) and Oracle Identity Manager (OAM) for DW authentications.
• Implementation team member of Audit Vault, IAM, OIM, OUD to comply with SOX audit rules and access management.
• Expertise with performance tuning SQL and PL/SQL, putting outlines, profiles, SPM to stabilize execution plan. Identify plans by explain plan, cost by TKPROF or oracle utilities.
• Proficient with performance monitoring tools like STRMMON, OSW, SQLT, AWR, ADDM, ASH and experience usage with 3rd party database tools.
• Implemented Oracle TDE, encrypted password security mechanism for automated scripts.
• Refreshing non-production environments from production with choice of data masking.
• Managing multiple lower environments to migrate application code path from development, test to production through valid migration paths.
• Migrated mainframe DB2 and legacy data to oracle databases as part of cost reduction.
• Architected, implemented and administration of Tableau, created linking various databases including oracle, Teradata, Mysql, MSSQL, created aggregation tables based on requirements, created analytical views for reporting portfolio data, optimizing tableau dashboard performance, created new processes to aggregate non-rdbms data and ways to present on dashboard.
• Extracted data efficiently from Oracle to flat files for BigData, Teradata implementation.
• Architected and migrated existing pipelines with Pentaho; used Business Analytics Platform with Integration and reports designer; converted existing BRIO report into Pentaho Report Designer.
• Implemented low cost documental system using Hadoop architecture for storing and retrieval of historical archives.
• Implemented, migrated and managed archival warehouse databases to MongoDB 3.x.
• Implemented and migrated SmartMeter data into Apache Cassandra and later into HPE Vertica database; analytics and process workflow aggregates data and feeds to downstream applications.
• Validated successful migration of long running jobs and met SLAs in Vertica database.
• Monitored and managed administration and alerts setup on Vertica using management console
• Managed multiple 100+Terabyte databases with several 8 RAC nodes. Managed Production and similar multiple environments combined database size over 2 Petabytes.
• Implementation team member on SOX audit rules, Grid Control alert notification.
• Lead member in Performance tuning and Capacity planning team.
• Expertise in tuning PL/SQL, SQL with Explain Plan, TKPROF profiling utility parses trace file, Memory, IO and other database components.
• Implemented RMAN backup and restore scripts, configured and schedule through UC4 external job scheduler/management tool.
• Implemented encrypted password security mechanism for automated scripts.

Consultant Data Solutions

Confidential,Emeryville, CA

• Architecture team member for High Availability and physical database design with Clusterware, Automatic Storage Management, Real Application Cluster and Data Guard technologies.
• Implemented 10G RAC including CRS, ASM, and migrated legacy data.
• Managed multiple VLDB databases with multiple RAC nodes (>6).
• Expertise in performance tuning on the SQL program layer on SQL, PL/SQL, along with the infrastructure stack.
• Expertise in performance monitoring tools like SQLT, AWR, ADDM, ASH, OSWatcher along with 3rd party database tools.
• Implemented RMAN backup and restore scripts, configured and scheduled jobs.

 Confidential, Oakland, CA

• Responsible for database architecture, modeling, layouts, backup, tuning, on-call production Confidential and support for clustered multi-terabyte production Oracle databases. Additional tasks included creation of SQL, PL/SQL, packages, physical, logical entities, triggers and schema objects.
• Performed Oracle Confidential duties including implementation of hot backups and full restore plans for client’s Oracle Apps databases. Applied patches and updates during the migration and helped application developers to upload various blob objects into Oracle.