Solution Architect - OLTP Data Architecture

Lorven technologies

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.

Apply

Vacancy posted 2 days ago

Similar jobs that could be interesting for youBased on the Solution Architect - OLTP Data Architecture in Saint Louis, MO vacancy

Google AI & Data Solutions Architect, Senior Manager
$124k - $280k
...Sector Not Applicable Specialism Data, Analytics & AI Management Level Senior... ...Opportunity As a Google AI & Data Solutions Architect you will lead client-focused solution... ...business needs into practical architecture and delivery approaches within our Data...
Data
Full time
H1b
PwC
Saint Louis, MO
2 days ago
Director, AI & Data Solution Architect
$155k - $410k
...Sector Not Applicable Specialism Data, Analytics & AI Management Level Director... ...As a Director, AI & Data Solution Architect you will lead the design of AI and data... ...help clients modernize platforms, shape architecture choices, and connect technical direction...
Data
Full time
H1b
PwC
Saint Louis, MO
2 days ago
Professional Services Solutions Architect (Remote Position)
...Summary The Professional Services Solutions Architect is a customer-facing, hybrid pre‑sales... ...guidance on solution design, architecture, and integration considerations Participate... ...deliverables; integration and API requirements; data conversion assumptions; identity and...
Data
Remote work
Omnigo Software LLC
Saint Louis, MO
29 days ago
SAP VISTEX Solution Architect
$160k
...Owens & Minor is a global healthcare solutions company providing essential products, services and technology solutions that support care... ...solution design for Vistex, including Incentives & Paybacks (IP), Data Maintenance Pricing (DMP), and Data Maintenance Rebates (DMR)....
Data
Full time
Temporary work
Local area
Worldwide
Owens & Minor
Saint Louis, MO
3 days ago
Revenue Cycle Solution Architect
...Description: Who We Are nimble solutions has over 20 years of specialized, surgical... ...As the Revenue Cycle Solution Architect, you will help drive client implementation... ...applications Analyzes client historical data to identify trends in AR, write offs, cash...
Data
Nimble Solutions
Chesterfield, MO
12 days ago
Technical Solutions Architect I -- Computer Vision Specialist
$110k - $138k
...cybersecurity, cloud and infrastructure solutions. Through its Advanced Technology... ...member of WWT’s Global Solutions & Architecture team, part of AI & Data Solutions, focused on computer... ...expertise with sellers and solution architects so more of the team can carry computer...
Data
Full time
Work experience placement
Remote work
Flexible hours
Shift work
World Wide Technology
Saint Louis, MO
1 day ago
SOLUTIONS ARCHITECT/ TIER 3 ENGINEER
...Job Description Job Description Solutions Architect / Tier 3 Engineer Managed Services —... ...volume and speed resolution. Solution Architecture & Design Architect cloud, hybrid,... ...onboarding, ensuring clean cutover and data integrity. Lead file and data...
Data
Permanent employment
Remote work
Hilltop Group Holdings LLC
Ballwin, MO
28 days ago
Databricks Architect -
$88.2k - $214.6k
Databricks Architect - Position Description We're growing rapidly... ...are looking for a senior-level data architect to help us design and... ...an enterprise-grade Lakehouse architecture on Databricks. This role leads end-to-end solution design—from data ingestion and...
Data
Local area
Saint Louis, MO
a month ago
Research Data Architect
...in St. Louis, MO Our client seeks a Research Data Architect to design and modernize data architecture supporting prominent research platforms, including... ...technology, business advisory, and life sciences solutions. For nearly 40 years, we have combined exceptional...
Data
Hourly pay
Local area
Work from home
Eliassen Group
Saint Louis, MO
a month ago
SAP PMMO/GPD Solution Architect
$80 - $85 per hour
...Description Job Description SAP PMMO/GPD Solution Architect Employer: Inabia Solutions &... ...integration with SAP and non-SAP data sources, including Deltek Costpoint.... ...Client-facing consulting and solution architecture experience. ~ Bachelor’s or master’s...
Data
Hourly pay
Remote work
Inabia Software & Consulting Inc.
Saint Louis, MO
2 days ago
Solution Architect
...Job Description LightEdge Solutions is developing the IT solutions... ...Lightedge is seeking a Solutions Architect with deep expertise in IBM... ...This role combines technical architecture, customer engagement, and strategic... ...across seven purpose-built data centers spanning Des Moines,...
Data
Lightedge
Saint Louis, MO
18 days ago
BPaaS GTM Solutions Architect (Provider, Hospitals, Clinic)
$182.12k - $337.25k
...Req ID: 387103 NTT DATA strives to hire exceptional, innovative and passionate... ...We are currently seeking a BPaaS GTM Solutions Architect (Provider, Hospitals, Clinic) to join... ...co-create the future-state AI-native architecture. Key Responsibilities : Understand...
Data
Full time
Temporary work
Work at office
Remote work
Flexible hours
NTT DATA, Inc.
Saint Louis, MO
9 days ago
Expert Enterprise AI Solutions Architect
$85 - $90 per hour
...MatchPoint Solutions is a fast-growing, young, energetic global IT-Engineering services... ...product management, application delivery, data engineering, and AI engineering, serving... ...aligned with business strategy, enterprise architecture, and enterprise data and knowledge...
Data
Contract work
For contractors
Local area
Remote work
Match Point Solutions
Maryland Heights, MO
2 days ago
IFS Cloud Solution Architect Senior Manager/Associate Director
$80.4k - $224.6k
...Accenture is a leading solutions and services company that helps the... ...As an IFS Cloud Solution Architect, you will define and own the... ...into a coherent and scalable architecture spanning configuration, extensions... ...recommendations based on rigorous data analysis. Develop Points...
Data
Full time
Work experience placement
Live in
Work at office
Local area
Accenture
Saint Louis, MO
3 days ago
Solution Architect - ArcGIS Enterprise (Defense & Intelligence)
$120.64k - $197.6k
...the design of mission critical geospatial solutions supporting Defense and Intelligence operations. As a Solution Architect, you will partner directly with mission focused... ...requirements into scalable system architectures that support high impact workflows, advanced...
Relocation
Relocation package
Esri
Saint Louis, MO
a month ago
PHP Solutions Architect
...headquartered in St. Louis, Missouri is seeking an experienced PHP Solutions Architect to join our growing Development team. As a firm, we provide... ...make an impact by: Leading the establishment of an IT Architecture practice, and the adoption of an architecture and standards...
Full time
Remote work
Flexible hours
Shift work
Steady Rain Inc
Saint Louis, MO
a month ago
Data Architect
...Michigan that offers strategic talent solutions tour clients world-wide. Our... ...businesses. Job Title: Data Architect Location: St. Louis, Mo Duration... ...Architect with deep expertise in OLTP Data Modeling and Data Architecture within the Telecom/Wireless...
Data
Temporary work
TekWissen LLC
Saint Louis, MO
2 days ago
Data Platform Architect
...Job Description Job Description Position: Data Platform Architect (onsite, Florissant, MO) Schedule: Full Time Reporting to: Architecture Lead Position Summary The Augustine Institute seeks a Data Platform Architect to lead the design and implementation...
Data
Full time
Work at office
Augustine Institute Inc
Florissant, MO
29 days ago
Agile Solutions Manager
$147.9k - $200.1k
...future with us. Boeing Company is currently seeking an Agile Solutions Manager to support a complex cross-functional program within... ...manufacturing engineering technology), chemistry, physics, mathematics, data science, or computer science Experience leading large-scale...
Data
Relocation
Visa sponsorship
Work visa
Flexible hours
Shift work
Day shift
Saint Louis, MO
11 days ago
Salesforce Solutions Architect
...Description About the Role: We’re looking for a Salesforce Solutions Architect with healthcare experience to design and deliver scalable,... .../EMR systems. Key Requirements: ~7+ years Salesforce architecture/implementation experience, preferably in healthcare. ~...
The Giant Bullseye
Saint Louis, MO
a month ago
AI Architect
...MatchPoint Solutions is a fast-growing, young, energetic global IT... ...hearing from you! AI Architect Whippany, NJ - Remote 1... ...requirements discovery and architecture through implementation, testing... ...models, APIs, enterprise data sources, and cloud-native AWS...
Data
Local area
Remote work
Match Point Solutions
Maryland Heights, MO
2 days ago
QA lead
...~ Key responsibilities: 1. Data Quality Strategy & Leadership: • Define and execute a comprehensive data quality testing strategy... ...data pipelines and queries. • Collaborate with data engineers, architects, and DevOps teams to optimize data processing workflows. 4....
Data
Work experience placement
Omni Inclusive
Saint Louis, MO
1 day ago
Senior Cloud & Data Architect - AWS & Databricks Expert
...Brillio is seeking a senior cloud architect in St. Louis to design scalable AWS and Databricks solutions. You will lead end-to-end data pipelines, implement medallion architectures, and optimize costs with modern tooling. The role demands extensive experience with...
Data
Jobleads-US
Saint Louis, MO
6 days ago
Oracle Database Solution Architect
...We are seeking an experienced Oracle Database Solution Architect to lead complex, large-scale enterprise transformation programmes. The ideal candidate will combine strong Oracle/enterprise architecture expertise with exceptional programme leadership, stakeholder management...
Temporary work
Delan Associates, Inc
Saint Louis, MO
more than 2 months ago
Development Manager
...real estate development, master planning, architecture, engineering, and construction firm that... ...North America the highest quality solutions on time, on budget, and above and beyond... ...Places to Work 2025 ENR Top 400 - Top Data Center Contractor 2025 ENR Top 100 Design...
Data
For contractors
Local area
Jobot
Saint Louis, MO
3 days ago
Solutions Architect IV
$75 - $83 per hour
...Maryland Heightsm MO is seeking an experienced Platform Architect to design, build, and evolve the architecture that supports our application deployments. This... ...and maintain observability and monitoring solutions using Datadog, including dashboards, alerting, and...
KForce
Maryland Heights, MO
2 days ago
Cross Domain Solutions Engineer (CDS)
$101k - $111k
...Job Description Job Description Cross Domain Solutions Engineer (CDS) Cyber Security Engineering Specialist III - Enterprise Cross... ...than 10%, local Salary Range: $101,000 – $111,000 Moving data between security domains, safely, at enterprise scale. RISA...
Data
Full time
Contract work
Local area
RISA
Saint Louis, MO
2 days ago
Client Solutions Engineer - GEOINT (TS or TS/SCI Clearance)
$115k - $155k
...About Fraym Fraym generates precise, localized data on demographics, attitudes, and behaviors, down to the town or village level. Organizations worldwide use our geospatial data to understand social and economic dynamics, design effective programs, and monitor investments...
Data
Full time
Remote work
Worldwide
Flexible hours
Fraym
Saint Louis, MO
a month ago
Talent Program Manager
...Us BW Design Group is a fully integrated architecture, engineering, construction, system... ...experiences, manage talent processes, and use data-driven insights to improve program... ...leadership development experiences and learning solutions Leverage technology, AI tools, and...
Data
Barry-Wehmiller Companies Inc
Saint Louis, MO
1 day ago
Technical Architect - Threat Vulnerability Management Engineering
...Fortune 500, published June 2024, data as of December 2023.... ...Team Overview: The Technical Architect will be responsible for working... ...Management services and solutions in a mixed on-prem and cloud... ...the integration of a hybrid architecture Creating and managing relationships...
Data
Contract work
Temporary work
Work at office
Home office
Flexible hours
3 days per week
Edward Jones
Saint Louis, MO
8 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Solution Architect - OLTP Data Architecture. Be the first to apply!