* Please send resumes to [email protected] <[email protected]> Yahoo! IM: premreddyg Oracle DBA Consultant Location: De Forest, WI Duration: 6 Months+ Job Description: Linux/Oracle Database/ Performance Testing SME: · Define detailed test parameters, including both functional and non-functional testing · Design the Test Strategy and Test Plans for Performance Benchmarking · Develop & Execute Performance Benchmarking test cases, document test results, track and report defects. · Provide test reports and maintain test results & test logs. · Create scripts if required within the boundaries of the tool set as applicable for automation · Will require to be deeply versed in Oracle, testing, and good to have Benchmark Factory knowledge. 5-8 Years Skill and Experience Details: · Works under close supervision to perform low-level database management tasks such as adding users, managing space etc. · Participates in testing back-ups, ensuring maximum up-time and maximum performance of database. · Familiarity with basic administrative commands is expected at this level. Front-line interaction with users to assist with low-level trouble-shooting requirements. · Database Admin (L3)-Independently performs database management tasks such as controlling access permissions and privileges. · Responsible for ensuring that storage, archiving, backup and recovery procedures are functioning correctly. · Writes database documentation, including data standards, procedures and definitions for the data dictionary. · Train users on database methodologies. · Responsible for refining the 'logical design' so that it can be translated into a specific data model and further refining the 'physical design' to meet system storage requirements. Plan data flows for a new or revised database. Guide new team members. Domain Skills: · Database concepts Relational Database Concepts Normalization Entity and relationships Database administration activities Conversant with DBMS Packages Backup and Recovery Patching & Cloning Trouble shooting Backup Ability to design logical and Physical models of Database layouts and Schema. · Performance Tuning Migration Techniques Knowledge on Replication Server HA Implementation Licensing Backup & Recovery · CPU/Memory/LAN utilization thru Tools. · Monitoring disk space quotas allocation. · Monitoring File Systems & RAW Disk alerts. · Documented activates (SOP based). · Starting and stopping of VMs. · Password management. · Monitoring & Managing network performance. · Installing and Upgrading VMware Tools. · Vmware Guest Backup. Starting the VI Client. · Stopping the VI Client. · Connecting to the Service Console. · Database Performance Tuning (L4)-Database Memory, I/O Tuning . · Planning for Performance in Database Design. · Indexes tuning and Design Adviser.? Configurations parameter tuning. · Table and index maintenance, Data base reorganization · Database High Availability (L4)-Design and Plan HA Strategy (High Availability -RAC / Cluster / Replication / Data Guard / Standby /Database Failover strategy · Database DR strategy /Flashback) How is it setup and configured What happens during a fail-over What happens during fail-back · What are the steps a DBA should perform in the event of a fail-over and fail-ba · Oracle Admin (L2)-Understand New Features in 10G. · Generate Explain Plan, Interpreting TKPROF Output. Interpret Stats pack report. · Familiar with init.ora parameters Create, Rename a database Partition Tables and Indexes Move databases between servers, plan and size databases. Re-org of Database. · Refresh Database using cold backup, Hot Backup & Export/import. · Maintain Standby database. · Manage Oracle Streams. · Troubleshoot CPU Load and resolve it. · Generate Statistics for the tables, Partitioned tables, Sub partitioned Tables & troubleshoot issues related to Statistics. · Troubleshoot issues like Database hanging, issues with undotable spaces, segments. · Be able to Tune SQL, SGA. Perform hot backup, Cold Backup. · Export, Import Recover under Various Scenarios (like recovery acorrupted database when the db runs in archive log mode, Recovery a table’s data when a user accidently drops it, etc). · Performance Optimization and Tuning · Should be aware of best practices for optimizing sql server Stored procedures Best Regards, G Prem Cloudeeva, Inc. Direct: 732-226-3459 104 Windsor Center Drive, Suite 300, East Windsor, NJ 08520. Email: [email protected] <[email protected]> Web: http://www.cloudeeva.com <https://mail.bgsl.co/owa/redir.aspx?C=7d63065af218416a87bfb76b95304e5b&URL=http%3a%2f%2fwww.cloudeeva.com%2f> [image: cid:[email protected]] <https://twitter.com/cloudeeva>[image: cid:[email protected]] <https://www.facebook.com/pages/Cloudeeva-Inc/121003204638957?ref=tn_tnmn>[image: cid:[email protected]] <http://www.linkedin.com/company/36717?trk=tyah>[image: cid:[email protected]] <https://plus.google.com/b/104975130351914332553/104975130351914332553/about/p/pub> [image: cid:[email protected]] *
-- You received this message because you are subscribed to the Google Groups "Exact Match" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/exact-match. For more options, visit https://groups.google.com/groups/opt_out.
