SUMMARY:

• Accomplished Senior Database Architect possessing 20+ years of progressive experience in Database, Linux and Unix Operating Systems,
• Developing, and delivering large - scale Enterprise, Cloud, Data & Analytical applications.
• A motivating leader with 15+ years of rich management experience in building diverse world-class technical teams, specializing in mentoring, and developing managers.
• Extensive experience as a solution architect for business information systems, focusing on Database architecture, data modeling, data analysis, software design, programming and application Integration
• In-depth knowledge of large database design techniques; data analysis, data cleansing, and data transformation &migration using ETL tools
• Oracle administration skills and knowledge of RMAN, RAC, database backup and performance turning.
• Extensive knowledge of Data Warehouse/Data mart concepts & Expertise in data modeling for OLAP & OLTP systems from design and analysis to implementation including the conceptual, logical and physical data models.
• Experience in UNIX and Windows environments, as well as operating system specific shell scripting and development using C/C++ with UML and OOAD Methods
• Extensive experience in preparing Functional specifications and Development of RDBMS based Commercial Database/Software Applications with GUI in a Client/Server environment. (Oracle 8i/7.3.4) and data modeling for Data warehouses in techniques like Dimensional modeling
• Designed, setup and tuned a Multi-Terabyte (2-4TB) oracle VLDB database for online & Batch Transactions
• Extensive experience in preparing Functional specifications and Development of RDBMS based Commercial Database/Software Applications with GUI in a Client/Server environment (Oracle 8i/7.3.4) and Data modeling for Data warehouses in techniques like Dimensional modeling
• Skilled in object-oriented, database, big-data infrastructure designs with hands-on experience in Technologies like Java, Python, Hadoop, JavaScript, etc.
• Consistent track record of driving project success by inspiring globally dispersed teams of skilled engineers and product managers to produce superior work quality while adhering to strict timelines.
• Rich experience working in a startup, wearing multiple hats, and well-versed in all aspects of software development from prototyping to production, scaling applications, supporting, etc.

AREA OF EXPERTISE

• Oracle SaaS Applications
• Oracle PaaS (App Integration, App Dev, Database)
• Oracle IaaS (compute, Storage, Networking)
• Webservices (Soap/Rest)
• Business Intelligence
• Cloud Architecture
• DevOps Efficiency
• Big Data Applications
• Amazon AWS
• Acquisition Integration
• Cross - Functional Collaboration
• Distributed Systems
• Containerization
• Massively Scalable Deployments
• Enterprise Applications
• Strategic Planning
• Coaching and Mentoring
• Identity Management
• Scaling Teams
• Managing Budgets
• Startups
• Agile Methodologies
• Compliance & Standards
• High-Availability
• Enterprise Data Warehouse

TECHNICAL SKILLS:

• Docker
• SQL, PL/SQL, MY SQL
• OBIEE
• TimesTen In - Memory Database
• Business Intelligence
• Python
• C, C++
• Oracle Fusion Middleware
• SQL, PL/SQL
• UNIX
• Linux (Redhat, Debian, OEL)
• Windows
• Apache Airflow
• Terraform
• Kubernetes
• HTML
• CSS
• Oracle Fusion Middleware
• Weblogic, Oracle Application Server, WebSphere
• Quest
• Oracle Enterprise Manager Grid
• Kana, Clarify, Interwoven (TeamSite tools)
• Pro *c
• Enterprise Data Warehouse

PROFESSIONAL EXPERIENCE:

Confidential, Pleasanton, CA

Principal Technologist

Responsibilities:

• Oracle RAC/ASM., Data-replication tools - Shareplex & Golden-Gate
• Change Management, Cloud Migration &Extensive experience managing highly-available, large, multi-datacenter clusters in production, in a platform/infrastructure/Sr.DBA role, preferably in a Cloud.
• Experience scripting administrative tasks using python & shell scripts
• Experience in Oracle 12c RAC, Performance tuning/troubleshooting skills and experience with VLDB's.
• Coordinated with internal and external customers to develop new value-added programs and data solutions with existing data warehouse structure
• Architecture & Design validations for ISV App certification on OCI & Assisted ISVs certify their solution on OCI
• Developed and Maintained data models, structures, and procedures to ensure the integrity and performance of database components
• Working with the ISV team on the Priority Cloud Accounts (Top ISV partners)
• Support Oracle cloud Implementation Projects with Oracle SI partners
• Responsible for partner operations to install the Fusion Application Environments (CRM, Financials, HCM etc.)
• Create & Maintain Linux VM’s in the Hypervisors inside & outside the firewalls
• Create & Maintain the OBIEE dashboards and ORACLE 12c databases
• Shared and Train the learning experience with Peers and assisted with Knowledge Transfer and issue escalation
• Integrated Oracle E-Business Suite (EBS) with Oracle Single Sign-On, Directory servers and deployed it on Oracle Partner applications
• Collaborated with the business stakeholders and created Dashboards, KPIs and Metrics. This helped streamline and centralize the data systems, reduce support costs
• Architected and engineered a Data Platform using AWS EMR, Airflow (Kubernetes,), Kafka, Docker, SAAS, Snowflake, Looker platform, Terraform, etc., to harvest data from 100+ silos into a Data Lake for running actionable analytics
• Architected, and developed a cloud service framework to automate complex IDM lifecycle procedures such as provisioning, upgrading, patching, and cloning.

