What are the responsibilities and job description for the Oracle Database Developer position at The Jupiter Group, Inc?
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.
