Oracle/SQL Developer with Python & PySpark

Synechron; Charlotte (NC); On-site; USD 90,000 - 100,000; Full time

Benefits offered by this job

Competitive compensation

Global offices

Paid leave

Maternity & paternity leave

Medical, dental, vision insurance

Retirement savings plans

Udemy for Business

Training opportunities

Job summary

Synechron in Charlotte, NC is seeking an experienced Oracle/SQL Developer to design, develop, and optimize database objects and data integration pipelines.

You will work across Unix scripting, batch processing, Python, PySpark, and AutoSys, collaborating with global clients to deliver high-performance data solutions.

Applicants should have strong SQL/PL/SQL skills, expertise in partitioning and performance tuning, and comfort with GitHub workflows.

Qualifications

• Advanced Oracle RDBMS development experience.
• Strong SQL, PL/SQL, and ANSI SQL knowledge.
• Understanding of partitioning, indexing, and query optimization.
• Experience with dynamic SQL, EXECUTE IMMEDIATE, and autonomous transactions.
• Experience with SQL*Plus, NDM/Connect:Direct, and AutoSys.
• Expert-level Python and PySpark experience.
• Experience integrating Python/PySpark with Oracle and workflows.
• Familiarity with GitHub Copilot and AI-assisted development practices.
• Strong analytical, troubleshooting, communication, and documentation skills.

Responsibilities

• Design, develop, and maintain Oracle database objects including partitions.
• Develop and optimize SQL and PL/SQL applications.
• Analyze execution plans and improve performance through indexing and hints.
• Handle dynamic SQL, EXECUTE IMMEDIATE, and autonomous transactions.
• Develop KornShell scripts and Unix tooling for automation.
• Create scripts invoking SQL*Plus for processing and automation.
• Develop and support NDM/Connect:Direct file transfers.
• Create and maintain AutoSys jobs and workflows.
• Develop Python and PySpark solutions for data processing and validation.
• Use GitHub for source control and code reviews.
• Collaborate across design, development, testing, deployment, and support.

Skills

Oracle RDBMS

SQL/PLSQL

Dynamic SQL

Python

PySpark

Partitioning

Performance tuning

GitHub Copilot

Problem solving

Documentation

Tools

SQL*Plus

NDM/Connect:Direct

AutoSys

GitHub

Job description

Synechron in Charlotte, NC is seeking an experienced Oracle/SQL Developer to design, develop, and optimize database objects and data integration pipelines.

You will work across Unix scripting, batch processing, Python, PySpark, and AutoSys, collaborating with global clients to deliver high-performance data solutions.

Applicants should have strong SQL/PL/SQL skills, expertise in partitioning and performance tuning, and comfort with GitHub workflows.