Oracle DBA Administrator

2 - 6 years

4 - 8 Lacs

Posted:1 month ago| Platform: Naukri logo

Apply

Work Mode

Work from Office

Job Type

Full Time

Job Description

Key Roles and Responsibilities
Database Management and Maintenance:
oAdministered Oracle databases (versions 11g, 12c, 19c) ensuring optimal performance, scalability, and security.
o Performed regular database health checks, capacity planning, and proactive monitoring to minimize downtime.
o Implemented database patches, upgrades, and migrations with minimal disruption to business operations.
Performance Tuning and Optimization:
o Conducted SQL query optimization and database tuning to enhance application performance.
o Analyzed and resolved performance bottlenecks using tools like AWR, ADDM, and SQL Trace.
Backup and Recovery:
o Designed and implemented robust backup and recovery strategies using RMAN and Data Pump.
High Availability and Clustering :
o Configured and managed Oracle RAC (Real Application Clusters) and Data Guard for high availability and disaster recovery.
o Monitored and maintained ASM (Automatic Storage Management) for efficient storage utilization.
Security and Compliance:
o Enforced database security policies, user access controls, and encryption standards.
o Ensured compliance with industry regulations (e g, GDPR, SOX) through regular audits and reporting.
Collaboration and Support:
o Worked closely with development teams to design and implement database schemas, indexes, and stored procedures.
o Provided 24/7 support for critical production environments, resolving incidents within SLA timelines.
Documentation and Reporting:
o Maintained comprehensive documentation of database configurations, processes, and troubleshooting guides.
o Generated detailed performance and usage reports for stakeholders.
Technical Skills
Database Tools: Oracle Enterprise Manager (OEM), RMAN, Data Pump, SQL*Plus Technologies: Oracle RAC, Data Guard, ASM, GoldenGate
Languages: SQL, PL/SQL, Shell Scripting
Operating Systems: Linux, Unix, Windows
Other Tools: AWR, ADDM, TOAD, SQL Developer

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now

RecommendedJobs for You