The Role
The Oracle DBA manages database software and environments, ensuring performance, security, and recovery. Responsibilities include installation, configuration, performance tuning, and automation using Python scripting.
Summary Generated by Built In
Oracle DBA responsibilities:
Database management and maintenance
- Install, configure, patch, and upgrade Oracle database software and related products.
- Manage the database throughout its lifecycle, from development to production.
- Design and implement database schemas and storage structures, including tables, views, and indexes.
- Create and maintain stored procedures, functions, and triggers using PL/SQL.
- Manage and troubleshoot complex Oracle GoldenGate replication environments.
- Automate routine database tasks using Python scripting.
- Configure and maintain high-availability solutions like Oracle Real Application Clusters (RAC) and Data Guard.
Performance and monitoring
- Monitor database health, performance, and resource utilization using tools like Oracle Enterprise Manager (OEM).
- Perform performance tuning and optimization to resolve bottlenecks and ensure fast query responses.
- Use diagnostic tools like AWR (Automatic Workload Repository) to analyze performance.
- Troubleshoot and debug database issues, providing timely resolution.
Security and access control
- Implement and enforce security policies, procedures, and standards.
- Manage database user accounts, roles, privileges, and security protocols.
- Ensure compliance with internal and external regulations.
- Conduct regular security audits and monitoring.
Backup and recovery
- Develop and implement backup and recovery strategies to ensure data integrity and availability.
- Use Oracle Recovery Manager (RMAN) for backups and restores.
- Perform regular testing of recovery plans.
Required qualifications and skills
Experience
- Prior experience as an Oracle DBA, with relevant experience managing complex Oracle databases.
- Proven experience with Oracle Application Express (APEX) development.
- Hands-on experience with Oracle GoldenGate installation, configuration, and troubleshooting.
- Experience with Python scripting for database automation and management.
- Strong knowledge of Oracle database architecture, administration, and internals.
Technical skills
- Proficiency in SQL and PL/SQL.
- Strong command of Linux/UNIX operating systems.
- Experience with high-availability solutions such as Oracle RAC and Data Guard.
- Knowledge of performance tuning and monitoring tools (e.g., OEM, AWR)
Top Skills
Awr
Data Guard
Linux/Unix
Oracle Database
Oracle Enterprise Manager
Oracle Goldengate
Oracle Rac
Pl/Sql
Python
SQL
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
InOrg helps organizations achieve global competitiveness through the seamless integration of talent, technology, and strategic capabilities.