Oracle Developer

PROPERTY MASTER OF MICHIGAN INC
United States
15 days ago
Apply on www.dice.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
5 years minimum
Working hours
Regular working hours
Job source

Tech stack

Amazon Web Services Microsoft Azure Code Review Databases Continuous Integration Information Engineering Extract Transform Load (ETL) Data Migration Database Design Database Development Database Schema Database Security
+24 more
Oracle Data Guard Oracle Exadata Identity and Access Management Python (Programming Language) Oracle Databases Oracle (Applications) Oracle Forms Oracle Rac Oracle SQL Developer Performance Tuning Scrum Methodology Query Optimization Oracle Apex Shell Script SQL Stored Procedures PL-SQL SQL Databases Scripting Freeform SQL Software Troubleshooting Database Performance Git Database Backup Oracle Cloud Infrastructure

Job description

We are looking for an experienced Oracle Developer with 5+ years of professional experience to design, develop, optimize, and maintain Oracle database solutions. The ideal candidate should have strong hands-on experience with Oracle Database, SQL, PL/SQL, stored procedures, performance tuning, ETL, and database development., * Design, develop, and maintain Oracle database applications.

  • Develop complex SQL queries and PL/SQL programs.
  • Create and maintain stored procedures, functions, packages, triggers, and views.
  • Optimize SQL queries and database performance.
  • Analyze and resolve database performance and production issues.
  • Develop database solutions based on business and technical requirements.
  • Perform data migration, transformation, and integration activities.
  • Design and maintain database schemas, tables, indexes, and constraints.
  • Collaborate with Application Developers, Business Analysts, QA, and Data Engineering teams.
  • Support database deployments and release activities.
  • Implement database backup, recovery, security, and access-control practices where required.
  • Create technical documentation and database development standards.
  • Participate in code reviews and Agile/Scrum ceremonies.
  • Troubleshoot production issues and provide root-cause analysis.

Visa & Submission Details

All Visa Types Accepted for W2, subject to client requirements and valid U.S. work authorization.

Requirements

  • 5+ years of professional experience in Oracle Database Development
  • Strong expertise in Oracle SQL and PL/SQL
  • Experience developing Stored Procedures, Functions, Packages, and Triggers
  • Strong knowledge of Oracle Database architecture and concepts
  • Experience with SQL query optimization and performance tuning
  • Experience with database design, normalization, and data modeling
  • Strong experience with complex SQL queries
  • Experience with views, indexes, sequences, and database objects
  • Experience with Oracle 12c/19c/21c or later
  • Experience with data migration and integration
  • Strong troubleshooting and analytical skills
  • Experience working in Agile/Scrum environments

Preferred Skills

  • Oracle RAC
  • Oracle Data Guard
  • Oracle GoldenGate
  • Oracle Exadata
  • Oracle APEX
  • Oracle Cloud Infrastructure (OCI)
  • Oracle Forms / Reports
  • ETL tools such as Informatica
  • Unix/Linux scripting
  • Python / Shell scripting
  • Performance tuning and query optimization
  • AWS / Azure cloud database services
  • Database security and access management
  • CI/CD and Git

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.dice.com
Prepare application

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

3:04 min

Database evolution and the funding behind vector databases

Erik Bamberg · LIVE

6:21 min

Investigating push inefficiencies with upstream Git experts

Jonathan Creamer · Coffee With Developers

1:06 min

Developer experience and project variety at scale

Alexandra Petri · World Congress 2023

4:01 min

Managing application isolation via pluggable database models

Wei Hu Wei Hu · World Congress 2022

56 sec

Favorite git commands and the importance of patch commits

Eileen Uchitelle Eileen Uchitelle +1 · Coffee With Developers

3:36 min

Critical infrastructure and performance skills for modern developers

Andrew Holway · LIVE

Videos

See all

Related articles

See all