Job Title: Oracle APEX Developer

Location: Richmond, VA (Onsite)

Duration: 12 months

Core Responsibilities:

1. DPU Application Design Components
   • Design and develop a responsive point of sale (POS) solution using Oracle APEX
   • Develop intuitive user interfaces for checkout workflows, inventory management, and sales reporting
   • Implement responsive design principles to ensure the application works on various devices
2. Payment Gateway Integration for DPU Payments 
   • Integrate Elavon payment gateway solutions to allow online, in-store, and mobile payments Elavon
   • Implement secure credit card processing and tokenization
   • Configure multi-currency support and payment method options
   • Develop and test transaction workflows for authorization, capture, refunds, and void operations
3. Database Development
   • Design and implement database structures to support POS operations
   • Write re-usable, readable code using SQL and PL/SQL following the most up-to-date industry standards
   • Create stored procedures, functions, and packages to implement business logic
   • Optimize database performance for transaction-heavy POS operations
4. Security Implementation
   • Organize, protect, and maintain the security of the Oracle APEX platform
   • Implement PCI DSS compliance requirements for payment processing
   • Develop secure authentication and authorization systems
   • Create audit trails and monitoring processes for financial transactions
5. Testing and Deployment
   • Perform unit testing, integration testing, and user acceptance testing
   • Design, develop, unit test, and work with testers to ensure application quality
   • Create deployment plans and procedures for production environments
   • Develop documentation for system operations and user training
6. Integration and API Development
   • Develop integration with Elavon
   • Create and consume RESTful APIs for external system communication
   • Implement batch processing for high-volume transaction processing
   • Design failover and recovery procedures for payment processing
7. Reporting and Analytics
   • Design customizable reporting options for management needs
8. Support and Maintenance
   • Work closely with product owners and business analysts to ensure acceptance criteria are accurately captured
   • Provide technical support for the POS system
   • Troubleshoot and resolve issues with payment processing and AR integration
   • Implement system enhancements and updates as requirements evolve

Required Technical Skills:

1. Core Technologies
   • Oracle APEX (version 19.x or later)
   • PL/SQL and SQL development
   • JavaScript, jQuery, and CSS
   • RESTful web services
   • Oracle database management
2. Payment Processing Knowledge
   • Elavon payment gateway API integration
   • Payment Card Industry Data Security Standard (PCI DSS)
   • Transaction processing workflows
   • Tokenization and encryption methods
3. Additional Skills
   • API development and consumption
   • Performance optimization techniques
   • Error handling and logging best practices
   • UI/UX design principles for POS systems

This job description provides a comprehensive overview of the responsibilities for an APEX developer focused on creating a point of sale solution with Elavon and Oracle AR integration. The position requires both technical development skills and knowledge of payment processing and financial systems.