Oracle & SQL Server Architect - 26-09339

Job Title: Oracle & SQL Server Architect

Location: Albany, NY
Duration: 24 Months
Work Schedule: Day 1 Onsite

Job Summary

We are seeking an experienced Oracle & SQL Server Architect to design, develop, and maintain enterprise database solutions supporting mission-critical applications. The ideal candidate will have extensive experience with Oracle and Microsoft SQL Server, strong expertise in database architecture, PL/SQL and T-SQL development, data integration, and relational database design.

Key Responsibilities

• Design, develop, and maintain enterprise relational database solutions using Oracle and Microsoft SQL Server.
• Interpret and implement physical database models while ensuring optimal database performance and scalability.
• Develop and maintain Oracle PL/SQL packages, stored procedures, functions, triggers, and database objects.
• Design, develop, and optimize Microsoft SQL Server databases using Transact-SQL (T-SQL).
• Create and maintain relational database structures, including tables, indexes, constraints, primary keys, and foreign keys.
• Design and implement database integration solutions across multiple database schemas.
• Perform database performance tuning, query optimization, and troubleshooting.
• Utilize Oracle database tools such as SQLPlus, SQLLoader, and related utilities for development and administration.
• Collaborate with application developers, architects, and business teams to support database requirements.
• Support database deployments, version control, and change management using Git.
• Develop technical documentation, database standards, and best practices.
• Ensure database security, integrity, reliability, and high availability.

Required Qualifications

• Minimum 7 years (84 months) of experience interpreting physical database models and working with relational database concepts, including indexes, primary keys, foreign keys, and constraints using both Oracle and Microsoft SQL Server.
• Minimum 7 years (84 months) of experience developing with Oracle PL/SQL, including:
  • Database Packages
  • Stored Procedures
  • Functions
  • Triggers
• Minimum 7 years (84 months) of experience working with Oracle Database 11g or later.
• Minimum 7 years (84 months) of experience using Oracle programming tools, including:
  • SQL*Plus
  • SQL*Loader
  • Other Oracle database development utilities
• Minimum 5 years (60 months) of experience developing using Microsoft Transact-SQL (T-SQL).
• Minimum 5 years (60 months) of experience designing relational databases.
• Minimum 2 years (24 months) of experience integrating multiple database schemas.
• Minimum 18 months of experience using Git for version control.

Preferred Skills

• Oracle Database 11g+
• Microsoft SQL Server
• Oracle PL/SQL
• Transact-SQL (T-SQL)
• Database Architecture
• Relational Database Design
• Data Modeling
• Database Performance Tuning
• Query Optimization
• SQL*Plus
• SQL*Loader
• Database Integration
• Schema Design
• Data Migration
• Git Version Control
• Database Security
• Database Administration
• Enterprise Data Management
• Technical Documentation