> Markdown version of [/jobs/ext/1449380-oracle-sql-server-architect](https://www.wearedevelopers.com/jobs/ext/1449380-oracle-sql-server-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Oracle & SQL Server Architect - **Company:** CVC IT SOLUTIONS LLC - **Location:** Schenectady, NY, United States (Remote available) - **Experience:** Experienced - **Contract:** Temporary to permanent - **Skills:** 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, 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 - **Published:** July 26, 2026 - **Apply:** https://www.careerjet.com/jobad/usb10d9175a4262564f325f5348316128b ## About the Role * 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. ## 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 ## Related Videos - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1520-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) - [Git for Code Reviews](https://www.wearedevelopers.com/videos/429-git-for-code-reviews) - [How building an industry DBMS differs from building a research one](https://www.wearedevelopers.com/videos/768-how-building-an-industry-dbms-differs-from-building-a-research-one) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) - [Stop Committing Your Secrets - GIt Hooks To The Rescue!](https://www.wearedevelopers.com/videos/573-stop-committing-your-secrets-git-hooks-to-the-rescue) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [7 Important Tips That Every Software Developer Should Know](https://www.wearedevelopers.com/magazine/101-7-important-tips-that-every-software-developer-should-know) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Quick guide: How to write a Software Developer CV](https://www.wearedevelopers.com/magazine/37-quick-guide-how-to-write-a-software-developer-cv) - [SQL Murder Mystery: A game for hobby detectives who want to learn SQL](https://www.wearedevelopers.com/magazine/38-sql-murder-mystery-a-game-for-hobby-detectives-who-want-to-learn-sql)