> Markdown version of [/jobs/ext/2660678-database-administrator](https://www.wearedevelopers.com/jobs/ext/2660678-database-administrator). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Database Administrator - **Company:** Affiliated Distributors - **Location:** Wayne, PA, United States - **Experience:** Experienced - **Contract:** Permanent contract - **Skills:** Sql Data Warehouse, Microsoft Windows, Amazon Web Services, Amazon S3, Microsoft Azure, Cloud Computing, Cloud Engineering, Cyber Security, Information Systems, Databases, Data as a Services, Data Cleansing, Information Engineering, Data Governance, Data Infrastructure, Data Integration, Data Integrity, Extract Transform Load (ETL), Data Migration, Data Mining, Data Recovery, Data Security, Dataspaces, Data Structures, Data Warehousing, Database Queries, Database Security, Linux, Document-Oriented Databases, Drupal, Microsoft SQL Server, MySQL, Oracle Databases, Oracle (Applications), Performance Tuning, Query Optimization, Power BI, Acquia, SQL Databases, Tableau (Software), Enterprise Data Management, Web Content Management System (WCMS), Freeform SQL, Snowflake, AWS Lambda, Usage Tracking, Information Technology, Performance Monitor, Qlikview, Star Schema, Google Bigquery, AWS Data Analytics, Data Management, Tools for Reporting, Multiplatform, Data Pipelines, Legacy Systems - **Published:** August 21, 2026 - **Apply:** https://www.careerbuilder.com/job-details/database-administrator-wayne-pa--ae041832-f6f1-45af-a906-3069a87030f8 ## About the Role * At least three years of hands-on experience with Oracle databases * Bachelor's degree in Computer Science, Information Systems, or related field (or equivalent experience) * 3+ years of experience working with data platforms, databases, or data engineering workflowsProficient in writing complex SQL queries * Strong SQL skills with experience writing complex queries and transformations * Experience with Snowflake or similar cloud data warehouse technologies * Experience working with AWS data services (e.g., S3, Glue, Lambda, Redshift, or similar) * Familiarity with extraction, transformation, and loading (ETL)/ELT tools and data pipeline development * Experience working with web or CMS data structures (Drupal experience preferred) * Experience working in both Windows and Linux operating systems * Experience migrating databases to cloud platforms (AWS, Azure, Oracle) is a plus * Strong written and verbal communication skills Desired Skills: * Proficient in administering Microsoft SQL Server and MySQL databases * Experienced in managing and improving database security * Ability to establish and enforce database management best practices with a focus on continuous improvement * Experience with reporting/BI tools (e.g. Qlik, Power BI, Tableau, or similar) * Familiarity with data governance and data quality frameworks * Experience working in hybrid environments combining legacy systems and modern cloud platforms, AWS Lambda, Amazon Simple Storage Service (S3), Amazon Web Services (AWS), Best Practices, Business Intelligence Software, Cloud Computing, Communication Skills, Computer Science, Continuous Improvement, Data Management, Data Migration, Data Modeling, Data Quality, Data Recovery, Data Structures, Data Warehousing, Database Administration, Database Extract Transform and Load (ETL), Database Recovery, Distribution Channel, Drupal, Ecosystems, Enterprise Data Integration, Information Technology & Information Systems, Information/Data Security (InfoSec), Linux Operating System, Microsoft SQL Server DBA (Database Administration), Microsoft Windows Azure, Microsoft Windows Operating System, Multiplatform/Cross-Platform, MySQL, Oracle, Oracle DBA (Database Administrator), Oracle Database, Performance Analysis, Performance Modeling, Performance Tuning/Optimization, Power BI, Presentation/Verbal Skills, Qlik, Query Optimization, Reconciliation, Reporting Dashboards, SQL (Structured Query Language), Snowflake Schema, Systems Administration/Management, Tableau, Web Content Management System (WCMS), Writing Skills ## Description The Database Administrator is responsible for administering, supporting, and optimizing Affiliated Distributors' enterprise database environments and modern data ecosystem, including Lawson databases, Snowflake, AWS-based data services, and Drupal (Acquia). This role combines traditional database administration responsibilities with modern cloud-based data platform and data warehousing functions. The Database Administrator serves as the primary technical owner for Lawson database-related responsibilities while also supporting enterprise data integration, data warehousing, reporting, and analytics initiatives. The position focuses on ensuring database reliability, performance, security, and availability while enabling efficient data extraction, transformation, modeling, and reporting across enterprise systems. The Database Administrator will play a key role in supporting the Drupal platform and broader data initiatives by ensuring enterprise data is secure, accurate and accessible across systems., Database Administration (Oracle Databases) * Serve as the primary technical owner for Oracle / Lawson database-related tasks and support, as our third-party service provider transitions off at the end of the year * Oversee Lawson-related performance monitoring, backups, recovery coordination, and database support activities * Support database-related aspects of system implementations, upgrades, and operational stability * Coordinate data access, integrations, and downstream data usage to ensure Lawson data is effectively leveraged across analytics and reporting platforms Data Platform & Warehoursing (Snowflake / AWS) * Support the Snowflake data warehouse environment, including data modeling and performance tuning * Develop and maintain data pipelines and workflows within AWS (e.g., S3, Lambda, Glue, or similar services) * Design and implement scalable data structures to support analytics / reporting needs * Monitor data pipelines and ensure reliability, performance, and data integrity Data Integration, ETL & Transformation: * Design, build, and maintain ETL/ELT processes to move and transform data across systems * Perform data cleansing, validation, and reconciliation between source and target systems * Support ongoing data migration and integration efforts, including Drupal * Develop and optimize SQL queries for transformation and reporting Drupal Data & Reporting: * Assist with Drupal (Acquia) data structures to extract, transform, and prepare data for reporting and analytics * Validate and reconcile data migrated from the private website to Drupal to ensure accuracy and completeness * Enable downstream reporting tools and dashboards through well-structured datasetsIntegrate Drupal and digital analytics data using platforms such as Google BigQuery to support scalable, actionable reporting Cross-System Data Management: * Support the need for consistent and synchronized data across platforms including Lawson, Snowflake, Drupal, and AWS * Establish and enforce data governance and data quality best practices * Document data flows, transformations, and system integrations ## Related Videos - [How building an industry DBMS differs from building a research one](https://www.wearedevelopers.com/videos/768-how-building-an-industry-dbms-differs-from-building-a-research-one) - [Docker network without Docker](https://www.wearedevelopers.com/videos/1418-docker-network-without-docker) - [MySQL Protocol Features You Should Be Aware Of](https://www.wearedevelopers.com/videos/100267-mysql-protocol-features-you-should-be-aware-of) - [Branch your database like your code: How schema changes and pull requests go hand in hand](https://www.wearedevelopers.com/videos/350-branch-your-database-like-your-code-how-schema-changes-and-pull-requests-go-hand-in-hand) - [Docker exec without Docker](https://www.wearedevelopers.com/videos/1094-docker-exec-without-docker) - [Coding for Good: Achieving social change with an app](https://www.wearedevelopers.com/videos/1645-coding-for-good-achieving-social-change-with-an-app) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)