*Oracle Data Modeling/ Architect * *Location: Chicago, IL*
*Duration: 6 months* *Rate: Open* *NEEDED SUPERSTAR FOR THIS REQ?* · The successful candidate will perform logical and physical design and administration of multiple Oracle databases containing more than 500 tables for both real-time and batch applications; · provide design alternatives to proposed processes as needed. Experience with queries tuning and performance monitoring is required. * * *Required Skills and Experience:* · A minimum of 6 years experience in Relational database *design and administration*,* Oracle *is mandatory, with special emphasis on *data modeling, data analysis and deployment of databases*. · *Erwin** or other data modeling skills are mandatory*. · Design of *large databases (100 + tables)* and database sizes greater then 1TB to include at least 3-5 years with applications analysis and design. · Knowledge and practical experience of applications development in distributed network environment · Experience with partitioned and sub-partitioned tables and VLDB is required. · Excellent written and verbal communications skills · Must be self-motivated and have the ability to work as part of a group, or, at times, independently · Knowledge and practical experience of Oracle 10i RAC is mandatory · Educational requirements include Bachelors degree-Computer Science or related discipline is preferred. Preferred Skills and Experience: · Knowledge of financial exchange systems a plus · Experience with Oracle table compression is a plus * * *Requirements Duties Include:* · Produce and documents logical and physical database design using Erwin as a data modeling tool, while working with users and developers to understand their data needs and relationships to existing corporate data. · Maintain the Enterprise data model repository using Erwin ModelMart Software. As part of the project team, define tasks and design systems architecture for new implementations, provide projects status information to management. · Perform physical database design at the object level, create DDL scripts, define database snapshots, table partitions, and backup-recovery strategy for Orcale 10g databases · Oracle database tuning and administration including security management, instance performance monitoring, tablespace utilization, schema object management, database capacity planning, "bottlenecks" and "offensive" SQL activity monitoring and resolution. · Experience with TKPROF, AWR, ASH and other monitoring tools is required · Assist developers with application design and performance tuning · Coordinate testing with other development groups and operations. Identify appropriate level of testing and ensure that testing is complete before signing off · Provide support for development and production systems. *Thanks & Regards,* *Aaron *** *Sr.Technical Recruiter* *Generic Solutions Inc. | * *12200 Ford Road Suite # 480****. Dallas, TX 75234* *Tel: 214-230-9240* *│**Fax: 972-346-6115**│**[email protected]*<[email protected]> *│**www.gensolinc.com |* *"Certified Minority Owned Business Enterprise (MBE)"** * * * * Note: This is not an unsolicited mail. If you are not interested in receiving our e-mails then please click "Remove"* *P* *Save a tree! Print this message only if it's absolutely necessary*** -- You received this message because you are subscribed to the Google Groups "KNOW.IT" 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/know_it_az?hl=en.
