December 20, 2010

Oracle jobs - Dec 20, 2010

Opening for Oracle Form Developer,(Oracle Form 10g,Pro*C,Solaris)-Singapore, Send CV to recruit@terrabit-consulting.com


Responsibilities:
Reporting to the Project Manager, your responsibilities would be to:
• Work with Team Leads of different project teams
• Support the day-to-day operation of maintenance projects as part of the development team
• Responsible for the Development, Unit Testing and System Integration Testing of Service requests and Defects reported.
• Troubleshooting issues raised by customers and providing its resolution
• Timely delivery of development work with quality, meeting the internal/external customers’ expectation

• Update relevant documents on all executed changes in a timely manner.
• Work as part of the team to meet project targets and quality objectives.
• Interact effectively with team members at all levels.

Requirements:
You should possess the following qualifications:
• Bachelor's degree in Computer Science or equivalent work experience
• Have at least 4 years experience in Oracle Form 10g onwards
• Experience in the configuration and administration of Oracle application server
• Experience in Pro*C development
• Experience working in Unix environment SUN Solaris
• Must possess strong problem solving and analytical skills
• Possess ability to lead and support the development team
• Possess strong written and verbal communication skills
• Prior experience in project maintenance
• With consistent focus on quality
• Have positive attitude to meet new challenges

Send CV to recruit@terrabit-consulting.com
-----------------------------------------------------------------------------------------------------------

URGENT!!!!! EXPERIENCED DBA AND A SENIOR HYPERION PLANNING CONSULTANT NEEDED FOR PERMANENT POSITIONS IN THE UK!!!!!!!****


DBA:
Full DBA exposure for the duration of the project lifecycle on at least 3 Oracle projects, Lead DBA/Technical team Leader experience, Track record of implementing Oracle E-Business Suite v11i or v12

Senior Hyperion Planning Consultant:
Excellent knowledge of Hyperion Planning and Essbase, ETL, proven experience of Hyperion Planning implementations, ideally part qualified/qualified Accountant.

CALL ME! 020 7 422 6017 / leigh@maximus-it.com

-------------------------------------------------------------------------------------------------------------
Oracle/People soft DBA - Infrastructure DBA Support

on W2
Locations: Secaucus, NJ
Additional Details:
Must have peoplesoft administration exp of 3 yrs.

Description:
Infrastructure DBA Support

Description of day to day tasks
Support of Oracle/PeopleSoft maintenance, upgrades and Incident resolution.
Sound experience in Oracle database administration on UNIX platform
The individual must have supported OLTP databases over 1 terabyte
Experience with cloning distributed (replicated) PeopleSoft databases
Ability to manage databases and troubleshoot issues via command line rather than OEM or other GUI tools
Solid knowledge of Oracle advanced replication and Materialized views
Familiarity with Oracle LDAP relative to names resolution
PeopleSoft Application Designer, Data Mover & Process Scheduler
Experience in supporting heavily customized PeopleSoft installations
UNIX shell scripting
Backup and recovery, RMAN and non-RMAN
Oracle Data Guard

Describe technical environment
8+ years of experience in IT
At least 5 years of Oracle database administration on UNIX platform,
3 years of PeopleSoft administration.Oracle/PeopleSoft

Must carry communication device and be reachable at all times. 98% response rate when contacted

Vijaya,
Enterprise Pals, Olathe, KS
Ph(W) : +1-816-984-0991
vijaya@enterprisepals.com
-------------------------------------------------------------------------------------------------------------
W2 role for Oracle application DBA in Charlotte, NC - Exp. with Erwin, data warehouse design, SQL tuning, data modeling, reporting, and ETL - Reach me @ 973-854-9109 or chhetra.thapa@collabera.com

-----------------------------------------------------------------------------------------------------------
Immediate needs for an Oracle DBA at Southfield MI


We have needs for an Oracle DBA from our client at Southfield MI whose role involves Installation, support, and migration of Oracle databases and ongoing administration and configuration of related tools along with providing technical expertise for projects and support. If interested send in your resume to nina.george@mastech.com and I shall contact you immediately.

-------------------------------------------------------------------------------------------------------
DBA Lead (Teradata, Oracle) (Cincinnati, OH)


Job Responsibilities:

