Solution Architect

JD:

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, 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:
o Tables and columns
o Primary and foreign keys
o Indexing strategies
o Constraints and sequences
o Partitioning structures
• Ensure database scalability, integrity, and performance.
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:
o Model validation
o Metadata extraction
o Schema compliance checks
o Data profiling
o 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:
o Erwin Data Modeler
o Oracle Database
o Advanced PL/SQL Development
o Python
• Expert understanding of:
o 3NF data modeling and normalization
o Logical and physical data modeling
o Database performance tuning
o 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 workflows
• Device and equipment management
• Device financing and installment plans
• Mobile subscriber identifiers:
o MSISDN
o IMSI
o ICCID/SIM
o IMEI
• Number portability (Port-In/Port-Out)
• Telecom BSS/OSS ecosystems
________________________________________
Preferred Qualifications
• TM Forum SID Data Model experience
• Telecom platforms such as:
o Amdocs
o Netcracker
o Ericsson
o 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