ORacle Developer

Dice is the leading career destination for tech experts at every stage of their careers. Our client, Uniplus Consultants Inc, is seeking the following. Apply via Dice today!

This is mostly onsite role and a in-person itnerview is required at the client site in Baltimore , MD

Technical Skills/Knowledge

Oracle Database 19c, SQL optimization and performance tuning, Oracle BI Publisher, Cognos Impromptu 7.4, Oracle Developer 2000/6i Forms, Toad 25.2 for programming in PL/SQL.

Job Responsibilities

Database Development (PL/SQL Focus)

• Design, develop, and optimize high-performance database objects (tables, procedures, functions, packages) in Oracle 19c to meet evolving federal and state data collection requirements.
• Lead full-cycle development of complex data collections using expert SQL and PL/SQL, ensuring accurate implementation of federal and state business rules.
• Manage and schedule critical back-end batch jobs to create accurate data snapshots (students, teachers, attendance) for validation and reporting purposes.
• Perform proactive SQL and PL/SQL performance tuning to ensure the database system remains efficient and scalable under high load.
  
  

Systems Maintenance & Support

• Diagnose and rapidly resolve complex data quality issues and anomalies during critical collection periods, ensuring data integrity across all MODE data collections).
• Maintain and support legacy internal data collections developed in Oracle Developer 2000/6i Forms (e.g., assessment data for MCAP, MISA).
  
  

Reporting & Data Delivery

• Develop and deploy required collection reports (error detail, summary, custom) using Oracle BI Publisher.
• Maintain and update legacy reporting processes using Cognos Impromptu 7.4 and associated macro scripts.
• Design and implement PL/SQL aggregation logic to generate summary reports with aggregates across multiple subgroups, school years, LEAs, and State levels.
• Generate and validate external data exports (EDW and Local School System reports), ensuring strict adherence to specified file formats and business rules.
  
  

Business Collaboration

• Collaborate closely with MSDE Accountability team and Business Analysts to translate complex regulatory requirements (ESSA, CCR Act, Graduation, Protect our Schools Act) into robust technical specifications and system solutions.