Oracle Database Administrator at Kobby Technologies Limited

The individual must:

• Be responsive and alert to new learning opportunities, growth and development of technical, interpersonal and business skills
• Be motivated and competent to contribute appropriate time and effort to work assigned
• Be attentive to detail with focus on accurate results
• Be organized and able to prioritize tasks;
• Strong analytical and problem-solving abilities
• Have the ability to conduct research into software issues and products as appropriate.
• Possess strong customer service orientation.
• Be able to contribute to team effort or individual achievement.

Job Description

• This position will require expertise and administration of multiple database environments.
• Individual must have strong knowledge of Oracle 9i/10g/11g/12c technology and thorough understanding of relational database environments.
• Responsibilities include but not limited to the administration and support of large scale Oracle production databases spanning multiple Terabyte plus in size utilizing Linux/Unix. The position will ensure regular backups and restores are available for all supported databases.
• Experience with various Oracle replication strategies is required.
• The database environment must be highly available and current with required updates and patches.

The position might involve certain level of travelling and skills in:

• Administering and supporting Oracle production databases spanning Multi-Terabyte in size on different platforms.
• Maintain databases in accordance with internal standards, access control and security guidelines.
• Ensure high availability, timely backups and if necessary restores of production databases.
• Work closely with development and QA to troubleshoot connectivity or query problems for applications dependent on Oracle environment.
• Work with Oracle support services to resolve issues.
• Provide off hours on-call support and work off hours as necessary.
• Test and apply database software patches and upgrades.
• Regular monitoring/tuning activities to include analysis of AWR reports to look for database performance trending and/ anomalies
• Knowledge of SQL Server 2005/2008R2 or MySQL to provide on call assistance is an added advantage.
• The successful applicant can use his/her skills to create and install procedures to aid in systems implementation; assist applications software development staff as needed on systems- and technology-related issues; answer users’ technical inquiries.
• Excellent written and verbal communication skills are essential, as are good human relations skills.

Required

• 4 year degree or equivalent experience.
• 5 plus years of work experience as an Oracle DBA.
• Experience installing and maintaining Oracle databases and replication in production environments.
• Experience with Oracle replication methods such as Data Guard/Golden Gate is preferable
• Demonstrated depth of knowledge of key Oracle technologies (e.g. RAC, ASM, OEM/Grid Control, RMAN, Partitioning).
• Performance tuning and optimization of SQL.
• Creation and maintenance of SQL queries and routines.
• Required to deal and understand complex data models and object relational database mapping as it relates to system performance and stability.
• Must have strong, demonstrated teamwork skills.
• Must have proven skills in system trouble shooting and problem resolution.
• Must have exceptional communication skills, both oral and written
• Must have good, planning and organization skills.
• Works independently with minimal guidance.
• Demonstrable analytical skills especially as they pertain to monitoring and gauging overall system performance, growth and stability.
• Able to articulate accomplishment/progress.
• Operating Systems: Linux , Windows, Unix

Preferred

• Cursory knowledge of SQL Server 2005/2008R2, MySQL. Advanced knowledge of MySQL administration and tuning a plus.
• Languages: Java, Shell Scripting, Sql Plus Reporting
• Experience with Oracle Engineered Systems (Exadata/ODA) is an added advantage.
• Hadoop experience is an added advantage.
• Experience with Oracle E-Business Suite as an Oracle Apps DBA