Senior Oracle Database Architect & PL/SQL Developer- Albany, NY (Hybrid)

Job Description:

This Database Architect position will function as Oracle database architect and developer for the project.

Tasks may include but are not limited to the following:

• Analysis and design of database objects and data collection systems, including the transformation of legislative requirements into system functionality;
• Data modelling;
• Software development tasks including Oracle PL/SQL coding, testing, and implementation;
• Troubleshooting issues in the application to find solutions;
• Preparation of technical and user documentation.

Sr. no. Skills Required
Required experience

(in months)

Experience you have

( in months)
1 84 Months of experience in interpreting physical database models and experience with relational database concepts such as indexes, primary and foreign keys, and constraints using Oracle. 84 Months 2 84 Months of experience developing using Oracle PL/SQL, including database packages, procedures, functions and triggers. 84 Months 3 84 Months of experience in working with Oracle version 11g or later. 84 Months 4 84 Months of experience in using Oracle programming tools (SQL*Plus, SQL*Loader or other Oracle database programming tools). 84 Months 5 60 Months of experience in designing relational databases. 60 Months 6 48 Months of experience in using at least 2 of the following techniques in Oracle PL/SQL: dynamic SQL, FORALL and BULK COLLECT, SYS_REFCURSOR, SYS_CONTEXT, and PL/SQL logging. 48 Months 7 24 Months of experience in integrating multiple database schemas. 24 Months