Job Overview:
We are seeking a highly skilled Oracle Database Specialist to join our team as a key member of our Database practice.
The successful candidate will provide technical consulting and managed services to a wide range of customers in Australia and New Zealand.
* Design and build databases, schemas, stored procedures, and other database objects.
* Set up routine database backup procedures and disaster recovery environments and procedures.
* Perform database recoveries.
* Assist developers and end-users with database usage, query development, and tuning.
* Develop operating system scripts to automate backups, data transfers, monitoring, etc.
* Support database connectivity from client applications.
* Design and implement database security.
* Provide direction to less senior DBA's. Assist associate and intermediate DBAs with complex database tasks.
The position will involve the database portion of various projects ranging from the installation of new packaged applications to the development of custom databases for in-house developed applications.
Key Responsibilities:
* Competent to work at the highest level of all phases of database administration.
* Have a good working experience in Oracle Core DBA Architecture, Backups/Recovery and Performance tuning exercise.
* Experience in Coordinating and working with Clients to understand the business requirement and design the architecture, accordingly, resolve issues if any.
* Must be a strong team player and able to work closely with the other technical specialists and team members;
* Ability to manage competing priorities in a complex environment;
* Excellent interpersonal oral and written communication.
Requirements:
Bachelor's degree or equivalent combination of education and experience required.
* Minimum of 8 years of experience as a database administrator, with implementations, upgrades, migrations, conversions and consolidation projects with Oracle databases.
* Strong experience with Oracle Database ranging from 10g through to 19c across UNIX/Linux and Windows platforms.
* Strong command administering database security, data recovery, performance monitoring and tuning.
* Design & build specific database environments to meet business requirements.
* Proficient in writing and optimizing SQL statements.
* Must have experience with Oracle Recovery Manager.
* Must have experience with Oracle Grid Infrastructure, Real Application Clusters and Automatic Storage Management.
Desirable Skills:
* Experience managing databases on engineered systems, such as Exadata and Oracle Database Appliance (ODA).
* Experience with administering or migrating databases on/to OCI, AWS, Azure, Exadata Cloud at Customer or on PaaS environments.
* Experience with SSO and E-Business Suite 11i / R12.
Australian Citizen. Baseline Clearance or higher – preferred but not required.