What are the responsibilities and job description for the Senior SQL - Oracle Developer position at Jobs via Dice?
Dice is the leading career destination for tech experts at every stage of their careers. Our client, SystemDomain, Inc., is seeking the following. Apply via Dice today!
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
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.
- 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.
- 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
- 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.