*Please send resumes to [email protected]* * *
*Job Title Oracle DBA with BASIS skills* *Experience Level *7-10+ years *Location *Beaverton, OR *Duration *Long term * * *Job Description* We are looking for a Core DBA candidate with BASIS skills. Around 90% in Oracle DBA and 10% in BASIS. · Installing oracle server and client software, creating, upgrading and patching databases in UNIX (Solaris, HP), Linux and Windows environments. · Designing and Architecture of Databases. · Experience in Upgrade and Migration of oracle database to higher version (from Oracle 8i/9i, 10G, 11G) in multi platforms. · Performance Tuning of database which includes SQL optimization, Oracle SGA, I/O balancing and memory. · Tuning Oracle databases and tuning applications (SQL), for tuning SQL working closely with development team. Extensive familiarity with Tuning · Tools like Oracle Enterprise Manager's (OEM's), SQL analyzer, Statspack, AWR and TOAD. · SQL tuning using "Explain plan", "SQL_TRACE*", Optimizer modes, using Optimizer hints, Gathering statistics etc. · Proficiency with Tuning the SGA, Buffer Cache, Rollback Segments, Redo Mechanisms, Monitoring and Detecting Locks. · Proficiency in SQL and PL/SQL programming - Includes, creating database objects like creating tables*, views, indexes, constraints, sequences, functions, procedures, packages, triggers, PL/SQL blocks, partitioned tables, etc. · Planning, scheduling and taking Oracle backups - Hands on experience in database backups and Recovery strategies using RMAN, Export/Import, Cold, Hot backups. · Proficiency in creating clone database for test and training purpose - Installation, Configuration and deployment of Oracle 10g database and Real Application Clusters (RAC) on different nodes with Automatic Storage Management (ASM). · Real Application Clusters monitoring, tuning, load balancing using OEM (Oracle Enterprise Manager), and V$ dynamic views. · Candidate needs to be proficient in Shell and Perl scripting.** -- You received this message because you are subscribed to the Google Groups "Oracle-Projects" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/oracle-projects?hl=en.
