Job Description

Requirements:

• Diploma/Bachelors degree in computer science, Information Systems, Business Management, Electrical Engineering, Electronics Engineering, or related discipline from an accredited tertiary institution
• Oracle Certified Professional 12g or greater
• 6+ years of experience in an Enterprise environment developing data management systems, tools and architectures using Oracle tools
• Experience designing and operating very large Data Warehouses and web facing online transaction processing databases
• Demonstrable proficiency and experience in Oracle, SQL Server, DB2, Linux, and programming languages such as R, Python, Ruby or Java
• The role might require traveling nationally and work after hours as and when required
• Demonstrated experience with database technologies and API interfaces to WebApps and Administration in one or more of the following PL/SQL, MySQL, Oracle, or NoSQL (minimum of 5 years)
• Experience in Sybase Database and Sybase Replication Server
• Experience with Oracle Replication and Clustering Technologies
• Experience in AWS, EBS and Golden Gate will be advantageous
• Experience in Unix AIX, Linux and Windows operating systems

Responsibilities:
The Oracle Database Administrator will be required to perform the following duties, amongst others:

• Ensure all database servers are backed up in a way that meets the businesss Recovery Point Objectives (RPO).
• Test backups to ensure we can meet the business Recovery Time Objectives (RTO).
• Troubleshoot Oracle Database Server service outages as they occur, including after-hours and weekends.
• Configure Oracle Database Server monitoring utilities to minimize false alarms.
• As new systems are brought in-house, choose whether to use clustering, data guard, or other appropriate technologies.
• Install and configure new Oracle Database Servers.
• Upgrading the Oracle database software as and when required.
• Deploy database change scripts provided by third party vendors.
• When performance issues arise, determine the most effective way to increase performance including tuning, hardware purchases, server configuration changes, or index/query changes.
• Document the Departments database environment.
• Tuning SQL and PL/SQL queries to improve performance.
• Troubleshooting hardware using technology toolsets.
• Failover clustering, SAN replication, and other high availability technologies.
• Root Cause Analysis of production-related database issues.
• Daily maintenance, monitoring, problem resolution and internal customer/development support.
• Review, design and develop data models in conjunction with the application development teams.

ExecutivePlacements.com