Leading trading firm is looking for a experienced Oracle Data Base Architect. Candidate will be performing logical and physical design and administration of multiple Oracle databases containing more than 500 tables for both Real Time and batch applications. Candidate must have excellent Erwin design skills as well as Data analysis and Data modeling. Excellent communication skills, as well as the ability to be a team player, a must. Primary Duties: 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 DB snapshots, table partitions, and backup-recovery strategy for Oracle 10g DBs Oracle DB tuning and administration including security management, instance performance monitoring, tablespace utilization, schema object management, DB 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 to ensure that testing is complete before signing off Provide support for development and production systems Required Experience and Skills: 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 a must Design of large databases (100+ tables) and database sizes greater than 1TB to include at least 3+ years experience 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 Practical experience with Oracle 10i RAC a must Bachelors degree in Computer Science or related field
Apply to this job