Pushpanathan Vanathaiyan
Oracle Apps DBA
Summary
Experienced Oracle Apps DBA with over 6 years. Excellent reputation for resolving problems and improving customer satisfaction. Summary Having 6 years of experience in Oracle Database and Oracle Application E-Business Suite Administration. Have specific expertise in Oracle Database Production installation and Fresh Implementations and DR configuration Upgrades and platform migrations, RMAN backup operations, Real Application Cluster and ASM storage. I have experienced in Oracle Database Cloning, Tablespace management, User management, Backup and Recovery. Having excellent communication and interpersonal skills ,experience in Oracle Applications Load balance, Cloning using Rapid clone procedure along with AD Utilities like AD Admin, AD Patch, AD Relink, and Autoconfig. Experienced in configuring and restoring the backups from Oracle cloud environments. I have good analytic and problem-solving abilities.
Overview
6
6
years of professional experience
4
4
years of post-secondary education
4
4
Certifications
2
2
Languages
Work History
Oracle Apps DBA
4i apps Solution private limited
Chennai
04.2017 - 08.2021
- R12.1.1 on Two node RAC Oracle Linux Oracle Apps DBA
- R12.1.1 on Two node RAC Oracle Linux Oracle Apps DBA
- Upgraded the database 10.2.0.4 to 11gR2 on the Production and Test instances
- Upgraded the database to 11gR2 and 12C on the Production and Test instances and configured
- DR.Upgraded database to 19c
- Configured DR for Oracle EBS R12.1 ,12.2.6 &R12.2.7
- Upgraded the Applications Version to R12.1.3 and R12.2 on PROD and TEST Instances
- Good knowledge on troubleshooting the upgrade issues
- Upgraded Oracle E-Business Suite Release 12.x JDK to Java 8.0 latest update
- Prepared and handover the Oracle EBS Upgrade documents to the client
- Migrated Operating system from 2003 32-bit server to 2008 64 bit with EBS application
- Raised SR & Interacted with Oracle support and solved the issues
- Configured Custom top for deploying customizations files 4
- Experienced in Oracle database & application Patching activity
- Experienced in Adpatch and ADOP online patch cycles
- Monitoring Alert log files for any ORA related errors
- Checking Tablespaces size & configured alert mail using OEM
- End user support for functional / technical related issues and resolve them timely
- Configured f5 load balancer URL for two node application
- Configured parallel concurrent processing
- Configured Disaster Recovery sites for Oracle database
- Health checkup of oracle application instances (Production, Development and Test)
- Changing Applsys, Sysadmin and Oracle user’s password using FNDCPASS utility
- Applied the latest RPC Collection 3 Patch on top of the R12.1.3 instance
- Re-Configured the work-flow with SSL certificate import after the upgrade
- Configured TLS in Oracle EBS 12.2.7
- Mobile Application configuration in Oracle EBS 12.2.7
- Configured and Maintained DR for critical databases
- Configured disaster recovery solutions for applications including EBS using storage replication method
- Monitoring & troubleshooting Hardware issues related to Server storage, disk space issue, backup, disk errors, Exchange queues, performance, health check, replications on DCO & Exchange servers
- Installing and migrating the existing environments to RAC environment
- Cloning the RAC to RAC and RAC to Non RAC environments
- Adding the storage to disk groups
- Administering and troubleshooting the ASM issues
- Collecting the client business requirement & prepared the suitable architecture for implementing 5 project
- Install and configuring the SSO with exiting ebs environments
- Updating the Form Authentication for Delegated Administration
- Enable SSO protection for the Oracle Identity Navigator and APM Consoles
- Validating the Oracle Access Manager Single Sign-On Setup
- Prepared the Approach & Project Plan
- Installed R12.2.0 with desired modules and applied R12.2.x patch set to achieve the latest functionalists
- Applied the latest AD&TXK patches on R12.2 to have new features of ADOP patching cycle options
- Performed installation of SQL Enterprise 2012 SP1 CU 5 64-bit version on Windows 2012 Sp1
- Clusters
- Implemented the new SQL Server 2012 mechanisms like data compression, online indexing,
- Contained Databases, security principals
- Troubleshooting the upgrade issues in a timely manner
- Upgraded Oracle E-Business Suite Release 12.2 JDK to Java 1.8.0.65 latest update
- Configured Oracle Enterprise Manager 12c to monitor and manage the database through OEM console
- Applied latest CPU patches in Production environment
- Configured Offline/Online backup activities through scripts and validated by restoring on Test environments
- Performed cloning activities to build development and test environments both single node and multi node
- Creating and managing Application Users and assigning responsibility
- Experience in using Data pump utilities like expdp and impdp for table refresh from Production to 6 development and test instances
- Security Maintenance like password settings, profile allocation etc
- Raising SR then troubleshooting and solving the issues
- Provide 24x7 supports for the Production and development environment
- Configuring and troubleshooting the Backups to Oracle Cloud
- Validating the backups by restoring the backups from Oracle cloud to in house serve
- Configured the RMAN backups in the Production environment
- Configuring the Development and Test instance from RAC to Non RAC Cloning with ASM
- ASM using RMAN with R12 EBS application
- Experienced handling RAC database and troubleshooting issues
- Monitoring the cluster status and troubleshooting cluster failures
- Applying Opatch in RAC instance and Adpatch in the application environment
- Creating Snapshot standby databases and Operational pre-reqs
- Creating Physical and logical standby Database
- Enabling Data guard protection modes and redo transport services
- Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server
- Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
- Configured PCP , forms & web load balancing using F5 and Cisco
- Applying required patches and family packs using adpatch, adadmin and adctrl utilities
- Managing Concurrent Managers and Concurrent Programs and troubleshooting the concurrent manager issues
- Managing Oracle Application using AD Utilities ad adrelink, adpatch, Adadmin, adclone
- Configured Workflow Notification Mailer in Oracle Application R12 and troubleshooting the notification issues
- Create and manage application users, assigning responsibilities and user profiles
- Maintenance included re-linking applications objects and regenerating forms and reports
- Monitoring Table spaces, Mount points and Archive logs on daily basis
- Upgrading the Java version from lower to higher version
- Configured Offline/Online backup scripts for backup activities
- Monitoring the alert log and trace files to monitor the day-to-day DBA activities
- Generating .fmx from file .fmb files using frmcmp_batch utility on client request
- Compiling JSP pages in R12
- Experienced troubleshooting load balancer issues
- Experienced troubleshooting parallel concurrent configuration
- Configured Oracle Mail Alert for error concurrent program in R12 PROD environment
Oracle Apps DBA
Bank Muscat
Muscat
11.2018 - 06.2019
- Collaborated with system architects, design analysts and others to understand business and industry requirements.
- Implemented Content server
- Security and vulnerability fixes from rapid 7.
- performance tuning for EBS and weblogic server.
- Support activities in EBS R12.2.6 and content server - Cloning, Security patching using ADOP, Health check, Memory leak patches, ETCC patches.
Oracle Apps DBA
PPGPL
06.2018 - 01.2019
- Cloning EBS R12.2.5 Environment in Windows machine.
- Database performance tuning.
- Daily support task,Issue analysis and health check
- SSO solution
Oracle Apps DBA
GSSL- Guardian Group
01.2018 - 12.2019
- Support activities in IBM AIX environment.
- DR solution Failover, switchover and switch back activates done in R12.1.3 environment.
- Cloning EBS R12.1.3 environment in IBM AIX machine. Applied ETCC patches using adadmin.
- Printer configuration,Database performance tuning
- Designed internal process improvements to automate repetitive tasks, shortening data delivery times.
- Unified disparate data structures and operating environments during revamps of processing facilities, data centers and more.
- Migrated numerous legacy systems to newer technologies, reducing costs and enhancing efficiency of computing tasks.
- Established and secured enterprise-wide data analytics structures.
Oracle Apps DBA
Gulf Drug
06.2019 - 08.2019
- Unified disparate data structures and operating environments during revamps of processing facilities, data centers and more.
- Designed internal process improvements to automate repetitive tasks, shortening data delivery times.
- Established and secured enterprise-wide data analytics structures.
- Verified isolation of data to specific geographic borders to comply with national and international data transmission laws and regulations.
- Enabled German language for EBS R12.2.7
- Applied Translation synchronization patches using ADOP
Oracle APPS Dba
Haya
muscat
01.2021 - 08.2021
- Cloning EXADATA database from PROD to non prod
- Support activity in ENDECA
- Cloning EBS in multinode environment.
- DMZ configuration
- PCP configuration
- SSO implementation
- IDCS configuration
- Provided High availability solution
- Performance tuning, Multi-node configuration,Load balancer configuration
Oracle Database Administrator
HID GLOBAL
Chennai
08.2021 - Current
- Proposed database changes to ease monitoring and administrative effort.
- Provided resources and skill sets to support DBA functions for applications.
- Established working relationships across various departments to understand existing and emerging IT requirements.
- Monitored and analyzed database activity to identify and prevent incidents and recommend performance improvements.
- Reviewed database design to recommend enhancements or improvements.
- Troubleshot database issues to create and resolve trouble tickets.
- Adhered to set schedules to test databases for flaws and reduce downtime.
- Administered, supported and monitored databases by proactively resolving database issues and maintaining servers.
- Installed and configured middleware in Linux and Windows environments.
- Defined hardware requirements and planning storage capacity to manage systems and infrastructure.
- Wrote and maintained technical and functional specifications to document database intentions and requirements.
- Implemented EBS Command center for finance and SCM modules.
- Installed apex and configured with IDCS
- Upgraded agile database and application from 12c to 19c, 12.2.1.3 to 12.2.1.4 and applied latest RUP patch.
- Configured EBS with SSO
- Upgraded vertex environment from release 8 to 9.
- Database character set conversion using DMU utility.
- EBS database upgrade from 12c to 19c.
- Worked in support activity on OIC,OCI,GAP,AGILE,APEX,VERTEX,DISCOVERER,IDCS,SSO
- Applied latest oracle security patches for EBS,DB,FMW,WEBLOGIC
- Cloning the multi-node environment.
Education
Bachelor of Science - Computer Engineering
Pallavan College of Engineering
Kanchipuram 08.2011 - 08.2015
Skills
RDBMS Oracle 10g/11g/12cundefined
Certification
Oracle Autonomous Database associate
Timeline
Safe Agile Practice
08-2022
Oracle Database Administrator
HID GLOBAL
08.2021 - Current
Oracle APPS Dba
Haya
01.2021 - 08.2021
Oracle Autonomous Database associate
01-2021
Oracle Cloud Infrastructure Foundation Associate
01-2021
Oracle OCI architect Associate
01-2021
Oracle Apps DBA
Gulf Drug
06.2019 - 08.2019
Oracle Apps DBA
Bank Muscat
11.2018 - 06.2019
Oracle Apps DBA
PPGPL
06.2018 - 01.2019
Oracle Apps DBA
GSSL- Guardian Group
01.2018 - 12.2019
Oracle Apps DBA
4i apps Solution private limited
04.2017 - 08.2021
Bachelor of Science - Computer Engineering
Pallavan College of Engineering
08.2011 - 08.2015
Similar Profiles
Srikanth CSrikanth C
Business Analyst at Azvasa Education Private LimitedBusiness Analyst at Azvasa Education Private Limited
Gowthami ThangarajGowthami Thangaraj
Senior Manager - Human Resources at 4I APPS SOLUTIONS PRIVATE LIMITEDSenior Manager - Human Resources at 4I APPS SOLUTIONS PRIVATE LIMITED
Narender SNarender S
PMO Project Coordinator at 4i Apps Solutions Private LimitedPMO Project Coordinator at 4i Apps Solutions Private Limited