Oracle Database Administrator

Optimal Solutions Inc.; Mechanicsburg (Cumberland County); Hybrid; USD 90,000 - 120,000; Full time

Job summary

Optimal Solutions Inc. is seeking an experienced Oracle DBA to provide comprehensive database administration support remotely, with one day on-site per week. The role includes ensuring the availability and data protection of managed database systems, performing backup and recovery testing, implementing data replication schemes, and executing database manipulation scripts.

The ideal candidate should have over 5 years of experience in Oracle Server Database Administration and possess strong skills in database technologies and performance tuning.

Qualifications

• 5+ years of proven experience in Oracle Server Database Administration.
• Experience with Oracle Database technologies.
• Experience with database integration and performance tuning.

Responsibilities

• Ensure availability and data protection of managed database systems.
• Perform backup and recovery testing for data integrity.
• Implement data replication schemes for redundancy.
• Execute database manipulation scripts and performance tuning.

Skills

Oracle Database Administration

Database Integration

Performance Tuning

Job description

Must be willing to work remotely with one day on-site per week.

Job Description:

• The Oracle DBA will be responsible for providing comprehensive database administration support for our managed database systems on a 24x7x365 basis.
• The candidate will have expertise in database technologies, environments, and system types, including Database Vendor Software, Database Homes and Instances, Database Storage, Database Memory, Database Network Integration and Connectivity, Database Security, Database Auditing, Database Logging, and more.

Key Responsibilities:

• Ensure the availability and data protection of managed database systems at DISA. This includes implementing and configuring backup methodologies, monitoring daily backup job logs, and initiating incident tickets to address failures impacting data restore capability.
• Perform backup and recovery testing to ensure effectiveness, execute database and data recovery in response to incidents or data integrity issues, and assist in application restoration.
• Implement and configure data replication schemes for managed systems to ensure data redundancy and system/data recoverability and provide integration support throughout the lifecycle of managed databases with master applications.
• The candidate will execute database manipulation language scripts, perform database integration with applications, and conduct database performance tuning to optimize performance and troubleshoot issues.

Experience:

• 5+ years of proven experience in Oracle Server Database Administration.
• Experience with Oracle Database technologies
• Experience with database integration and performance tuning.