- Company Name
- TekValue IT Solutions
- Job Title
- Oracle PL/SQL Developer
- Job Description
-
**Job Title:** Oracle PL/SQL Developer
**Role Summary:** Lead developer responsible for designing, implementing, and optimizing Oracle PL/SQL solutions in large OLAP and OLTP environments. Expertise in database architecture, ETL development, and performance tuning is essential to support mission‑critical data workloads.
**Expectations:** • 8–12 years of professional PL/SQL development experience. • Proven track record delivering end‑to‑end ETL jobs and complex database objects. • Deep proficiency in tuning SQL/PLSQL, partitioning, DBMS jobs, and user‑defined types. • Ability to collaborate with UI teams, working with cursors, XML, and JSON. • Strong analytical skills for debugging, tracing, and resolving performance issues. • Familiarity with Oracle Exadata, and optional experience with SingleStore/MySQL. • Knowledge of Python and related data‑processing libraries (requests, json, pandas) is a plus. • Background in Oil & Gas industry is highly valued.
**Key Responsibilities:**
1. Design, develop, and maintain PL/SQL code, packages, procedures, functions, and user‑defined types.
2. Create and schedule DBMS jobs, implement partitioning strategies, and manage database objects.
3. Build and maintain end‑to‑end ETL jobs, integrating with UI applications and handling cursor, XML, and JSON data exchange.
4. Perform SQL/PLSQL tuning, index optimization, and query rewrite to meet performance targets.
5. Analyze data flows, debug issues, trace execution paths, and implement fixes for performance bottlenecks.
6. Collaborate with cross‑functional teams to define requirements, estimate effort, and deliver high‑quality solutions.
7. Stay current on Oracle database features, Exadata best practices, and emerging data‑engineering tools.
**Required Skills:**
- Advanced PL/SQL development (packages, procedures, functions, triggers).
- OLAP/OLTP architecture design and optimization.
- Database partitioning, DBMS jobs, and user‑defined types.
- Cursor handling, XML, JSON data integration.
- ETL job design and implementation.
- SQL and PL/SQL performance tuning (explain plans, statistics).
- Debugging, tracing, and performance analysis.
- Oracle Exadata experience (preferred).
- SingleStore/MySQL exposure (plus).
- Python programming, database connection libraries, requests, json, pandas (plus).
- Oil & Gas industry domain knowledge (preferred).
**Required Education & Certifications:** Bachelor's degree in Computer Science, Information Systems, or related field. (No specific certifications required.)