Senior SQL - Oracle Developer

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.