Oracle Data Architect locals

Position: Oracle Data Architect-----Need locals
Company DescriptionUSM Business Systems Inc. is a quickly developing worldwide System Integrator, Software and Product Development, IT Outsourcing and Technology assistance supplier headquartered in Chantilly, VA with off-shore delivery centers in India. We offer world-class ability in giving most astounding quality and administrations through industry best practices planned to convey remarkable worth to our customers.

Utilizing our industry knowledge, administration service offering expertise and innovation abilities, we distinguish new business and innovation slants and create answers for help customers around the globe, giving top of the line solid and practical IT benefits which are cost effective services.

Established in 1999, the organization has corner qualities in building and dealing with a Business Oriented IT environment with rich involvement in technology innovation, ERP and CRM counselling, Product Engineering, Business Intelligence, Data Management, SOA, BPM, Data Warehousing, SharePoint Consulting and IT Infrastructure. Our other offerings include modified solutions and administrations in ERP, CRM, Enterprise architecture, offshore advisory services ,e-commerce, Social , Mobile, Cloud, Analytics (SMAC) and Dev Ops.

USM, a US ensured Minority Business Enterprise (MBE) is perceived as one of the fastest developing IT Systems Integrator in the Washington, DC zone. Most as of late, USM was positioned #9 on the rundown of the Top administrations organizations in the DC Metro Area – Washington Business Journal (2011). We are a project-driven firm that reliably meets the IT needs of our State and Government customers through development and business keenness.

Job Description Oracle Data Architect Chicago, IL6-12+ months

Need LocalsMUST HAVE a financial background

Technical Requirements
• 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.
• IBM Infosphere Data Stage – strong preference
• Basic knowledge of SQL Server 2012 preferred
• Basic knowledge of SSIS ETL Tools preferred

Job Description Perform physical design and performance tuning of multiple databases containing more than 500 tables for both real-time and batch applications. Ideal candidates will have deep Oracle Exadata and SQL Server experience, although this is not mandatory. Oracle experience, however, is mandatory.

Data Stage ETL, Data Stage, ERwin, Model Mart Software, Data Stage ETL, Data Stage, ERwin, Model Mart Software Duties and Responsibilities
• Produce and document 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 Model Mart Software. As part of project team, define tasks and design system 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
• Database tuning, instance performance monitoring, tablespace utilization, schema object management, database capacity planning.
• 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.
• In the near future, will be asked to architect and develop Data Stage ETL Jobs with multi-threading and parallelism. Design, Develop and maintain…