Senior PL/SQL Developer
Join Us
At Vodafone, we’re not just shaping the future of connectivity for our customers – we’re shaping the future for everyone who joins our team. When you work with us, you’re part of a global mission to connect people, solve complex challenges, and create a sustainable and more inclusive world. If you want to grow your career whilst finding the perfect balance between work and life, Vodafone offers the opportunities to help you belong and make a real impact.
Role purpose:
Enhance and optimize telecommunications network planning and inventory systems for Vodacom local markets, ensuring data integrity, consistency, and normalization across complex relational database models. Focus on performance optimization, integration, automation, and compliance with telecom industry standards for data storage, backup, and disaster recovery.
Work closely with network engineers, planners, and business analysts to design and implement PL/SQL stored procedures, triggers, packages, and functions, while customizing platforms like ATOL and Oracle UIM to support network planning, topology visualization, and inventory tracking.
Key accountabilities and decision ownership
Develop, optimize, and maintain PL/SQL stored procedures, triggers, packages, and functions for telecommunications planning and inventory systems. Design and implement efficient database schema structures, partitions, and indexing strategies for large-scale telecom datasets.
Enhance and customize ATOL and Oracle UIM to support network planning, topology visualization, and inventory tracking. Design data models and workflows to map telecommunication networks, equipment, and physical/logical resources within Oracle UIM.
Implement query optimization techniques, materialized views, and indexing to improve data retrieval speeds. Tune PL/SQL code and batch processes to handle large-scale datasets in telecom environments. Develop ETL scripts for loading and processing network inventory data.
Develop APIs and database interfaces to integrate Oracle UIM with third-party telecom tools and network management systems. Automate data workflows and reporting using PL/SQL, shell scripting, and Oracle SQL Loader. Implement real-time and batch data synchronization strategies for distributed network inventory environments.
Enforce data security policies, access controls, and role-based permissions within Oracle databases. Ensure compliance with telecom industry standards for data storage, backup, and disaster recovery.
Core competencies, knowledge and experience
Deep expertise in Oracle PL/SQL development, including performance tuning, data modeling, and schema design. This involves developing, optimizing, and maintaining PL/SQL stored procedures, triggers, packages, and functions for telecommunications planning and inventory systems.
Strong background in SQL query optimization, indexing strategies, and database schema design. This includes designing and implementing efficient database schema structures, partitions, and indexing strategies for large-scale telecom datasets, ensuring data integrity, consistency, and normalization across complex relational database models.
Experience working with telecom network planning and inventory tools such as ATOL and Oracle UIM. This involves enhancing and customizing these platforms to support network planning, topology visualization, and inventory tracking, as well as designing data models and workflows to map telecommunication networks, equipment, and physical/logical resources within Oracle UIM.
Proficiency in integrating Oracle UIM with other telecom network management systems and developing APIs and database interfaces. This includes automating data workflows and reporting using PL/SQL, shell scripting, and Oracle SQL Loader, and implementing real-time and batch data synchronization strategies for distributed network inventory environments.
Knowledge of data security policies, access controls, and role-based permissions within Oracle databases. This involves enforcing data security policies and ensuring compliance with telecom industry standards for data storage, backup, and disaster recovery.
Must have technical / professional qualifications:
Bachelor’s degree in Computer Science, Information Systems, or a related field.
2+ years of experience in Oracle PL/SQL development. (Perl)
Strong expertise in SQL query optimization, indexing strategies, and database schema design.
Experience working with telecom network planning and inventory tools such as ATOL and Oracle UIM.
Knowledge of data modeling for network topology, telecom inventory, and asset management.
Proficiency in designing large-scale relational database structures for high-performance data processing.
Experience integrating Oracle UIM with other telecom network management systems.
Familiarity with geospatial data processing in telecom environments.
Preferred Skills (Nice to Have):
Experience with Oracle Spatial & Graph for network topology mapping.
Familiarity with JSON, REST APIs, and XML for data integration.
Understanding of cloud-based Oracle database solutions (e.g., Oracle Cloud, AWS RDS).
Knowledge of telecom industry standards for inventory and network planning