Oracle Developer

Overview

On Site
Accepts corp to corp applications
Contract - Long Term

Skills

oracle
SQL
Oracle DB
Snowflake and Oracle databases

Job Details

Position: Oracle Developer

Location: Denver CO - Remote

Duration: Long Term

Job Description:

  • We are seeking a skilled Oracle Developer with expertise in optimizing SQL statements and ensuring the performance, security, and availability of databases. The ideal candidate will have experience with Snowflake and Oracle databases, with a focus on transitioning from Snowflake to Oracle Cloud Infrastructure (OCI). The role involves collaborating with other team members and stakeholders to develop and maintain database objects.

Responsibilities:

  • Help write and optimize in-application SQL statements to ensure efficient data retrieval and manipulation.
  • Ensure the performance, security, and availability of databases by implementing best practices and optimizing database configurations.
  • Prepare documentations and specifications related to database structures, queries, and optimizations.
  • Profile server resource usage, and optimize and tweak as necessary to maintain optimal performance.
  • Collaborate with other team members and stakeholders to understand business requirements and translate them into effective database solutions.
  • Develop and maintain existing Snowflake program units, ensuring their compatibility with the transitioning process to Oracle DB.
  • Assist with the implementation of new Snowflake program units and their migration to OCI.
  • Create consistent and high-performance database objects, including tables, views, indexes, and stored procedures.
  • Participate in database design discussions and contribute to the optimization of database schemas.
  • Stay updated with Oracle's Cloud offerings, especially OCI, and contribute to the migration strategy from Snowflake to OCI.

Requirements:

  • Bachelor's degree in Science, Information Technology, with minimum 12+ Years of relevant experience. Proven experience as a Database Engineer or similar role, with a focus on SQL optimization and database performance tuning.
  • Strong proficiency in SQL programming and optimization techniques.
  • Experience with Snowflake and Oracle databases, with a willingness to transition from Snowflake to OCI.
  • Excellent problem-solving and analytical skills.
  • Ability to work independently and as part of a team in a fast-paced environment.
  • Strong communication and interpersonal skills.