Senior Oracle Developer

Description:

We are seeking an experienced Oracle Developer to join our team. The ideal candidate will have a strong background in Oracle database development, including PL/SQL programming, performance tuning, and database design. This role involves working closely with business analysts and other IT professionals to design, implement, and maintain robust and scalable database solutions that support our business needs.

Key Responsibilities:

• Database Development:

• Design, develop, and maintain Oracle database applications using PL/SQL.
• Write complex SQL queries, stored procedures, functions, and triggers.
• Optimize and tune SQL queries for performance.

• Database Management:

• Assist in database design and architecture to ensure scalability and reliability.
• Implement and maintain data models and database designs.
• Ensure data integrity and security.

• Application Support:

• Troubleshoot and resolve database-related issues.
• Provide support for production, test, and development database environments.
• Collaborate with application developers to ensure database designs meet application requirements.

• Performance Tuning:

• Analyze and optimize database performance, including query tuning and indexing.
• Monitor and manage database performance, capacity, and security.

• Documentation and Reporting:

• Create and maintain comprehensive documentation for database designs, schemas, and code.
• Generate reports and data extracts as required by business units.

Qualifications:

• Education: Bachelor’s degree in Computer Science, Information Technology, or a related field.
• Experience:
• Minimum of 3 years of experience as an Oracle Developer.
• Proven experience with Oracle database technologies (Oracle 11g, 12c, 19c).
• Experience in database design, development, and performance tuning.
• Technical Skills:
• Proficient in PL/SQL, SQL, and Oracle database tools.
• Knowledge of Oracle database architecture and concepts.
• Experience with Oracle Application Express (APEX) is a plus.
• Familiarity with Unix/Linux shell scripting.
• Soft Skills:
• Strong problem-solving and analytical skills.
• Excellent communication and teamwork skills.
• Ability to work independently and manage multiple tasks.