Introduction:
We are seeking a highly skilled and experienced Senior Oracle Developer to join our team. The successful candidate will be responsible for designing, developing, and maintaining Oracle database solutions that support business objectives. This role involves working closely with stakeholders, project managers, and IT teams to ensure efficient, scalable, and secure database solutions.
Core Skills: Oracle SQL, PL/SQL, performance tuning, database architecture, and security.
Key Responsibilities: Database design, performance optimization, maintenance, collaboration, and documentation
Responsibilities and Work Outputs:
Database Design and 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.
- Ensure database design aligns with best practices and industry standards.
Performance Tuning and Optimization:
- Analyze and optimize database performance, including query tuning, indexing, and resource management.
- Identify and resolve performance bottlenecks and scalability issues.
- Monitor and manage database health using Oracle tools and utilities.
Database Maintenance and Support:
- Perform routine database maintenance tasks such as backups, restores, and upgrades.
- Troubleshoot and resolve database-related issues.
- Implement and enforce security measures and access controls.
Project Management and Collaboration:
- Work with project managers, business analysts, and IT teams to gather requirements and deliver database solutions.
- Lead and participate in database development projects, ensuring timely delivery.
- Provide mentorship to junior developers and team members.
Documentation and Reporting:
- Maintain comprehensive documentation for database designs, development processes, and system configurations.
- Prepare reports on database performance and project status for senior management.
Continuous Improvement:
- Stay up to date with Oracle database technologies and industry trends.
- Recommend and implement improvements for performance, security, and functionality.
- Participate in post-implementation reviews for future enhancements.
Qualifications, Knowledge & Experience:
- Education: Bachelor’s degree in Computer Science, IT, or a related field. Oracle certifications are a plus.
- Experience: 7+ years of experience in Oracle database development.
- Skills:
- Advanced knowledge of Oracle database architecture and development.
- Strong proficiency in SQL and PL/SQL programming.
- Experience with data migration, ETL processes, and database integration.
- Strong problem-solving skills and analytical thinking.
- Effective communication and collaboration abilities.
Desired Skills:
- Oracle Web Developer
- Senior Oracle Web Developer
- Oracle Database Solutions