Senior SQL Oracle Developer

• 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 of 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 client's technical environment will be advantageous.
• Bachelor s degree in information technology, Data Analytics, Computer Science with 8 -10 years of relevant experience