The Oracle DBA will be responsible for the design implementation maintenance and performance tuning of Oracle databases. This role involves ensuring database reliability security and availability while supporting application teams with database solutions. The ideal candidate will have extensive experience with Oracle Database Administration a deep understanding of database architecture and strong problemsolving skills.
Key Responsibilities:
1. Database Management:
- Install configure and upgrade Oracle database servers and related software.
- Create and manage database structures including tablespaces schemas and objects.
- Perform regular database maintenance tasks including backups restores and data recovery operations.
2. Performance Tuning and Optimization:
- Monitor database performance and implement enhancements for optimal performance.
- Analyze and resolve performance bottlenecks using Oracle tools like AWR ADDM and SQL Tuning Advisor.
- Optimize SQL queries and PL/SQL scripts for efficiency.
3. Security and Compliance:
- Implement and maintain database security policies and procedures to protect sensitive data.
- Manage user access and roles ensuring compliance with company security standards.
- Conduct regular audits and apply patches to maintain system security.
4. Backup and Recovery:
- Develop and implement backup strategies including RMAN backup and recovery plans.
- Perform disaster recovery planning and testing to ensure data integrity and availability.
5. Support and Troubleshooting:
- Provide 24/7 support for databaserelated issues ensuring minimal downtime.
- Troubleshoot and resolve databaserelated incidents and service requests.
- Collaborate with development and application teams to resolve database issues.
6. Documentation and Reporting:
- Maintain comprehensive documentation of database environments configurations and procedures.
- Prepare regular reports on database performance incidents and capacity planning.
Qualifications :
- Education: Bachelors degree in Computer Science Information Technology or a related field.
- Experience: 5 years of experience as an Oracle DBA.
- Technical Skills:
- Proficiency in Oracle Database versions 11g/12c/19c.
- Strong knowledge of Oracle RAC ASM Data Guard and GoldenGate.
- Experience with Oracle Enterprise Manager (OEM).
- Proficiency in SQL PL/SQL and shell scripting.
- Familiarity with backup and recovery tools (RMAN).
- Understanding of database security and compliance standards.
- Soft Skills:
- Strong analytical and problemsolving skills.
- Excellent communication and collaboration skills.
- Ability to work independently and as part of a team.
Preferred Qualifications:
- Oracle Certified Professional (OCP) or Oracle Certified Master (OCM).
- Experience with cloud platforms (e.g. Oracle Cloud AWS Azure).
- Knowledge of other databases (e.g. MySQL SQL Server).
Personal Attributes:
- Detailoriented with a commitment to accuracy and quality.
- Proactive approach to identifying and resolving issues.
- Strong organizational and timemanagement skills.
Additional Information :
- Need for immediate joining.
- Work from home.
Remote Work :
Yes
Employment Type :
Fulltime