Oracle PL/SQL Developer Job at Smart IMS Inc, Lansing, MI

MXBNbExLdkhDVmFtRklMK2VDbmFGVnBwcWc9PQ==
  • Smart IMS Inc
  • Lansing, MI

Job Description

Job Title: Oracle PL/SQL Developer

Duration (Contract): 12 Months

Client Location: Lansing, MI 48933

Location Preference: Hybrid

Job Description

As an Oracle PL/SQL Developer, you will be responsible for designing, developing, and supporting enterprise data solutions within an Oracle database environment. This role focuses on database development, data modeling, ETL processes, system integrations, data quality, and performance optimization while supporting critical agency applications and vendor-hosted solutions.

Key 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 supporting enterprise applications.

  • Support logical and physical data modeling efforts, 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.

Required Skills, Experiences, Education, and Competencies

  • 8+ years of Oracle PL/SQL development experience including packages, procedures, functions, triggers, and advanced SQL programming.

  • 8+ years of experience using Oracle development tools such as TOAD, SQL Developer, or equivalent platforms.

  • 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.

  • 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 (Commercial Off-The-Shelf) solutions.

  • Strong database troubleshooting, performance tuning, and optimization skills.

  • Ability to work independently while providing technical leadership and collaborating with cross-functional teams.

Preferred Qualifications

  • 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.

The hourly range for roles of this nature are $40.00 to $80.00/hr. Rates are heavily dependent on skills, experience, location, and industry.

cyberThink is an Equal Opportunity Employer.

Job Tags

Hourly pay, Contract work

Similar Jobs

Cornerstone Caregiving

Home Care Aide $19-$40 p/hour Job at Cornerstone Caregiving

 ...We are looking for compassionate individuals to join our team as Home Care Aides. Whether youre looking for a few hours a week or a full...  ...4/7 to back you up. What Youll Do Youll help our clients stay safe and happy at home by assisting with: Personal care (... 

PMG

Influencer & Branded Content Senior Associate Job at PMG

 ...integrates business strategy, media, creative, and data within a single...  ...measurable results across social, digital, and experiential...  ...develop and execute influencer marketing programs that seamlessly align...  ...mentoring and guiding Associate-level team members, providing support... 

Royal Bank of Canada

Senior Analyst, Global Investment Banking, FIG Job at Royal Bank of Canada

 ...Job Description What is the opportunity? The role will support the Investment Banking Financial Institutions Team in New York What will you do? Transaction execution, new business presentations and meetings, and other such duties Working with Associates... 

Quaker Windows

Manufacturing Production Associate Job at Quaker Windows

 ...strong work ethicAbility to lift up to 50 lbs (with or without reasonable accommodation)Willingness to learn new skillsManufacturing or factory experience is helpful, but not requiredAvailable ShiftsWeekend: Friday through Sunday, 6:00AM to 6:30 PMDay: Monday through Friday,... 

Limitless East Marketing

Event Staff Job at Limitless East Marketing

 ...ensuring measurable results for your brand. Job Description Job Description : We are seeking motivated and enthusiastic Event Staff to join our dynamic team and help deliver exceptional experiences at a wide range of events. As an integral part of our event...