At a Glance
- Tasks: Administer Oracle databases on AWS and ensure optimal performance.
- Company: Join CareCone Group, a leader in IT services and consulting.
- Benefits: Competitive salary, full-time role, and opportunities for professional growth.
- Other info: Great career advancement opportunities in a supportive environment.
- Why this job: Be part of a dynamic team and work with cutting-edge database technologies.
- Qualifications: Experience with Oracle Database administration and AWS required.
The predicted salary is between 140000 - 150000 $ per year.
Location: Sydney, NSW
Employment Type: Permanent
Must have:
- Full working rights. No sponsorship available.
- Data Guard or Golden Gate
Key Responsibilities:
- Administer and maintain Oracle databases hosted on AWS (RDS and/or EC2).
- Perform regular database operations, including shutdowns, restarts, patching, log cleanup, backup/recovery, and performance tuning.
- Implement SSL/TLS encryption to ensure secure application-to-database communication.
- Configure and manage RMAN (Recovery Manager) for backup, restore, and disaster recovery operations.
- Support data migration activities in non-production and production environments, including one-time data loads and Oracle GoldenGate (OGG)-based replication.
- Perform Oracle database performance tuning and optimization across environments.
- Administer and operate Data Guard or GoldenGate for replication between primary and standby databases.
- Proficient with proactive monitoring using OEM or custom scripts.
- Experience in performing failover procedures and validating application connectivity post-failover.
- Experience implementing SSL/TLS for secure database connections.
- Scripting skills (e.g., Shell, Bash, Python) to automate routine tasks.
- Solid understanding of networking, storage, and security within cloud environments.
Skills:
- Strong hands-on experience with Oracle Database administration (12c, 19c or higher).
- Experience managing Oracle databases on AWS, including both RDS and EC2.
- Proficiency with Oracle GoldenGate for data replication.
- Operational experience with RMAN for backup, recovery, and configuration.
- Proven skills in Oracle database performance tuning and troubleshooting.
- Experience with Data Guard and GoldenGate for database replication.
- Expertise in configuring and managing active-passive setups with proper role definitions.
- Ability to configure Fast-Start Failover (FSFO) and monitor Data Guard status.
Nice to have:
- Experience with CI/CD and Infrastructure-as-Code tools.
Documentation & Governance:
- Ability to review and contribute to LLDs, runbooks, and solution documentation.
- Experience auditing and validating third-party or vendor deliverables.
- Familiarity with OATS and DOATs processes in large enterprise environments.
Seniority level: Mid-Senior level
Employment type: Full-time
Job function: IT Services and IT Consulting and Outsourcing and Offshoring Consulting
Oracle Database Administrator in Sydney employer: CareCone Group
CareCone Group is an exceptional employer located in the vibrant city of Sydney, offering a dynamic work culture that fosters innovation and collaboration. Employees benefit from ongoing professional development opportunities, competitive remuneration, and a supportive environment that values work-life balance. Joining our team means being part of a forward-thinking organisation dedicated to delivering high-quality IT solutions while ensuring compliance with Australian working rights.