Database Developer (Iceberg, Oracle, Starburst)

Rose International

Rutherford, New Jersey

Apply

JOB DETAILS

SALARY

$80–$92 Per Hour

JOB TYPE

Contractor

SKILLS

Amazon Simple Storage Service (S3), Amazon Web Services (AWS), Analysis Skills, Apache, Apache Spark, Best Practices, Business Intelligence, Cloud Computing, Communication Skills, Computer Science, Data Analysis, Data Formats, Data Lake, Data Management, Data Modeling, Data Processing, Data Quality, Data Science, Data Storage, Data Warehousing, Database Design, Database Extract Transform and Load (ETL), Database Programming, Database Technology, Dimensional Modeling, GCP (Good Clinical Practices), Git, High Availability, High Reliability, Identify Issues, Information Technology & Information Systems, Mentoring, Microsoft Windows Azure, Multiplatform/Cross-Platform, Operations Processes, Oracle, Oracle Database, Oracle PL-SQL, Performance Tuning/Optimization, Problem Solving Skills, Programming Languages, Python Programming/Scripting Language, Query Optimization, Requirements Management, SQL (Structured Query Language), Scala Programming Language, Software Engineering, Source Code/Configuration Management (SCM), Stored Procedures, Technical Writing, Virtualization

LOCATION

Rutherford, New Jersey

POSTED

1 day ago

Job TitleJob Description Required Education• Bachelor's degree in computer science, Information Systems, Data Engineering, or a related technical field.Preferred Education• Master's degree in a related field.Required Skills• 7-10 years of experience in database development or data engineering roles.• 7-10 years of experience with Apache Iceberg for managing large-scale, high-performance table formats in a data lake context.• 7-10 years of experience 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, GCP) 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• 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).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.**Only those lawfully authorized to work in the designated country associated with the position will be considered.****Please note that all Position start dates and duration are estimates and may be reduced or lengthened based upon a client's business needs and requirements.**

About the Company

Rose International

Founded in 1993 by Sue Bhatia, Rose International is one of the nation's leading minority- and woman-owned providers of Staffing and Total Talent Solutions. We serve companies in all 50 states and employ thousands of people across the country.

COMPANY SIZE

2,500 to 4,999 employees

INDUSTRY

Staffing/Employment Agencies

WEBSITE

https://www.roseint.com/

Database Developer (Iceberg, Oracle, Starburst)

Rose International

Rutherford, New Jersey

About the Company

Rose International

Similar Job Searches