Archived listing. The details below describe a past opening.
We are looking for a Database Administrator to join a contract opportunity with the potential to become permanent, based in Wayne, Pennsylvania. This position supports a mixed enterprise data environment that includes Oracle/Lawson, Snowflake, AWS-based data services, and Drupal/Acquia platforms. The role is ideal for someone who can balance core database administration with data integration, reporting support, and cloud platform optimization. You will play a key part in keeping business-critical data dependable, secure, and well-structured for operational and analytical use.
Responsibilities:
- Oversee the day-to-day administration of Oracle/Lawson databases, including performance monitoring, backup coordination, recovery planning, and platform maintenance.
- Partner with technical teams to support database needs for application updates, system enhancements, and production issue resolution.
- Administer and improve Snowflake environments by refining data models, tuning workloads, and supporting scalable reporting structures.
- Build and maintain AWS-based data pipelines using services such as S3, Lambda, and Glue to move and transform enterprise data efficiently.
- Create and support integration processes across multiple business systems, with a focus on data validation, transformation, reconciliation, and consistency.
- Prepare and organize Drupal/Acquia data for reporting, analytics, and downstream consumption by dashboards or business intelligence tools.
- Validate migrated and integrated data to ensure completeness, accuracy, and alignment with business rules.
- Develop complex SQL solutions to support data extraction, transformation, and reporting requirements across legacy and cloud platforms.
- Document data movement, integration logic, and governance practices to improve transparency, quality, and long-term supportability.
- At least 3 years of hands-on experience administering Oracle databases in a production environment.
- At least 3 years of experience in database administration, data platform support, or data engineering work.
- Strong SQL skills, including the ability to write and optimize advanced queries and data transformations.
- Experience working with Snowflake or another enterprise cloud data warehouse platform.
- Practical experience with AWS data technologies such as S3, Glue, Lambda, or Redshift.
- Background in designing or supporting ETL processes, system integrations, and data pipelines.
- Familiarity with Windows and Linux operating environments.
- Bachelor’s degree in Computer Science, Information Systems, or a related discipline, or equivalent relevant experience.