Oracle Database Engineer

Role: Oracle Database Engineer

Location: Gurgaon

Experience: 6 Year+

JD is as below

Role Overview:

We are looking for a highly skilled Senior Oracle Database Resource to join our innovative team. The ideal candidate will possess significant experience in database design, development, and administration, with a strong emphasis on Oracle databases alongside familiarity with ETL tools and Snowflake. Experience in migrating databases from Oracle to PostgreSQL will be an added advantage.

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.

1. Performance Tuning & Optimisation:

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

1. Migration Expertise:

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

1. Documentation & Training:

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

1. 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.