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.