Solution Architect OLTP Data Modeling TelecomWireless Onsite St Louis 6 Months

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

About Genius Business Solutions Inc. (GBSI)

Featured in CNBC, Digital Journal, Fox News, and CIO Review, GBSI is a globally recognized IT services leader with 20+ years serving Fortune 500 organizations. Our teams deliver solutions across automotive, manufacturing, retail, and pharmaceutical industries. Headquartered in Moline, IL, GBSI supports clients and consultants throughout the US, Canada, Europe, and India.

Join our innovative team to lead enterprise-grade SAP solutions and drive digital transformation initiatives across global enterprises.

Job Summary

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
• 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 workflowsDevice 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

Preferred Qualifications

• TM Forum SID Data Model experience
• Telecom platforms such as:
  • Amdocs
  • Netcracker
  • Ericsson
  • CSG
• Oracle Exadata
• Oracle GoldenGate
• Schema version control and automation
• Temporal and history-based data modeling
• Supertype/Subtype modeling patterns
• Capacity planning and scalability modeling

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

Equal Employment Opportunity

GeniusBSI is an Equal Opportunity Employer. We believe that no one should be discriminated against because of their differences, such as age, disability, ethnicity, gender, gender identity and expression, religion, or sexual orientation.

All employment decisions shall be made without regard to age, race, creed, color, religion, sex, national origin, ancestry, disability status, veteran status, sexual orientation, gender identity or expression, genetic information, marital status, citizenship status, or any other basis as protected by federal, state, or local law.