Oracle Developer

Hire Resolve’s client is looking for a a Senior Oracle Developer to join their team in Centurion, GP.  You will be responsible for designing, developing, and maintaining Oracle database solutions that align with Investments’ business goals. You will collaborate with stakeholders, project managers, and IT teams to deliver efficient, scalable, and secure database solutions, ensuring optimal data integrity, performance, and security.

Responsibilities: 

Database Design & Development

• Design and implement Oracle database solutions, including schemas, tables, indexes, and stored procedures.

• Develop and optimize complex SQL queries, PL/SQL code, and database functions to meet business requirements and performance standards.

• Ensure database design follows best practices and industry standards.

Performance Tuning & Optimization

• Analyze and optimize database performance, including query tuning, indexing, and resource management.

• Identify and resolve performance bottlenecks and scalability issues, ensuring high availability and reliability.

• Monitor and manage database health and performance using Oracle tools and utilities.

Database Maintenance & Support

• Perform routine database maintenance tasks, such as backups, restores, and upgrades.

• Provide troubleshooting and support for database-related issues.

• Implement and enforce security measures and access controls to safeguard sensitive data.

Project Management & Collaboration

• Work closely with project managers, business analysts, and IT teams to gather requirements and deliver solutions that support project goals.

• Lead and participate in database development projects, ensuring timely delivery and alignment with project specifications.

• Provide technical leadership and mentorship to junior developers and team members.

Documentation & Reporting

• Create and maintain comprehensive documentation on database designs, development processes, and system configurations.

• Prepare and present reports on database performance, project status, and development activities to senior management.

Continuous Improvement

• Stay up-to-date with Oracle database technologies, industry trends, and best practices.

• Recommend and implement database improvements to enhance performance, security, and functionality.

• Participate in post-implementation reviews to evaluate database solutions and incorporate feedback for future enhancements.

Requirements: 

• Bachelor’s degree in Computer Science, Information Technology, or a related field.

• Advanced degree or relevant certifications (e.g., Oracle Certified Professional) is a plus.

• 7+ years as an Oracle Developer, with extensive experience in designing, developing, and optimizing Oracle database solutions.

• Proven expertise with Oracle database tools and technologies (e.g., Oracle SQL, PL/SQL, Oracle Performance Tuning).

• Experience with data migration, ETL processes, and database integration.

Skills

• Advanced knowledge of Oracle database architecture, design, and development.

• Strong proficiency in SQL and PL/SQL programming with a focus on performance optimization.

• Excellent analytical and problem-solving abilities for addressing complex database challenges.

• Strong communication and interpersonal skills for effective collaboration with stakeholders and team members.

• Experience with database management and monitoring tools.