Job Description

Core Responsibilities:

• Database Installation and Configuration
• Installing configuring and upgrading Oracle database software and related tools

Database Creation and Management

• Creating new databases managing storage structures and defining database objects like tables indexes and views

User Management and Security

• Creating and managing user accounts assigning roles and privileges and implementing security policies to protect sensitive data

Performance Tuning and Optimization

• Monitoring database performance identifying bottlenecks and implementing solutions to improve efficiency

Backup and Recovery

• Developing and implementing backup and recovery strategies to ensure data availability and recoverability in case of failures

Troubleshooting and Issue Resolution

• Diagnosing and resolving database-related issues including performance problems errors and security breaches

Database Monitoring

• Continuously monitoring database health performance and resource usage to proactively identify and address potential problems

Capacity Planning

• Evaluating database server hardware storage needs and planning for future capacity requirements

Collaboration

• Working closely with application developers system administrators and other IT professionals to ensure seamless database operations

Documentation

• Creating and maintaining documentation related to database design configuration and procedures
• Additional Responsibilities may vary based on the organization

Database Design and Architecture

• Designing the logical and physical structure of databases to meet specific business requirements

Data Modeling

• Developing and maintaining data models to represent the structure and relationships of data within the database

Scripting and Automation

• Developing scripts and automation tools to streamline database administration tasks

New Technology Implementation

• Evaluating and implementing new database technologies and tools to improve performance security or functionality

Disaster Recovery Planning

• Developing and testing disaster recovery plans to ensure business continuity in the event of a major outage

Reporting and Analytics

• Generating reports and dashboards to track database performance usage and other key metrics

Training and Support

• Providing guidance and training to other users on databaserelated topics

Mandatory Skills: OCI Database Migration, EXADATA, Oracle DBCS, Oracle RAC, ORACLE RMAN, DATAGUARD, Oracle DB Administration

Good to Have Skills: Oracle DB Administration

Job Tags

Similar Jobs