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.