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.