Job Summary: We are seeking an experienced Senior Oracle Developer to join our dynamic team. As a Senior Oracle Developer, you will be responsible for designing, developing, and maintaining Oracle database systems and applications. You will play a key role in analyzing business requirements, implementing efficient data models, and optimizing database performance. The ideal candidate should have a strong background in Oracle technologies, excellent programming skills, and a solid understanding of database design principles.
Responsibilities:
- Collaborate with business analysts, system architects, and other stakeholders to understand business requirements and translate them into technical specifications.
- Design and develop Oracle database systems and applications, ensuring high quality, performance, and scalability.
- Create and maintain database schemas, tables, indexes, and other database objects.
- Write efficient SQL queries, stored procedures, and triggers to support data retrieval, manipulation, and reporting requirements.
- Optimize database performance by analyzing query execution plans, indexing strategies, and database configuration settings.
- Conduct thorough testing and debugging of database applications to ensure accuracy, reliability, and data integrity.
- Perform database tuning and optimization activities to improve system response time and throughput.
- Collaborate with the development team to integrate Oracle database solutions with other applications and systems.
- Provide technical guidance and mentorship to junior developers, assisting them in resolving complex technical issues.
- Stay updated with the latest Oracle technologies, industry trends, and best practices to continuously improve the development process.
Requirements:
- Bachelor's degree in Computer Science, Information Systems, or a related field.
- Proven experience as an Oracle Developer, with a focus on database design, development, and optimization.
- Strong proficiency in Oracle PL/SQL programming language.
- Extensive knowledge of Oracle database concepts, such as data modeling, indexing, partitioning, and performance tuning.
- Experience with Oracle database administration tasks, including backup and recovery, user management, and security.
- Proficiency in SQL and understanding of relational database principles.
- Familiarity with Oracle development tools, such as SQL Developer, Oracle Forms, and Oracle Reports.
- Experience with Oracle Application Express (APEX) is a plus.
- Strong analytical and problem-solving skills, with the ability to diagnose and resolve complex database issues.
- Excellent communication and teamwork skills, with the ability to collaborate effectively with cross-functional teams.
- Proactive and self-motivated, with the ability to work independently and manage multiple projects simultaneously.
- Strong attention to detail and commitment to delivering high-quality solutions within agreed timelines.