Solution Architect OLTP Data Modeling || St. Louis, MO || Onsite || Long Term

We at NJ TECH INC are focused on hiring highly skilled professionals who are excited by the opportunity to make a true impact on their careers as well as on our clients' business. We power our clients success and drive our consultants career growth.

We are seeking an experienced and outstanding Solution Architect OLTP Data Modeling for one of our esteemed clients.

Job Title: Solution Architect OLTP Data Modeling

Location: St. Louis, MO (Onsite)

Duration: Long Term

Primary Skills: Erwin Data Modeler, Oracle, PL/SQL, Python, OLTP Data Modeling, Telecom/Wireless Domain

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, 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

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

• 12+ 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

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

Nice-to-Have Skills

• TM Forum SID
• Oracle Exadata
• Oracle Goldengate
• Amdocs / Netcracker / Ericsson / CSG
• Schema Automation & Version Control

Looking for: A hands-on Solution Architect who can gather business requirements, design enterprise-grade OLTP data models, and implement Oracle database solutions.

NJ TECH INC is an equal opportunity employer. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, We cannot sponsor any visa at this time

NJ TECH INC, is a globally managed IT service, consulting and Business solutions partner. Our "High-Performance Business" strategy builds up our expertise in technology and consulting. Our consulting plays a major role in helping clients to achieve their objectives in the highest level; ultimately creating sustainable value for customers. Come, transform your career with us and be a part of our high-performing team