Environment: Sun Solaris, Oracle Enterprise Linux, Windows Server, E-Business, PeopleSoft, OBIEE

Confidential, Palo Alto, CA

Database Architect

Responsibilities:

• Primary responsibility for all administration of 2 production and 3 development databases.
• Duties encompassed of installation, upgrades, configuration, auditing, hot /cold backups, recovery, proactive monitoring and all tuning
• Designed, setup and tuned a multi-Terabyte Oracle Database for online & Batch Transactions
• Streamlined Oracle RDBMS management by use of Software, which included the Oracle Enterprise Manager with Performance, Tuning and Change Management Packs.
• Heavy experience with Quest Software’s Space Manager and SQL Lab Tuner, and SQL Navigator
• Architecture and Data Modeling using Erwin for creation of logical/physical Normalized models and PL/SQL Programming
• Worked from design through implementation of reporting data warehouse using an ODS (operational data store)
• Enhancements of HP Business Store in Functional Requirements
• Created Unix, SQL, PL/SQL, and SQL*Loader scripts to automate data downloads and summary table creation from a legacy system into Oracle
• Responsible for finalizing user requirements and building Dimensional, Fact models for meeting Datawarehousing requirements
• Metadata strategy for integrating Data Model description-Oracle reconfiguration, defragmentation, monitoring, and tuning to reduce overhead and improve performance
• I/O subsystem configuration (Mirroring, Striping) and Troubleshooting the performance issues

Environment: HP-UX 9000/ N, K class series, Oracle 8.0.5/8i series, Brio, Business Objects

Confidential, San Francisco, CA

Database Architect

Responsibilities:

• Monitoring resources both at the OS & Database levels
• Installing & upgrading the patches
• Written Perl scripts to run & monitor the Process
• Used Erwin tool to design Entity relationships & process models
• Troubleshooting the performance issues and performed Backup & Recovery Operations
• Ran many performance tests to evaluate the system, tune the database and estimate any required extra CPU and memory
• Capacity planning and tuning the storage parameters for each table and index
• Wrote packages and stored procedures and supported the Dev team
• Design and development of hot and cold backup scripts
• Tuned a VLDB (3TB) oracle databases for online & Batch Transactions

Environment: Sun Enterprise servers 450 series, Oracle 8.0.5/8i

Confidential, Oakland, CA

Oracle DBA

Responsibilities:

• As a member of IT-Ops team, involved in supporting and smooth implementing of the project and responsible for maintaining the software after it has been successfully implemented
• Tested and Implemented patches
• As MOVE system Administrator added users to the MOVE application
• Installed builds on various nodes to create the environment needed for production and testing purposes (for patches, outbound and FTO)
• Processed the OMS-OFS gateway files
• Enabled cron to process the OMS-OFS gateway files
• Troubleshoot and established the causes when there is discrepancy in the inventory maintained by the OMS and OFS
• Wrote wrapper scripts as workarounds to certain problems in Data Warehousing
• Ran Inventory Snapshot to upload the files to PeopleSoft for customer invoices
• Setting Order Allocation in crontab files depends on induction time
• Wrote SQL Scripts to print reports for merchandising, operations and also for messaging the database data to ensure desired function of the system on daily basis
• Trained the operations in using the RF guns (RF guns can communicate with the server and are capable of running the MOVE application)
• Understanding the Data Warehouse Management System and how it interfaces with the other systems
• Handle requests on daily basis from the operations and resolve the data problems by identifying the systems bugs or training issues

Environment: Windows NT, Oracle 8.0.5, Microsoft Access 97, SQL PLUS, SUN Solaris 2.6

Confidential, New York

Application DBA

Confidential, Redwood city, CA

Porting Engineer for Unisys Corp

Confidential

Sr. System Analyst