Please reply to a...@cigniti.com along with the resume, contact details and rate confirmation.
*NEED CANDIDATES WHO CAN FURNISH 2 PROFESSIONAL REFERENCES * Location: Chicago, Illinois Position: Database Architect Contract Length: 6 months Required Skills/# of Years: • 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 . Preferred Skills and Experience: • Knowledge of financial exchange systems a plus • Experience with Oracle table compression is a plus Description of Project: 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. • Produce and documents logical and physical database design using Erwin 7 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. ______________ With Kind regards ABHI | Technical Recruiter | Cigniti Inc ® a...@cigniti.com 1304 W Walnut Hill Lane. Ste 240 Irving TX 75038 Iowa | Texas | Pennsylvania | Hyderabad (India) | -- You received this message because you are subscribed to the Google Groups "Oracle Users" group. To post to this group, send email to oracle-us...@googlegroups.com. To unsubscribe from this group, send email to oracle-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/oracle-users?hl=en.