Lead Oracle DBA/ Developer

Title : Lead Oracle DBA /Developer

Location - NYC

Duration - 6 to 12 months +

Work Mode - Hybrid ( 3 Days Onsite and 2 Days Remote )

37.5 Hours per Week hours

• Client needs a strong Oracle DBA /Developer with expertise in PL/SQL, Power BI, and BI Publisher to modernize our legacy application currently built on Oracle Forms, Oracle Reports, and PL/SQL.
• Database Development: Write, optimize, and maintain complex PL/SQL procedures, packages, triggers, and views.
• Reporting & Analytics: Develop interactive reports and dashboards using Power BI and BI Publisher to improve data visualization and decision-making.
• 5+ years in Oracle Database Administration
• 5+ years of experience in Oracle application development, including Apex and PL/SQL.
• Strong expertise in Oracle Apex 22.x or later, including Dynamic Actions, RESTful Web Services, and Interactive Reports.
• Proficiency in PL/SQL development, including performance tuning and optimization.
• Experience with Power BI and BI Publisher for data visualization and reporting.
• Hands-on experience in migrating legacy Oracle Forms and Reports applications to modern platforms.
• Knowledge of Oracle Database (12c/19c), SQL, and relational database design.
• Familiarity with APIs, RESTful web services, and JSON/XML processing in Oracle Apex. • Understanding of security best practices in Apex development, including authentication and authorization mechanisms.
• Experience in cloud-based deployment (Oracle Cloud, AWS, or Azure).
• Knowledge of JavaScript, HTML, and CSS for Apex UI customization. • Familiarity with Agile development methodologies. • Experience with CI/CD pipeline integration for Apex applications.