Design, develop, and maintain Oracle APEX applications that align with DTA’s business needs and data strategy.
Develop user interfaces, workflows, and application functionalities to ensure a seamless user experience.
Configure application features and functionalities, making use of Oracle database features and APEX components.
Data Integration and Reporting
Implement new reporting features, dashboards, and data visualizations within APEX applications as per business requirements.
Work with data engineering teams to integrate data from the DTA Data Warehouse and external data sources, ensuring efficient data flows.
Design and develop data-driven features that support reporting and analytics, leveraging tools like Snowflake, Informatica, and Splunk as needed.
Testing, Troubleshooting, and Optimization
Conduct unit testing and assist with end-to-end testing, ensuring APEX applications meet functional and performance requirements.
Troubleshoot application issues and bugs, providing timely resolutions to maintain high application reliability.
Continuously optimize application code, database queries, and data processing to improve application performance and scalability.
Documentation and Support
Develop and maintain system documentation, including application design documents, data dictionaries, and configuration guides.
Create user guides and provide training to end-users on application functionalities.
Provide technical support and respond to inquiries from users and stakeholders, ensuring a high level of satisfaction with APEX applications.
Research and Implementation of Best Practices
Stay updated on advancements in Oracle APEX, Oracle database features, and data warehousing technologies.
Identify opportunities to implement new features, tools, or best practices to enhance application functionality and efficiency.
Work with IT and data strategy teams to explore cloud-based data tools and technologies, especially Snowflake, to improve scalability and data accessibility.