Database Administrator (Oracle)

We are seeking an experienced Oracle Data Warehouse Specialist to join our team. The ideal candidate will have a strong understanding of data warehousing concepts and hands-on experience with Oracle technologies. This role involves designing, implementing, and managing complex data warehouse solutions to support critical business decisions. You will also be responsible for developing and maintaining interactive BI dashboards to provide valuable insights into business performance.

Responsibilities:

• Collaborate with business analysts and data architects to understand data requirements and design efficient data warehouse solutions.
• Develop and implement ETL processes using Oracle ODI to extract, transform, and load data from various sources into the data warehouse.
• Create and maintain data warehouse models, including dimensional and star schemas.
• Monitor and optimize data warehouse performance, including query optimization, indexing, and partitioning.
• Troubleshoot and resolve data warehouse issues, ensuring data integrity and availability.
• Implement data security measures and access controls to protect sensitive information.
• Administer Oracle Database 19c (Single Instance and RAC) environments, including database installation, configuration, and patching.
• Perform database backups and recovery procedures.
• Monitor database performance and optimize database parameters.
• Develop and maintain web applications using Oracle APEX.
• Configure and deploy Oracle REST Data Services (ORDS) to expose data services.
• Manage and configure Oracle WebLogic Server (WLS) and other Oracle middleware components.
• Administer Linux servers, including user management, file system management, and security configuration.
• Design, develop, and maintain interactive BI dashboards using Oracle BI tools to provide insights into business performance.

Requirements:

• Minimum academic and professional qualifications: A degree in Computer Science, Information Technology, or a related field.
• At least 4 years of relevant experience in data warehousing and Oracle technologies.
• Strong understanding of data warehousing concepts, including dimensional modeling and ETL processes.
• Proficiency in Oracle Database 19c (Single Instance and RAC).
• Experience with Oracle ODI, Oracle APEX, ORDS, and Oracle OAS.
• Expertise in SQL and PL/SQL.
• Strong knowledge of Linux operating systems.
• Experience with BI tools for dashboard development.
• Excellent problem-solving and analytical skills.
• Strong communication and interpersonal skills.
• Database Design and Implementation
• Maintenance and Monitoring
• Security Management
• Performance Tuning
• Effective communication
• Problem-solving
• Creativity
• Analytical thinking

Benefits:

• Work from home option
• Flexible working hours
• Training courses, Professional development opportunities
• Military service project (Limited)
• Supplemental health insurance
• Team-building budget
• Performance-based bonuses
• Loans
• Lunch subsidies