Massachusetts Information Technology Jobs

Search for Jobs in Information Technology
MassHire JobQuest Logo

Job Information

Oracle Principal Database Architect-Oracle Health Sciences in Burlington, Massachusetts

Job Identification : 210006US

Job Category : Product Development

Job Locations :

Burlington, Massachusetts, United States

Oracle’s Health Sciences Group is looking for a hands-on database architect, preferably with experience in the healthcare space, to enhance its operational data and analytics infrastructure to support its growing customer base and expanding partner ecosystem.

The ideal candidate is a highly skilled individual, who can lead the design and development of operational datastore and data warehouse infrastructure that is scalable, highly performant, and able to handle diverse data sets. We are looking for a technical leader that is passionate about solving real world large scale business problems used by large health systems around the world. If you have experience designing and building large scale data warehouses, business intelligence especially around secondary use of healthcare data and are excited about leveraging your experience to catapult Oracle Health Sciences Global Business Unit into hyper-growth, this job is for you.

Responsibilities:

  • Provide architectural and hands on technical guidance to highly skilled data modelers, ETL, and BI developers.

  • Develop design standards and guidelines, and mentor other architects and engineers on database best practices and performance tuning

  • Design, model, and lead the building of a secure healthcare/life science focused transactional systems, operational data, warehouse and downstream marts, with privacy controls.

  • Enhance and modernize platform for Oracle Healthcare and associated applications.

  • Provide key input into build/buy/partner decisions for all components of the data infrastructure.

  • Heavy collaboration with geographically dispersed development team providing technical leadership and designs.

  • Collaborating with product management and acting as the bridge between product management, engineering teams, and customers to understand requirements and technical solutions

  • Skills and Experience:

  • 10+ years of experience in Oracle Database Administration and implementation

  • Strong understanding of relational database and Data warehousing concepts.

  • Strong understanding and experience in Oracle database indexing, optimizer, query and memory tuning and effective partitioning, analysis of AWR, ADDM, ASH, SQLTRPT, AWRRPT, TKPROF reports

  • Hands on experience in Oracle performance optimizations, understanding explain plans, redo logs/checkpoint tuning, ability to work with global teams and help advice and code database performance enhancements.

  • Experience in using Oracle database 12c multi-tenant features.

  • Database design for cloud solutions (0 downtime DB upgrades, scaling databases)

  • Strong understanding and experience in dimensional modeling, data analysis, OLTP, data warehouse and business intelligence solutions

  • Strong implementation experience of logical and physical models in 3NF and star schemas

  • Strong communication, team leadership and project management skill

  • BS/MS in Computer Science or relevant experience working with database

  • Experience in the clinical trial/pharma industry is a big plus.

Analyze, design develop, troubleshoot and debug software programs for commercial or end user applications. Writes code, completes programming and performs testing and debugging of applications.

As a member of the software engineering division, you will analyze and integrate external customer specifications. Specify, design and implement modest changes to existing software architecture. Build new products and development tools. Build and execute unit tests and unit test plans. Review integration and regression test plans created by QA. Communicate with QA and porting engineering to discuss major changes to functionality.

Work is non-routine and very complex, involving the application of advanced technical/business skills in area of specialization. Leading contributor individually and as a team member, providing direction and mentoring to others. BS or MS degree or equivalent experience relevant to functional area. 7 years of software engineering or related experience.

About Us

Innovation starts with inclusion at Oracle. We are committed to creating a workplace where all kinds of people can be themselves and do their best work. It’s when everyone’s voice is heard and valued, that we are inspired to go beyond what’s been done before. That’s why we need people with diverse backgrounds, beliefs, and abilities to help us create the future, and are proud to be an affirmative-action equal opportunity employer.

Oracle is an Equal Employment Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability and protected veterans status, age, or any other characteristic protected by law. Oracle will consider for employment qualified applicants with arrest and conviction records pursuant to applicable law.

DirectEmployers