Haystack
← Back to Jobs
Technology
LILiveMindz logo

Solution Architect OLTP Data Modeling (Telecom/Wireless)

LiveMindzSt. Louis, MO🇺🇸United StatesPosted Oct 19, 2026

Quick Overview

Seniority
Mid Senior
Work mode
On Site
Location
St. Louis, MO, United States
Posted
22 hours ago
OraclePL/SQLSQLETLPython

Job Description

Job Description: Solution Architect OLTP Data Modeling (Telecom/Wireless)

Job Title: Solution Architect OLTP Data Modeling
Location: St. Louis, MO

Work Arrangement: Onsite (4 days/week, No Remote Option)
Experience Required: 10+ Years
Primary Skills: Erwin Data Modeler, Oracle, PL/SQL, Python, OLTP Data Modeling, Telecom/Wireless Domain

Looking for: A hands-on Solution Architect who can gather business requirements, design enterprise-grade OLTP data models, implement Oracle database solutions, and optimize transactional systems within a Telecom/Wireless environment.

Position Overview

We are seeking an experienced Solution Architect with deep expertise in OLTP Data Modeling and Data Architecture within the Telecom/Wireless industry.

This role requires a hands-on architect capable of designing and governing highly normalized transactional databases that support customer-facing mobile applications, subscriber management systems, product catalogs, order management, and activation workflows.

The ideal candidate will have strong experience with Erwin Data Modeler, Oracle Database, PL/SQL, and Python, along with a proven track record of architecting scalable, high-volume transactional systems in a telecom environment.

Note: This is an OLTP-focused role. Candidates with primary experience in Data Warehousing, BI, Analytics Engineering, Reporting, or ETL/ELT development will not be considered.

Key Responsibilities

Data Architecture & Modeling

  • Translate business requirements into conceptual, logical, and physical data models.
  • Design and maintain highly normalized (3NF) enterprise data models.
  • Create conceptual Entity Relationship Diagrams (ERDs) and logical data models.
  • Establish and govern business data definitions, standards, and naming conventions.

Oracle Database Design

  • Design Oracle physical schemas, including:
    • Tables and columns
    • Primary and foreign keys
    • Indexing strategies
    • Constraints and sequences
    • Partitioning structures
  • Ensure database scalability, integrity, and performance.

Erwin Data Modeling

  • Develop and maintain enterprise data models using Erwin Data Modeler.
  • Manage model versioning through Erwin Mart.
  • Perform forward and reverse engineering.
  • Utilize Complete Compare to identify and resolve schema differences.
  • Maintain naming standards, domains, and model governance.

PL/SQL Development & Performance Tuning

  • Develop and optimize complex PL/SQL code.
  • Analyze execution plans and identify performance bottlenecks.
  • Optimize indexing strategies and database queries.
  • Troubleshoot locking, contention, and concurrency issues in high-volume transactional environments.

Data Governance & Quality

  • Define data modeling standards, governance procedures, and review processes.
  • Develop data dictionaries and impact analysis documentation.
  • Establish controls for data quality, consistency, completeness, and integrity.
  • Ensure compliance with security and privacy requirements.

Python Automation

  • Develop automation tools for:
    • Model validation
    • Metadata extraction
    • Schema compliance checks
    • Data profiling
    • Deployment support

Required Qualifications

  • 10+ years of Data Architecture and Data Modeling experience.
  • Majority of experience focused on OLTP/transactional systems.
  • Strong hands-on expertise with:
    • Erwin Data Modeler
    • Oracle Database
    • Advanced PL/SQL Development
    • Python
  • Expert understanding of:
    • 3NF data modeling and normalization
    • Logical and physical data modeling
    • Database performance tuning
    • Data governance practices
  • Ability to work directly with business stakeholders and translate requirements into technical solutions.

Telecom/Wireless Domain Experience (Mandatory)

Candidates should possess hands-on experience in one or more of the following areas:

  • Subscriber and account lifecycle management
  • Multi-line and hierarchical account structures
  • Product catalogs, rate plans, and offers
  • Features, entitlements, compatibility, and eligibility rules
  • Order management, activation, and provisioning workflows
  • Device and equipment management
  • Device financing and installment plans
  • Mobile subscriber identifiers:
    • MSISDN
    • IMSI
    • ICCID/SIM
    • IMEI
  • Number portability (Port-In/Port-Out)
  • Telecom BSS/OSS ecosystems

Must-Have Skills

  • OLTP Data Modeling
  • Data Architecture
  • Erwin Data Modeler
  • Oracle Database
  • Advanced PL/SQL
  • Database Performance Tuning
  • Python Automation
  • Telecom/Wireless Domain Experience
  • Data Governance & Standards

Similar jobs

Browse related jobs

Apply