Senior SQL - Oracle Developer

Providence, RI, US • Posted 3 hours ago • Updated 1 hour ago
Full Time
Part Time
On-site
Fitment

Dice Job Match Score™

📋 Comparing job requirements...

Job Details

Skills

  • PL/SQL
  • Oracle SQL Developer
  • DML (Data Manipulation Language)
  • SQL Performance Tuning
  • Relational Database Management System (RDBMS)

Summary


Senior SQL Oracle Developer

Location: Providence, RI (Local Candidates only)

Duration: Long-Term

Position Summary

We are seeking an experienced Senior SQL Oracle Developer with extensive expertise in Oracle database development, SQL/PL-SQL programming, data modeling, and reporting solutions. The ideal candidate will collaborate with technical leads, business stakeholders, and cross-functional teams to design, develop, optimize, and maintain enterprise database applications while ensuring high performance, data integrity, and scalability.

Key Responsibilities

  • Design, develop, maintain, and support database-driven applications and reporting solutions.
  • Develop complex SQL queries, PL/SQL packages, procedures, functions, triggers, and database objects.
  • Optimize SQL queries and database performance through effective tuning techniques.
  • Design and maintain database schemas, data models, and relational database structures.
  • Troubleshoot and resolve complex database and application issues involving DML and DDL operations.
  • Develop ETL processes for extracting, transforming, and loading enterprise data.
  • Perform data validation, quality assurance, and ensure referential integrity across database systems.
  • Collaborate with business analysts and technical teams to gather requirements and deliver scalable solutions.
  • Maintain database security, access controls, and role-based permissions.
  • Utilize version control systems and CI/CD tools for deployment and code management.
  • Document database architecture and technical designs using UML and related methodologies.
  • Participate in Agile development processes including Scrum, Kanban, and sprint planning activities.

Required Qualifications

  • Bachelor's degree in Computer Science, Information Technology, Data Analytics, or a related field.
  • 8-10 years of experience working with Oracle databases and SQL/PLSQL development.
  • Strong expertise in writing complex SQL queries and developing PL/SQL objects.
  • Experience with database performance tuning and query optimization.
  • Strong understanding of relational database management systems (RDBMS) and database design principles.
  • Experience with data modeling and reporting solutions.
  • Strong debugging, troubleshooting, and analytical problem-solving skills.
  • Experience working with very large datasets and high-volume transactional systems.

Technical Skills

  • Oracle Database Development
  • SQL and PL/SQL Programming
  • Database Performance Tuning
  • Data Modeling
  • ETL Development (preferred: Informatica or Pentaho)
  • Tableau or Power BI
  • Git Version Control
  • Jenkins CI/CD
  • TOAD, SQL Developer, or SQL Navigator
  • UML Documentation
  • Database Security and Role-Based Access Control

Preferred Skills

  • Experience with enterprise workflow management tools such as JIRA and ServiceNow.
  • Experience with data validation, quality assurance, and referential integrity.
  • Experience developing regulatory or compliance reporting solutions.
  • Knowledge of XML, CSS, JavaScript, and modern JavaScript frameworks such as jQuery, AngularJS, Node.js, or React.
  • Familiarity with Agile software development methodologies.
  • Oracle certification is an added advantage.


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.
  • Dice Id: 90970922
  • Position Id: SYS - 4758-3975-1781906489
  • Posted 3 hours ago
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Providence, Rhode Island

3d ago

Easy Apply

Third Party, Contract

Depends on Experience

Marlborough, Massachusetts

3d ago

Full-time

USD 128,500.00 - 164,000.00 per year

Remote

3d ago

Full-time

USD 13,665.00 per month

No location provided

Today

Full-time

Search all similar jobs