Oracle DBA | Schlumberger

Job Details

Oracle DBA

Cota - Colombia

The Oracle production apps database administrator is responsible for the delivery of 24x7 uptime. This position requires database design/ architectural experience and ability to mentor application development team in all phases of database development. Also, should work closely with development team, and the server team in maintaining a reliable environment around systems hardware and operating systems server software. The applications supported by these databases are a wide variety of vendor provided to in-house developed apps.

Roles and Responsibilities:

  • Design, install, upgrade, administer, monitor, patch, and clone Oracle eBusiness 11.5.10 and related Oracle 11gR2/ 12c databases in RAC and non-RAC environments (RAC optional)
  • Integrate Oracle eBusiness application with other boundary systems like OID/ OIM/ OAM, RevPro, Sabrix, OBIEE, GRC, GTrM and Hyperion
  • Optimize system/ database operations and resource utilization and performs system capacity analysis and planning
  • Monitor and support patch control and database configuration across environments
  • Database performance tuning at system and application levels, for development and production databases
  • Develop stored procedures and other database objects to implement some business logics in the database
  • Design and manage database security, roles, and profiles
  • Design and implement disaster recovery plans.
  • Develop scripts for database task scheduling, monitoring and maintenance
  • Support all non-production databases including installation, upgrade, backup, recovery, database refresh, and multi-language support
  • Configure monitoring and setup alerts using OEM grid control 12c
  • Proactively tune the performance of EBS application and database
  • Provide support and direction to developers with trouble-shooting and performance tuning as needed
  • Maintain and develop backup/ recovery process for Oracle eBusiness suite installations, for online and offline backups and disaster recovery
  • Create monitors and alerts for user sessions, concurrent processes, table extents and locks for production and test/development systems
  • Follow change management process and participate in related meetings
  • Create and maintain database architecture and standards following Oracle best practices for physical structures, logical databases and user management

Qualifications and Experience:

  • Minimum 7+ years of Oracle server administration experience required
  • Advanced english level
  • Bachelors or Master’s degree in computer science or equivalent
  • Knowledge of Oracle applications architecture (RAC Optional)
  • Experience and understanding of patching, cloning, concurrent managers, workflow, OAM, Enterprise Manager Cloud/ Grid Control  11GR2 and 12c, security, RMAN backup and recovery procedures
  • Experience in managing large and transactional oracle databases
  • Experience with Linux/ AIX/ Solaris operating system is required
  • Troubleshooting skills and ability to resolve issues quickly and effectively
  • Experience in Unix shell scripting
  • Understanding of SDLC processes for database & application management
  • Oracle Certified Professional (OCP) is preferred
  • Proven experience to perform in a fast-paced demanding environment
  • Experience with Oracle golden gate (optional)
  • MySQL/ Mongo/ Cassandra/ BigData/ Hadoop Database Administration knowledge/ hands-on is an additional advantage

Other skills and abilities

  • Comfortable working across time-zones (open to shifts) and people of different nationalities
  • Good interpersonal, oral and written communication skills with the ability to deal effectively with business, peers and management.
  • Self-driven and proactive
  • Works well with all personality types
  • Fluent and confident speaker in English (upper B2)
  • Open to travel overseas

Schlumberger is an equal employment opportunity employer. Qualified applicants are considered without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, or other characteristics protected by law.

 

 

Oracle DBA
Log in to apply for this position today.
Apply Now

Share This