Oracle Database Developer - Amazon Relational Database Service

Summary

The Center for Biomedical Informatics (CBMI) at Harvard Medical School is looking for a database developer to help populate, tune and manage the data warehouses behind our research platforms. We seek an individual to work on our multidisciplinary team of data scientists, medical doctors, and developers. This individual will work directly with data stakeholders to understand their data and load it into our data warehouse. The individual will also have a chance to utilize database tuning and design skills as the project progresses.

Our team studies large and disparate datasets from the domains of biology, healthcare and social media. The goal of our efforts is to transform healthcare and research to usher in a new age of individualized data driven medicine.

We work in a constantly evolving environment, iterating through prototypes with our experts to create research tools and methods. In this rapid and open space individuals will be able to exercise creativity in developing solutions to novel problems. This requires an individual be able to work independently and explore all available options for completing tasks. This opportunity involves the development and management of an Oracle instance within Amazon’s Relational Database Service (RDS) environment. Opportunities exist to gain experience in big data storage and usage as well as various cloud technologies.

Principal Duties and Responsibilities

  • Work with domain experts to acquire data and understand how it is to be loaded into our data warehouse.
  • Utilize an existing workflow pattern to transform and load data, creating novel tools and scripts where it is needed in this process.
  • Periodically perform database tuning.
  • Assist with architectural decisions as our database needs grow.

Ideal Technical Skillset

  • 3-5 years of experience working with the Oracle DBMS including PL/SQL, stored procedures, views and other database entities.
  • Experience in query tuning and optimization utilizing indexing, partitioning and system level strategies.
  • Experience with ETL tools (Pentaho’s Kettle/Data Integration) and loading tools like SQL*Loader.
  • Experience in scripting languages like Perl or Python.
  • Experience working in “Big Data” environments.
  • Experience working in a Unix like system.

Non-Technical Skills

  • Ability to manage projects in a self-starting, nearly autonomous fashion.
  • Ability to communicate effectively both orally and in writing.