Please don't reply on this mail. Hi All,
Hope you are doing well!!!! Please Send me the suitable profiles to sop...@datagrp.com With rate confirmation Contact Details with Current Location. Position: Senior/Lead Oracle DBA Location: Providence, RI Duration: 3 Month Contract Rate: $50-55/hr (Not Negotiable) I need a very Senior, Lead Oracle DBA with strong skills in 10g R2. FACE TO FACE INTERVIEW REQUIRED - COM SKILLS MUST BE 10/10... 8-10+ yrs of overall experience please. Candidates in MA, RI, ME, CT and NH would likely be able to attend a face to face interview... Oracle Contractor There are three areas for the Oracle contractor to address: Oracle 10g R2 Education, CareTracker running on an Oracle 10g R2 database, and Upgrading current caretracker 9i database to 10g R2. Each of these is discussed in more detail below. Oracle 10g R2 Education Staff currently has experience with oracle 9i (9.2.0.7) in a production environment. The database server is hosted on Windows Server 2003 R2 Enterprise Edition SP2. The host has 16CPUs and 16GB RAM. The database is approximately 1TB in size. Data is hosted on an EMC CX3-20 with many Raid Groups and LUNs. These are mounted as NTFS filesystems to the windows server. The database is accessed via a single Oracle instance. The instance is configured to use AWE and is sized with a 10GB buffer cache. Data guard is used to provide four physical standby databases. Three of these are local (hosts accessed via a LAN from the primary host) and one is accessed via a WAN at an off-site location. One of the local standby databases is in managed mode and actively applies the received archive logs. The others apply the logs during a maintenance window the early am hours. The primary database is online 24X7 with occasional offline maintenance scheduled as needed during off-peak hours. 9i RAC has been explored but never put into production. OEM is not used. Database monitoring is performed using Quest Spotlight on Oracle along with home-grown SQL "capture" scripts. Quest Central aids in database maintenance activities. Given knowledge of the current database environment, one objective we be to educate the staff on what Oracle 10g R2 brings to the table with special focus on in the areas of scalability and management efficiencies. Topics involving the following will need to be covered: - 64-bit: >4GB windows process size and > 16GB RAM access - RAC (is RAC required or just an option - Pros/Cons) - Grid and Grid Control - OEM - Adding nodes to cluster - Load balancing - Data guard and TAF CareTracker running on an Oracle 10g R2 database The following are all included in supporting the CareTracker application's access of the current 9i database: - ASP/VB6 via MSDAORA (i.e. Microsoft Data Access Provider for Oracle) from both IIS web pages and DLLs - .net via the 'Microsoft .NET Data provider for Oracle - Both 8i and 9i SQL*Net - MSDTC - ADO Given the knowledge of the current application access methods, one objective will be to determine what changes need to be implemented in the environment and/or by the CareTracker applications to enable access of a 10g R2 version of the database and to be production-ready. Areas of concern might be: - Upgrading client-side SQL*Net - Upgrading client-side drivers to be those available from Oracle rather than those available from Microsoft for Oracle - Scope of CareTracker application code changes required to function properly in the 10g environment Upgrading current CareTracker 9i database to 10g R2 Given the knowledge of the current database environment, one objective will be to develop a plan of attack for the database and environment upgrade from 9i to 10g R2. This objective will include the following: - Staging the upgrade in a test environment as many times as needed to full-proof the process - Accounting for the effort involved in upgrading the data guard servers in conjunction with the primary database - Accounting for the effort involved in upgrading the web servers and other client hosts as needed - Fully understanding and minimizing primary database offline time as much as possible Thanks & Regards, Sophia Jones Technical Recruiter Data Group, Inc. Certified Minority Women Owned Business Enterprise (MWBE) & Small Business Enterprise (SBE) ________________________________________ |Office: 1 - 732 - 791 - 2348 xtn: 250| Fax: 732 - 907 - 1174 | Email: sop...@datagrp.com | Website: www.datagroupinc.net | ________________________________________ Note: Under Bill s.1618 Title III passed by the 105th U.S. Congress this mail cannot be considered Spam as long as we include contact information and a remove link for removal from our mailing list. To be removed from our mailing list reply with "remove" and include your "original email address/addresses" in the subject heading. Include complete address/addresses and/or domain to be removed. We will immediately update accordingly. We apologize for the inconvenience if any caused to you. ________________________________________ --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "zilliontechnologies" group. To post to this group, send email to zilliontechnologies@googlegroups.com To unsubscribe from this group, send email to zilliontechnologies+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/zilliontechnologies?hl=en -~----------~----~----~----~------~----~------~--~---