Oracle PL/SQL Developer
About The Position
The Oracle PL/SQL Developer designs, develops, and supports enterprise data solutions in an Oracle database environment. The role focuses on database development, data modeling, ETL processes, system integrations, data quality, and performance optimization, supporting critical agency applications and vendor-hosted solutions. This is a 12-month contract role based in Lansing, Michigan, with a hybrid location preference. The developer works with Data Architects, DBAs, developers, and vendors to implement scalable data solutions and participates in planning, estimation, technical design, documentation, testing, deployment, and ongoing support.
Requirements
- At least 8 years of Oracle PL/SQL development experience, including packages, procedures, functions, triggers, and advanced SQL programming.
- At least 8 years of experience using Oracle development tools such as TOAD, SQL Developer, or equivalent platforms.
- At least 8 years of experience designing, creating, and maintaining Oracle database objects and schemas.
- Strong experience with logical and physical data modeling, database normalization, and relational database design.
- At least 8 years of experience in data analysis, data quality management, metadata management, and data governance practices.
- Extensive experience developing and integrating SOAP- and REST-based web services.
- Proven experience supporting data migration, ETL development, and data conversion initiatives.
- Experience integrating enterprise applications with vendor-hosted or COTS solutions.
- Strong database troubleshooting, performance tuning, and optimization skills.
- Ability to work independently, provide technical leadership, and collaborate with cross-functional teams.
Nice To Haves
- Experience supporting large-scale enterprise applications and government systems.
- Experience working with Data Architects and Database Administrators on enterprise data initiatives.
- Knowledge of ETL frameworks, data integration best practices, and enterprise application modernization efforts.
- Experience participating in Agile, Scrum, or structured project delivery methodologies.
- Strong analytical, communication, documentation, and problem-solving skills.
Responsibilities
- Design, develop, and maintain Oracle database objects, including tables, views, indexes, triggers, and constraints.
- Develop, enhance, and optimize PL/SQL packages, procedures, functions, and database components that support enterprise applications.
- Support logical and physical data modeling, database normalization, and data architecture initiatives.
- Lead data migration, data conversion, and integration activities for application implementations and system upgrades.
- Design and support SOAP and REST web service integrations between internal applications and vendor-hosted systems.
- Analyze data quality, metadata, and data integrity to ensure compliance with agency standards and business requirements.
- Collaborate with Data Architects, DBAs, developers, and vendors to design and implement scalable data solutions.
- Perform database performance tuning, query optimization, and code reviews.
- Troubleshoot data-related issues, conduct root-cause analysis, and implement corrective actions.
- Participate in project planning, estimation, technical design, documentation, testing, deployment, and ongoing support activities.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Career Level
Senior
Education Level
No Education Listed
