Oracle & SQL Server Architect

CVC IT SOLUTIONS LLC
Troy, United States of America
2 days ago

Role details

Contract type
Temporary to permanent
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Troy, United States of America

Tech stack

.NET
Databases
Data Integration
Data Migration
Relational Databases
Database Schema
Database Security
Programming Tools
Microsoft SQL Server
Oracle
Oracle Applications
Oracle SQL Developer
Query Optimization
Standard Sql
SQL Stored Procedures
PL-SQL
SQL*Plus
T-SQL
Enterprise Data Management
System Availability
Database Optimization
Oracle SQL Loader
Database Performance
GIT
Software Version Control

Job description

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., * 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., * 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, Job Title: Senior .NET Architect Location: Albany, NY Duration: 20 Months Work Schedule: Day 1 Onsite Job Summary We are seeking an experienced Senior .NET Architect to des…
  • 1 day ago
  • Apply easily

Requirements

  • 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.

Apply for this position