Oracle Database Engineer

Responsibilities

Database Design & Architecture :

Design, implement, and optimize Oracle database architectures to meet application and business requirements.Develop and maintain logical and physical data models, including database schemas and entity-relationship diagrams (ERDs).Collaborate with developers and stakeholders to ensure Oracle database design aligns with application needs and business goals.

SQL & PL / SQL Development :

Write, review, and optimize complex SQL queries, PL / SQL scripts, stored procedures, and triggers.Support developers by designing and reviewing efficient SQL and PL / SQL queries, ensuring optimal data access patterns.

Performance Tuning :

Proactively monitor and troubleshoot Oracle database performance issues, including query performance, indexing, partitioning, and resource contention.Implement performance tuning techniques such as query optimization, indexing strategies, materialized views, and Oracle Real Application Clusters (RAC) configurations.Analyze and optimize Oracle database settings, such as memory allocation, buffer cache, and connection pooling.

Oracle Database Administration :

Administer and maintain Oracle databases, ensuring high availability, security, and performance.Implement and manage backup, recovery, and disaster recovery strategies using Oracle RMAN and Data Guard.Plan and execute Oracle database upgrades, patching, migrations, and performance audits.Manage Oracle RAC, ASM (Automatic Storage Management), and Oracle Grid Infrastructure for clustered environments.

Data Management & Security :

Ensure data integrity, security, and compliance with company policies and industry standards.Implement database auditing, encryption, and role-based access controls (RBAC) to ensure secure data handling.

Collaboration & Support :

Collaborate with development teams to provide guidance on Oracle database design and integration.Support the implementation of ETL processes, data integration workflows, and report generation.Provide ongoing support and troubleshooting for Oracle database issues in production environments.