> Markdown version of [/jobs/ext/3450990-solution-architect-oltp-data-architecture](https://www.wearedevelopers.com/jobs/ext/3450990-solution-architect-oltp-data-architecture). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Solution Architect - OLTP Data Architecture

- **Company:** Lorven Technologies Inc
- **Location:** St. Louis, MO, United States
- **Experience:** Expert
- **Contract:** Permanent contract
- **Skills:** Third Normal Form, Information Systems, Data Architecture, Data Dictionary, Data Governance, Data Profiling, Python (Programming Language), Metadata, Online Transaction Processing, Oracle Databases, Query Optimization, Reverse Engineering, Concurrency, Database Optimization, Model Validation, Indexer, Information Technology, OSS/BSS, Physical Data Models
- **Published:** September 23, 2026
- **Apply:** https://www.dice.com/job-detail/11e7f1f6-0f6a-4d2d-8c4e-1728be90bef1

## About the Role

* 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.