Lorven TechnologiesDenver, Colorado, United States
30+ days ago
Job description
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.