Principal Database Engineer

Abbott is a global healthcare leader that helps people live more fully at all stages of life. Our portfolio of life-changing technologies spans the spectrum of healthcare, with leading businesses and products in diagnostics, medical devices, nutritionals and branded generic medicines. Our 115,000 colleagues serve people in more than 160 countries.

JOB DESCRIPTION:

The key to successful treatment and full recovery is often fast, accurate diagnosis. Abbott's life-changing tests and diagnostic tools provide insights that enable smarter, faster decisions and transform the way the world is managing health.

Our pioneering technology spans the world of healthcare operations - with medical diagnostic instruments, tests, automation and informatics solutions for hospitals, reference labs, blood centers, emergency departments, physician offices and clinics.

Abbott Rapid Diagnostics is part of Abbott's Diagnostics family of businesses, bringing together exceptional teams of experts and industry leading technologies to support diagnostic testing which provides important information for treatment and management of diseases and other conditions.

The position of Principal Database Engineer is within our Infectious Disease Developed Markets business unit located at the Towne Centre site in San Diego, California. This role requires extensive hands-on, database design and coding experience, developing modern data platform and associated code utilizing Cloud native database technologies. This role will be responsible for supporting database solutions for both on market projects and new platform development. This includes handling field investigations related to data integrity/discrepancy. This position will also participate in new platform development responsible for database design and implementation.

WHAT YOU'LL DO

• Design and implement conceptual, logical, and physical data models that support business needs on Cloud-based systems.
• Propose, design and implement cost effective solution for data migration to consolidate multiple dispersed databases into common database engine. (Consolidate Mango DB, PostgreSQL, Cosmos DB and Azure SQL Database).
• Build and maintain efficient data pipeline architecture, ingress / egress data pipelines for applications, utilizing Azure Data Factory.
• Experience with multi-tenancy database design.
• Experience with database sharding strategies.
• Develop and document the data movement standards, best practices, and promote them across department.
• Conduct code and design reviews to ensure data related standards and best practices are met.
• Proactively educate others on modern data engineering concepts and design
• Guide and support junior colleagues to develop their skills.
• Work in the team following Agile - Scrum practices.
• Take responsibilities of internal activities outside of the project.
• Ability to work with geographically dispersed teams.
• Evaluate current development processes and provide recommendations for improvements.
• Understands and is aware of the quality consequences which may occur from the improper performance of the products.
• Identify key barriers/core problems and apply problem-solving skills in order to deal creatively with complex situations. Troubleshoot and resolve complex problems, and make decisions under conditions of uncertainty, sometimes with incomplete information, that produce effective end results.
• Use strong technical abilities and able to suggest multiple solutions to problems.
• Provide estimates for the development related efforts in systematic and time sensitive way.
• Carries out duties in compliance with established business policies.
• Other duties as assigned, according to the changing needs of the business.

EDUCATION AND EXPERIENCE YOU'LL BRING

Required:

• 10+ years of experience in software development involving database design.
• Bachelor of Science, Computer Engineering, Computer Science or equivalent experience (MS preferred).

Preferred:

• Experience in delivering products for the Medical Device industry.
• Experience with PostgreSQL, Azure SQL Database, Cosmos DB, Mongo DB and Snowflake.
• Developing using Python and SQL.
• Experience with RDBMS and NoSQL
• Candidate MUST have hands on experience crafting and implementing data pipelines across large scale systems.
• Experience implementing data pipelines with Azure is a must.
• Production delivery experience in Cloud based PaaS related technologies (Azure SQL Database. Cosmos DB, PostgreSQL)
• Experienced in multiple Cloud PaaS persistence technologies, and in-depth knowledge of cloud based ETL offerings and orchestration technologies.
• Experience with OLTP and OLAP.
• Experienced in stream-based and batch processing applying modern technologies.
• Database design skills including normalization/de-normalization and data warehouse design.
• Experience in Disaster Recovery procedures and geo-redundant strategies.
• Strong analytical / Debugging / Troubleshooting skills
• Understanding of Distributed File Systems (Azure Blob Storage, HDFS)
• Knowledge and understanding of relevant legal and regulatory requirements, such as SOX, PCI, HIPAA, Data Protection
• Strong Programming Experience - Python / SQL etc.
• Experience in the healthcare industry, a plus
• Collaborative and informative mentality is a must!

COMPETENCIES:

• Creates a workplace environment of mutual respect. TYakes time to explain decisions.
• Reaches across departments, organizations or geographies to best serve the customer.
• Ability to work with geographically dispersed teams across time zones.
• Hands-on experience with Agile software development
• Relational database principles and practical database development experience
• Good problem-solving skills

WHAT WE OFFER

At Abbott, you can have a good job that can grow into a great career. We offer:

• Training and career development, with onboarding programs for new employees and tuition assistance
• Financial security through competitive compensation, incentives and retirement plans
• Health care and well-being programs including medical, dental, vision, wellness and occupational health programs
• Paid time off
• 401(k) retirement savings with a generous company match
• The stability of a company with a record of strong financial performance and history of being actively involved in local communities

Learn more about our benefits that add real value to your life to help you live fully: http://www.abbottbenefits.com/pages/candidate.aspx

Follow your career aspirations to Abbott for diverse opportunities with a company that provides the growth and strength to build your future. Abbott is an Equal Opportunity Employer, committed to employee diversity.

Connect with us at www.abbott.com, on Facebook at www.facebook.com/Abbott and on Twitter @AbbottNews and @AbbottGlobal.

The salary for this role is between:

$104,300 - $208,500

JOB FAMILY:

Product Development

DIVISION:

IDDM ARDx Infectious Disease Developed Markets

LOCATION:

United States > San Diego : 4545 Towne Center Court

ADDITIONAL LOCATIONS:

WORK SHIFT:

Standard

TRAVEL:

Not specified

MEDICAL SURVEILLANCE:

Not Applicable

SIGNIFICANT WORK ACTIVITIES:

Continuous sitting for prolonged periods (more than 2 consecutive hours in an 8 hour day), Keyboard use (greater or equal to 50% of the workday)

Abbott is an Equal Opportunity Employer of Minorities/Women/Individuals with Disabilities/Protected Veterans.

EEO is the Law link - English: http://webstorage.abbott.com/common/External/EEO_English.pdf

EEO is the Law link - Espanol: http://webstorage.abbott.com/common/External/EEO_Spanish.pdf