Senior Oracle Developer
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
Oracle PL/SQL Developer for Prometheus Group, enhancing the RiskPoynt application in EHS. Focus on database solutions and collaboration with engineering and product teams.
Responsibilities:
- Design robust stored procedures, functions, packages, triggers, and views using Oracle PL/SQL.
- Build ETL/ELT pipelines (native PL/SQL, external tools, or DBMS_* packages) to ingest, transform, and publish data.
- Implement error handling, exception management, logging, and instrumentation for traceability.
- Develop and maintain database schemas, constraints, indexes, and materialized views.
- Create reusable APIs (e.g., PL/SQL APIs, REST) to expose data services.
- Analyze query plans and tune SQL (e.g., EXPLAIN PLAN, SQL Monitor, dbms_xplan).
- Optimize data access patterns (indexes, partitioning, hints, statistics) and reduce I/O.
- Work with architects to align physical design (partitioning, tablespaces) with data growth and access patterns.
- Partner with application developers to design efficient SQL/PLSQL interfaces.
- Work with business analysts to translate requirements into robust data solutions.
- Produce documentation: Application specs, deployment guides, and runbooks.
Requirements:
- Strong knowledge on RDBMS, Enterprise Data architecture (+5 years hand-on experience with Oracle Database and PL/SQL)
- Strong knowledge of PL/SQL including functions, procedures, packages, and triggers
- Solid SQL Tuning, Trace, and Performance experience for 19g Oracle databases
- Strong knowledge of Oracle advanced querying techniques and writing high performing and optimized queries
- Ability to Document technical specifications
- Ability to troubleshoot and resolve complex issues related to the application in the form of support and defect resolution
- Ability to collaborate with stakeholders working closely with other application developers, partners, and front-line application consultants.
- Ability to support report development using various business intelligence platforms.
Benefits:
- Health insurance
- Retirement plans
- Flexible work arrangements
- Professional development
Similar Jobs
Senior Developer, Machine Identity
Senior Developer focused on access management for AI workflows at 1Password. Code, test, and maintain production software systems for new and existing product features.
Senior Manager, GRC Engineering
Senior Manager for client relationship management and compliance execution at Workstreet. Leading client engagements and developing high-performing teams in a remote-first culture.
Staff Applications Developer – Mendix
Mendix Dev Tech Lead developing and maintaining applications using Mendix platform at Dexcom. Collaborating with cross-functional teams to optimize systems and enhance user experiences.
Senior Mobile Developer
Senior Mobile Architect leading design, architecture, and delivery of mobile applications at Reply. Working fully remote from Brazil on hybrid app development projects.
Team Lead Software Development, Benefits Platform
Lead Software Engineer developing and managing a scalable Multi-Benefit platform. Seeking an experienced technical leader to drive architectural projects and build a cross-functional team.
Developer Workflow Management
Developer in Workflow Management for coeo integrating and automating workflows in IKAROS software while modeling processes and optimizing existing functionalities.
C# Developer
C# Developer responsible for developing innovative applications for coeo's web services. Work includes APIs, backend services, and optimizing database designs.
C# Developer – AI Focus
C# Developer focusing on AI to develop intelligent software solutions for data-driven processes. Collaborating closely with departments for requirements analysis and creating AI-based solutions.
Senior Product Developer
Full Stack Developer focusing on AWS product development at Gainwell. Supporting innovative technologies and solutions in health and human services.
Service Now Integration Developer – VA EHR
ServiceNow Integration Developer contributing technical expertise to large-scale health IT programs. Collaborating across teams to maintain operational continuity and support EHR integration efforts.
Developer – OutSystems
Desenvolvedor (OutSystems) na Hitss criando soluções tecnológicas e evoluindo aplicações em ambiente ágil. Participar do levantamento de requisitos e garantir a performance e escalabilidade das soluções.
Mobile Engineer
Mobile Engineer developing Android and iOS applications for a leading nearshore staff augmentation provider in Latin America. Collaborate on high-impact projects with top American companies.
Engineer / Developer – Freelance
Freelance Engineer/Developer at SPACE44 building scalable applications and cloud environments for diverse client projects. Join an expert community of engineers across various technical domains.
Flutter Developer III – Franchisee Backoffice
Flutter Developer creating high complexity mobile solutions for Grupo Boticário. Contributing to multidisciplinary teams and ensuring technical quality in digital products.
Flutter Developer – Specialist I
Flutter developer at Grupo Boticário developing mobile applications for customer management and sales. Collaborating with design and backend teams on technical solutions and improving code quality.
Mobile App Developer
Mobile App Developer building scalable iOS and Android applications for a rapidly growing AI startup. Collaborating with engineers to enhance a leading global mobile app platform.
Playable Ads Developer
Playable Ads Developer tasked with creating engaging interactive ads for Voodoo's mobile games. Collaborating with diverse teams to optimize user experience and performance.
Desenvolvedor Oracle OFS/OIC – Sênior
Develop Oracle Field Service solutions in critical operational environments, maintaining and evolving integrations and plugins. Participates in technical design, troubleshooting, and documentation processes.
Developer, XML, Data Integration
Developer working on XML-based data integrations for educational offerings at velpTEC. Focused on data structure modelling and automation for consistent information exchange.
Lead Mobile Engineer
Mobile Engineer Lead managing BeatStars’ mobile strategy while defining architecture and standards for the mobile practice. Writing production code and mentoring the mobile engineering team.