Experience
2 - 6 yrs
Job Location
Bengaluru, India
Vacancy
1
Designation
Oracle Database Administrator
Job Type
ONSITE
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:
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.
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
No Referrers Available
There are currently no referrers available for this job. You can still apply, will let you know once there is any referrer available.