Description
You will design, develop, and optimize complex database solutions using Oracle SQL and PL/SQL.
This role is on-site.
Responsibilities
- Design and optimize complex SQL queries, stored procedures, functions, and triggers in Oracle SQL.
- Tune database performance using indexing strategies, execution plans, and optimization techniques.
- Model databases, design schemas, and ensure data normalization to support application needs.
- Implement and maintain data security, backup, and disaster recovery procedures.
- Troubleshoot database issues to maintain high availability and reliability for large-scale transactional databases.
Required Skills
- 8+ years experience as a Database Developer specializing in Oracle SQL.
- Strong proficiency in PL/SQL development (stored procedures, triggers, functions).
- Expertise in query performance tuning, indexing, and execution plans.
- Knowledge of database partitioning, materialized views, and caching techniques.
- Hands-on experience with ETL processes and data migration.
- Familiarity with Oracle Cloud or AWS RDS.
- Strong analytical and problem-solving skills.
Preferred Skills
- Experience working with large-scale transactional databases.