Demo

Solution Architect - OLTP Data Architecture

Lorven Technologies, Inc.
St. Louis, MO Contractor
POSTED ON 9/25/2026
AVAILABLE BEFORE 10/24/2026

Hi ,

Our client is looking for an Oracle Fusion Supply Chain Functional Consultant for a project and below is the detailed requirement.

Job Title: Solution Architect - OLTP Data Architecture

Location: St. Louis, MO

Qualifications & Experience:

  • Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related field, or equivalent experience.
  • 10 years of experience in Data Architecture and Data Modeling.
  • Strong hands-on experience with OLTP / transactional systems, primarily in Telecom/Wireless environments.
  • Expert knowledge of 3NF, normalized data modeling, conceptual, logical, and physical data models.
  • Strong hands-on experience with Erwin Data Modeler, including Erwin Mart, forward/reverse engineering, and Complete Compare.
  • Strong experience with Oracle Database, including schema design, tables, keys, constraints, indexes, sequences, and partitioning.
  • Advanced PL/SQL development and database performance tuning experience.
  • Strong knowledge of query optimization, execution plans, indexing, locking, concurrency, and high-volume transactions.
  • Hands-on Python experience for model validation, metadata extraction, schema checks, data profiling, and automation.
  • Strong experience establishing data governance, standards, naming conventions, data dictionaries, and data quality controls.
  • Mandatory Telecom/Wireless domain experience with subscriber, account, product, order, activation, provisioning, or device management systems.
  • Experience with MSISDN, IMSI, ICCID/SIM, IMEI, number portability, rate plans, offers, and entitlements is preferred.
  • Strong understanding of BSS/OSS ecosystems and telecom transactional platforms.
  • Strong analytical, problem-solving, stakeholder management, and technical documentation skills.

Hourly Wage Estimation for Solution Architect - OLTP Data Architecture in St. Louis, MO
$61.00 to $75.00
If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

What is the career path for a Solution Architect - OLTP Data Architecture?

Sign up to receive alerts about other jobs on the Solution Architect - OLTP Data Architecture career path by checking the boxes next to the positions that interest you.
Income Estimation: 
$170,841 - $219,163
Income Estimation: 
$159,552 - $206,899
Employees: Get a Salary Increase
View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

Job openings at Lorven Technologies, Inc.

  • Lorven Technologies, Inc. Rangeley, ME
  • Hi, As discussed, Please find the below JD Our Client is Looking for Business Analyst/ Business Process Consultant- Remote. Kindly Please share the resume ... more
  • 2 Days Ago

  • Lorven Technologies, Inc. PLEASURE RDGE, KY
  • Hi, Our client is looking for Backend Engineer with Python in Louisville, Kentucky below is the detailed requirements. Job Title: Backend Engineer with Pyt... more
  • 2 Days Ago

  • Lorven Technologies, Inc. Hanover, NJ
  • Hi, Our client is looking Product Owner for Contract project in Hanover,NJ (Hybrid) is the detailed requirements. Job Title : Product Owner Location : Hano... more
  • 2 Days Ago

  • Lorven Technologies, Inc. Jersey, NJ
  • Position : Attorney - insurance defense Location: Jersey City, NJ Job type : Full time JOB DESCRIPTION: This role is designed for an attorney with 3-8 year... more
  • 2 Days Ago


Not the job you're looking for? Here are some other Solution Architect - OLTP Data Architecture jobs in the St. Louis, MO area that may be a better fit.

  • Synkriom St. Louis, MO
  • Primary Skills: Erwin Data Modeler, Oracle, PL/SQL, Python, OLTP Data Modeling, Telecom/Wireless Domain Position Overview We are seeking an experienced Sol... more
  • 2 Days Ago

  • NJTECH INC. St. Louis, MO
  • We at NJ TECH INC are focused on hiring highly skilled professionals who are excited by the opportunity to make a true impact on their careers as well as o... more
  • 3 Days Ago

AI Assistant is available now!

Feel free to start your new journey!