Senior SQL Developer

Delphi - Providence, RI

Full-time - Mid Level

Providence, RI

Administrative and Support Services

About the position

The Senior SQL Developer will play a crucial role in analyzing data and delivering quality solutions by collaborating with experienced leads and business resources. This position involves designing, implementing, and working with various systems, focusing on SQL querying, database manipulation, and performance tuning.

Responsibilities

• Debug and troubleshoot logical and functional coding errors
• Perform SQL querying and database manipulation with very large data sets
• Conduct database and SQL performance tuning
• Establish effective working relationships and collaborate with team members
• Communicate technical concepts clearly
• Work with relational database designs and ISDM methodologies
• Ensure database security through role-based access
• Utilize query tools like TOAD, SQL Developer, or SQL Navigator

Requirements

• Bachelor's degree in information technology, Data Analytics, or Computer Science
• 7-10 years of relevant experience
• Minimum of 7 years of experience with Oracle databases
• Strong experience with database and SQL performance tuning
• Proficient in data modeling and data visualization tools (Preferred Tableau/Power BI)
• Working knowledge of ETL practices (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
• Familiarity with code repositories, ideally Git
• Experience with continuous integration tools, preferably Jenkins
• Knowledge of relational database designs and database security

Nice-to-haves

• 5 Years of Integrated Eligibility 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 of Data Visualization Technologies such as Tableau
• Oracle certification(s)
• Familiarity with Agile methodologies, particularly Scrum, XP, and Kanban