Sign upLog in
See more jobs

Oracle PL/SQL Developers - 6 OPENINGS

Akt LLC
  • NY
  • Remote
  • $55 Per Hour
11 days ago

Job Description

Fidelity Investments

Location: REMOTE

Rate: $55/hr C2C

Visa: OPT or STEM --- MUST SUBMIT I-797 or I-20 upon submission

Must-Have Skills:

  • Core Oracle PL/SQL Engineering: Development of complex stored procedures, packages, database business logic, custom data types, and transactional data modeling.

Advanced SQL Analytics & Data Manipulation: Analytical and windowing functions, complex joins, aggregation pipelines, set operators, and subquery optimization.

Database Performance Tuning: Query optimization, reading execution plans, database diagnostics, PGA memory tuning, and partitioning strategies.

ETL, Batch & DevOps Integration: Informatica PowerCenter mapping development, Autosys batch job scheduling/recovery, and database ATDD automation with CI/CD deployment pipelines.

Job Responsibilities

  • Expertise writing Oracle SQL and PLSQL code, performing data analysis, data modelling, designing and implementation of data APIs and performance tuning.
  • Expertise writing and maintaining batch jobs with technologies like ETL/Informatica and Autosys
  • Understanding of fundamental design principles for building a scalable application
  • Experience following ATDD (acceptance test driven development) and writing automated tests for database code.
  • Experience with cloud technologies is a bonus: Snowflake, S3
  • Interest in writing clean, testable, readable, easily maintainable, and performant code.

Numbers & Facts

LocationNY (
Remote
)

Skills

  • Acceptance Testingunmatched
  • Amazon Simple Storage Service (S3)unmatched
  • Application Programming Interface (API)unmatched
  • Automationunmatched
  • CA Workload Automation AE (AutoSys Edition)unmatched
  • Cloud Computingunmatched
  • Continuous Deployment/Deliveryunmatched
  • Continuous Integrationunmatched
  • Data Analysisunmatched
  • Data Modelingunmatched
  • Database Extract Transform and Load (ETL)unmatched
  • Database Recoveryunmatched
  • DevOpsunmatched
  • Informaticaunmatched
  • Memory Hardwareunmatched
  • Oracle Databaseunmatched
  • Oracle PL-SQLunmatched
  • Performance Tuning/Optimizationunmatched
  • Procedure Developmentunmatched
  • Query Optimizationunmatched
  • SQL (Structured Query Language)unmatched
  • Scalable System Developmentunmatched
  • Stored Proceduresunmatched
  • Test Automationunmatched
  • Test Driven Development (TDD)unmatched
  • Test Plan/Scheduleunmatched

Be found by employers

5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Free resume builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Free resume builder