Oracle Database Administration Jobs

8 were found based on your criteria {{ paging.total|number:0 }} were found based on your criteria

show all
  • Hourly ({{ jobTypeController.getFacetCount("0")|number:0}})
  • Fixed Price ({{ jobTypeController.getFacetCount("1")|number:0}})
Hourly - Intermediate ($$) - Est. Time: Less than 1 week, Less than 10 hrs/week - Posted
I have 21 expdp dump file which I got from different company. They didn't give me log file. . I tried show option to check the content of expdp dump file one by one. But gave me error message " Can not find master table" . Getting this too z:\datadave\sql>impdp system/!Q2w3e4r5t directory=BACKUP_DIR dumpfile=expdp_acapp01.dmp,expdp_acapp0 2.dmp,expdp_acapp03.dmp,expdp_acapp04.dmp,expdp_acapp05.dmp,expdp_acapp06.dmp,expdp_acapp07.dmp,expd p_acapp08.dmp,expdp_acapp09.dmp,expdp_acapp10.dmp,expdp_acapp11.dmp,expdp_acapp12.dmp,expdp_acapp13. dmp,expdp_acapp14.dmp,expdp_acapp15.dmp,expdp_acapp16.dmp,expdp_acapp17.dmp,expdp_acapp18.dmp,expdp_ acapp19.dmp,expdp_acapp20.dmp,expdp_acapp21.dmp,expdp_acapp22.dmp,expdp_acapp23.dmp show=y Import: Release 11.2.0.3.0 - Production on Fri Mar 11 13:43:46 2016 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options ORA-39001: invalid argument value ORA-39000: bad dump file specification ORA-31619: invalid dump file "Z:\backup_database\expdp_acapp02.dmp" Then try to directily import multiple dump file to create new database but still get error message "Can not find Master table" Import: Release 11.2.0.3.0 - Production on Fri Mar 11 12:14:34 2016 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. ;;; Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options ;;; Legacy Mode Active due to the following parameters: ;;; Legacy Mode Parameter: "show=TRUE" Location: Parameter File, Replaced with: "sqlfile=expdp_acapp01.sql" ORA-39246: cannot locate master table within provided dump files ORA-39059: dump file set is incomplete z:\datadave\sql>impdp system/!Q2w3e4r5t directory=BACKUP_DIR dumpfile=expdp_acapp23.dmp full=y Import: Release 11.2.0.3.0 - Production on Fri Mar 11 17:21:35 2016 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options ORA-39002: invalid operation ORA-31694: master table "SYSTEM"."SYS_IMPORT_FULL_01" failed to load/unload ORA-31640: unable to open dump file "Z:\backup_database\expdp_acapp23.dmp" for read ORA-19505: failed to identify file "Z:\backup_database\expdp_acapp23.dmp" ORA-27046: file size is not a multiple of logical block size OSD-04012: file size mismatch (OS 741224638) We don't know whether dmp file is database, table or schema. We have to find ourself. How can I keep master table. I need someone who can help us as early as poosible . It is very urgent. I need someone who can give detail steps how to resolve the problem We are trying to do from Oracle 11.1 to 11.2.0.3
Skills: Oracle Database Administration SQL
Hourly - Expert ($$$) - Est. Time: More than 6 months, Less than 10 hrs/week - Posted
PLEASE READ: This is not a post about web development, HTML or banner ads. This is a job post for a developer/architect for a higher education ERP system by Ellucian, known as Banner. Do not submit applications for web development. - Experience with Banner data. - Experience with building metadata models specifically in Cognos Framework Manager and Cognos Transformer. - Experience with other Cognos tools such as Report Studio, Query Studio, and other preferred. - Experience with data warehouse architectures, ETL tools, mapping, and the ability to design and develop custom ETL. - Experience with Ellucian ODS, Cognos Framework Manager, and Oracle Warehouse Builder BANNER - ODS Administration: Experience with Ellucian ODS, Ellucian ODS Administrator, Oracle Warehouse Builder - COGNOS: Experience with Cognos administration, including Cognos content store management. - Business requirements gathering through customer workshops, crafting of functional and technical specifications, translation of requirements into report and data model specifications. - Experience in relational and dimensional data modeling, data warehouse concepts and design, ability to build metadata models. - Experience with business intelligence tools and how to analyze and present data in a fashion that customers can easily understand. - Strong technical background, ability to develop complex SQL queries and analyze data in aggregate and in detail, systems integration experience. - Experience with or understanding of data warehouse architectures, ETL concepts, changed data capture, data cleansing, schemas, fact and dimension tables, and conforming dimensions. - Critical thinking, ability to troubleshoot problems in real-time, ability to analyze data in aggregate and in detail, and diagnose system anomalies back to the root cause. - Software quality management, experience with developing and executing test plans. - Ability to work collaboratively with functional users and data warehouse developers to design and implement reporting solutions that meet the customer needs. - Experience with PL/SQL; ability to develop complex queries for detailed and aggregate analyses. - Experience with other3rd generation programming languages. - Experience with software development and software quality processes. - Ability to document code effectively, develop and execute test plans. - Experience with Oracle database administration, Oracle certification, comfortable with analyzing aggregate and detailed data and developing complex queries. - In depth understanding of data warehouse concepts and structures, including translation from a data source to a de normalized reporting view, change data captures, and business intelligence tools. - Experience with maintaining a metadata repository. - Experience with business intelligence solutions, ability to conceptualize, design, and maintain an overall security model for managing access to sensitive report data, and organize access so that permissions can be managed in a hierarchical manner. - Experience with data warehouse concepts and the management of data into reporting packages. - Strong communication skills, able to work in a collaborative environment with others at varying levels of technical abilities. - Good understanding of Windows, Linux operating systems, web server administration, enterprise application administration, and networking and firewall security structures. - Good understanding of applications integration, system performance, and the ability to manage the factors that influence applications performance and availability in a complex, integrated environment. - Customer Services oriented, ability to multi-task, ability to troubleshoot problems in real-time and diagnose and repair the root cause.
  • Number of freelancers needed: 3
