Oracle Developer

V Group Inc.; New York (NY); On-site; USD 90,000 - 120,000; Part time

Job summary

V Group Inc. seeks an Oracle Developer for a long-term contract with New York City Department of Social Services.

The project, OCSS Strategic Modernization, involves converting mainframe processes to the OCSS Web platform and building a data-centric, .NET-based web application for case management and child support tooling. You will design database architectures, develop ETL processes, optimize SQL, and coordinate with business users to ensure data integrity and performance across complex data

Qualifications

• Minimum of 4 years of experience with Oracle, SQL Server, and related technologies.
• Experience with ETL processes and scheduling jobs.
• Strong SQL performance tuning and query optimization.

Responsibilities

• Design and develop Database design and architecture
• Design scalable and efficient database architecture based on business requirements
• Develop logical and physical data models (ER diagrams, schema design)
• Define tables, indexes, constraints, and relationships for optimal performance
• Normalize and denormalize data structures as needed for performance and usability
• Establish data standards, naming conventions
• Design and monitor OCSSWeb monthly data refresh process
• Schedule business process in SQL Agent jobs and Oracle Scheduled Jobs
• Design and program ETL processes
• Design and develop ETL process for data integration
• Extract data from heterogeneous sources (databases, files,)
• Transform data using business rules, validations, and cleansing logic
• Load data into target systems
• Implement error handling, logging, and recovery mechanisms
• Schedule and automate ETL jobs using SQL Agent Jobs tool and Oracle Scheduled Jobs
• Collaborate with Business users to understand data requirements
• Analyze slow-running queries and identify performance bottlenecks
• Review and interpret execution plans to improve query efficiency
• Design and maintain effective indexing strategies
• Implement query rewriting and refactoring techniques
• Identify and resolve locking, blocking, and concurrency issues
• Collaborate with developers to enforce query best practices
• Maintain performance tuning documentation and guidelines
• File transfer between shared folders/Database servers and FTP servers
• Establish secure SFTP connections to source and target systems
• Transfer files between servers while ensuring data integrity
• Schedule and automate file transfers using scripts
• Monitor and verify successful completion of file transfers
• Implement error handling, retry mechanisms, and logging
• Maintain transfer documentation, including file paths and schedules
• Coordinate with business users to validate transferred data
• Troubleshoot connectivity or transfer failures promptly
• Archive and manage historical transferred files for audit and compliance purposes
• Create and maintain database architecture documentation
• Document logical and physical data models (ER diagrams, schemas)
• Maintain data models version on TFS (Team Foundation Server)
• Define database standards, naming conventions, and best practices
• Document tables, relationships, constraints, and indexing strategies
• Maintain version control and track schema changes
• Collaborate with developers and DBAs to keep documentation up to date

Skills

Oracle DB

SQL Server

IBM Informix

PL/SQL

T-SQL

ETL

SQL Agent

Oracle Scheduler

TFS

Jira Software

SQL*Plus

Toad

SQL Developer

SQL Loader

SSIS/SSRS

SSMS

PuTTY/MobaXterm

Tools

SQL*Plus

SQL Loader

Toad

SQL Developer

Enterprise Manager

SFTP/FTP

Jira Software

SQL Server Management Studio

PuTTY/MobaXterm

TFS (Team Foundation Server)

Job description

End Client: New York City Department of Social Services

Job Title: Oracle Developer

Duration: 36-60 Months

Start Date: ASAP

Position Type: Contract

Interview Type: Webcam

PROJECT NAME: OCSS Strategic Modernization

Project Overview:

