USM Business Systems
Technology & SoftwareDirect SmartRecruiters career site

Oracle Data Architect-----Need locals

Location
Chicago, IL
Job type
Contract
Level
Senior
Experience
10+ years
Education
Bachelor's degree
Listed
Yesterday

Skills & highlights for this role

  • ERwin data modeling
  • Oracle database design
  • IBM InfoSphere DataStage
  • data warehouse star schema design

Also useful

  • SQL Server 2012
  • SSIS
  • Oracle Exadata
Free · No account needed

How well does your resume fit this job?

Upload your resume to see your score for this USM Business Systems role, what matches, what's missing, and your best other matches.

Scored on our server and not saved there. The file stays in this browser so you don't have to upload it again after you sign up.

About the role

  • Oracle Data Architect
  • Chicago, IL
  • 6-12+ months
  • Need Locals

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 DataStage – strong preference
  • Basic knowledge of SQL Server 2012 preferred
  • Basic knowledge of SSIS ETL Tools preferred

About the role

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.

DataStage ETL, DataStage, ERwin, ModelMart Software, DataStage ETL, DataStage, ERwin, ModelMart 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 ModelMart 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 DataStage ETL Jobs with multi-threading and parallelism. Design, Develop and maintain DataStage processes with proper utilization of multithreading, partitioning and other performance tuning techniques - this is the reason DataStage is strongly preferred

Education and Training

Bachelor’s degree - Computer Science or related discipline is preferred.

Professional Experience

  • Experience with queries tuning and performance monitoring. Candidates should have examples.
  • A minimum of 10 years’ experience in Data Warehouse environment with Star Schema / Relational database design.
  • Knowledge and practical experience of applications development in distributed network environment.

Additional Information

If my requirement matches your resume, then please do reply on my email id preethib@usmsystems(dot)com or can directly call me on

About the Company

USM 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 DevOps.

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.

Read the original posting

From USM Business Systems's careers page, first listed on Rolev.ai on November 20, 2026. Rolev.ai is not the employer.

How Rolev.ai helps with this application

Rolev.ai is a job search and application tool for US job seekers. For this Oracle Data Architect-----Need locals role at USM Business Systems, it shows how your resume fits, tailors your resume to the posting, and prepares the application for you to review.

  • See how you fit

    Openings from employer career sites are ranked against your whole resume—and searchable inside Claude, ChatGPT, and Cursor via Rolev.ai MCP.

  • Tailor without inventing

    Every change to your resume is checked against your original. New experience goes in only with your yes—zero fabricated claims.

  • Draft the full kit

    Tailored and Full Match resumes, role-specific cover letters, and answers to employer screening questions are prepared in seconds.

  • 1-Click Extension Autofill

    The Chrome extension fills the employer's Greenhouse, Workday, Lever, or Ashby form in 1 click. You review it and press Submit.

Common questions

Where is the Oracle Data Architect-----Need locals job at USM Business Systems located?

This Oracle Data Architect-----Need locals position at USM Business Systems is located in Chicago, IL. Always check USM Business Systems's application page for specific state eligibility or relocation policies.

What qualifications are required for Oracle Data Architect-----Need locals at USM Business Systems?

For the Oracle Data Architect-----Need locals role, USM Business Systems highlights 10+ years of relevant experience; a bachelor's degree; experience with ERwin data modeling, Oracle database design, IBM InfoSphere DataStage, data warehouse star schema design. Rolev.ai can score your existing resume against these requirements and show any skill gaps before you apply.

How do I apply for the Oracle Data Architect-----Need locals position at USM Business Systems?

This listing links directly to USM Business Systems's SmartRecruiters application page. You can apply directly on USM Business Systems's site, or use Rolev.ai to check your resume fit, generate a zero-hallucination tailored resume and cover letter for this posting, and autofill the SmartRecruiters application form in 1 click with the Rolev.ai Chrome extension. You always review the form and press Submit yourself.