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.