Database Architect/Modeler/DBA (Oracle)
Needed: Oracle - Data Architect/Modeler/DBA ***Please note that a face-to-face interview will be required*** ****6 Month Contract and Contract-to-Hire available, Chicago IL, Rate 75-85/hr; ~115k/yr+ Benefits**** Horizon Technology Partners, Inc. has an immediate opening for a Senior Data Architect/Data Modeler with solid understanding of Oracle 10g/11g Administration skills (Particularly, partitioning/indexing). This is a very high transaction, very large DB environment, and the Data Architects all need a very high level of knowledge of Oracle's strengths and weaknesses from a physical/admin perspective when operating under such demanding use to insure optimal efficiency in all designs and orders the DA's pass along to the DBA group, including special partitioning needs and RAC implementations. Your skills are needed to assist a large financial institution located in downtown Chicago, IL. with understanding their Business Rules and applying them to their data model and database design. The selected candidate will have a minimum of 4 years experience in Relational database design and administration on Oracle, with special emphasis on data modeling, analysis and deployment of large databases (100+ tables). At least 7 years with applications analysis and design - expert level Erwin skills are mandatory. 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. Strong experience with Partitioning, Indexing, queries, tuning and performance monitoring is required. Knowledge of trading or financial exchange systems is a plus. Duties may include: - Produce and document 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 project team, define tasks and design system architecture for new implementations, provide project 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 Oracle 10g/11g databases. - Oracle database tuning and administration including security management, instance performance monitoring, table space utilization, schema object management, database capacity planning, *bottlenecks* and *offensive* SQL activity monitoring and resolution. - 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. Please forward resumes to: firstname.lastname@example.org
Related projectsSearch for freelance jobs
can’t wait for more clients
and advertising. Thank you."