Requirement for Exadata DMA DBA and ODA Oracle DBA Trainer
₹1250-2500 INR / hour
Closed
Posted almost 2 years ago
₹1250-2500 INR / hour
Exadata DMA and ODA Oracle DBA Training:
Oracle databases in Exadata machine and ODA(Oracle Database Appliance) environments.
Troubleshooting and supporting databases in Oracle Linux, Oracle RAC, and Oracle ASM configuration
ODA architecture and patching experience.
Oracle Exadata architecture and internal framework ; Must have worked on X3/X4/X5/X6/X7/X8 Exadata machines ( at least 2 models), Oracle 19c grid, Oracle 12.2/18/19c RAC databases, 13c cloud control.
Monitor Oracle DATABASE, Check alerts and take care of DATABASE issues (issue resolution) in Exadata
Exadata and database monitoring using Oracle Enterprise Manager(OEM) - Agent installation, DATABASE discovery, Database alert configuration.
Setup various default and customized metrics in cloud control for Exadata
Training to work with Oracle on all hardware issues and facilitate fixing the same.
Performance tuning as needed to ensure DATABASE is up and running healthy
Oracle RMAN backup automation using shell script, backup monitoring, backup tuning, and different types of RMAN Database recovery procedures
Database problem troubleshooting tasks ( using AWR report, ASH report, ADDM report, Various Oracle Advisory framework)
Oracle database Disaster Recovery(DR) setup and management using Oracle Data Guard and Oracle Golden Gate.
Different Oracle database migration methodologies including data pump export/import and cross platform migration etc.
Critical Database Migration on Production systems using DR setup/Pre-cutover/Cutover and EXPDP-IMPDP ; Database migration from ODA(Oracle database appliance) to Exadata and vice-versa.
Base home installation, Database upgrade, patching, and regular maintenance of databases in Exadata
Exadata patching procedures like QFSDP
Identifying and resolving DATABASE issues, problem troubleshooting, root cause analysis, opening ticket with oracle
Various database refresh procedures - Database cloning and Data pump export/import
Troubleshooting and supporting databases in Oracle Linux, Oracle RAC, and Oracle ASM configuration.
ODA architecture, ODA deployment, ODA reimage, and ODA patching experience.
Oracle ODA internal framework; Must have worked on X3/X4/X5/X6/X7/X8 ODA machines (at least 2 models), Oracle 19c grid, Oracle 12.2/18/19c RAC databases, 13c cloud control.
Monitor Oracle DATABASE, Check alerts and take care of DATABASE issues (issue resolution) in ODA.
ODA and database monitoring using Oracle Enterprise Manager (OEM) - Agent installation, DATABASE discovery, Database alert configuration.
Setup various default and customized metrics in cloud control for ODA.
System admin, networking, and storage knowledge.
Work with Oracle on all hardware issues and facilitate fixing the same.
Performance tuning as needed to ensure DATABASE is up and running healthy
Oracle RMAN backup automation using shell script, backup monitoring, backup tuning, and different types of RMAN Database recovery procedures
Database problem troubleshooting tasks ( using AWR report, ASH report, ADDM report, Various Oracle Advisory framework)
Oracle database Disaster Recovery (DR) setup and management using Oracle Data Guard and Oracle Golden Gate.
Different Oracle database migration methodologies including data pump export/import and cross platform migration etc.
Critical Database Migration on Production systems using DR setup/Pre-cutover/Cutover and EXPDP-IMPDP ; Database migration from ODA(Oracle database appliance) to Exadata and vice-versa.
Database home installation, Database upgrade, patching, and regular maintenance of databases in ODA.
ODA maintenance activity like disk, memory, and network card SFP replacement.
Identifying and resolving DATABASE issues, problem troubleshooting, root cause analysis, opening ticket with oracle
Various database refresh procedures - Database cloning and Data pump export/import
Hi,
I have 9+yrs of experience in oracle core and APPS database administration,oracle database migration, upgradation,single instance and cluster configuration (ORACLE RAC), Dataguard,Golden gate ,OCI cloud,AWS RDS, AWS EC2,S3, Oracle docker container and development experience like SQL and PLSQL.I have lot of database upgrade from oracle 12c to 18c and 19c from on premise to on premise and on premise to oracle cloud AWS RDS and EC2 using DMS and S3 bucket . Please let me know if you need any db support.
Thank you.
I am working as Oracle DBA and having over 12 years of experience, Vast experience in handling Very large Oracle Databases. Vast experience in Performance tuning. RAC, ASM , Datapump,RMAN, Adrci etc. VAst experience in programming and scripting also. Shell scripting, php, c#. Huge Experience in SQL loader, DATAPUMP , migration DB from Linux to windows.
Daily Tasks
• RAC,ASM ,Enterprise Manager 11G,12c
• Manage Users, Roles and privileges.
• Data Analysis, Reports generation as per the requirements.
• Report Generation according to analysis.
• Backup Recovery RMAN Backups, DataPump.
• Performance Tuning (AWR, ADDM Reports)
• Index Rebuilding, Space Management, Tablespace Management.
• Creating business processes for new Software Implementations.
• Table Partitioning, Index Partitioning
• Gather Stats Schema wise Database wise
• Oracle Enterprise Manager
• Software Development API integration JSON/XML
• SQL Loader
My 12 years of experience as an Oracle DBA has made me an expert in every Oracle DBA task and I think this expertise makes me a great fit for your organization. Last 3 yrs working on MySQL and Maria Database.
My professional experience includes installing and configuring Oracle Real Application Clusters and implementing Oracle ASM, as well as overseeing the day-to-day upkeep of Oracle databases. I think this experience makes me a great fit for Evergreen Data Management.
Here are some of my most recent skills and qualifications:
• 12 years of experience in ORACLE Database Administration on Production and Development Databases. More than one year of experience in MYSQL Database administration.
• Exadata Administration.
• Exadata environment monitoring using OEM.
• Database creation and refresh in non-prod environment.
• Working closely with Oracle FE engineer while H/W failure.
• Performance related issues handled.
• Compression using EHCC to reclaim space from database.
• High Availability RAC 10g/11g/12c/18c/19c
• Restoration of RAC database for testing environment.
• Configuration of Data Guard.
• Planning switch over and switch back activity.
• Applying PSU and one-off patch in testing and prod environment.
• Monitoring the health check of RAC Database.
• Handled 12c container and non-container databases issues
• Experience in capacity planning, space management, database upgrades/migration.
• Migrated Non-ASM Single Instance to ASM RAC Instance.