Solution Architect - OLTP Data Architecture

Lorven Technologies Inc

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

Solution Architect - Senior Manager - Consulting - Location OPEN
$151.5k - $346k
...future. Our elite team of product leaders, data scientists, designers, and software... ...expect. As a Senior Manager in Solution Architecture, you will be at the heart of our technology... ...and the hiring process. As a Software Architect, you will: Partner with customer technical...
Data
Summer holiday
Flexible hours
EY
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
26 days ago
Senior Solutions Architect - Consumer Product Goods
$219.1k - $301.3k
...of helping large enterprises become more data-driven. Working with the Account Executive... ...technical strategies around Databricks solutions - You will provide structured mentorship... ...technologies such as Hadoop, NoSQL, MPP, OLTP, and OLAP, or full lifecycle data science...
Data
Full time
Local area
Remote work
Worldwide
Databricks
Saint Louis, MO
a month ago
Technical Architect - ServiceNow
$80k - $104k
...of experience in design and architecture roles within ServiceNow or other... ...Certified Technical Architect certification is preferred.... ...design end-to-end technical solutions on ServiceNow. Architect,... ...streamline workflows. Define data archiving strategies that support...
Data
Full time
Work at office
Work from home
Home office
Flexible hours
Edward Jones
Saint Louis, MO
24 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
9 days 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
25 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
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
15 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
6 days 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 OTC Solution Architect / Process Lead
Kforce has a client that is seeking an SAP OTC Solution Architect/Process Lead in Chesterfield, MO. Responsibilities: * Own and lead the end... ...narratives, business requirements, integration requirements, data requirements, decision logs, process controls, business rules...
Data
Temporary work
Local area
Chesterfield, MO
6 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
3 days ago
SailPoint solutions architect
$123k - $163k
...SailPoint IdentityIQ administration and architecture ~ Familiarity with Active Directory,... ...Design and sustain SailPoint and IDAM solution architectures that comply with enterprise... ...Technologies: Active Directory Architect IAM IdentityIQ Support Security...
Full time
Flexible hours
Kforce Technology Staffing
Saint Louis, MO
a month 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
Sr. Business Analyst - SRBIZA
...JOB Title - Solution Architect Pay####/Hr Location : St. Louis Onsite JD: Position Overview We are seeking... ...experienced Solution Architect with deep expertise in OLTP Data Modeling and Data Architecture within the Telecom/Wireless industry. This role requires...
Data
Ipolarity LLC
Saint Louis, MO
2 days 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 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
26 days 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
3 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
Network Engineer
...using DNA.Should have worked on detailed level the Cisco DNA Center Assurance system architecture, functional components, features, Licensing genration of DNA on AP's/WLC's and data-processing concepts.Deploy and configure Cisco DNA Center to use Assurance features for...
Data
Omni Inclusive
Saint Louis, MO
2 days ago
AI Engineer/Data Scientist :: Hybrid Saint Louis Missouri :: Need Local candidate
Job ID: 28113686Reference Number: 26-00434Title: AI Engineer/Data Scientist :: Hybrid Saint Louis Missouri :: Need Local candidatePosted... ...are seeking a highly skilled Lead Engineer to lead the architecture, design, and development of the PISCES HUB platform, a configuration...
Data
Local area
HAN Staffing
Saint Louis, MO
a month 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
19 hours 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
...BW Design Group is a fully integrated architecture, engineering, construction, system integration... ..., manage talent processes, and use data-driven insights to improve program effectiveness... ...development experiences and learning solutions Leverage technology, AI tools, and...
Data
Full time
Barry-Wehmiller
Saint Louis, MO
2 days ago
Fabric Data Engineer
...Fabric Data EngineerST Louis MO onsite Duration: 6+ months Mode... ...Warehousing, and Analytics solutions. Strong implementation... ...Experience implementing Medallion Architecture (Bronze/Silver/Gold) and... ...with business users, analysts, architects, and data platform teams. Ability...
Data
Echo IT Solutions
Saint Louis, MO
4 days ago
Principal Architect
...15 years of experience in cloud architecture, including significant hands‑on... ...implementing AWS and Databricks‑based solutions Key Responsibilities: Design and architect scalable, secure, and high-... ...Write efficient SQL queries for data transformation, validation, and...
Data
Work at office
3 days per week
Brillio
Saint Louis, MO
2 days ago
Golf Product Marketing Manager
...Malaysia, Rapsodo represents more than just sports technology and data analytics. It stands as the clear front-runner in providing... ...easy-to-understand customer value. ~ Develop the messaging architecture that guides customer-facing communications across Marketing, Sales...
Data
Shift work
Rapsodo
Saint Louis, MO
12 days ago
Contact Center Architect CallMiner
...are seeking a Senior Contact Center Architect with deep expertise in CallMiner... ...scale voice and interaction analytics solutions. This role will lead architecture and strategy for speech analytics... ...voice, chat, email, and omnichannel data sources. Integrate CallMiner...
Data
The Giant Bullseye
Saint Louis, MO
a month ago
Senior Quality Analyst
...frameworks. Strong experience testing AWS data pipelines and cloud-native applications.... ...testing Apache Kafka-based event-driven architectures. Proven experience validating:... ...Award- IT and Engineering Staffing & Solutions Best of MichBusiness winner in HR Wizards...
Data
Visa sponsorship
Work visa
Kyyba
Saint Louis, MO
4 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!