Apply Now

Oracle Developer | (GC)/(USC) | Only W2

Hybrid in New York, NY, US • Posted 8 hours ago • Updated 8 hours ago

Contract Independent

Contract W2

30 Months

No Travel Required

Hybrid

Depends on Experience

Fitment

Dice Job Match Score™

To see how well you match this job, please log in or create an account.

Once logged in, be sure to complete your profile to get the most accurate match score.

🔢 Crunching numbers...

Job Details

Skills

Business Rules
Concurrent Computing
Extract, Transform, Load
FTP
IBM
Management
Database Design
Design Architecture
Business Intelligence
Database Architecture
Data Structure
Code Refactoring
Microsoft SQL Server DBA
Microsoft SSIS
Microsoft SQL Server
Microsoft TFS
Microsoft SSRS
PL/SQL
SQL*Plus
SQL*Loader
Transact-SQL
SQL
PuTTY
Servers
SFTP
Oracle Enterprise Manager
Recovery
Regulatory Compliance
Performance Tuning
Microsoft Visual Studio
Toad
Oracle
Version Control
Business Process
Database
JIRA

Business Rules
Concurrent Computing
Extract, Transform, Load
FTP
IBM
Management
Database Design
Design Architecture
Business Intelligence
Database Architecture
Data Structure
Code Refactoring
Microsoft SQL Server DBA
Microsoft SSIS
Microsoft SQL Server
Microsoft TFS
Microsoft SSRS
PL/SQL
SQL*Plus
SQL*Loader
Transact-SQL
SQL
PuTTY
Servers
SFTP
Oracle Enterprise Manager
Recovery
Regulatory Compliance
Performance Tuning
Microsoft Visual Studio
Toad
Oracle
Version Control
Business Process
Database
JIRA

Summary

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
Database query performance turning
Analyze slow-running queries and identify performance bottlenecks
Optimize SQL queries (joins, subqueries, execution paths)
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
Database design/architecture/process documentation
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)

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: 90718572
Position Id: 9091953
Posted 8 hours ago

Contact the job poster

Rahul Basineni

Team Lead @ ISite Technologies Inc

View Profile

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Hybrid in New York, New York

•

5d ago

Job Title: SQL Server Database Architect & Data Engineer Location: New York, NY - Hybrid; 3 days onsite, 2 days remote Duration: Thru 2/28/2027 (very likely to be extended) Pay Range: $70-75/hr (W2), depending on experience Interview Process: First round virtual via MS Teams, 2nd round likely onsite in New York, NY Position Overview Our Fortune 500 client located in New York, NY is seeking an experienced Senior SQL Server Database Architect & Data Engineer to design, administer, optimize, integ

Easy Apply

Contract

$75+

Database Administrator - NYC- DSS

New York, New York

•

Yesterday

Good to have r ecent experience in NYC-DSS M&O Services for DSS Application Systems Tasks & Duties Designing and Developing Software Systems Design, develop, and maintain Oracle 19c CARES DataMart and SQL Server database objects, ensuring optimal structure, performance, and scalability for both transactional and analytical systems Create and maintain critical operational and analytical reports (e.g., 24/7 Resource Room reports) to support agency decision-making Support and enhance key housing su

Easy Apply

Contract

Depends on Experience

Database Administrator - NYC- DSS

New York, New York

•

Today

Good to have recent experience in NYC-DSS M&O Services for DSS Application Systems Tasks & Duties Designing and Developing Software SystemsDesign, develop, and maintain Oracle 19c CARES DataMart and SQL Server database objects, ensuring optimal structure, performance, and scalability for both transactional and analytical systemsCreate and maintain critical operational and analytical reports (e.g., 24/7 Resource Room reports) to support agency decision-makingSupport and enhance key housing subsid

Easy Apply

Contract

Depends on Experience

Oracle Application Developer

Hybrid in New York, New York

•

Yesterday

About Us: Established in 1997, PruTech is committed to innovative problem-solving, solution creation, and fostering strong client partnerships. Serving a diverse array of industries, from government to finance, retail, and manufacturing, PruTech operates from strategic locations including New York City, Washington DC, North Carolina, and boasts a nearshore office in Mexico City and multiple offshore offices in India. With over two decades of experience in Information Technology and system integr

Easy Apply

Third Party, Contract

Up to 75

Search all similar jobs

More jobs at ISite Technologies Inc in New York, NY

Oracle Developer | (GC)/(USC) | Only W2

Dice Job Match Score™

Job Details

Skills

Summary

Rahul Basineni

Similar Jobs