Oracle PL/SQL Developers

Remote • Posted 1 hour ago • Updated 1 hour ago
Contract W2
Contract Independent
12 Months
No Travel Required
Remote
Depends on Experience
Company Branding Image
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • Oracle PL/SQL
  • Advanced SQL
  • Stored Procedures
  • Packages
  • Database Development
  • Data Modeling
  • SQL Analytics
  • Window Functions
  • Complex Joins
  • Query Optimization
  • Performance Tuning
  • Execution Plans
  • PGA Memory Tuning
  • Database Partitioning
  • Informatica PowerCenter
  • ETL
  • Autosys
  • Batch Jobs
  • ATDD
  • CI/CD
  • Automated Testing
  • Data APIs
  • Oracle Database
  • Snowflake
  • AWS S3
  • Cloud Technologies

Summary

Position Tittle: Oracle PL/SQL Developers
Location: Remote
Duration: Long Term
 
Job Details:
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.
 
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 91140092
  • Position Id: TISS9940
  • Posted 1 hour ago

Company Info

About Transcend IT Solutions

Our business model has scaled to successful heights on account of the long-lasting and loyal relationship with our clients, partners and candidates who have been pillar foundation of why Transcend IT Solutions is a market leader.

Our team has an outstanding track record of success in project staffing, project development and management, and consulting services. With firsthand experience in these areas, we have a sound understanding of our client’s needs.

Transcend IT Solutions provides assistance with staffing for all Information Technology roles. Providing the best-fit person of the highest caliber is our recruiting team’s goal. Our success is based on longevity of client-candidate relationships. Whether it is an individual team member or an entire team, Transcend IT Solutions will assist you with your staffing needs.

Our consulting services cover all aspects of Information Technology. Our expert consultants provide expertise in the areas of project management, requirement gathering and management, analysis and design, construction, quality control and assurance, and system deployment. As well as being individual contributors, our consultants also provide mentoring, process improvement expertise, and reviews and audits of existing projects.

About_Company_OneAbout_Company_Two
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

It looks like there aren't any Similar Jobs for this job yet.

Search all similar jobs