Oracle & SQL Server Architect - 26-09339
CVC - IT
Saratoga Springs, NY, USA
6/14/2022
Technology
Full Time
Job Description
Job Description
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