Database Administrator

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

Requirements

• 3 or more years of experience in Oracle database administration and enterprise database operations.
• Proficiency in Snowflake cloud data warehousing, performance tuning, and data modeling.
• Experience with AWS cloud data services including Amazon S3, AWS Glue, and AWS Lambda.
• Experience in advanced SQL scripting, stored procedures, and complex data transformation logic.
• Experience with ETL/ELT pipeline design, data reconciliation, and database migration workflows.
• Experience in CMS backend data structures such as Drupal, Google BigQuery, or secondary SQL engines.
• Excellent verbal and written communication skills.

Responsibilities

• Administer, monitor, and optimize production Oracle database instances supporting core ERP systems.
• Execute database backups, disaster recovery procedures, and software upgrade maintenance tasks.
• Design, build, and optimize scalable data warehouse schemas and pipelines within Snowflake.
• Develop automated serverless data processing pipelines and workflows using AWS Lambda and Glue.
• Build robust ETL/ELT data transformations and validate data reconciliation across source systems.
• Extract, structure, and model web CMS data to enable downstream reporting in Google BigQuery.
• Enforce enterprise data governance standards and author technical system integration documentation.

Founded in 1999, Resourcesoft, Inc. is a leading Technology Consulting and Professional Services organization. Headquartered in Marlborough, MA, the company serves the technology needs of its clients nationwide. Resourcesoft has often been recognized by prominent rating agencies for its exemplary growth and stability. With over two decades of industry experience, the Company has evolved as a front runner in enabling project optimization. We partner with leading organizations to provide technology solutions within the financial, insurance, education, government, publishing, healthcare and pharmaceutical domains. We take pride in mentoring a workforce that is well positioned to respond to the emerging IT trends and needs. With the employees at the crux of every business endeavor, our success is driven by our expertise in pairing the right talent with the best jobs in the technology sector. We forge long term, personalized relationships with our employees to advance their career to the next level. We engage them in technology centric client projects that provide opportunities for them to evolve, innovate and deliver world class products and services. Our career opportunities offer challenging assignments and exposure to emerging and cutting edge technologies. We are committed to providing our employees with the tools necessary to accelerate their career progression, while maintaining a healthy, work-life balance. We are deeply committed to providing a workplace ambience that is both challenging and fulfilling.

Resourcesoft is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.

For more information about Resourcesoft and our services, please visit our website.