Oracle PL/SQL Developer (Data Modeling, ETL, Shell Scripting)

Oracle PL/SQL Developer (Data Modeling, ETL, Shell Scripting) - Scalarinfotech

Date Posted: Aug 30, 2025

Job is expired

PL/SQL Development:
- Design, code, and maintain stored procedures, packages, triggers, and functions
- Optimize SQL queries for performance and scalability
- Conduct code reviews and enforce best practices
Data Modeling & Architecture:
- Develop logical and physical data models using tools like ERwin or Oracle Designer
- Collaborate with analysts to translate business requirements into data structures
- Implement partitioning, indexing, and archival strategies for large datasets
ETL Workflows:
- Build and maintain ETL pipelines using PL/SQL, SQL Loader, and external scripts
- Integrate data from multiple sources including APIs, flat files, and legacy systems
- Ensure data quality, transformation accuracy, and audit logging
Shell Scripting (Unix/Linux):
- Automate batch jobs, backups, and data transfers using Bash, Korn, or PowerShell
- Monitor job execution and handle exceptions or reruns
- Interface with FTP/MQFTE for secure data exchange

Category	Skills & Tools
Database	Oracle 12c/19c, PL/SQL, SQL, TOAD, SQL Developer
Data Modeling	ERwin, Oracle Designer, normalization, indexing, partitioning
ETL	SQL Loader, UTL_FILE, DBMS_SCHEDULER, external tables
Scripting	Bash, Korn Shell, PowerShell, Cron jobs
Version Control	Git, SVN
Performance Tuning	Explain Plan, AWR reports, indexing strategies
Security	Role-based access, encryption, auditing

Given your background in modular systems and animation workflows, you could:

Build automated data visualizations from PL/SQL outputs for onboarding dashboards
Create shell-scripted batch exports of job post analytics for Recruiterz.Com
Architect ETL pipelines that feed into branded explainer video metrics