Oracle Database Developer

POSITION OVERVIEW

We are seeking an experienced Oracle Database Developer with expertise in SQL, PL/SQL, and hands-on experience working with AWS data services and Integration Platform as a Service (iPaaS) tools such as Boomi. The ideal candidate while ensuring seamless integration across cloud environments and enterprise systems. This role requires strong analytical skills, a deep understanding of relational databases, and the ability to work with modern cloud-based and integration solutions.

Diversity, Equity, and Inclusion Statement

At NBME, we continue to innovate and improve how we fulfill the evolving needs of the health care community. This commitment starts and ends with the people at NBME. By recruiting and empowering talented individuals from various disciplines and backgrounds, which includes professionals with diverse life experiences, abilities, and perspectives, NBME can take a well-informed, robust approach to advancing medical education and assessment for years to come. We also continue to focus on ensuring that our DEI work is impactful and ingrained in everything we do, including with our staff, workplace culture, products and services, the Philadelphia community and the broader medical education landscape.

RESPONSIBILITIES

• Database Design and Development:
  • Develop, optimize, and maintain complex SQL queries, PL/SQL procedures, functions, packages, and triggers.
  • Design and implement relational database schemas and ensure efficient table design and indexing strategies.
• AWS Data Services Integration:
  • Work with AWS persistent data store services such as S3, DynamoDB, DocumentDB, or other database technologies to migrate our legacy Oracle schema designs to cloud-based workflows.
  • Implement data pipelines using tools like AWS Glue, DataSync, or Step Functions.
• Performance Tuning:
  • Analyze and optimize database performance, including query tuning and resource management.
  • Troubleshoot database and integration issues to ensure high availability and reliability.
• Data Integration and iPaaS Expertise:
  • Develop and maintain integrations between Oracle databases and other enterprise systems using Boomi or similar iPaaS tools.
  • Build workflows, APIs, and connectors in Boomi or similar iPaaS tools to streamline data exchange between systems.
  • Ensure data synchronization across on-premises, cloud, and hybrid environments.

• XML / JSON Processing and Schema Design
  • Processing JSON or XML and transformations
  • Define and maintain JSON or XML schemas

• Documentation and Best Practices:
  • Prepare technical documentation for database processes, integrations, and workflows.
  • Promote best practices for database development, integration, security, and performance.

• Collaboration:
  • Work closely with cross-functional teams, including developers, data engineers, integration specialists, and cloud architects, to deliver end-to-end solutions.

QUALIFICATIONS

Skills & Abilities

• Proven experience as an Oracle Database Developer with strong SQL and PL/SQL programming skills.
• Experience designing and optimizing database schemas and objects (views, indexes, partitions, etc.).
• Hands-on experience with AWS data services (S3, DynamoDB, DocumentDB, Glue, or Data Pipeline).
• Expertise with iPaaS tools such as Boomi, including designing and deploying integrations.
• Knowledge of ETL tools and processes, particularly in cloud and hybrid environments a plus
• Experience with API development and integration workflows using Boomi or similar platforms.
• Excellent problem-solving and communication skills.
• 8 or more years of experience in an engineering or software project leadership role as an individual contributor demonstrating progressively increasing responsibility.

Education and Certifications

• Bachelor's degree in computer science, Information Technology, or a related field
• Agile Certifications: nice to have
• AWS Certification(s): nice to have

NBME offers a versatile selection of high-quality assessments and educational services for students, professionals, educators, regulators and institutions dedicated to the evolving needs of medical education and health care. To ensure our assessments meet the highest standards of quality, stay relevant and align to the current curriculum in medical schools and training programs, we rely on a wide network of collaborators. These include the volunteers who help develop our exam questions, the committees and panels who represent various groups within the medical education community, external researchers and health profession organizations.

We are committed to meeting the needs of educators and learners globally with assessment products and expert services such as NBME® Subject Examinations, Customized Assessment Services, Self-Assessments, the International Foundations of Medicine® Program and Item Writing Workshops. Together with the Federation of State Medical Boards, NBME develops and manages the United States Medical Licensing Examination®, which measures the ability to apply knowledge and skills that form the basis of safe and effective patient care. Our Competency-based Assessment unit is focused on new methods as well as the optimization of assessment in the workplace and education.

As a result of leadership in ongoing research, innovative measurement practices and the exploration of forward-thinking assessment modalities and improvements, NBME advances assessment science. Our grant and funding opportunities further support this dedication to medical education and assessment science. We help develop the next generation of assessment professionals through our Summer Psychometric Internship Program. Through the Stemmler Fund, Strategic Educators Enhancement Fund and Latin America Grants Program, researchers and educators can continue to improve the assessment of health care professionals around the world.

NBME views diversity, equity and inclusion (DEI) as foundational and enduring to our strategy and vision. We continue to focus on ensuring that our DEI work is impactful and ingrained in everything we do, including with our staff, culture, products and services, the Philadelphia community and the broader medical education landscape. Our commitment manifests in our hiring and staff development, recruitment for committees, grants programs, design and review of our assessments, and involvement in our local and national communities.

Learn more about NBME at NBME.org.

Compensation we are offering for this position is at $130,640- 165,000/year. Please note that the offered rate for this position typically aligns with the minimum to midrange of this grade, but it can vary based on the successful candidate's qualifications and experience, department budget, and an internal equity review.

The NBME offers competitive salaries, excellent benefits, and a rewarding work environment.

Excellent Benefits include: Healthcare, Dental, Prescription, and Vision plans; 401(k) w/match, Tuition Reimbursement Plan, Commuter Benefit: Public Transit or Parking options. Remote Friendly Workplace.

NBME is an equal opportunity employer as defined by the EEOC.

Salary : $130,640 - $165,000