Senior Oracle/SQL Developer & Data Engineer (PySpark)
Kaav Inc
Turn this role into an interview — a resume and cover letter built around what this employer wants.
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
Education
Tools
Job description
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
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
