Oracle Database Resource

Role & responsibilities

Key Responsibilities:

1. Database Design & Development:

• Design, implement, and maintain robust Oracle database solutions.
• Develop and manage ETL processes to ensure data accuracy and quality.
• Collaborate with business stakeholders to gather requirements and develop scalable database solutions.

2. Performance Tuning & Optimisation:

• Monitor and enhance database performance and efficiency.
• Implement industry best practices for database management and security compliance.

3. Migration Expertise:

• Lead projects on database migration from Oracle to PostgreSQL.
• Assist in establishing strategies and methodologies for successful database transitions.

4. Documentation & Training:

• Produce and maintain comprehensive documentation for database architecture, processes, and procedures.
• Provide training and support to team members and end-users.

5. Quality Assurance:

• Ensure adherence to data governance and regulatory compliance.
• Conduct regular database backups and develop disaster recovery plans.

Required Qualifications:

• Extensive experience with Oracle Database (specific version if necessary).
• Proficient in ETL tools (e.g., Informatica, Talend, Apache NiFi).
• Solid understanding of Snowflake and its integration with existing systems.
• Proven experience in designing and implementing complex database solutions.
• Familiarity with database migration processes, especially from Oracle to PostgreSQL.

Desired Skills:

• Strong analytical and problem-solving abilities.
• Excellent verbal and written communication skills.
• Ability to work collaboratively in a team environment and mentor junior members.

Preferred candidate profile