->Participate in the design and architecture of large scale Distributed Oracle DBaaS Service features->Design, write and deliver software to improve the availability, scalability, latency, and efficiency of Oracle DBaaS service.->Participate in research and prototyping (proof of concept) different aspect of Oracle DBaaS service ->Primarily responsible for DBAAS SRE Operations handling customer provisioning problems and make sure Customer Exadata Systems are healthy… Show more ->Participate in the design and architecture of large scale Distributed Oracle DBaaS Service features->Design, write and deliver software to improve the availability, scalability, latency, and efficiency of Oracle DBaaS service.->Participate in research and prototyping (proof of concept) different aspect of Oracle DBaaS service ->Primarily responsible for DBAAS SRE Operations handling customer provisioning problems and make sure Customer Exadata Systems are healthy ->Clear understanding OCI internals of virtual machines/networks, on-premise/hybrid cloud computing, cloud identity, security models, cloud monitoring different levels of storage.->Deep Dive troubleshooting on Cloud compute instances , Block Storage/boot volumes make sure compute nodes backups are healthy so that customer VM's & dependent applications are actively working->Expert level analysis on Planning, Implementing new researches solutions to Exadata Systems and Quality presentation to customers & make sure to satisfy customer need & requirement ->Conduct periodic on call duties->Solve complex and difficult problems and build automation to prevent problem recurrence->Participate in DBaaS service capacity planning and demand forecasting, software performance analysis and system tuning.->Responsible in various projects to help customers in Cloud in terms of VM's failures, Application performance and high IO contention issues->Define and develop monitoring infrastructure criteria’s (SLIs, SLOs) for Oracle DBaaS service->Logically Ingest Brand New Exadata Racks with standard Infrastructure level based ,Configure in Cloud with all DBAAS compute & storage requirements before provisioning to Customers ->Troubleshoot Customer network problems, complete analysis from VCN(Virtual Cloud Network) in understanding Subnets of VCN and ensure customer application traffic is going through good load balancing capabilities Show less

Senior Oracle Exadata & EBS Apps DBA responsible for Exadata environments and R12.2.5 EBS Applications •Expert level analysis on Planning & Implementing Oracle Critical Patch Updates and ensure all databases & EBS Applications are meeting standards with current.•Focused on Oracle databases 12.1.0.2 & Oracle EBS R12.2.5 & R12.2.7 production support & monitoring the environments•Expert level of Performance analysis & troubleshooting on Exadata Datawarehouse databases and… Show more Senior Oracle Exadata & EBS Apps DBA responsible for Exadata environments and R12.2.5 EBS Applications •Expert level analysis on Planning & Implementing Oracle Critical Patch Updates and ensure all databases & EBS Applications are meeting standards with current.•Focused on Oracle databases 12.1.0.2 & Oracle EBS R12.2.5 & R12.2.7 production support & monitoring the environments•Expert level of Performance analysis & troubleshooting on Exadata Datawarehouse databases and ETL/Reporting Applications•Top level notch and deep drive analysis on Datawarehouse system migrations and piece to piece performance tuning on all level of SQL based analysis and fix issues•Highly involved in Exadata to VX RAC migrations for required Databases EBS and also migrated to SAAS Snow Flake for complicated Datawarehouse Reporting applications•Strong Analysis & fix Oracle database & EBS complex performance issues concurrent jobs and queries running long.•Expert level analysis on Exadata Storage cell servers addition, rebalancing ASM & memory , upgrade from Exadata X5 to X7 , upgrade EBS R12.2.5 to EBS 12.2.7 and ensure to follow mick runs protocol.•Monitor Non Production & Production Data Guard , RMAN back up scripts and fix as per requirement.•Extensive usage of Python and Puppet Scripting on Oracle databases based on security design & requirementCustomers: Google, Silgan Plastics , AMNS Calvert, Caterpillar Financials & Wellcare Show less