Will provide a blend of Technical/Functional subject matter expertise in the areas of maintenance, support and development for a variety of database platforms including Teradata, Oracle, SQL Server, IDMS, and Sybase. This role specifically works in collaboration with vendor engineering teams and the internal community to provide enterprise and system level consulting on business analysis, database design, and development efforts. This role identifies ways technology solutions can be applied to support business strategies and improve business processes. Individuals in this role partner with business units and company Business Consultants team to communicate and clarify business needs to vendor resources, contribute to development of long-range systems plans and architecture, assist in requirements elaboration, and ensure products and services are aligned and implemented to meet business needs. May be required to participate minimally in hands-on development work, specifically when it comes to assisting with high severity incident reports or time-critical project deadlines. Incumbents will conduct business process analysis, needs assessments, and preliminary cost-benefit analysis. They also review estimates and designs to ensure compliance with architectural standards. Strong collaboration with the architecture team is expected. This position can also act in a Business Relationship Management capacity partnering with the business functions to ensure that their IT systems needs are met. Working in collaboration with the Business Consultant, the role may also be responsible for developing end to end Level 4 business requirements and the management of Level 0-4 capabilities and requirements for small, vertical domain focused business requests, documented using the Blueprint tool. Following are general accountabilities as well as targeted accountabilities depending on the nature of the position.

Job Requirements:

HS diploma + 8 years experience in all phases of IT system development Life Proven appropriate degree of Functional and Technical acumen for the respective technology domain. Knowledge of large complex systems with respect to the Business Processes, Technology, Integration points, and Infrastructure. Ability to size concepts and develop L4 use cases using Blueprint or related tool. Ability to work and collaborate effectively with offshore-based vendors. Understanding of Organizational Change Management (OCM) and Quality Assurance Technical Requirements:

1. 2+ plus years hands on experience with Erwin

2. Extensive knowledge in all facets of data warehouse design (Star, Snowflake, normalized verses denormalized, referential integrity, etc.)

3. Certified DBA in either Oracle or Teradata with working knowledge of one or more of the following databases: SQL Server, Sybase, IDMS, Sybase Prior experience writing ETL solutions

4. 8+ years experience in the design, build, deployment, and maintenance of an Enterprise Data Warehouse environment

5. 8+ years SQL coding experience

6. 8+ years managing databases from planning and testing stages through implementation and support

7. In-depth understanding of security and backup procedures to ensure database integrity

8. Good understanding of database schema objects including tables, views, packages, procedures, sequences, indexes, and constraints

9. Experience in database reorganization, migration, server tuning, capacity planning, collecting statistics, software upgrades, Disaster Recovery, and High-Availability

10. Strong in-depth experience in database performance tuning and SQL tuning

Desired Requirements:
BS in CS or IT;; IBM DataStage experience is a plus
Interested candidates should send me a WORD resume and I will contact all qualified candidates. Only GREEN CARD HOLDERS or US CITIZENS will be considered. (tom@wefilljobs.com)

---------------------------------------------------------------------------------------------------------
Oracle Apps DBA needed in Temple, Texas - Salary PLUS Bonus AND Generous Relocation Package US Citizens and Green Card Holders only - No Sponsorship


We need an Oracle Apps DBA to be the principal administrator of installation and maintenance of Oracle applications. Responsible for managing Oracle application patches and determining the related dependencies when applying those patches. Work with the application development team to manage service requests with Oracle application support. Provide ongoing monitoring of the Oracle application and database environments. Manage database and recovery strategy. Review SQL for performance considerations. Implement database object changes to the Oracle application environment. Experience should include 2 to 4 years with Oracle Applications, including E-Business Suite.

Full-time, permanent, onsite positions offer salary/benefits/bonus/relocation. Approximately 5% travel.
If you're interested in this position, please contact my colleague Susan at RecruitSS@PrecisionSystems.com.

OR: if you know an appropriate person, please refer him or her to us. Our company will give you $1000 if your referral ends up getting the position!
-------------------------------------------------------------------------------------------------------
Oracle PL/SQL -- New York,NY(Job Id: LR:2191)


Job Title: Oracle PL/SQL
Location: New York,NY.
Job Id: LR:2191

Duration: 6 months Contract

Description:

• PL/SQL
• Unix
• Shell Scripting
• Minimum 1 years experience with SQL Server or Oracle

****Please send your updated resume to jobs@mapleresource.net

August 14, 2009

Interview Questions

1. How do you move the tablespaces or datafiles from one server to another server with archivelog mode.
2. How do you copy database from production to new server using RMAN.
3. Session hangs, user unable to connect the database, what is your analysis and how do you resolve it.
4. Archive destination is full 100%,database hangs and configured RMAN, how do you resolve the issues.
5. What is LOCAL LISTENER, how does it work.
6. You have created one index on Primary database, how do you check whether it is avaliable on Standby database.
7. If you change SYS password on Primary database, will standby database work.
8. When you fire (DML) statement, what is doing oracle archicture.
9. If you add datafiles on primary database, what will happend on standy database. What parameter is required and What will happend if you set AUTO or Manual
10. How do you apply critical patch.