Description

Design, optimize, and maintain database objects and processes within an Oracle environment. You will ensure data integrity and high performance through rigorous testing and architectural best practices.

Responsibilities

• Develop and maintain stored procedures, functions, packages, triggers, views, and materialized views.
• Optimize query performance using indexing, partitioning strategies, and bulk operations.
• Analyze AWR and ADDM reports to troubleshoot and resolve database performance issues.
• Execute integration, user acceptance, and performance testing to validate functionality.
• Manage data quality by identifying and resolving root causes within database design.

Required Skills

• 5+ years of experience with relational database concepts and SQL analytical skills.
• Expertise in PL/SQL, including advanced bulk operations and SQL Loader.
• Strong understanding of data modeling and data architecture.
• Proven ability to perform performance optimization and database design.
• Experience using Jira and Bitbucket for workflow management.
• Exposure to DevOps CI/CD pipelines and RLM processes.
• Oracle Database PL/SQL Developer Certified Professional designation.

Key Skills

Education

ANY GRADUATE