Global Apps DBA responsible for Oracle E-Business and custom applicationsImplementation of Oracle E-Business which includes latest versions of R12.2.3 and R12.2.6Oracle Fusion Middleware InstallationsPrice, Quote, SAP components and Installations. Provide consulting to client for best practices to be followed and manage documentation, issue tracker & time capturing for all the installations.Implementation of new ideas to customer with latest installed E-Business… Show more Global Apps DBA responsible for Oracle E-Business and custom applicationsImplementation of Oracle E-Business which includes latest versions of R12.2.3 and R12.2.6Oracle Fusion Middleware InstallationsPrice, Quote, SAP components and Installations. Provide consulting to client for best practices to be followed and manage documentation, issue tracker & time capturing for all the installations.Implementation of new ideas to customer with latest installed E-Business modulesMonitor and check all E-Business Applications & databases are healthyTechnical project lead for Oracle E-Business 12.2 implementation for Financial and Leasing modulesCloned Oracle Database and applications for R12.2.3Worked on applying patches using ADOP utilities.Effectively working with Development team on Deployments.Troubleshooting performance related issues by working with Development Team using Explain Plan and tracing techniques.Analyzed and applied Delta Patches.Upgraded Oracle Database from 11.2.0.3 To 12.1.0.2Worked on DC Migration for Production and Non Production Instances. Show less

Managing Oracle ERP systems of versions 11i and R12. Architected or improved the architecture for all of these ERPs. Responsible for Non-Enterprise Oracle Databases running varied applications.Design, Develop and Implementation of ERP and Database Systemsleading implemented DR Solution for Oracle E-Business.Leading DBA team operational support and Migrations.Supporting Demantra implementation & R12 upgrade for APS System.R12 implementation for applicationsStrategic… Show more Managing Oracle ERP systems of versions 11i and R12. Architected or improved the architecture for all of these ERPs. Responsible for Non-Enterprise Oracle Databases running varied applications.Design, Develop and Implementation of ERP and Database Systemsleading implemented DR Solution for Oracle E-Business.Leading DBA team operational support and Migrations.Supporting Demantra implementation & R12 upgrade for APS System.R12 implementation for applicationsStrategic Support for MDM, SOA, CTMS and Aurgus rollouts.High-level Responsibilities:Leading implemented DR Solution for Oracle E-Business.Leading DBA team operational support and Migrations.Supporting Demantra implementation & R12 upgrade for APS System.R12 implementation for applicationsStrategic Support for MDM, SOA, CTMS and Aurgus rollouts.Strategized, designed, vendor selected and implementing Global Support Team under offshore Model.Coordinating Offshore team on daily operations supportHigh Visibility on Database Audit model with business to ensure database systems meet with IT Quality as per standards Show less

Responsibilities•Upgraded oracle applications from 11.5.10 to R12 on RHEL5.•Involved in Cloning and patching of oracle applications 11.5.10/R12.•Support and maintain Troubleshoot problems with Apache, concurrent manager, Jserv processes and various oracle application environments..Responsible for Installation of 11g database on 2 nodes RAC, Grid Infrastructure with ASM file systems.•Expert in effective troubleshooting of those problems encountered on a daily basis in… Show more Responsibilities•Upgraded oracle applications from 11.5.10 to R12 on RHEL5.•Involved in Cloning and patching of oracle applications 11.5.10/R12.•Support and maintain Troubleshoot problems with Apache, concurrent manager, Jserv processes and various oracle application environments..Responsible for Installation of 11g database on 2 nodes RAC, Grid Infrastructure with ASM file systems.•Expert in effective troubleshooting of those problems encountered on a daily basis in production & development database environments along with the problems encountered in performance monitoring.•Provided Database Administration support (24x7) for 8TB production oracle 11g Databases.•Responsible for installation, creation of 11g RAC databases for Development and user acceptance test.•Responsible for Upgrading the Database from 10.2.0.3 to 11.1.0.6.Configured ASM file system and administering ASM Instances and Disk Groups in RAC. •Responsible for SQL query tuning, optimization. Performance tuning using tools such as Tkprof, STATSPACK, Explain plan and SQL*Trace.•Responsible for undo rollback management. Created database objects, users, roles and profiles•Responsible for implementing Load Balancing in RAC Database.•Implemented Fast Connection Failover and Transparent Application Failover for ensuring Database High Availability. Created and Managed Services using DBCA.•Excellent in depth understanding of Oracle automatic Undo Management.•Refresh/Cloning of Database from production environment to test environment and application of patches.•Updated development databases by using import/export and SQL loader utilities.•Responsible for monitoring Oracle database activities using Oracle Enterprise Manager.•Responsible for configuration and implementation of backup and recovery using RMAN.•Installed and configured Recovery Manager Catalog Database.•Configuration of Shareplex (Dell Support) between two databases. Show less

