Oracle Developer

RICEFW Technologies Inc; Providence (RI); On-site; USD 110,000 - 150,000; Full time

Job summary

RICEFW Technologies Inc, based in Providence, RI, seeks a Senior SQL Developer who loves data analysis and designing, implementing, and working in diverse systems. You will partner with experienced leads and business resources to deliver robust solutions and scalable database-driven reporting.

Expectations include 8–10 years of Oracle experience, expertise in PL/SQL, data modelling, ETL (Informatica/Pentaho), and proficiency with Tableau/Power BI.

Qualifications

• 8–10 years Oracle DB experience and strong SQL/PLSQL.
• Data modelling and large data sets expertise.
• Experience with ETL tools (Informatica/Pentaho).

Responsibilities

• Design, implement and maintain database-driven reporting.
• Collaborate with leads and business resources.
• Optimize SQL performance and troubleshoot complex DML.

Skills

Data analysis

SQL proficiency

Problem solving

Team collaboration

Communication

UML

Tools

Tableau

Power BI

TOAD

SQL Developer

SQL Navigator

Git

Jenkins

JIRA

ServiceNow

Informatica

Pentaho

Job description

Required Skills:

Client is looking for a Senior SQL Developer who has a passion for analyzing data, working with software and learning new technologies. The developer will be working directly with experience leads, and business resources to deliver quality solutions. You will be involved with designing, implementing and working in various systems.

Database and Programming Proficiency:

• Minimum of 8 - 10 years of experience with Oracle databases, capable of writing complex SQL queries and developing complex PL/SQL objects, including DML and DDL.
• Strong experience with database and SQL performance tuning.
• Proficient in data modelling and data visualization tools (Preferred Tableau/Power BI)
• Working knowledge of ETL practices (Extract, Transform, and Load) (Preferred - Informatica, Pentaho)

• Excellent understanding of database management systems (DBMS)
• Strong troubleshooting debugging skills with complex DML
• Expert level SQL querying and database manipulation with very large data sets
• Ability to debug and troubleshot logical and functional coding errors

Development Tools and Methodologies:

• Familiarity with code repositories, ideally Git.
• Experience with continuous integration tools, preferably Jenkins.
• Knowledge of relational database designs, ISDM methodologies, database security (role-based), and query tools like TOAD, SQL Developer, or SQL Navigator.

Technical and Analytical Skills:

• Proficiency in Unified Modeling Language (UML) for documenting system architecture.
• Ability to solve complex problems creatively and anticipate issues with software designs or specifications.
• Excellent interpersonal skills to establish effective working relationships, collaborate with team members, and communicate technical concepts clearly.

Preferred Knowledge, Skills & Abilities:

• 5 Years of Integrated Eligibility/Healthcare domain experience. Experience developing reports submitted to federal agencies. (SNAP/TANF/Medicaid)

• Design, Develop, Maintain, and support of various database-driven reporting initiatives

• Strong Data Validation, Quality Assurance, and Referential Integrity skills

• Experience with Enterprise Workflow Management Tools such as JIRA and ServiceNow

• Advanced Understanding to Data Visualization Technologies such as Tableau

Certifications and Agile Practices:

• Oracle certification(s) are a plus.
• Familiarity with Agile methodologies, particularly Scrum, XP, and Kanban.

Web and Front-End Development

Industry Knowledge:

• Experience with environmental regulatory processes is beneficial.
• Understanding of the client's technical environment will be advantageous.