Oracle Applications Dba Resume
4.00/5 (Submit Your Rating)
SUMMARY:
- To succeed in an environment of growth and excellence and earn a job which provides me job satisfaction, self - development and help me achieve personal as well as organization goals.
- Thorough Understanding of the Philosophy and Features of MongoDB
- Knowledge of all the CRUD operations
- Knowledge of both Simple and Complex Indexing
- Used Indexing to reduce performance cost on database
- Thorough knowledge of In-Memory Computing
- Clear understanding of various reducers like $match and all other aggregate functions
- Aware of Mongodb Replica sets, priorities of nodes in replica set etc.
- Knowledge on Configuration of shards, when to shard a collection etc
- Knowledge on User authentication and authorization in MongoDB
TECHNICAL SKILLS:
ERP: Oracle APPS R12, 11i, R12.2, R12.2.5
Database: Oracle 11g,12c
NosqlDatabase: MongoDB
Cloud Technologies: AWS
Operating Systems: UNIX Linux, Solaris, Windows
Languages: SQL, HTML5, JavaScript
Software and Tools: Virtual Network Computing tools, Remote Desktop, Putty WinSCP, SQL*Plus, MS Office
Middleware: Weblogi
PROFESSIONAL EXPERIENCE:
Confidential
Oracle Applications DBA
Responsibilities:
- Administrating and Maintenance of 24 x 7 Production, Non-Production, Development, Test environment Supported the Upgrade of Oracle E-business Suite from 12.1.3 to 12.2.5 Supported the Upgrade of Oracle Database from 11g to 12c Clone the E-business suite system according to the needs of development teams System administration (sysadmin) functions like creating users, Creating responsibilities and menus, Printer setup, Password reset, Report registration, defining customize concurrent manager, scheduling request Checking the status of important services like concurrent manager, form server, web server, application listener, database listener etc.
- Create backup strategies to meet business needs, which involve technologies like hot backup, cold backup.
- Created and Managed ASM instance and Database in RAC Experience in Real Application Cluster (RAC) Create and maintain scripts for identifying long running jobs, backlog jobs, memory hogs. Work on code migrations from Development instances to Test and Production instances.
- Performance tuning of poor performing queries Installation and configuration of Oracle Fusion Middleware applications like
- Oracle Weblogic and Fusion middleware administration, applying weblogic patches
- Oracle 11g OEM grid control installation, configuration and monitoring hosts
- Participate in a team to maintain & support multiple oracle databases and applications in high availability (24 X 7) environment.
- Handle day-to-day DBA activities using Oracle utilities and tools, monitoring space and memory requirements.
- Checking Alert Logs, Archive Logs, Trace files, backup verifications & Health check-ups of database.
- Maintenance of concurrent processing requests and concurrent managers. Interact with the functional team; define responsibilities, menus, request groups, users. Handle multi-tier architecture: Desktop tier, Application tier (Web server, Form server,Concurrent processing server and Administration server) and Database tier.
- Use different Oracle Applications tools like Adadmin, Adctrl, Adpatch etc., for maintaining database and applications Applying latest releases of the application patches from Oracle on Production and test instance to resolve application issues. Coordinate in resolving various performance issues Code migration for custom development from production environment to Development and vise versa Applying Patches Create and Follow up Service Requests with Oracle Support for Technical Support Managing Users, Responsibilities and Profile options Monitoring Health Check of servers by background process and by using OAM Installation and maintenance of Oracle Products on LINUX platform. Assigning responsibilities to users. Code Migration through FNDLOAD, WFLOAD.
- Extensively worked on Oracle Applications AD Utilities. DataBase Administration tasks.
- Monitor alert logs, space and object growth related problems in the databases. Oracle Applications System Administration such as managing concurrent programs and requests, application security, user registration, assignment of responsibilities.
- Analysis of trace and log files to determine and resolve potential problem areas.
- Monitored and diagnosed database performance through monitoring of alert files, trace files.
- Post installation trouble shooting.
- Cloning from Production database to Development database and Testing.
- Perform a daily database refresh of the training and practices instances from pre-production and Production server. Monitored concurrent processes / spawned processes so that performance of the system is maintained. Having a good knowledge on routine monitoring, database shutdown, backup, startup etc.
- Cloning of Oracle Applications with autoconfig. Patch analysis for database and applications patches including, family packs, and one-of patches. Performed patch analysis for patches involving lot of pre-requisites. Experience working with Linux, AIX, and Solaris operating systems.
- Good Experience in AD utilities. Very good in communicating to the clients and end users Good analytical and troubleshooting skills. Well organized and detail oriented with strong adherence to deadlines.
Environment: Oracle 11g, Oracle Applications R12, Oracle Enterprise Linux, Shell scripting, SQL Developer, TOAD, Developer 10g suite, telnet, Oracle Weblogic 11g
Confidential
Mobile Applications Developer
Responsibilities:
- Used SAPUI5 a framework tool
- Used Javascript HTML5 and CSS3
- Procedures in SAP HANA to fetch the Data
- Helped and developed the strategy for the project “ Blood Link ”
- Performed Intensive testing
- Have a thorough understanding of the framework tool
- Built ER Diagrams to develop procedures in HANA
- Tested the compatibility on all environments (Android, Windows and IOS)
Environment: SAPUI5, SAPHANA, JavaScript, HTML5, CSS3