Providing 24X7 Oncall DBA support for 500+ Production instancesInstallation, maintenance cloning, patching and post Go-Live support of Production and development environments.Experience in Installation and configuration of Oracle Applications E-Business suite 11iLicensing the new Oracle application productsRegistered customized applications, created responsibilities, customized menus, attached menus to responsibilities and assigning to usersWorked closely with technical… Show more Providing 24X7 Oncall DBA support for 500+ Production instancesInstallation, maintenance cloning, patching and post Go-Live support of Production and development environments.Experience in Installation and configuration of Oracle Applications E-Business suite 11iLicensing the new Oracle application productsRegistered customized applications, created responsibilities, customized menus, attached menus to responsibilities and assigning to usersWorked closely with technical, functional teams and Oracle Support to troubleshoot and resolve issues during implementationPerformed maintenance tasks like Purging Concurrent manager log files, Gather schema statistics, Purging Workflow Obsolete Runtime DataWork with Oracle support in resolving bugs, bug fix patches, multiple sev 1 SRs etcImplement oracle standard procedures for purging, archiving solutions.Created the new custom top on Oracle application tierSystem Administration responsibilities include application security, scheduling work shifts, registering new concurrent programs / request SetsHandling issues related to concurrent manager and performance of concurrent managerPerformed multiple clones from Production to Test environmentsPerformed tracing for various user sessions and for various concurrent ProgramsManaging backups of the apps instances & maintaining daily hot backups of database of dev/test and involved in recovery of databaseRegular checking alert log and trace files for errorsExpertise in configuring Workflow Mailer, troubleshooting and rebuilding workflow queues as and when necessary. Show less

• Applying high priority, security patches, patch sets to oracle using OPatch Utility, runInstaller.• Data Refresh/Cloning from production to setup test (QA) and development environments.• Planned and implemented Disaster Recovery (DR) solutions using Oracle Standby Database/Data Guard.• Had very good experience with SQL, PL/SQL and UNIX Shell Scripting, writing stored procedures, functions and database triggers for maintaining data integrity in the databases.• SQL Query tuning,… Show more • Applying high priority, security patches, patch sets to oracle using OPatch Utility, runInstaller.• Data Refresh/Cloning from production to setup test (QA) and development environments.• Planned and implemented Disaster Recovery (DR) solutions using Oracle Standby Database/Data Guard.• Had very good experience with SQL, PL/SQL and UNIX Shell Scripting, writing stored procedures, functions and database triggers for maintaining data integrity in the databases.• SQL Query tuning, Database instance tuning, application tuning using sql trace, explain plan, hints, tkprof, AWR reports, Statspack reports, ADDM reports, initialization parameters, etc.• Partitioned the large tables and indexes by determining the suitable methodology to improve performance and manageability, Extract, Transform and Load (ETL) data from flat files into database using SQL* Loader.• Defining and implementing Backup and Recovery Strategies on production, test, development databases using RMAN, VERITAS Net backup, and RECOVERPOINT, Hot and Cold Backups.• Recovered tablespaces, datafiles on Oracle 10g using Recovery Manager (RMAN).• Converting datafiles across different platform using RMAN convert, Transportable Tablespaces (TTS).• Crontab jobs and UNIX Shell scripts to automate backups, exports/imports, analyzing tables indexes, monitor tablespace growth, alert logs, startup, shutdown of databases, gathering statistics.• Excellent day to day administration in every means and monitoring alert log files and trace files. Show less