Title Oracle SQL/PLSQL Developer
Location- Onsite @ Alpharetta, GA or Berkeley Heights, NJ
Duration Contract
Oracle SQL/PLSQL Developer
Onsite @ Alpharetta, GA or Berkeley Heights, NJ
Contract
We are seeking a highly skilled Oracle SQL/PLSQL Developer to design, develop, and manage highperformance relational database solutions. You will be responsible for creating robust data models, writing advanced serverside programmatic logic, and aggressively tuning complex queries to ensure maximum data throughput and application stability.
Key Responsibilities
- Design, write, and maintain robust, highperformance database objects such as stored procedures, packages, functions, and database triggers.
- Code complex business rules directly into the Oracle database layer using PL/SQL for security and processing speed.
- Diagnose, troubleshoot, and optimize sluggish SQL statements using available tools.
- Design efficient relational database architectures including schemas, tables, primary/foreign key relationships, and indexes.
- Build, manage, and scale Extract, Transform, Load (ETL) data integration workflows to ingest external application data.
- Interface with backend application developers (e.g., Java engineering teams) to align frontend APIs with datatier structures.
- Author deployment scripts, execute data migration runs, and maintain comprehensive schema version control.
Core Technical Requirements
- Oracle Database Expertise: Proficient experience with recent versions (e.g., Oracle 19c or 21c).
- Advanced PL/SQL Mastery: Proven capability utilizing collections, bulk operations, analytical functions, and ref cursors.
- Tuning Methodologies: Handson experience partitioning tables, managing optimizer statistics, and modifying query execution paths.
- IDE Tools: High familiarity with Oracle SQL Developer, Toad, or PL/SQL Developer.
- Scripting Language: High familiarity and experience with UNIX scripting.
Preferred / NicetoHave Skills
- Cloud Environments: Experience managing or mapping databases on cloud infrastructures like AWS (Amazon RDS/S3) or Oracle Cloud Infrastructure (OCI).
- Complementary Languages: Basic competency with Python or core Java.
- CI/CD Paradigms: Understanding of DevOps data practices such as database versioning and automated deployment pipelines.
