ERT

Senior Oracle DBA

US-NJ-Bridgewater
Shift
Mon-Fri, 8:30-5pm
Type
Regular Full-Time

Overview

ERT is a global data and technology company that minimizes uncertainty and risk in clinical trials so that our customers can move ahead with confidence. With more than 45 years of clinical and therapeutic experience, ERT balances knowledge of what works with a vision for what’s next, so it can adapt without compromising standards.

Powered by the company’s EXPERT® technology platform, ERT’s solutions enhance trial oversight, enable site optimization, increase patient engagement, and measure the efficacy of new clinical treatments while ensuring patient safety. Over the past four years, more than half of all FDA drug approvals came from ERT-supported studies. Pharma companies, Biotechs, and CROs have relied on ERT solutions in 9,500+ studies spanning three million patients to date. By identifying trial risks before they become problems, ERT enables customers to bring clinical treatments to patients quickly – and with confidence. For more information, go to ert.com or follow us on LinkedIn, Twitter, and Facebook.

 

ERT is looking to hire a Senior Oracle DBA. This person will ensure operation and maintenance of all ERT Oracle databases supported by IT Operations in 24x7x365 environment. 

Responsibilities

 

ESSENTIAL DUTIES AND RESPONSIBILITIES:

 

  1. Responsible for the creation and management of database instances. This includes tasks such as user creation, creating and altering table spaces, configuring listeners and creating and managing rollback segments. Responsible for the daily backup and data export of all database instances including hot backups and cold backups.
  2. Document and execute changes on Production and non-Production environments, including (but not limited to) database configuration changes, database patches, and software updates.
  3. Collaborate with Validation and R&D Teams in support of the SDLC (DevOps model). Escalate issues to appropriate teams.  Provide notification of scheduled releases to business stakeholders.  Support developers with special database requests such as replication, configuration, archiving of data, database snapshots and web server configuration.
  4. Follow industry Best Practice and Guidelines to ensure that Database design and configurations are optimal. Minimize risks to system availability and security. Report all potential risks, operational failures, time constraint problems and extraordinary events that will negatively impact to the supervisor.
  5. Perform Incident Management duties including (but not limited to) responding to operational help desk calls and tickets entered in Service Desk Management. This is primarily for database issues but will at times pertain to general system issues. Take appropriate action to resolve and/or escalate when necessary.  Provide timely and accurate responses to maintain high levels of Customer Satisfaction.
  6. Performs tasks in accordance with IT and Corporate Standard Operating Procedures.
  7. Perform after hours maintenance and/or on-call duties, on average, twice a week.
  8. On-call duties includes monitoring and response to critical monitoring database alerts.
  9. Database support of product releases, which are scheduled once a week, working with product developers and production operations (DevOps).

 

 

OTHER DUTIES AND RESPONSIBILITIES:

 

  1. Provide support to IT Operations teams in other locations.
  2. Ability to travel (including international) to other locations. 

The duties and responsibilities listed in this job description represent the major responsibilities of the position. Other duties and responsibilities may be assigned, as required. This job description and any attachments do not constitute or represent a contract.

Qualifications

QUALIFICATIONS AND SKILLS NEEDED:

 

  1. College/University degree or equivalent work experience.
  2. Expert knowledge of Oracle database administration including (but not limited to) installation, management, troubleshooting, patching, upgrading, and tuning. Minimum 8 years with Oracle RDBMS experience
  3. Expert knowledge of Oracle database backups, and recovery / restores. Use of Oracle RMAN.
  4. Knowledge of systems used to monitor performance and availability of Oracle databases, such as Oracle GRID.
  5. Experienced in redundant database design, using technologies such as Oracle RAC (Real Application Clusters). Experience with technologies such as Oracle DataGuard for use in failover and Disaster Recovery situations.  Minimum 5 years of experience with Oracle RAC.
  6. High level of proficiency in Linux Operating Systems required. Minimum 10 years of experience with Linux or Unix system administration experience
  7. Demonstrated experience in the use of Oracle PL / SQL scripting for task automation.
  8. Demonstrated experience in the use of shell scripting
  9. Understanding of basic project management, such as project planning and time management.
  10. Strong interpersonal skills needed to effectively communicate with customers and business stakeholders.
  11. Strong troubleshooting skills and ability to perform root cause analysis.
  12. Ability to understand and adapt to ERT’s IT environment. Stay current with IT technologies and industry trends.
  13. Knowledge of Microsoft SQL Server, PostgreSQL, MongoDB, AWS RedShift, other AWS RDA platform service a plus.

 

We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law.

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed

Connect With Us!

Not ready to apply? Connect with us for general consideration.