Skills: Oracle Database Administration Oracle Forms Oracle PL/SQL
Hourly - Expert ($$$) - Est. Time: More than 6 months, Less than 10 hrs/week - Posted
Job Description: • The Senior Golden Gate Administrator is a highly skilled technical position that involves intricate knowledge of the Oracle Golden Gate product. • Golden Gate install configuration, tuning, maintenance, patching, and problem diagnosis and resolution are all critical functions that the Sr Golden Gate administrator performs. • Manage all aspects of the Golden Gate design, implement and support in development, UAT and production environments • Identify and resolve Golden Gate problems occurring in all database environments including performance related issues (i.e. database & SQL tuning). • Assist with performance and Disaster Recovery testing • 5+ years’ experience with installation, configuration and maintenance of Oracle Golden Gate. • 10+ years’ experience working with mission critical Oracle databases in a high profile type of organization. • 5+ years’ experience in the following areas: Database configuration, tuning, maintenance, patching, and problem diagnosis and resolution. • Experience with Oracle to Oracle replication. • General Database Administration skills. • Team player that is willing to dig in and do what it takes to make the team successful. • Effective communication skills. • Highly organized, ability to multitask • Strong ability to diagnose issues and problem solve • Logical, decisive thinker
  • Number of freelancers needed: 5
Skills: Oracle Database Administration Linux System Administration
Fixed-Price - Intermediate ($$) - Est. Budget: $25 - Posted
Hi, Oracle Apps DBA technical consultant required. Who can provide scripts for some specific tasks given (DBA related tasks) and can give recommendations and solutions. Must have experience in following. Oracle EBS 12.2 Oracle EBS 12.2 with RAC. ASM. RMAN Backups. Oracle EBS/ Database Performance tuning. Oracle Linux Your availability required on skype from 9AM to 6PM Pakistan time. This is 1 week job. If you perform better contract will extend. Regards, Salahuddin.
Skills: Oracle Database Administration Oracle E-Business Suite
Hourly - Entry Level ($) - Est. Time: More than 6 months, 10-30 hrs/week - Posted
Details looking for remote support who can work for US time zone * Monitoring, performing daily checks, and troubleshooting of the production, testing, and development database environments * Performing database backups and recovery as required, capacity planning and performance tuning as it pertains to the Oracle environment. * Resolving problems from the production environment and interacting with Testing and Development Divisions to resolve problems and identify system enhancements. * Provide leadership and oversight to support, maintain and enhance applications * Lead and participate in process improvement initiatives. * Provide technical leadership and guidance on developing customer-service infrastructure strategy REQUIRED KNOWLEDGE AND SKILLS: * at least 7 years of hands-on information technology experience. An additional 4 years of experience may be substituted in lieu of degree. * Advance level experience with Oracle Database Administration experience in Unix/Linux environments * Prior experience with Oracle SQL or PL/SQL development along with experience configuring/maintaining Oracle Golden Gate, Oracle RAC, Oracle ASM. * Solid understanding of installing, configuring, upgrading and tuning Oracle 11g on Linux. * Must be an Oracle Database Administrator Certified Professional. * Experience with Oracle Enterprise Manager (OEM), Oracle Recovery Manager (RMAN), and have Unix shell scripting, SQL scripting and PL/SQL experience.
Skills: Oracle Database Administration Red Hat Enterprise Linux (RHEL)
Hourly - Intermediate ($$) - Est. Time: Less than 1 month, Less than 10 hrs/week - Posted
We need senior DBA help ASAP please. Price is negotiable for the right candidate You must have the following: • hands on experience in any of the following databases: Oracle, MySQL, SQL Server • years of data warehousing experience • Strong database fundamentals and internals of relational database platform and solution • Experience using all load /unload utilities • Strong knowledge on performance tuning, execution plan/awr reports analysis is a plus • physical database design and tuning •Deep knowledge of SDLC principles, process and methodologies •Debugging and problem solving skills •Experience building high performance, scalable systems adhering to industry code quality standards is preferred
  • Number of freelancers needed: 2
Skills: Oracle Database Administration MySQL Administration SQL