Database Architect - Oracle/SQL Server, PL/SQL & T-SQL

GENESYS Consulting Services, Inc.; City of Albany (NY); On-site; USD 83,000 - 152,000; Full time

Job summary

GENESYS Consulting Services, Inc. is offering a 30-month HBITS contract with the State of New York. The role requires extensive Oracle and SQL Server experience, strong database design and integration skills, and familiarity with Git for version control.

The position is based in Albany, NY, and may extend based on project needs. The ideal candidate will have hands-on expertise in relational databases, Oracle PL/SQL development, T-SQL, and current Oracle tools, contributing to complex data

Qualifications

• 84+ months interpreting physical database models and relational concepts.
• 84+ months developing with Oracle PL/SQL (packages, procedures, functions, triggers).
• 84+ months working with Oracle 11g or later.
• 84+ months using Oracle programming tools (SQL*Plus, SQL*Loader or equivalents).
• 60+ months developing using Microsoft Transact-SQL (T-SQL).
• 60+ months designing relational databases.
• 24+ months integrating multiple database schemas.
• 18+ months using Git.

Tools

SQL*Plus

SQL*Loader

Job description

GENESYS Consulting Services, Inc. is offering a 30-month HBITS contract with the State of New York. The role requires extensive Oracle and SQL Server experience, strong database design and integration skills, and familiarity with Git for version control.

The position is based in Albany, NY, and may extend based on project needs. The ideal candidate will have hands-on expertise in relational databases, Oracle PL/SQL development, T-SQL, and current Oracle tools, contributing to complex data