Oracle DBA L2
Experience 5yrs
Location Pune (Hybrid)
Immediate Joiners
Role Objective: Become a key member of the Oracle DBA team with hands on experience on Oracle Real Application Clusters (RAC) and Oracle Data Guard ensuring the optimal uptime and performance of our Oracle databases.
Detailed Roles and Responsibilities:
- Database Management: Administer configure and support Oracle databases ensuring they are available secure and performant.
- RAC & Clustering: Manage and configure Oracle Real Application Clusters (RAC) ensuring high availability load balancing and fault tolerance across multiple database instances.
- Data Guard: Implement configure and support Oracle Data Guard for disaster recovery ensuring seamless failover and replication of databases across locations.
- Database Performance Tuning: Monitor and optimize database performance
- Backup and Recovery: Maintain robust backup and recovery solutions for Oracle databases including RMAN and Data Guard configurations.
- Patch Management: Apply Oracle patches upgrades and critical updates ensuring system stability and compliance with Oracle s best practices.
- Capacity Planning: Plan for database growth and provide recommendations for scaling databases efficiently.
- Security & Compliance: Ensure databases meet security standards manage user access control and perform audits to ensure compliance with industry standards.
- Documentation & Reporting: Maintain uptodate documentation for all databaserelated processes configurations and procedures.
- Collaboration: Work closely with developers system administrators and other teams to support databasedriven applications and resolve issues in a timely manner.
- Incident Management: Respond to databaserelated incidents performing troubleshooting root cause analysis and corrective actions.
Technical Expertise:
- Proficient in Oracle database architecture administration and management.
- Strong expertise in Oracle RAC configuration management and troubleshooting.
- Indepth knowledge of Oracle Data Guard setup configuration and maintenance.
- Proficient in Oracle backup and recovery solutions specifically RMAN.
- Strong experience in database performance tuning including SQL optimization and query performance analysis.
- Experience with Oracle Enterprise Manager (OEM) for monitoring and management.
- Familiarity with Oracle 12c/18c/19c versions or higher.
1. Educational Qualifications:
Bachelor s degree in engineering Information Technology or a related field (preferred).
Proven experience working with enterprise resource planning (ERP) systems is a strong plus.
2. Skills & Experience:
3. tensive experience with Oracle Financials modules: General Ledger Accounts Payable Accounts Receivable Cash Management Fixed Assets.
Indepth knowledge of Oracle EBusiness Suite architecture and Oracle Fusion Cloud Financials.
Proficiency in configuring and customizing Oracle Financials to meet business needs.
Expertise in Oracle technologies: PL/SQL SQL Forms Reports Workflow BI Publisher.
Skilled in developing customizations extensions interfaces and workflows.
Experience with data migration integration techniques and Oracle reporting tools.
Familiar with Oracle administration tools and version control systems.
Minimum 5 years of experience as an Oracle DBA with hands on RAC and Data Guard.
Should have good communication skills with a cando attitude.
Good knowledge of Oracle RAC and Data Guard administration.
Proficiency in configuring and customizing Oracle Financials to meet business needs.
4. Behavioral Skills:
Strong problemsolving skills and ability to translate business requirements into technical solutions.
Should be ready to learn new technologies and provide support wherever required.
Excellent communication and teamwork skills to interact with business users and colleagues effectively.
High level of accuracy in system configurations customizations and reporting.
Commitment to providing highquality support and understanding business user needs.
Ability to manage multiple tasks and prioritize effectively to meet deadlines.
data migration,reports,rman,oracle enterprise manager (oem),financials,oracle financials,data,oracle data guard,database,skills,data guard,oracle e-business suite,oracle dba,databases,sql,bi publisher,pl/sql,workflow,oracle,management,oracle rac,backup and recovery,database performance tuning,forms