Solution Architect - OLTP Data Architecture
Lorven Technologies Inc
St. Louis, MO, United States
19 days ago
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Apply on www.dice.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
10 years minimum
Working hours
Regular working hours
Job source
Tech stack
Third Normal Form
Information Systems
Data Architecture
Data Dictionary
Data Governance
Data Profiling
Python (Programming Language)
Metadata
Online Transaction Processing
Oracle Databases
Query Optimization
Reverse Engineering
+7 more
Concurrency
Database Optimization
Model Validation
Indexer
Information Technology
OSS/BSS
Physical Data Models
Requirements
- Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related field, or equivalent experience.
- 10+ years of experience in Data Architecture and Data Modeling.
- Strong hands-on experience with OLTP / transactional systems, primarily in Telecom/Wireless environments.
- Expert knowledge of 3NF, normalized data modeling, conceptual, logical, and physical data models.
- Strong hands-on experience with Erwin Data Modeler, including Erwin Mart, forward/reverse engineering, and Complete Compare.
- Strong experience with Oracle Database, including schema design, tables, keys, constraints, indexes, sequences, and partitioning.
- Advanced PL/SQL development and database performance tuning experience.
- Strong knowledge of query optimization, execution plans, indexing, locking, concurrency, and high-volume transactions.
- Hands-on Python experience for model validation, metadata extraction, schema checks, data profiling, and automation.
- Strong experience establishing data governance, standards, naming conventions, data dictionaries, and data quality controls.
- Mandatory Telecom/Wireless domain experience with subscriber, account, product, order, activation, provisioning, or device management systems.
- Experience with MSISDN, IMSI, ICCID/SIM, IMEI, number portability, rate plans, offers, and entitlements is preferred.
- Strong understanding of BSS/OSS ecosystems and telecom transactional platforms.
- Strong analytical, problem-solving, stakeholder management, and technical documentation skills.
Apply for this position
This job is hosted externally. Click below to view the full posting and apply.
Apply on www.dice.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this role…