Back
BlackStone eIT
Senior Oracle DB Developer
Location:
Dubai, United Arab Emirates
Department: Information Technology
Job Description
- Develop and Maintain PL/SQL Code: Write efficient and maintainable PL/SQL code to support application requirements, including stored procedures, functions, packages, and triggers.
- Database Design and Optimization: Design and optimize database schema, indexes, and other database objects to ensure high performance and scalability.
- Data Integration: Develop and maintain ETL processes to integrate data from various sources into the Oracle database.
- Performance Tuning: Monitor and tune database performance, troubleshoot performance issues, and implement solutions to optimize query execution.
- Collaborate with Development Teams: Work closely with application developers, business analysts, and other stakeholders to understand requirements and deliver solutions that meet business needs.
- Documentation: Create and maintain technical documentation, including design specifications, user guides, and operational procedures.
- Testing and Quality Assurance: Develop and execute unit tests, and support system and user acceptance testing to ensure the quality and functionality of delivered solutions.
- Support and Maintenance: Provide ongoing support and maintenance for existing PL/SQL code and database systems, including troubleshooting and resolving issues as they arise
Requirements
- Education: Bachelor’s degree in Computer Science, Information Technology, or a related field.
- Experience: Minimum of 5 years of experience in Oracle PL/SQL development.
Technical Skills:
- Proficiency in PL/SQL programming and SQL.
- Experience with Oracle database versions (e.g., Oracle 12c, 19c).
- Strong understanding of database concepts, normalization, and data modeling
- Experience with performance tuning and query optimization.
- Familiarity with ETL processes and tools.
- Knowledge of Oracle tools and utilities (e.g., SQL*Plus, Oracle SQL Developer, PLSQL Developer).
- Working Knowledge of NoSQL ( Mongo DB ) will be advantageous
Soft Skills: - Excellent problem-solving and analytical skills.
- Strong communication and collaboration skills.
- Ability to work independently and as part of a team.
- Attention to detail and commitment to delivering high-quality solutions.
Benefits
- Paid Time Off
- Training & Development
- Performance Bonus
BlackStone eIT
Senior Oracle DB Developer