Oracle DBA

Teamware Solutions

2 - 4 years

2 - 5 Lacs

bengaluru karnataka india

Posted:9 hours ago| Platform: Foundit logo

Apply

Skills Required

etl processes

Work Mode

On-site

Job Type

Full Time

Job Description

Key Responsibilities:
Database Administration:
Install, configure, and maintain
Oracle databases
(versions 12c, 18c, 19c, etc.).
Perform
database backups
and
disaster recovery
planning, ensuring business continuity.
Implement and manage
high availability
solutions like
Oracle Data Guard
,
RAC (Real Application Clusters)
, and
Oracle GoldenGate
.
Monitor and manage the health of
Oracle databases
to ensure high availability, efficiency, and reliability.
Performance Tuning:
Analyze and optimize
database performance
, including query tuning, index optimization, and system resource management.
Identify and resolve
performance bottlenecks
and implement
scalability
solutions.
Work with developers to review and improve
SQL queries
,
PL/SQL scripts
, and overall database design.
Monitor
database logs
and proactively resolve issues related to database efficiency and performance.
Backup and Recovery:
Develop and implement
backup strategies
using
Oracle RMAN (Recovery Manager)
and ensure regular testing of
recovery plans
.
Manage and maintain
Oracle Flashback
,
Data Guard
, and
standby databases
for high availability and disaster recovery.
Ensure the
integrity
of the database backup processes and manage the
archival
and
restoration
of critical data.
Security and Compliance:
Implement
security best practices
to ensure the protection of database data, including
user access control
,
encryption
, and
audit logging
.
Maintain and review
Oracle database security policies
, ensuring compliance with organizational security standards.
Perform regular
vulnerability assessments
and
patch management
for Oracle databases to ensure that security patches are applied in a timely manner.
Database Monitoring and Maintenance:
Utilize
Oracle Enterprise Manager (OEM)
and other monitoring tools to keep track of database performance, health, and security.
Perform
routine maintenance tasks
like
database upgrades
,
patch management
, and
capacity planning
.
Manage
storage allocations
,
tablespaces
, and other database resources efficiently.
Troubleshooting and Issue Resolution:
Diagnose and resolve
complex database issues
, including performance degradation,
database corruption
, and
failed queries
.
Provide
on-call support
for production database environments to resolve issues in real time.
Troubleshoot
database connectivity
and data access issues, including resolving issues with
networking
,
load balancing
, and
high availability
configurations.
Database Integration:
Work with developers and application teams to ensure that
databases
are integrated seamlessly into
enterprise applications
.
Optimize
data migration
processes and integrate data between
Oracle databases
and other systems (e.g.,
ETL processes
, third-party tools).
Provide support for
data replication
,
data warehousing
, and
analytics platforms
.
Automation and Scripting:
Write and maintain
shell scripts
,
SQL scripts
, and
PL/SQL
scripts to automate repetitive database administration tasks such as backups, reporting, and monitoring.
Utilize
scripting
to implement
database automation
solutions for proactive maintenance, patching, and system monitoring.
Documentation and Reporting:
Maintain detailed and up-to-date documentation on
database configurations
,
patching procedures
,
security protocols
, and
disaster recovery
plans.
Generate regular
reports
on
database health
,
performance metrics
, and
security status
for management and stakeholders.
Create and maintain
user guides
and
technical documentation
for the
development and support teams
.
Collaboration and Knowledge Sharing:
Collaborate with development teams to ensure that
database design
aligns with application requirements and best practices.
Mentor junior DBA staff and assist them in
problem-solving
and
troubleshooting
complex database issues.
Stay current with emerging
Oracle technologies
and best practices in database administration and management.
Required Qualifications:
Bachelor's degree
in
Computer Science
,
Information Technology
,
Engineering
, or a related field.
3-5 years
of experience working as an
Oracle Database Administrator
.
Extensive experience in
Oracle database administration
(versions 12c, 18c, 19c).
Hands-on experience with
Oracle RMAN
,
Data Guard
,
RAC
, and
GoldenGate
.
Strong knowledge of
PL/SQL
,
SQL
performance tuning, and
Oracle database architecture
.
Experience with
Oracle Enterprise Manager (OEM)
or other monitoring tools.
Proficiency in
shell scripting
,
Python
, or
PowerShell
for task automation.
Experience in
data migration
,
replication
, and
ETL processes
.
Knowledge of
Oracle security
, including
user management
,
data encryption
, and
auditing
.
Familiarity with
cloud-based Oracle databases
(e.g.,
Oracle Cloud
).

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview

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.