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.
