Telecom OLTP Data Architect - 3NF Modeling, Oracle & Erwin

ReqRoute,Inc; St. Louis (MO); On-site; USD 120,000 - 180,000; Full time

Job summary

ReqRoute,Inc. seeks a seasoned Solution Architect in St. Louis (onsite) to lead OLTP data modeling and data architecture for telecom/mobile applications. You will design highly normalized transactional databases using Erwin, Oracle, PL/SQL, and Python.

Responsibilities include translating requirements into conceptual/physical models, governing standards, and ensuring performance in high-volume environments. Telecom domain experience is essential.

Qualifications

• 10+ years of Data Architecture and Data Modeling experience.
• OLTP/transactional systems experience.
• Expert with Erwin Data Modeler, Oracle Database, PL/SQL, Python.
• 3NF data modeling, normalization, governance.
• Ability to work with business stakeholders and translate requirements into technical solutions.

Responsibilities

• Data Architecture & Modeling: Translate requirements into conceptual, logical, and physical models; maintain highly normalized enterprise data models; create ERDs and data dictionaries.
• Oracle Database Design: Design physical schemas, tables, keys, indexing, constraints, sequences, and partitioning; ensure scalability and performance.
• Erwin Data Modeling: Develop and maintain models in Erwin; manage versioning; perform forward/reverse engineering; use Complete Compare; enforce governance.
• PL/SQL Development & Performance Tuning: Develop and optimize complex PL/SQL; analyze execution plans; optimize queries and indexing; troubleshoot locking and concurrency.
• Data Governance & Quality: Define standards, governance procedures, data dictionaries, quality controls, and compliance with security/privacy.
• Python Automation: Build automation tools for model validation, metadata extraction, schema checks, data profiling, deployment support.

Skills

OLTP Data Modeling

Data Architecture

Erwin Data Modeler

Oracle Database

Advanced PL/SQL

Python Automation

Telecom/Wireless Domain Experience

Data Governance & Standards

3NF Modeling

Tools

Oracle Exadata

Oracle GoldenGate

Job description

ReqRoute,Inc. seeks a seasoned Solution Architect in St. Louis (onsite) to lead OLTP data modeling and data architecture for telecom/mobile applications. You will design highly normalized transactional databases using Erwin, Oracle, PL/SQL, and Python.

Responsibilities include translating requirements into conceptual/physical models, governing standards, and ensuring performance in high-volume environments. Telecom domain experience is essential.