Job Role: Oracle SQL Developer
Location: Charlotte, NC (Hybrid- 3 days Onsite)
Duration: Long Term
W2 Position!
Final round F2F Interview!
OPTs with genuine experience are accepted!
Overview:
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
- Oracle optimizer behavior
- Appropriate indexing strategies
- Query optimization techniques
- Optimizer hints
- Support database partitioning strategies and understand different partitioning methods.
- Develop and maintain Unix/KornShell scripts using utilities such as:
- Invoke and manage SQL*Plus sessions from shell scripts.
- Develop and support batch-processing workflows using AutoSys.
- Manage enterprise file transfers using NDM / Connect:Direct.
- 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.
Never miss an opportunity! Create an alert based on the job you applied for.
