Data Engineer (Oracle/Exadata & PySpark) - Onsite Charlotte

Smart IT Frame LLC

Charlotte (NC)

On-site

USD 110,000 - 140,000

Full time

2 days ago

Be an early applicant

Application generator

Get a reply from this employer — a resume and cover letter tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Smart IT Frame LLC in Charlotte, NC is seeking an Oracle/PL SQL Developer with PySpark/Data Engineer skills. The role focuses on designing and maintaining Oracle database objects, tuning performance, and enabling data processing with Python/PySpark.

Onsite work in Charlotte, you will collaborate with cross-functional teams and utilize Exadata 19c capabilities. You will develop complex SQL/PL SQL code, optimize queries, handle indexing strategies, and manage job scheduling with AutoSys, while

Qualifications

Experience designing and optimizing Oracle database objects.
Strong PL/SQL development and SQL tuning skills.
Exposure to PySpark for data processing.
Familiarity with version control and collaboration tools.

Responsibilities

Design, develop, and maintain Oracle database objects (tables, views, indexes).
Develop complex SQL and PL/SQL programs, procedures, functions, packages, and triggers.
Perform Oracle performance tuning and query optimization.
Analyze queries with Explain Plans and optimize indexing strategies.
Work with Oracle Exadata 19c architecture and performance capabilities.
Invoke SQL*Plus from shell scripts and manage job scheduling with AutoSys.
Develop data processing solutions using Python/PySpark.
Use GitHub for source-code management and collaboration.
Troubleshoot production issues and provide root-cause analysis.