Description

Lead the technical design, development, and documentation of database solutions for enterprise master data platforms.

Responsibilities

• Lead the technical design, development, and documentation of database solutions.
• Build, maintain, and promote enterprise master data platforms.
• Manage the full life-cycle development of data-centric applications.
• Create and maintain database objects including tables, indexes, views, and synonyms.
• Perform database performance tuning using AWR reports and partitioning.

Required Skills

• 8+ years of experience in architecture, design, development, testing, and maintenance of scalable relational database services.
• 5-7 years of hands-on experience with Oracle 12c or better.
• Expertise in SQL and PL/SQL, including stored procedures, functions, triggers, and views.
• Proficiency in Dimensional Data Modeling.
• Experience with Unix/Linux and scripting using Bash or Python.
• Knowledge of ETL processes and programming in Java or Python.
• Experience with version control and DevOps tools such as Git and Jenkins.
• Understanding of information security and access control protocols.

Preferred Skills

• Experience with Change Data Capture (CDC) such as Oracle GoldenGate.

Key Skills

Education

Bachelor’s or Master’s degree