What are the responsibilities and job description for the Oracle DBA position at Solomons International?
Job Responsibilities/Duties:
- Design and manage Oracle OCI environments, including database, middleware, and infrastructure components.
- Develop and maintain Oracle APEX applications and ORDS services.
- Configure and administer Oracle WebLogic Server and related technologies.
- Plan and execute database upgrades, migrations, and conversions.
- Implement and manage backup, recovery, and replication strategies using RMAN and other tools.
- Ensure high availability, disaster recovery, and data protection.
- Monitor and optimize database performance, implementing tuning recommendations.
- Implement and automate routine tasks using shell scripting and tools like Ansible.
- Collaborate with development and DevOps teams to ensure seamless application deployment.
- Proactively identify and resolve potential issues, providing timely support.
- Document and train on best practices for Oracle OCI environment management.
Required Skills:
- 10 years of hands-on experience with Oracle Cloud Infrastructure (OCI) and related technologies including:
- Oracle Application Express 18 and higher (APEX)
- Oracle Rest Data Services 22 and higher (ORDS)
- Oracle WebLogic Server 14 (both Fusion Middleware and WebLogic Suite)
- Oracle Database 19c and 26ai
- Container Database (CDB) and Pluggable Database (PDB)
- Experience with upgrading Oracle Database from 19c to 26ai
- Proficiency in Linux/Unix, including shell scripting
- PDB cloning
- RMAN and backup/recovery procedures
- WebLogic administration (patching/maintenance)
- Oracle Enterprise Manager (OEM) 24ai
- PSU Patching Oracle DB using Fleet Management Tool
- Experience with DBaaS in OCI
- Proficiency in Gitlab and Ansible scripting
- Oracle Dataguard
- Strong understanding of cloud computing concepts and architecture.
- Ability to design and implement high-availability and disaster recovery solutions.
- Experience with Oracle OEM Cloud Control for monitoring and management.
- Familiarity with containerization technologies such as Docker and Kubernetes.
- Proficiency in scripting languages such as Python and JavaScript.
- In-depth knowledge of database security best practices.
- Expertise in performance tuning and optimization.
- Excellent analytical and problem-solving skills.
- Strong communication and collaboration abilities.
- Ability to provide 24/7 support and troubleshoot critical issues.
- Oracle Database 12c (6 years experience)
- Oracle Database 11g (10 years experience)
- Oracle Grid Control to include version 13c (7 years experience)
- Oracle APEX administration and support (5 years experience)
- Oracle DB migration from Solaris to Linux (database 12c/11g) (10 years experience)
- Oracle Database backup/restore/RMAN/Dataguard (10 years experience)
- Oracle performance tuning/database maintenance/management (10 years experience)
- On-call production support (10 years experience)
Preferred Skills:
- Certification in Oracle technologies such as OCIP, OCP, or OCE.
- Experience with CI/CD tools such as Jenkins or GitLab CI.
- Understanding of microservices architecture and API integration.
- Oracle WebLogic 12c/Fusion Middleware (7 years experience)
- Oracle cloud setup/AWS/Azure administration (3 years experience)
- Windows/SQL Server/IIS administration (5 years experience)
Professional Skills :
| Skill Name | Required/Desired | Total Years |
|---|---|---|
| oracle database 12c | Required | 6 |
| oracle database 11g | Required | 10 |
| oracle grid control to include version 13c | Required | 7 |
| oracle weblogic 12c/fusion middleware | Highly desired | 7 |
| oracle apex administration and support | Required | 5 |
| oracle db migration from solaris to linux (database 12c/11g) | Required | 10 |
| oracle database backup/restore/rman/dataguard | Required | 10 |
| oracle performance tuning/database maintenance/management | Required | 10 |
| on-call production support | Required | 10 |
| oracle cloud setup/AWS/Azureadministration | Desired | 3 |
| Windows/sql server/IIS administration | Highly desired | 5 |