Job description:
- Senior DBA-level experience with regards to designing and implementing enterprise class data repositories built upon Oracle on-prem and cloud-hosted databases.
- Practical experience developing fully automated ETL processes from a variety of flat-file and DB sources.
- Experience with utilizing API calls for automated data refreshes.
- Experience with Oracle Analytics Cloud (OAC)
- Mastery of SQL and PL/SQL and the ability to develop complex procedures, functions, views, and scripts.
- Expertise in dimensional modeling.
- Experience with tabular data models.
- Proven ability to accurately capture complex business requirements and translate those into technical solutions which are robust, performant, scalable, reliable, and expandable.
- Demonstrates a disciplined approach to process and error logging.
- Maintains excellent work habits when it comes to coding comments, system documentation, and metadata creation.
- Ability to develop architectural diagrams and system documentation, and train others on the content.
- Demonstrates previous success in independently researching technical options to find suitable solutions for evolving technical needs.
- Works independently towards project and/or assignments goals with limited day-to-day oversight and/or prompting.
Top Skills:
- Minimum of 5 years' experience as a Data Architect.
- Experience with developing fully automated ETL processes from a variety of flat-file and DB sources.
- Significant Senior DBA-level experience with regards to designing and implementing enterprise class data repositories built upon Oracle on-prem and cloud-hosted databases.
- Expertise in dimensional modeling.
- Ability to act as a technical mentor to junior developers.
Department: Preferred Vendors
This is a contract position
.jpg)