Sr. SQL Developer

Sr. SQL Developer

Location: Providence RI On-site

Duration: 12 months

Interview: Virtual and in-person

Note:

Local with DL copy

LinkedIn with location

Required Skills:
Database and Programming Proficiency:

• Minimum of 8 - 10 years of experience with Oracle databases capable of writing complex SQL queries and developing complex PL/SQL objects including DML and DDL.
• Strong experience with database and SQL performance tuning.
• Proficient in data modelling and data visualization tools (Preferred Tableau/Power BI)
• Working knowledge of ETL practices (Extract Transform and Load) (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
• Ability to debug and troubleshot logical and functional coding errors

Development Tools and Methodologies:

• Familiarity with code repositories ideally Git.
• Experience with continuous integration tools preferably Jenkins.
• Knowledge of relational database designs ISDM methodologies database security (role-based) and query tools like TOAD SQL Developer or SQL Navigator.

Technical and Analytical Skills:

• Proficiency in Unified Modeling Language (UML) for documenting system architecture.
• Ability to solve complex problems creatively and anticipate issues with software designs or specifications.
• Excellent interpersonal skills to establish effective working relationships collaborate with team members and communicate technical concepts clearly.

Preferred Knowledge Skills & Abilities:

• 5 Years of Integrated Eligibility/Healthcare domain 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 to Data Visualization Technologies such as Tableau

Certifications and Agile Practices:

• Oracle certification(s) are a plus.
• Familiarity with Agile methodologies particularly Scrum XP and Kanban.

Web and Front-End Development:

• Experience in XML CSS and JavaScript frameworks (such as JQuery AngularJS NodeJS or React) for web development.

Industry Knowledge:

• Experience with environmental regulatory processes is beneficial.
• Understanding of the clients technical environment will be advantageous.
• Bachelors degree in information technology Data Analytics Computer Science with 8 -10 years of relevant experience