Onsite Database Architect - Oracle and SQL Server

JSM Consulting Inc.; City of Albany (NY); On-site; USD 110,000 - 150,000; Full time

Job summary

JSM Consulting Inc. is seeking a seasoned database professional for a 100% onsite role in Albany. The candidate will interpret physical database models, design relational schemas, and work with Oracle PL/SQL, SQL*Plus/SQL*Loader, and T-SQL to implement robust data solutions.

Strong experience with indexes, keys, and constraints is required, along with hands-on schema integration. The ideal applicant will demonstrate 7+ years of database and programming experience, with a focus on Oracle

Qualifications

• 84 Months of experience interpreting physical database models and relational database concepts including indexes, keys, and constraints.
• 84 Months of experience developing using Oracle PL/SQL, including packages, procedures, functions and triggers.
• 84 Months of experience with Oracle version 11g or later.
• 84 Months of experience using Oracle programming tools (SQL*Plus, SQL*Loader or other tools).
• 60 Months of experience developing using Microsoft T-SQL.
• 60 Months of experience in designing relational databases.
• 24 Months of experience integrating multiple database schemas.
• 18 Months of experience in using Git.

Skills

Relational database concepts

Data interpretation of physical models

Database design

Git

Tools

Oracle PL/SQL

Oracle 11g+

SQL*Plus/SQL*Loader

T-SQL (Microsoft)

Job description

JSM Consulting Inc. is seeking a seasoned database professional for a 100% onsite role in Albany. The candidate will interpret physical database models, design relational schemas, and work with Oracle PL/SQL, SQL*Plus/SQL*Loader, and T-SQL to implement robust data solutions.

Strong experience with indexes, keys, and constraints is required, along with hands-on schema integration. The ideal applicant will demonstrate 7+ years of database and programming experience, with a focus on Oracle