KNOWLEDGE BUILDERS
HBITS Database Architect - Expert
KNOWLEDGE BUILDERS - Albany, New York, us, 12237
Work at KNOWLEDGE BUILDERS
Overview
- View job
Overview
Job Description
Database Architect - Expert
New York State Electronic Certificate of Need (NYSE-CON)
This Database Architect position will function as Oracle database architect and developer for the NYSE-CON project.
Day to Day Tasks
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.
Mandatory Qualifications
Database Architect - Determines database structural requirements by analyzing client operations, applications, and programming; reviews objectives with clients; evaluates current systems; provides database support by coding utilities, responding to user questions, and resolving problems.
Expert - 84+ months: Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.
Requested Qualifications
- 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 of experience developing using Oracle PL/SQL, including database packages, procedures, functions and triggers. - 84 Months of experience in working with Oracle version 11g or later. - 84 Months of experience in using Oracle programming tools (SQL*Plus, SQL*Loader or other Oracle database programming tools). - 60 Months of experience in designing relational databases. - 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. - 24 Months of experience in integrating multiple database schemas.
Database Architect - Expert
New York State Electronic Certificate of Need (NYSE-CON)
This Database Architect position will function as Oracle database architect and developer for the NYSE-CON project.
Day to Day Tasks
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.
Mandatory Qualifications
Database Architect - Determines database structural requirements by analyzing client operations, applications, and programming; reviews objectives with clients; evaluates current systems; provides database support by coding utilities, responding to user questions, and resolving problems.
Expert - 84+ months: Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.
Requested Qualifications
- 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 of experience developing using Oracle PL/SQL, including database packages, procedures, functions and triggers. - 84 Months of experience in working with Oracle version 11g or later. - 84 Months of experience in using Oracle programming tools (SQL*Plus, SQL*Loader or other Oracle database programming tools). - 60 Months of experience in designing relational databases. - 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. - 24 Months of experience in integrating multiple database schemas.