Pl/SQL Developer + Snowflake

Diverse Lynx LLC

Jersey City, United States of America

29 days ago

Role details

Contract type

Temporary to permanent

Employment type

Full-time (> 32 hours)

Working hours

Regular working hours

Languages

English

Experience level

Senior

Compensation

$ 146K

Job location

Jersey City, United States of America

Tech stack

Agile Methodologies

Amazon Web Services (AWS)

Databases

Continuous Integration

Information Engineering

Data Governance

Data Integration

ETL

Data Transformation

Data Systems

Data Warehousing

Relational Databases

Database Design

Dimensional Modeling

Job Scheduling

Online Analytical Processing

Online Transaction Processing

Operational Databases

Oracle SQL Developer

Performance Tuning

Scrum

Systems Development Life Cycle

PL-SQL

SQL Databases

Snowflake

Information Technology

Data Pipelines

Job description

This role is responsible for developing, enhancing, and supporting high-performance Oracle PL/SQL-based data solutions while contributing to ongoing data modernization initiatives leveraging the Snowflake cloud data platform. The ideal candidate will have strong database engineering fundamentals, hands-on experience with Oracle PL/SQL, and working knowledge of Snowflake in support of analytical, reporting, and regulatory data workloads., * Design, develop, and maintain complex Oracle PL/SQL code including packages, procedures, functions, triggers, and views

Support transactional (OLTP) and analytical (OLAP) data workloads with a focus on performance, reliability, and scalability
Develop and optimize Snowflake SQL objects including tables, views, and schemas
Support data transformation, validation, reconciliation, and audit controls
Perform SQL and PL/SQL performance tuning, root-cause analysis, and production issue resolution
Partner with application teams, data engineers, and business stakeholders to deliver data solutions aligned with enterprise standards
Participate in Agile ceremonies, sprint planning, and release execution
Ensure compliance with SDLC, change management, data governance, and security standards
Contribute to technical documentation, data models, and operational runbooks, Principal Oracle PL/SQL Developer - Hybrid NYC or Dallas, TX area - W2 Only Hybrid, NYC or Dallas, TX area W2 only Extensive Oracle SQL & PL/SQL development experience. 8+ ye…

Requirements

Bachelor's degree in Computer Science, Engineering, or equivalent professional experience
Strong hands-on experience with Oracle SQL and PL/SQL in enterprise environments
Proven experience developing and supporting complex PL/SQL-based data solutions
Experience working with Snowflake as a cloud data warehouse
Solid understanding of relational data modeling and database design principles
Experience supporting production data platforms and resolving performance issues
Strong analytical, troubleshooting, and communication skills, * Experience with data warehousing concepts (dimensional modeling, star/snowflake schemas)
Exposure to cloud platforms (AWS preferred)
Experience with ETL, data pipelines, or data integration tools
Familiarity with Unix/Linux environments and job scheduling tools
Experience in financial services or regulated environments
Knowledge of CI/CD practices and Agile delivery models

Key Competencies

Database & Data Engineering Excellence
Performance Optimization & Problem Solving
Data Quality & Integrity
Collaboration & Stakeholder Partnership
Operational Readiness & Production Support

Benefits & conditions

$68.00-70.00 per hour Immediate need for a talented PL/SQL Developer. This is a 12 months contract opportunity with long-term potential and is located in Jersey City, NJ/Charlotte,NC/Plano,TX(Hybrid). P…
2 days ago