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<