Oracle Database Developer- EOG, Texas

Interview: Onsite

Visa: All excpet h1b

Onsite: Houston, TX

First step is a 45 min coding challenge, so that weeds out a lot of weak candidates as well as candidates who try cheating.

JD:
Job Summary:

We are seeking a highly skilled Oracle Database Developer with strong PL/SQL development expertise to design, develop, and optimize database solutions . The ideal candidate will have experience in performance tuning, data analysis, and integrating with UI applications using SQL, PL/SQL, and Python.

Key Responsibilities:

Develop and maintain complex PL/SQL code, including packages, procedures, functions, triggers, and user-defined types.

Design and implement database partitioning strategies and DBMS jobs for optimized performance.

Collaborate with UI and application teams to facilitate seamless database interactions using cursors, XML, JSON, and RESTful integrations.

Perform SQL and PL/SQL tuning to enhance query performance and database efficiency.

Conduct data analysis, troubleshoot performance issues, and implement optimizations.

Work with Python for database-related scripting, utilizing libraries such as DB connectors, Requests, JSON, Pandas, and others.

Ensure database integrity, security, and scalability through best practices.

Qualifications & Skills:

Strong expertise in PL/SQL development and SQL tuning.

Hands-on experience with database partitioning, indexing, and query optimization.

Proficiency in working with UI applications, handling structured and semi-structured data (XML, JSON).

Knowledge of Python scripting and database connectivity libraries.

Strong debugging and troubleshooting skills for performance bottlenecks.