Sr. Oracle DBA

An Oracle Admin (Oracle Database Administrator or DBA) is responsible for installing, configuring, maintaining, and optimizing Oracle databases to ensure data security, integrity, and availability. Key duties include managing backups and disaster recovery, patching and upgrading databases, monitoring performance, and ensuring database security. They also support application developers, troubleshoot issues, and plan for database growth and resource utilization. 

Core Responsibilities

Installation & Configuration: Install, configure, and maintain Oracle database software and environments, including on-premises and cloud platforms like OCI. 

Performance Tuning: Monitor database performance, identify and resolve performance issues, and tune SQL queries and database configurations for efficiency. 

Backup & Recovery: Develop, implement, and manage backup, recovery, and disaster recovery strategies using tools like RMAN. 

Security Management: Implement and maintain database security measures, including managing user access, roles, profiles, and permissions. 

Upgrades & Patching: Plan and execute database upgrades and apply necessary patches to ensure the database remains up-to-date and secure. 

Monitoring & Maintenance: Regularly monitor database health, space utilization, and user activity, performing routine maintenance tasks. 

Troubleshooting: Diagnose and resolve database-related issues to ensure continuous and seamless operation. 

Capacity Planning: Monitor and plan for future storage needs, ensuring adequate resources for database growth and performance. 

Collaboration: Work with application developers and other teams to provide support, design database schemas, and integrate databases into applications. 

Documentation & Reporting: Create and publish database health check reports, document processes, and develop scripts to automate tasks. 

Key Skills & Knowledge 

Expertise in Oracle Database architecture and management tools (e.g., RMAN, Data Guard).

Strong understanding of database concepts, data modeling, and normalization.

Experience with database security best practices and compliance requirements.

Familiarity with operating systems, particularly Linux/Unix.

Skills in performance monitoring, tuning, and troubleshooting.

Ability to plan and execute database upgrades and migrations.

Problem-solving skills and an algorithmic approach to complex issues.

Familiarity with cloud platforms and cloud-based database services.