Description

You will manage and maintain Oracle database environments for the Apriso MES project.

Responsibilities

• Design database packages and procedures.
• Provide support to the development team on design, development, archiving, and purging.
• Review and tune SQL and PL/SQL code.
• Write ad-hoc queries based on schema knowledge.
• Monitor, report on, and tune Oracle databases, ensuring data warehouse scalability.

Required Skills

• 5+ years of experience in DBA activities for MES projects.
• In-depth knowledge of Oracle 12c/19c.
• Expertise in PL/SQL from both DBA and Programmer perspectives, including performance tuning.
• Proficiency in SQL for query creation and maintenance.
• Experience with job scheduling and monitoring tools.
• Ability to handle complex data models and object-relational database mapping.
• Experience with database performance monitoring and tuning.
• Strong verbal and written communication skills in English.

Key Skills

Education

Any Graduate