Senior Database Engineer

Employer
Client
Location
Conshohocken, PA
Posted
Jul 21, 2017
Administrative Jobs
Technology, Database Administration
Jobs Outside Higher Education
Software & Technology
Institution Type
Outside Academe


Job Description

Our client has an immediate need for a Senior Database Engineer that will help build a scalable, timely, and highly available data platform to power clinical trials. Successful candidates will have built innovative data solutions and have the curiosity to try new technologies and explore new paradigms and ability to derive information from large clinical data-sets and processing then in a scalable and timely fashion with the latest available technologies.

Responsibilities:
  • Develop and implement ETL and ELT processes
  • Develop maintainable code that meets design specifications
  • Close cooperation with Software Quality Assurance team throughout the life cycle
  • ETL and database performance tuning
  • Design and optimize queries, write complex stored procedures and/or user defined functions
  • Support and maintain data and database systems to ensure service levels
  • Team with Product and Technical managers to align strategic direction
  • Processing of structured and semi-structured data

Skills/Requirements:
  • SQL Expert
  • Production experience with one or more leading databases including Oracle, MySQL, SQLServer, Postgres or DB2
  • ETL experience with at least one leading tool such as Pentaho, SSIS, Informatica or AB Initio in a large scale production environment
  • Dealt with the challenges of large relational datasets, including load performance, query performance, archiving, etc.
  • Experience with relational database design/modeling using tools
  • Linux and windows command line expertise
  • Scripting expertise, such as bash or PowerShell scripts

Additional desired skills:
  • AWS Cloud Services, including S3 and EC2
  • AWS RDS, Aurora exposure an additional plus
  • Columnar databases such as Redshift or Impala
  • Hadoop, Pig and Hive jobs
  • Message Stream Processing, such as Kafka/Kinesis to Spark/Storm
  • NoSQL databases such as DynamoDB or MongoDB
  • Experience with Clinical Trials and/or healthcare software system
  • Programming experience with a popular language such as Java, C#, Python or Ruby

Experience and Education:
  • MS / PHD in computer science or related field; or a BS in computer science or related field; or equivalent years of experience
  • Requires a minimum of 5 years relevant experience



Conshohocken, PA

dd6ade8612

Thu, 20 Jul 2017 07:52:52 PDT

PI98759288