Oracle SQL Developer, Charlotte, NC (Hybrid- 3 days Onsite)

MetaRPO; Town of Charlotte (NY); On-site; USD 120,000 - 180,000; Full time

Job summary

MetaRPO in New York seeks an experienced Oracle/SQL Developer to design, develop, and optimize Oracle databases, SQL/PLSQL, and Unix scripting. The role includes partitioning, performance tuning, and batch processing using AutoSys and NDM/Connect:Direct.

You will implement data-processing pipelines with Python and PySpark, automate data ingestion and validation, and collaborate with developers, analysts, and infrastructure teams using GitHub and CI/CD practices.

Qualifications

• Advanced experience with Oracle RDBMS.
• Strength in SQL and PL/SQL development.
• Experience creating and managing Oracle database objects (tables, views, indexes, partitions, procedures, functions, packages, triggers).
• Strong understanding of partitioning, index types, and query optimization.
• Unix/Linux and KornShell scripting proficiency (sed, awk, grep, SQL*Plus).
• AutoSys job scheduling and workflow management experience.
• NDM / Connect:Direct file transfers experience.
• Python and PySpark for data processing and performance optimization.
• GitHub for source control and code collaboration; familiarity with Copilot.

Responsibilities

• Design, develop, and maintain Oracle database objects and applications.
• Develop and optimize SQL/PLSQL code and analyze execution plans for performance.
• Support partitioning strategies and batch-processing workflows (AutoSys).
• Develop Unix/KornShell scripts and SQL*Plus interactions in shell environments.
• Design data-processing solutions using Python/PySpark; automate ingestion, transformation, and validation.
• Collaborate with developers, data engineers, analysts, and infrastructure teams.
• Prepare technical documentation and implementation plans.

Skills

Oracle RDBMS

SQL/PLSQL

Unix scripting

KornShell

Python

PySpark

GitHub

GitHub Copilot

Data engineering

Performance tuning

Education

Bachelor's degree in Computer Science / Information Systems / Engineering

Tools

AutoSys

NDM/Connect:Direct

GitHub Copilot

Job description

Overview:

We are seeking an experienced Oracle / SQL Developer with strong expertise in Oracle database development, SQL, PL/SQL, Unix scripting, batch processing, and data engineering. The ideal candidate will have advanced knowledge of Oracle database architecture and performance optimization, along with expert-level experience in Python and PySpark.

This role will contribute to the design, development, optimization, and support of database solutions and data-processing applications. The successful candidate will also use modern development practices, including GitHub-based source control and GitHub Copilot to improve development efficiency.

Key Responsibilities

• Design, develop, and maintain Oracle database objects and applications.

• Create and manage:

  • Tables
  • Views
  • Indexes
  • Partitioned tables and indexes
  • Stored procedures, functions, and packages

• Develop efficient and maintainable SQL and PL/SQL code.

• Analyze and improve SQL performance using:

  • Execution plans
  • Oracle optimizer behavior
  • Appropriate indexing strategies
  • Query optimization techniques
  • Optimizer hints

• Support database partitioning strategies and understand different partitioning methods.

• Develop and maintain Unix/KornShell scripts using utilities such as:

  • sed
  • awk
  • grep
  • SQL*Plus

• Invoke and manage SQL*Plus sessions from shell scripts.

• Develop and support batch-processing workflows using AutoSys.

• Manage enterprise file transfers using NDM / Connect:Direct.

• Design and implement data-processing solutions using Python and PySpark.

• Automate data ingestion, transformation, validation, and reconciliation processes.

• Use GitHub as a source-code repository and follow branching, pull request, and code-review practices.

• Use GitHub Copilot responsibly to accelerate development, improve productivity, and assist with code generation, refactoring, and troubleshooting.

• Troubleshoot production issues, perform root-cause analysis, and provide timely technical support.

• Collaborate with application developers, data engineers, business analysts, and infrastructure teams.

• Prepare technical documentation, support procedures, and implementation plans.

Required Qualifications and Skills

• Advanced experience with Oracle RDBMS.

• Strong hands-on experience with SQL and PL/SQL development.

• Experience creating and managing Oracle database objects, including:

  • Tables
  • Views
  • Indexes
  • Partitioned objects
  • Procedures
  • Functions
  • Packages
  • Triggers

• Strong understanding of:

  • Table partitioning
  • Different index types and their appropriate use cases
  • Query optimization
  • Optimizer hints
  • Execution plans and plan analysis
  • ANSI SQL standards
  • Dynamic SQL using EXECUTE IMMEDIATE
  • Autonomous transactions

• Advanced experience with Unix/Linux and KornShell scripting.

• Proficiency with sed, awk, grep, file handling, process control, and SQL*Plus shell execution.

• Experience with AutoSys job scheduling and workflow management.

• Experience with NDM / Connect:Direct file transfers.

• Expert-level proficiency in Python.

• Expert-level proficiency in PySpark, including distributed data processing and performance optimization.

• Experience using GitHub for source control and code collaboration.

• Familiarity with GitHub Copilot and AI-assisted software development tools.

• Strong analytical, troubleshooting, communication, and documentation skills.

Preferred Qualifications

• Experience developing large-scale batch-processing or data-engineering solutions.
• Experience working with high-volume Oracle databases and performance-sensitive applications.
• Knowledge of ETL/ELT development and data-quality processes.
• Experience with CI/CD pipelines and automated testing.
• Familiarity with cloud data platforms and distributed computing environments.
• Experience establishing coding standards, reusable frameworks, and development best practices.
• Bachelor s degree in Computer Science, Information Systems, Engineering, or a related discipline, or equivalent professional experience.