Database Developer

Rutherford, NJ, US • Posted 1 day ago • Updated 10 hours ago
Contract W2
On-site
Company Branding Image
Fitment

Dice Job Match Score™

📋 Comparing job requirements...

Job Details

Skills

  • Financial Services
  • Virtualization
  • Data Management
  • Stored Procedures
  • Data Integration
  • Collaboration
  • Business Intelligence
  • Storage
  • Data Quality
  • Evaluation
  • High Availability
  • Specification Gathering
  • Data Flow
  • Mentorship
  • Data Modeling
  • Computer Science
  • Information Systems
  • Management
  • Database
  • PL/SQL
  • Performance Tuning
  • SQL
  • Data Manipulation
  • Optimization
  • Data Warehouse
  • Dimensional Modeling
  • Extract
  • Transform
  • Load
  • ELT
  • Cloud Computing
  • Microsoft Azure
  • Google Cloud Platform
  • Google Cloud
  • Data Storage
  • Amazon S3
  • GCS
  • Data Processing
  • Apache Spark
  • Apache Flink
  • Version Control
  • Git
  • Analytical Skill
  • Problem Solving
  • Conflict Resolution
  • Communication
  • Articulate
  • Data Lake
  • Apache HTTP Server
  • Programming Languages
  • Python
  • Scala
  • Data Engineering
  • Workflow
  • Orchestration
  • Apache Airflow
  • Data Governance
  • Oracle
  • Amazon Web Services
  • Data Analysis
  • MEAN Stack
  • Customer Service
  • Training And Development
  • SAP BASIS

Summary

Software Guidance & Assistance, Inc., (SGA), is searching for a Database Developer for a right to hire assignment with one of our premier financial services clients in Rutherford, NJ.

Responsibilities :
  • Design, develop, and maintain robust and scalable data solutions within our data lakehouse architecture, leveraging Apache Iceberg for open table format management.
  • Develop and optimize data ingestion, transformation, and curation processes using technologies compatible with Iceberg, Oracle, and Starburst.
  • Utilize Starburst (Trino) for high-performance querying and data virtualization across various data sources, including Iceberg tables and Oracle databases.
  • Work extensively with Oracle databases for enterprise data management, including schema design, stored procedures, performance tuning, and data integration.
  • Collaborate with data architects, data scientists, and business intelligence teams to translate business requirements into technical data models and data solutions.
  • Implement and manage ETL/ELT pipelines to move data efficiently between Oracle, data lake storage (e.g., S3, ADLS), and Iceberg tables.
  • Ensure data quality, integrity, and security across all data platforms, adhering to data governance standards.
  • Perform performance tuning and optimization for queries running on Starburst, Iceberg tables, and Oracle databases.
  • Participate in the evaluation and adoption of new data technologies and best practices to enhance our data platform capabilities.
  • Troubleshoot and resolve complex data-related issues, ensuring high availability and reliability of data infrastructure.
  • Document technical specifications, data flows, data models, and operational procedures.
  • Mentor junior team members and contribute to a culture of continuous learning and improvement.
  • The ideal candidate will be instrumental in designing, developing, and optimizing our data lakehouse environment, integrating traditional enterprise data sources with cutting-edge open table formats and query engines. This role demands a strong understanding of database development, data modeling, ETL/ELT processes, and distributed data processing.
Required Skills :
  • Bachelor's degree in Computer Science, Information Systems, Data Engineering, or a related technical field.
  • 7-10 years of experience in database development or data engineering roles.
  • Proven hands-on experience with Apache Iceberg for managing large-scale, high-performance table formats in a data lake context.
  • Strong expertise in Oracle database development, including SQL, PL/SQL, schema design, indexing, and performance tuning.
  • Experience with Starburst (Trino) for distributed query processing and federated queries across heterogeneous data sources.
  • Proficiency in SQL for complex data manipulation, analysis, and optimization.
  • Solid understanding of data warehousing concepts, dimensional modeling, and ETL/ELT methodologies.
  • Experience with cloud platforms (e.g., AWS, Azure, Google Cloud Platform) and their data storage services (e.g., S3, ADLS, GCS).
  • Familiarity with distributed data processing frameworks (e.g., Apache Spark, Flink).
  • Experience with version control systems (e.g., Git).
  • Excellent analytical, problem-solving, and communication skills, with the ability to articulate complex technical concepts.
Preferred Skills :
  • Master's degree in a related field.
  • Experience with other data lake table formats (e.g., Delta Lake, Apache Hudi).
  • Knowledge of other distributed query engines (e.g., Presto, Athena, Dremio).
  • Proficiency in programming languages such as Python or Scala for data engineering tasks.
  • Experience with workflow orchestration tools (e.g., Apache Airflow, Dagster).
  • Familiarity with data governance tools and practices in a data lakehouse environment.
  • Relevant industry certifications (e.g., Oracle Certified Professional, AWS Certified Data Analytics).
SGA is a technology and resource solutions provider driven to stand out. We are a women-owned business. Our mission: to solve big IT problems with a more personal, boutique approach. Each year, we match consultants like you to more than 1,000 engagements. When we say let's work better together, we mean it. You'll join a diverse team built on these core values: customer service, employee development, and quality and integrity in everything we do. Be yourself, love what you do and find your passion at work. Please find us at .

SGA is an Equal Opportunity Employer and does not discriminate on the basis of Race, Color, Sex, Sexual Orientation, Gender Identity, Religion, National Origin, Disability, Veteran Status, Age, Marital Status, Pregnancy, Genetic Information, or Other Legally Protected Status. We are committed to providing access, equal opportunity, and reasonable accommodation for individuals with disabilities in employment, and our services, programs, and activities. Please visit our company to request an accommodation or assistance regarding our policy.
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: sgainc
  • Position Id: 26-01660
  • Posted 1 day ago

Company Info

About Software Guidance & Assistance

Founded in 1981, SGA is a technology and resource solutions provider with a national footprint and headquartered in the shadow of Wall Street. We’re a certified women-owned business. We provide contingent staffing, direct placement, and professional and managed services to transform businesses and evolve careers. We’re small enough to tailor our services to each client and big enough to deliver for some of the world’s largest employers. Our professionals are experts in areas such as IT, finance, accounting, risk, and clinical.

SGA provides contingent staffing, direct placement, and professional and managed services nationwide for Fortune 500 companies, mid-size businesses and select startups.

Our core skillsets include all areas of technology – business & data analysis, cyber & network security, database administration, development & architecture, infrastructure, program & project management, quality assurance & testing. We also deliver talent across professional business functions such as finance, accounting, risk, and clinical.

Our Professional & Managed Services team delivers IT projects through onshore, offshore and hybrid delivery models. We develop software products, modernize applications, add features, and integrate and maintain systems. Our scope covers, among others, complex application suites, data management and visualizations, machine learning and mobile applications.

About_Company_OneAbout_Company_Two
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Rutherford, New Jersey

Today

Contract

Rutherford, New Jersey

Today

Contract

USD 72.47 - 86.96 per hour

Rutherford, New Jersey

Today

Contract

USD 72.47 - 86.96 per hour

New York, New York

Today

Contract

Search all similar jobs