What are the responsibilities and job description for the ORacle Developer position at Uniplus Consultants Inc?
Job Details
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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.