What are the responsibilities and job description for the Senior SQL - Oracle Developer position at SystemDomain, Inc.?
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.