Oracle DB

InOrg-posted 2 months ago

251-500 employees

Resume

Match Score

Upload and Match ResumeTrack Jobs with Teal

The Oracle DBA is responsible for the management and maintenance of Oracle databases, ensuring their performance, security, and availability. This role involves installing, configuring, patching, and upgrading Oracle database software and related products. The DBA will manage the database throughout its lifecycle, from development to production, and design and implement database schemas and storage structures, including tables, views, and indexes. Additionally, the DBA will create and maintain stored procedures, functions, and triggers using PL/SQL, and manage complex Oracle GoldenGate replication environments. Automation of routine database tasks using Python scripting is also a key responsibility. The DBA will configure and maintain high-availability solutions like Oracle Real Application Clusters (RAC) and Data Guard.

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
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
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
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

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
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)

Track Jobs with Teal

Job Search Resources

•

AI Resume Builder

•

SQL DBA Resume Examples

•

Cover Letter Examples

Oracle DB

Job Search Resources

Tools

Career Hubs

Guides

Company