Overseas Contractor

14 Minutes ago • All levels

Job Summary

Job Description

This role involves comprehensive Oracle database administration, including installation, configuration, management, security, performance tuning, backup, and recovery. Key responsibilities extend to monitoring, capacity planning, and troubleshooting. Additional duties may include database design, data modeling, scripting, automation, and disaster recovery planning, ensuring robust and efficient database operations.

Must have:

Installing, configuring, and upgrading Oracle database software and related tools.
Creating new databases, managing storage structures, and defining database objects.
Creating and managing user accounts, assigning roles and privileges, and implementing security policies.
Monitoring database performance, identifying bottlenecks, and implementing solutions to improve efficiency.
Developing and implementing backup and recovery strategies.
Diagnosing and resolving database-related issues, including performance problems, errors, and security breaches.
Continuously monitoring database health, performance, and resource usage.
Evaluating database server hardware, storage needs, and planning for future capacity requirements.
Creating and maintaining documentation related to database design, configuration, and procedures.

Good to have:

Designing the logical and physical structure of databases.
Developing and maintaining data models.
Developing scripts and automation tools to streamline database administration tasks.
Evaluating and implementing new database technologies and tools.
Developing and testing disaster recovery plans.
Generating reports and dashboards to track database performance, usage, and other key metrics.
Providing guidance and training to other users on database-related topics.

4 skills required

4 skills required for this role

Add these skills to join the top 1% applicants for this job

problem-solving

oracle

game-texts

oracle-database

Job Details

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 databaserelated 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