The project deals with Strategic Modernization of OCSS Web, Conversion of Mainframe processes into OCSS Web, this is a .NET Framework, based web application. Case Management System for CLU (Centralized Locate Unit) to manage their case load efficiently. Case Management for Enforcement helps identify work assignments for the Enforcement team and streamline referral assignment. It will also track aging of requests and changes in priorities. Parent Support Program (PSP) Participant Tracking System is to find the most effective way to assist the PSP Resources Coordinator to easily track NCPs who are participating in Parent Support Program when client shows up for his/her appointment and provides timely progress reports back to the court. Child Support Snapshot (CSS) gives Community Based Organizations (CBOs) the tool to assist the NCP (noncustodial parent) with their Child Support case. Automated Mailing System (AMS) is to automate the current manual process of printing and mailing court documents and inserts to the Custodial Parent (CP)/Assignor and Noncustodial Parent (NCP)/ Respondent in non-e-Filed support cases. OCSE Web legacy (CSTrack). These projects involve designing specifications for processes to fetch and process data from Court Messages, designing and implementing custom applications to utilize the retrieved data, generating reports, and ensuring the timely execution of scheduled jobs.

Tasks & Duties:

• Design and develop Database design and architecture


• Design scalable and efficient database architecture based on business requirements


• Develop logical and physical data models (ER diagrams, schema design)


• Define tables, indexes, constraints, and relationships for optimal performance


• Normalize and denormalize data structures as needed for performance and usability


• Establish data standards, naming conventions


• Design and monitor OCSSWeb monthly data refresh process


• Schedule business process in SQL Agent jobs and Oracle Scheduled Jobs


• Design and program ETL processes


• Design and develop ETL process for data integration


• Extract data from heterogeneous sources (databases, files,)


• Transform data using business rules, validations, and cleansing logic


• Load data into target systems


• Implement error handling, logging, and recovery mechanisms


• Schedule and automate ETL jobs using SQL Agent Jobs tool and Oracle Scheduled Jobs


• Collaborate with Business users to understand data requirements


• Analyze slow-running queries and identify performance bottlenecks


• Review and interpret execution plans to improve query efficiency


• Design and maintain effective indexing strategies


• Implement query rewriting and refactoring techniques


• Identify and resolve locking, blocking, and concurrency issues


• Collaborate with developers to enforce query best practices


• Maintain performance tuning documentation and guidelines


• File transfer between shared folders/Database servers and FTP servers


• Establish secure SFTP connections to source and target systems


• Transfer files between servers while ensuring data integrity


• Schedule and automate file transfers using scripts


• Monitor and verify successful completion of file transfers


• Implement error handling, retry mechanisms, and logging


• Maintain transfer documentation, including file paths and schedules


• Coordinate with business users to validate transferred data


• Troubleshoot connectivity or transfer failures promptly


• Archive and manage historical transferred files for audit and compliance purposes


• Create and maintain database architecture documentation


• Document logical and physical data models (ER diagrams, schemas)


• Maintain data models version on TFS (Team Foundation Server)


• Define database standards, naming conventions, and best practices


• Document tables, relationships, constraints, and indexing strategies


• Maintain version control and track schema changes


• Collaborate with developers and DBAs to keep documentation up to date

Required Skills :

A minimum of 4 years of experience with the following skill sets:

• Databases: Oracle 19c,12c, 11g, 10g, 9i, Microsoft SQL Server 2016/2008/2005, IBM Informix


• Special tools: SQL*Plus, SQL Loader, Toad, SQL Developer, Enterprise manager, SFTP/FTP, SQL Server Management Studio, Jira Software, MS Visual Studio 2016/2008/2005, PuTTY/MobaXterm for Unix


• Proficiency in PL/SQL, T-SQL languages


• ETL - SQL Loader, SQL Server Export/Import, SQL Server Business Intelligence tools – SSIS/SSRS, Oracle External tables


• Scheduling Database jobs – SQL Agent jobs – Oracle Scheduled jobs


• Version control – Database objects and documentation – TFS (Team Foundation Server)


• Comprehensive Health Insurance Coverage for employees and eligible dependents.


• Employee Referral Bonus Program with rewards for successful candidate referrals.


• Opportunities for career growth, professional development, and certifications.


• Flexible and collaborative work environment.


• Access to challenging projects with leading public sector and enterprise customers.


• Opportunity to work with Vivid's diverse public sector client base, contributing to meaningful digital transformation initiatives.


• Exposure to innovative technologies and industry-leading solutions.