Wall Street Consulting Services LLC
Oracle Database Architect
⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for an Oracle Database Architect with 15+ years of experience, requiring expertise in SQL (Oracle 12c+), data modeling (ERWIN), ETL processes, and Linux scripting. Contract duration exceeds 6 months, with a competitive pay rate.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
Unknown
-
🗓️ - Date
December 20, 2025
🕒 - Duration
More than 6 months
-
🏝️ - Location
Unknown
-
📄 - Contract
Unknown
-
🔒 - Security
Unknown
-
📍 - Location detailed
Albany, NY
-
🧠 - Skills detailed
#SQL Queries #"ETL (Extract #Transform #Load)" #Data Modeling #Logical Data Model #Bash #SQL (Structured Query Language) #Databases #Linux #ERWin #Debugging #Oracle #Data Analysis #Triggers
Role description
Requirements Experience (15+ Years)
84 months experience creating Views, Triggers, stored procedures, functions, and writing SQL in Oracle (12c or higher).
• 84 months of experience using a data modeling tools such as ERWIN to create physical and logical data models, reverse engineer existing databases, and compare existing databases in Oracle (12c or higher).
• 84 months of experience developing complex ETL processes using shell scripts (Korn, Bash, and Power Shell), SQL scripts, and PL/SQL.
• 84 months of experience performing data analysis and creating reports for customers. 84 months of experience optimizing SQL queries and debugging PL/SQL objects (packages, functions, and procedures).
• 60 months of experience developing Korn shell and bash shell scripts in a Linux environment.
Requirements Experience (15+ Years)
84 months experience creating Views, Triggers, stored procedures, functions, and writing SQL in Oracle (12c or higher).
• 84 months of experience using a data modeling tools such as ERWIN to create physical and logical data models, reverse engineer existing databases, and compare existing databases in Oracle (12c or higher).
• 84 months of experience developing complex ETL processes using shell scripts (Korn, Bash, and Power Shell), SQL scripts, and PL/SQL.
• 84 months of experience performing data analysis and creating reports for customers. 84 months of experience optimizing SQL queries and debugging PL/SQL objects (packages, functions, and procedures).
• 60 months of experience developing Korn shell and bash shell scripts in a Linux environment.
