What are the responsibilities and job description for the Oracle Developer position at CIS Technologies Inc.?
Title: Oracle Developer
Location: Lansing, MI (Local candidates preferred. Non-local candidates must relocate at their own expense from acceptance and be onsite from day 1)
Duration: 12-18 months (Mid Term) - Hybrid
Employment Mode: Full Time
What You'll Do / Key Responsibilities
- Design, develop, and maintain Oracle database objects, including tables, views, indexes, triggers, and constraints.
- Develop and optimize PL/SQL packages, procedures, and functions to support business logic, data services, and ETL processes.
- Support logical and physical data modeling activities, including database normalization.
- Lead and execute data migration and data conversion tasks for new implementations, upgrades, and system integrations.
- Develop and consume SOAP and/or REST web services for data integrations between internal systems and vendor-hosted COTS solutions.
- Analyze data and metadata to ensure accuracy, integrity, and compliance with applicable agency standards.
- Collaborate with Data Architects and Database Administrators on performance tuning, code reviews, and database best practices.
- Troubleshoot data issues, identify root causes, and implement corrective solutions.
- Participate in planning, estimation, documentation, and technical design sessions for new projects and ongoing maintenance activities.
Required Qualifications
- 8 years of Oracle PL/SQL development experience, including packages, procedures, and functions.
- 8 years of experience using Oracle development tools such as Toad or SQL Developer.
- 8 years of experience designing, creating, and maintaining Oracle database objects.
- 8 years of experience with logical and physical data modeling and database normalization.
- 8 years of experience in data analysis, data quality, and metadata management.
- 8 years of experience developing and integrating web services using SOAP and/or REST.
- 8 years of experience with database programming for data migration and data conversion.
Experience supporting or integrating vendor-hosted or COTS systems.