We're sorry, but this job has been placed on hold. See other open jobs at Mediaocean

Oracle PL/SQL programmer

Chicago, IL | Product Development

Job Description

What we need

MediaOcean, LLC seeks an Oracle DBA in Chicago, Illinois.

What you’ll do

  • Responsible for database installation and configuration.
  • Perform maintenance, migration, security, and disaster recovery.
  • Responsible for cloning, backup and recovery, performance tuning, capacity and space management.
  • Perform database modeling, PL/SQL development, system documentation and system management and support.
  • Upgrade, maintain, monitor, patch, and tune Oracle databases.
  • Provide support to developers with troubleshooting and performance tuning, including SGA analysis, latch contention analysis, disk subsystem tuning, and SQL tuning of Oracle and custom views and queries.
  • Maintain and develop backup/recovery process for Oracle installations using RMAN and/or scripts 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.
  • Design and implement database objects. Develop SQL/PLSQL as necessary.

What you’ll bring to the job

  • Requires a Bachelor’s degree in Computer Science, Information Science, or a related field, plus five years of experience as a Database Administrator or Database Developer.
  • In lieu of a Bachelor’s degree plus five years of experience, employer will accept a Master’s degree in Computer Science, Information Science, or a related field, plus two years of experience as a Database Administrator or Database Developer.
  • Requires experience performing product support for application and database deployment of upgrades and patch releases.
  • Experience supporting distributed databases in a multi-server/multi-location environment.
  • Strong performance and tuning skills.
  • Experience designing and implementing High Availability and Disaster Recovery solutions using Oracle technologies.
  • Experience working with Oracle support, opening, managing, and resolving Oracle TARs.
  • Experience and in-depth understanding of Oracle backup and recovery methodologies.
  • Experience in database reorganization, migration, planning capacity, Disaster Recovery, and High-Availability.
  • Experience in database performance and SQL tuning. Strong data modeling and PL/SQL programming experience.
  • Experience with Unix shell scripting.
  • Experience with tools such as Oracle Enterprise Manager, Spotlight, and Toad.
  • Knowledge of Oracle AS and Snapshot technologies.
  • Ability to find root causes and provide solutions.
  • Employer will accept any suitable combination of education, training, and/or experience.

What’s next

  • If you’re ready to be part of something exciting, please apply online.

 

Position Filled
Not the right job?
Describe your perfect job
Join our Talent Network »