Sr. Oracle Developer with Python

Kaav Inc; Charlotte (NC); Hybrid; USD 120,000 - 165,000; Full time

Job summary

Kaav Inc in Charlotte, NC seeks an experienced Oracle Developer with Python and PySpark to design, develop, optimize database solutions, and support data-processing applications.

Role involves Unix scripting, batch workflows with AutoSys, and GitHub-based development practices, with a hybrid work arrangement (3 days onsite).

Qualifications

• Advanced Oracle RDBMS expertise and SQL/PL-SQL development.
• Unix/Linux shell scripting and batch processing experience.
• Expert Python and PySpark development skills.

Responsibilities

• Design, develop, and maintain Oracle database objects and applications.
• Develop efficient and maintainable SQL and PL/SQL code.
• Develop and support Unix/KornShell scripts and batch-processing workflows (AutoSys).
• Design and implement data-processing solutions using Python and PySpark.

Skills

Oracle RDBMS

SQL

PL/SQL

Unix/KornShell

Python

PySpark

GitHub

GitHub Copilot

Education

Bachelor's degree

Tools

SQL*Plus

AutoSys

NDM / Connect:Direct

Job description

Job Title: Sr. Oracle Developer with Python

Location: Charlotte, NC – 3 days/week onsite

Position Type: Full Time

Job Description:

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:
• Different index types and their appropriate use cases
• Query optimization
• 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.