Oracle & SQL Server Architect

CVC IT SOLUTIONS LLC

Schenectady, NY, United States

17 days ago

Role details

Contract type

Temporary to permanent

Employment type

Full-time (> 32 hours)

Experience level

Experienced

Experience required

2 years minimum

Working hours

Regular working hours

Job source

www.careerjet.com

Tech stack

Databases Data Integration Data Migration Relational Databases Database Schema Database Security Programming Tools Microsoft SQL Server Oracle Databases Oracle (Applications) Oracle SQL Developer Query Optimization

+12 more

Standard Sql SQL Stored Procedures PL-SQL SQL*Plus Transact-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

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.