Oracle PL/SQL Developer

ApTask
Charlotte, United States of America
4 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Intermediate

Job location

Charlotte, United States of America

Tech stack

Amazon Web Services (AWS)
Azure
Big Data
Code Review
Databases
Data Integrity
ETL
Data Migration
Data Mining
Database Design
Database Development
Revision Control Systems
Oracle
Oracle Applications
Oracle Forms
Oracle SQL Developer
Performance Tuning
Scrum
Query Optimization
Release Management
Oracle APEX
Shell Script
SQL Stored Procedures
PL-SQL
SQL Databases
Enterprise Software Applications
Database Optimization
Indexer
Information Technology
Oracle Cloud Infrastructure

Job description

We are seeking an experienced Oracle PL/SQL Developer to design, develop, optimize, and maintain database solutions for enterprise applications. The ideal candidate should have strong expertise in Oracle Database, PL/SQL programming, performance tuning, and database development best practices. The role requires close collaboration with application developers, business analysts, and cross-functional teams to deliver scalable and high-performing database solutions., * Design, develop, test, and maintain Oracle PL/SQL packages, procedures, functions, triggers, and views.

  • Write efficient and optimized SQL queries for data extraction, reporting, and application support.
  • Perform database performance tuning, query optimization, and troubleshooting.
  • Develop and maintain complex stored procedures and ETL processes.
  • Work with large datasets and ensure data integrity, security, and consistency.
  • Collaborate with development and business teams to understand requirements and deliver technical solutions.
  • Support database deployment, migration, and release management activities.
  • Create and maintain technical documentation for database objects and processes.
  • Troubleshoot production issues and provide timely resolution.
  • Participate in code reviews and ensure adherence to coding standards and best practices.

Requirements

  • Bachelor's degree in Computer Science, Information Technology, or related field.
  • 4+ years of hands-on experience in Oracle PL/SQL Development.
  • Strong expertise in Oracle SQL, PL/SQL, Stored Procedures, Packages, Functions, and Triggers.
  • Experience with query optimization and performance tuning techniques.
  • Good understanding of database design, normalization, and indexing concepts.
  • Experience working with Oracle 11g/12c/19c databases.
  • Knowledge of ETL processes and data migration techniques.
  • Familiarity with UNIX/Linux commands and shell scripting is a plus.
  • Experience with version control tools and deployment processes.
  • Strong analytical, problem-solving, and communication skills.

Preferred Qualifications

  • Experience with Oracle Forms/Reports or Oracle APEX is an advantage.
  • Exposure to cloud platforms such as OCI, AWS, or Azure is preferred.
  • Knowledge of Agile/Scrum methodologies.
  • Oracle Certification is a plus.

About the company

ApTask is a leading global provider of workforce solutions and talent acquisition services, dedicated to shaping the future of work. As an African American-owned and Veteran-owned company, ApTask offers a comprehensive suite of services, including staffing and recruitment solutions, managed services, IT consulting, and project management. With a focus on excellence, collaboration, and innovation, ApTask provides unparalleled opportunities for professional growth and development. As a member of the ApTask team, you will have the chance to connect businesses with top-tier professionals, optimize workforce performance, and drive success across diverse industries. Join us at ApTask and be part of our mission to empower organizations to thrive while fostering a diverse and inclusive work environment. Applicants may be required to attend interviews in person or by video conference. In addition, candidates may be required to present their current state or government issued ID during each interview. Candidate Data Collection Disclaimer: At ApTask, we prioritize safeguarding your privacy. As part of our recruitment process, certain Personally Identifiable Information (PII) may be requested by our clients for verification and application purposes. Rest assured, we strictly adhere to confidentiality standards and comply with all relevant data protection laws. Please note that we only collect the necessary information as specified by each client and do not request sensitive details during the initial stages of recruitment.

Apply for this position