Oracle DBA & Snowflake Data Warehouse Engineer (AWS)

RESOURCESOFT, INC.; Wayne (PA); On-site; USD 90,000 - 120,000; Full time

Job summary

Resourcesoft, Inc. is a leading Technology Consulting and Professional Services organization founded in 1999.

Headquartered in Marlborough, MA, it serves the technology needs of its clients nationwide, recognized for growth and stability across financial, insurance, education, government, publishing, healthcare and pharmaceutical domains. We partner with leading organizations to provide technology solutions, mentoring a workforce to respond to emerging IT trends and needs.

Qualifications

• 3+ years of Oracle database administration experience.
• Proficiency in Snowflake data warehousing and modeling.
• Experience with AWS data services (S3, Glue, Lambda).
• Advanced SQL scripting and data transformations.
• ETL/ELT pipeline design and data reconciliation.
• CMS data structures experience (Drupal/BigQuery).
• Excellent verbal and written communication skills.

Responsibilities

• Administer, monitor, and optimize production Oracle databases for ERP systems.
• Execute backups, DR procedures, and software upgrade tasks.
• Design and optimize Snowflake data warehouse schemas and pipelines.
• Develop serverless data processing with AWS Lambda and Glue.
• Build ETL/ELT transformations and validate data reconciliation.
• Extract and model CMS data for downstream reporting in BigQuery.
• Enforce data governance and document system integrations.

Skills

Oracle DBA

Snowflake

AWS cloud services

SQL scripting

ETL/ELT design

CMS data modeling

Communication skills

Tools

Google BigQuery

Drupal

Amazon S3

AWS Glue

AWS Lambda

Job description

Resourcesoft, Inc. is a leading Technology Consulting and Professional Services organization founded in 1999.

Headquartered in Marlborough, MA, it serves the technology needs of its clients nationwide, recognized for growth and stability across financial, insurance, education, government, publishing, healthcare and pharmaceutical domains. We partner with leading organizations to provide technology solutions, mentoring a workforce to respond to emerging IT trends and needs.