Oracle DBA

Job Openings

Oracle DBA

Experience
7-15 Years

Location
Mumbai, Airoli

Job Summary:

Lead Oracle database management and administration activities, overseeing a team of DBAs to ensure high availability, performance, and scalability across both production and non-production environments. Drive efficiency through automation, enforce security standards, and collaborate with cross-functional teams to support business demands.

Key Responsibilities:

• Database Management & Administration : Oversee Oracle database administration, including upgrades, patching, backups, and recovery, ensuring high availability, performance, and scalability across environments.
• Team Leadership & Development : Lead and mentor a team of Oracle DBAs, offering guidance on best practices, troubleshooting, and career growth. Conduct performance reviews and set professional development plans.
• Database Performance Tuning : Conduct query optimization, storage management, indexing, and configuration tuning to ensure optimal database performance. Regularly perform health checks and optimization tasks.
• Backup & Disaster Recovery : Design and implement backup strategies and disaster recovery plans to protect data integrity and minimize data loss.
• Security & Compliance : Implement and enforce database security policies, ensuring compliance with standards and regulations (e.g., GDPR, HIPAA). Manage user access controls, encryption, and auditing.
• Automation & Scripting : Automate DBA tasks such as maintenance, performance tuning, and monitoring using scripting languages (e.g., Shell, Python, Perl).
• Database Architecture & Design : Collaborate with application developers and architects to create efficient database architectures. Advise on schema design, data partitioning, and indexing to improve performance.
• Incident & Problem Management : Lead troubleshooting and resolution of complex database issues. Manage incidents and collaborate with cross-functional teams to prevent recurrence.
• Capacity Planning & Scaling : Plan and manage database resources (storage, CPU, memory) to align with business growth.
• Upgrades & Patches : Handle Oracle database version upgrades and patches to minimize downtime and maintain stability.
• Collaboration & Cross-Functional Work : Work closely with development, operations, and DevOps teams for smooth database integration with applications and services. Provide support for database-related issues.

Qualifications:

• Experience : Minimum of 7+ years as an Oracle DBA, with at least 3+ years in a leadership or managerial role.
• Oracle Database Expertise : Deep knowledge of Oracle database versions, architecture, and features, including RAC, Data Guard, and ASM.
• Performance Tuning & Optimization : Proficiency in performance tuning, SQL query optimization, and resource management (CPU, storage, I/O).
• Backup & Recovery : In-depth knowledge of Oracle backup and recovery, including RMAN, data pump, and flashback.
• Security & Compliance : Strong foundation in Oracle database security, user access management, encryption, and auditing.
• High Availability & Disaster Recovery : Experience in high availability and disaster recovery solutions, such as Oracle Data Guard or GoldenGate.
• Scripting & Automation : Proficiency in scripting (e.g., Shell, Perl, Python) for routine database task automation.
• Cloud Experience : Familiarity with cloud environments for Oracle databases (e.g., Oracle Cloud, AWS, Azure) is advantageous.
• Problem-Solving : Skilled in troubleshooting complex database issues under pressure, with a focus on quick resolution.
• Communication : Excellent verbal and written communication skills for conveying technical information to non-technical stakeholders.