Solution Architect OLTP Data Modeling
Job Title: Solution Architect OLTP Data ModelingLocation: St. Louis, MO OnsiteWork Arrangement: Onsite (4 days/week, No Remote Option)Experience Required: 10+ YearsPrimary Skills: Erwin Data Modeler, Oracle, PL/SQL, Python, OLTP Data Modeling, Telecom/Wireless DomainJob Description: Solution Architect OLTP Data Modeling (Telecom/Wireless)Position OverviewWe 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 ResponsibilitiesData Architecture & ModelingTranslate 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 DesignDesign Oracle physical schemas, including:Tables and columnsPrimary and foreign keysIndexing strategiesConstraints and sequencesPartitioning structuresEnsure database scalability, integrity, and performance.Erwin Data ModelingDevelop 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 TuningDevelop 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 & QualityDefine 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 AutomationDevelop automation tools for:Model validationMetadata extractionSchema compliance checksData profilingDeployment supportRequired Qualifications10+ years of Data Architecture and Data Modeling experience.Majority of experience focused on OLTP/transactional systems.Strong hands-on expertise with:Erwin Data ModelerOracle DatabaseAdvanced PL/SQL DevelopmentPythonExpert Understanding Of3NF data modeling and normalizationLogical and physical data modelingDatabase performance tuningData governance practicesAbility 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 managementMulti-line and hierarchical account structuresProduct catalogs, rate plans, and offersFeatures, entitlements, compatibility, and eligibility rulesOrder management, activation, and provisioning workflowsDevice and equipment managementDevice financing and installment plansMobile subscriber identifiers:MSISDNIMSIICCID/SIMIMEINumber portability (Port-In/Port-Out)Telecom BSS/OSS ecosystemsPreferred QualificationsTM Forum SID Data Model experienceTelecom platforms such as:AmdocsNetcrackerEricssonCSGOracle ExadataOracle GoldenGateSchema version control and automationTemporal and history-based data modelingSupertype/Subtype modeling patternsCapacity planning and scalability modelingMust-Have SkillsOLTP Data ModelingData ArchitectureErwin Data ModelerOracle DatabaseAdvanced PL/SQLDatabase Performance TuningPython AutomationTelecom/Wireless Domain ExperienceData Governance & StandardsNice-to-Have SkillsTM Forum SIDOracle ExadataOracle GoldenGateAmdocs / Netcracker / Ericsson / CSGSchema Automation & Version ControlLooking for: A hands-on Solution Architect who can gather business requirements, design enterprise-grade OLTP data models, implement Oracle database solutions, and optimize transactional systems within a Telecom/Wireless environment. Thanks & Regards, Pankaj Singh - Team LeadPhone #