Oracle Database Developer


Code Beacons Inc
Dice Job Match Score™
🔢 Crunching numbers...
Job Details
Skills
- Oracle Database 11g
- Oracle 12c
- Oracle 19c
- Oracle SQL
- PL/SQL
- Stored Procedures
- Functions
- Packages
- Triggers
- Views
- Tables
- Indexes
- Sequences
- SQL Query Optimization
- Performance Tuning
- Execution Plan Analysis
- Data Modeling
- Database Design
- Database Schema
- ETL
- Data Migration
- Data Transformation
- Oracle Data Pump
- SQL Loader
- RMAN
- Oracle RAC
- ASM
- Data Guard
- Database Replication
- Oracle APEX
- Oracle Cloud Infrastructure (OCI)
- Git
- Database Security
- Production Support
- Troubleshooting
- Agile/Scrum
- AWS
- Azure
- OCP Certification.
Summary
We are seeking an experienced Senior Oracle Database Developer to design, develop, optimize, and maintain Oracle database solutions supporting mission-critical business applications. The ideal candidate should possess strong expertise in Oracle SQL, PL/SQL development, database performance tuning, data modeling, and ETL processes. The candidate will work closely with application developers, business analysts, and database administrators to deliver scalable and high-performing database solutions.
The Role
Responsibilities:
- Design, develop, and maintain Oracle database objects including tables, views, indexes, sequences, packages, procedures, functions, and triggers.
- Develop complex SQL queries and PL/SQL programs to support business requirements.
- Perform database performance tuning and query optimization.
- Analyze and troubleshoot production database issues.
- Develop and maintain ETL processes for data migration and transformation.
- Create and maintain data models, database schemas, and documentation.
- Ensure database security, integrity, and compliance with organizational standards.
- Support application development teams in database design and integration activities.
- Participate in code reviews and implement best practices for database development.
- Collaborate with cross-functional teams for requirement gathering and technical solutions.
- Assist in database deployments, upgrades, and release management activities.
Requirements:
- Strong experience with Oracle Database (11g/12c/19c or higher).
- Expertise in SQL, PL/SQL, Stored Procedures, Functions, Triggers, Packages, and Views.
- Experience with performance tuning, query optimization, and execution plan analysis.
- Strong knowledge of data modeling and database design principles.
- Experience with ETL tools and data integration processes.
- Familiarity with Oracle Data Pump, SQL Loader, RMAN, and database utilities.
- Experience with version control systems such as Git.
- Strong troubleshooting and analytical skills.
- Excellent communication and collaboration abilities.
Preferred, but not required:
- Experience with Oracle RAC, ASM, Data Guard, and database replication.
- Knowledge of Oracle APEX and Oracle Cloud Infrastructure (OCI).
- Experience in Agile/Scrum development environments.
- Oracle Certifications such as Oracle Certified Professional (OCP) are preferred.
- Exposure to cloud platforms including AWS, Azure, or OCI.
- Dice Id: 91174554
- Position Id: 9144288
- Posted 1 day ago
Company Info
About Code Beacons Inc
Pioneering the Future of AI Innovation
At Code Beacons, we're dedicated to making artificial intelligence accessible and impactful for businesses worldwide.
Empowering Innovation Through AI Excellence
Code Beacons has been at the forefront of AI innovation, helping businesses leverage artificial intelligence to solve complex challenges and drive growth. Our mission is to make advanced AI technology accessible to organizations of all sizes.
