Principal Database Engineer

SUMMARY:
We are looking for a Software Developer in a Principal Database Engineer position who has significant hands-on experience with Oracle Suite, for a Multinational company based int he Fourways area in Johannesburg. If you have strong background with ODI, Oracle and OAS then please apply.

POSITION INFO:
Position overview:
We are seeking a Principal Database Engineer to join an established company’s Information Technology team. The IT team delivers quality software solutions that provide measurable business value. Day to day you will lead all aspects of the design, development, and delivery of database, business intelligence, data warehouse, and data integration solutions. As a Principal Database Engineer, you will partner cross-functionally to provide expert technical knowledge and leadership guidance during design, development, and delivery to ensure solid, scalable, robust solutions.

Requirements:

• 4 Year / Bachelor’s degree - Bachelor’s degree in Computer Science or a related field and at least 10 years of related experience, or Master’s degree in Computer Science or a related field with at least 8 years of experience required.
• Minimum 8 years of relational database, ETL, data warehouse, and business intelligence design, data modeling, development, or architecture experience required.
• Hands-on experience with the Oracle Suite, specifically ODI (Oracle Data Integrator), OAS/OAC (Oracle Analytics Server/Cloud), Oracle Database, SQL, PL/SQL, and Data warehouse concepts
• Experience with Azure Cloud, Azure Data Factory, Fabric, and Databricks would be an advantage but not essential

• Oracle and Cloud Azure experience
• Experience in the ETL tool
• Experience in reporting OAS/ODI
• Experience in SQL reporting

• Engage with business users to extract complex requirements and priorities in order to propose the right solution for business needs.
• Engage with business users to extract complex requirements and priorities in order to propose the right solution for business needs.
• Champion and create Company development standards or industry best practices across business intelligence and data warehouse solutions.
• Assist the organization with understanding, testing, and incubating the newest technology advances and best practices, leveraging both to support business drivers for future use.
• Lead technical teams in the design and development of data solutions by providing expert technical and architectural guidance.
• Design logical and physical data models, ETL jobs, and repository metadata for a variety of functional departments that utilize data from the telecommunications or real estate industry.
• Create and maintain all database models.
• Audit and review performance metrics for new and existing data integration solutions and database queries to ensure adherence to service level agreements as well as system health.
• Other duties as assigned

• Proven ability to deliver high-impact, performance-focused solutions using low- maintenance development methods.
• Strong proficiency in Structured Query Language (SQL) and PL/SQL programming.
• Skilled in data modeling tools and data warehouse architecture, including design, implementation, and concepts such as Kimball methodology, star and snowflake
• schemas, and semantic layer design.
• Hands-on experience with Oracle Exadata, 19c or later databases, and SQL Developer.
• Expertise in writing complex stored procedures and tuning relational databases.
  Knowledge of Oracle Golden Gate and data replication technologies.
• Ability to design, develop, and maintain ETL processes using Oracle Data Integrator (ODI), including topology and model administration, object migration between environments, scheduling and monitoring, tuning load plans and batch jobs, and error
• handling within package flows.
• Familiarity with Python scripting, Spark, and extracting data via REST APIs.
• Experience with OAS Repository Development or equivalent Enterprise BI metadata development, including creating Physical, Business, and Presentation layers and administering BI security with Active Directory integration.
• Exposure to cloud architecture such as Fabric, Snowflake, or Databricks and adaptability to AI-driven BI solutions.
• Approximately 10% travel may be required in support of the position’s responsibilities.
• Strong written and oral communication skills, including the ability to present ideas and suggestions clearly and effectively.
• Ability to work with different functional groups and levels of employees to effectively and professionally achieve results.
• Strong organizational skills; ability to accomplish multiple tasks within the agreed upon timeframes through effective prioritization of duties and functions in a fast-paced environment.
• Strong written and oral communication skills, including the ability to present ideas and suggestions clearly and effectively.
• Ability to work with different functional groups and levels of employees to effectively and professionally achieve results.
• Strong organizational skills; ability to accomplish multiple tasks within the agreed upon timeframes through effective prioritization of duties and functions in a fast-paced environment

• Hybrid working model - 3 days in the Office, 2 days working from home