Sr Oracle/SQL Developer

Kaav Inc; Charlotte (NC); On-site; USD 110,000 - 170,000; Full time

Job summary

Kaav Inc in Charlotte, NC seeks an experienced Oracle/SQL Developer to design, develop, and optimize Oracle database objects and batch processes. You will write high-performance SQL/PL-SQL, craft Unix/KornShell scripts, and implement data pipelines with Python and PySpark, while coordinating with engineers and analysts across the data platform.

The role emphasizes modern development practices, including GitHub-based source control and using GitHub Copilot to accelerate delivery, with onsite work

Qualifications

• Advanced experience with Oracle RDBMS and SQL/PL/SQL development.
• Experience with Unix/Linux and KornShell scripting.
• Expert-level Python and PySpark programming for data processing.

Responsibilities

• Design, develop, and maintain Oracle database objects including tables, views, indexes, partitions, procedures, functions, packages, and triggers.
• Develop efficient SQL/PL-SQL code and optimize performance using execution plans and indexes.
• Develop Unix/KornShell scripts and manage SQL*Plus sessions from shell scripts.
• Build and maintain batch-processing workflows with AutoSys.
• Design data-processing solutions using Python and PySpark for ingestion, transformation, validation, and reconciliation.
• Collaborate with engineers, analysts, and infrastructure teams; maintain documentation and support procedures.

Skills

Oracle RDBMS

SQL

PL/SQL

Unix scripting

Python

PySpark

GitHub

GitHub Copilot

KornShell

Education

Bachelor’s degree in Computer Science, Information Systems, Engineering, or related discipline

Tools

AutoSys

NDM / Connect: Direct

Job description

Location: Charlotte, NC – 3 days/week onsite

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
• Appropriate indexing strategies
• Query optimization techniques
• 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.
• 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.