Skip to main content

Search jobs

Search jobs

About AbbVie

AbbVie’s mission is to discover and deliver innovative medicines that solve serious health issues today and address the medical challenges of tomorrow. We strive to have a remarkable impact on people’s lives across several key therapeutic areas: immunology, oncology, neuroscience, eye care, virology, women’s health and gastroenterology, in addition to products and services across its Allergan Aesthetics portfolio. For more information about AbbVie, please visit us at www.abbvie.com. Follow @abbvie on Twitter, Facebook, Instagram, YouTube and LinkedIn.

Oracle Developer

Lake County, Illinois Req ID 2204634 Category Information Technology Division AbbVie

ABOUT THE COMPANY:

AbbVie (NYSE:ABBV) is a global, research-based biopharmaceutical company formed in 2013 following separation from Abbott Laboratories. The company's mission is to use its expertise, dedicated people and unique approach to innovation to develop and market advanced therapies that address some of the world's most complex and serious diseases. AbbVie employs approximately 48,000 people worldwide and markets medicines in more than 170 countries.

 

POSITION DESCRIPTION:

The Data Solutions Department within the Information Research (IR) Division is building the next generation of data management and decision support tools and services to optimize the efficiency and efficacy of research and development at AbbVie.

 

The Database Engineer is a critical technical role for AbbVie within the Data Solutions department. This position provides a combination of thought leadership and execution in the ongoing design, development and delivery of AbbVie’s Discovery and Preclinical Development data warehouses.  This position provides the tactical IT leadership to achieve business and enterprise operating objectives, including support of key business solutions in the preclinical space.  Key responsibilities include the technical stewardship for AbbVie’s preclinical data warehouses, PL/SQL development and providing oracle leadership within Data Solutions. Provide solutions to performance related issues and work with downstream systems to support data driven demands.  Escalate open issues to ensure execution success and keeps stakeholders informed through effective verbal and written communication. Responsible for modifying existing software to correct errors and/or improve performance.

 

Key Responsibilities

  • Business Knowledge – knowledge in Drug Discovery or Drug Development is important
  • Collaborative Design – you should find it inspiring to work with a wide variety of colleagues (e.g., data scientists, developers, scientists); understand their needs and then propose and build solutions
  • Build – through your own efforts and by working with other database engineers, develop custom solutions/processes that contribute to and help foster the growing AbbVie data integration environment
  • Adaptability – given our diverse mission you should be able to move fluidly between different project responsibilities
  • Breadth – as a talented and motivated Database Engineer, you can contribute to a wide variety of missions related to enhancing drug discovery and development
Qualifications:

Qualifications:

  • Working knowledge of the drug discovery and/or drug development process is desired
  • Responsible for having a concise understanding of the end to end operational data warehouses, including system integrations, data quality and harmonization rules, as well as an understanding of downstream information consumption
  • Have the necessary skills and experience to both design and develop ETLs in PL/SQL (using materialized views, packages, procedures, triggers, functions etc.)
  • Experience in advanced analytical SQL and performance tuning SQL queries in Oracle are required.
  • Experience using python for file processing and orchestrating data pipelines.
  • Experience replicating data from other databases (MySQL/MS SQL Server/Hadoop) to Oracle is desired.
  • Demonstrated expertise with Oracle required, MS SQL Server, My SQL is a plus
  • Dedicated team player who can interface with stakeholders from a variety of internal IT disciplines (infrastructure, DBAs, architects, data scientists, etc.)
  • Proficient in python scripting (preferred) or Unix shell scripting
  • Experience using latest features in Oracle including but not limited to JSON and XML data processing is a plus.
  • A self-motivated learner and thinker with a hands-on approach
  • An analytical mind with outstanding interpersonal, verbal and written communication skills

 

**Equal Opportunity Employer Minorities/Women/Veterans/Disabled**

 

Significant Work Activities: Continuous sitting for prolonged periods (more than 2 consecutive hours in an 8 hour day)
Travel: No
Job Type: Experienced
Schedule: Full-time
ABBVIE

Most recent jobs

Sign up for job alerts

Join our talent network and receive AbbVie news and job alerts to your inbox.

Interested InPlease select a category or location option. Click “Add” to create your job alert.

  • Information Technology, Lake County, Illinois, United StatesRemove

Our Terms of Use, Cookie Policy and Privacy Policy explain how we collect and use information about you and the rights you have. By submitting your information, you acknowledge you have read those documents and consent to receive SMS communications and email jobs alerts from AbbVie.

Recently viewed jobs

You have not viewed any jobs recently.

Phishing scam alert

As an online job seeker, you could be a target of cyber (online) thieves seeking to secure personal information from you by sending you “phishing” messages.

Please be alert to and protect yourself from phishing scams. Find out how you can avoid being a victim of job phishing scams.

For Internal Candidates only - Notice of Filing of Labor Condition Application

Equal Employment Opportunity | Reasonable Accommodation