Telecom OLTP Data Architect — 3NF, Oracle & Erwin

Genius Business Solutions; Bay St. Louis (MS); On-site; USD 110,000 - 170,000; Full time

Job summary

Genius Business Solutions Inc. (GBSI) seeks an experienced Solution Architect with deep expertise in OLTP Data Modeling and Data Architecture within the Telecom/Wireless industry.

This hands-on architect will design and govern highly normalized transactional databases that support mobile applications, subscriber management, product catalogs, order management and activation workflows. Proficiency with Erwin Data Modeler, Oracle Database, PL/SQL, and Python is 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, PL/SQL, Python.

Responsibilities

• Data Architecture & Modeling: translate business requirements into conceptual, logical, and physical data models.
• Oracle Database Design: design physical schemas with tables, keys, indexes, constraints, sequences, and partitions.
• Erwin Data Modeling: develop enterprise data models using Erwin Data Modeler and manage versions.
• PL/SQL Development & Performance Tuning: write and optimize PL/SQL; analyze execution plans and bottlenecks.
• Data Governance & Quality: define standards, dictionaries, and ensure data quality and security.
• Python Automation: build tools for model validation, metadata extraction, and schema checks.

Skills

OLTP Data Modeling

Data Architecture

3NF Modeling

Stakeholder Collaboration

Tools

Erwin Data Modeler

Oracle Database

PL/SQL

Python

Job description

Genius Business Solutions Inc. (GBSI) seeks an experienced Solution Architect with deep expertise in OLTP Data Modeling and Data Architecture within the Telecom/Wireless industry.

This hands-on architect will design and govern highly normalized transactional databases that support mobile applications, subscriber management, product catalogs, order management and activation workflows. Proficiency with Erwin Data Modeler, Oracle Database, PL/SQL, and Python is required.