Oracle DBA

Skills

Description

We are seeking a highly skilled and experienced Oracle Production Database Administrator (DBA) with extensive expertise in managing large-scale Oracle database deployments and troubleshooting. As a Senior Oracle Production DBA, you will play a critical role in ensuring the smooth operation, performance, and reliability of our mission-critical Oracle database systems. You will collaborate closely with cross-functional teams, including developers, system administrators, and data engineers, to design, implement, and optimize Oracle database solutions that meet our business needs.

Responsibilities

• • Manage Large-scale Oracle Database Deployments: Oversee the deployment, configuration, and administration of large and complex Oracle database systems, ensuring efficient utilization of resources and high availability.
• • Performance Optimization: Identify and resolve performance bottlenecks, fine-tuning Oracle database configurations, optimizing SQL queries, and implementing caching strategies to enhance overall system performance.
• • Troubleshooting and Issue Resolution: Proactively monitor Oracle database systems, investigate and troubleshoot issues, and develop effective solutions to ensure minimal downtime and optimal system performance.
• • Database Security and Compliance: Implement and maintain Oracle database security measures, including access controls, encryption, and auditing, to ensure data privacy and compliance with industry standards and regulations.
• • Backup and Recovery: Develop and implement backup and recovery strategies for Oracle databases to safeguard data integrity, minimize data loss, and ensure rapid recovery in the event of system failures or disasters.
• • Database Design and Architecture: Collaborate with development teams to design and implement efficient Oracle database schemas, indexing strategies, and data partitioning techniques to support scalability, data integrity, and application performance.
• • Capacity Planning and Scalability: Assess current and future Oracle database capacity requirements, analyze growth trends, and propose scalable solutions to accommodate increasing data volumes and user demands.
• • Automation and Scripting: Develop automation scripts and tools using Oracle scripting languages (e.g., PL/SQL, Shell scripting) to streamline routine Oracle database tasks, such as backups, monitoring, and performance tuning, to improve operational efficiency and reduce manual effort.
• • Documentation and Knowledge Sharing: Create comprehensive documentation, including Oracle database system configurations, procedures, and troubleshooting guides, and actively share knowledge with team members to enhance the overall expertise of the team.
• • Stay Updated with Oracle Technologies: Keep abreast of the latest advancements and best practices in Oracle database technologies, emerging trends, and tools relevant to Oracle production DBA responsibilities, and recommend their adoption when appropriate.