What are the responsibilities and job description for the Oracle Database/ PL/SQL Developer - local to Houston - TX only - F2F interview position at Shift Code Analytics?
Job Details
Hi,
I hope you are doing well.
Please let me know if you are looking for a job change and interested in the below position.
Additional Job Information: Title: Oracle Database/ PL/SQL Developer Position Type: Contract
Location: Houston, TX
Description:
Interview: Onsite
First step is a 45 min coding challenge, so that weeds out a lot of weak candidates as well as candidates who try cheating.
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.
Thanks & Regards,
Anikat Kumar
Technical Recruiter
ShiftCode Analytics Inc.
Email:
Website :
Address :
