Database Administrator

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.

Primary Responsibilities:

Database Administration (Oracle Databases)

1. 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
2. Oversee Lawson-related performance monitoring backups recovery coordination and database support activities
3. Support database-related aspects of system implementations upgrades and operational stability
4. 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)

1. Support the Snowflake data warehouse environment including data modeling and performance tuning
2. Develop and maintain data pipelines and workflows within AWS (e.g. S3 Lambda Glue or similar services)
3. Design and implement scalable data structures to support analytics / reporting needs
4. Monitor data pipelines and ensure reliability performance and data integrity

Data Integration ETL & Transformation:

1. Design build and maintain ETL/ELT processes to move and transform data across systems
2. Perform data cleansing validation and reconciliation between source and target systems
3. Support ongoing data migration and integration efforts including Drupal
4. Develop and optimize SQL queries for transformation and reporting

Drupal Data & Reporting:

1. Assist with Drupal (Acquia) data structures to extract transform and prepare data for reporting and analytics
2. Validate and reconcile data migrated from the private website to Drupal to ensure accuracy and completeness
3. 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:

1. Support the need for consistent and synchronized data across platforms including Lawson Snowflake Drupal and AWS
2. Establish and enforce data governance and data quality best practices
3. Document data flows transformations and system integrations

1. At least three years of hands-on experience with Oracle databases
2. Bachelors degree in Computer Science Information Systems or related field (or equivalent experience)
3. 3 years of experience working with data platforms databases or data engineering workflowsProficient in writing complex SQL queries
4. Strong SQL skills with experience writing complex queries and transformations
5. Experience with Snowflake or similar cloud data warehouse technologies
6. Experience working with AWS data services (e.g. S3 Glue Lambda Redshift or similar)
7. Familiarity with extraction transformation and loading (ETL)/ELT tools and data pipeline development
8. Experience working with web or CMS data structures (Drupal experience preferred)
9. Experience working in both Windows and Linux operating systems
10. Experience migrating databases to cloud platforms (AWS Azure Oracle) is a plus
11. Strong written and verbal communication skills

Desired Skills:

1. Proficient in administering Microsoft SQL Server and MySQL databases
2. Experienced in managing and improving database security
3. Ability to establish and enforce database management best practices with a focus on continuous improvement
4. Experience with reporting/BI tools (e.g. Qlik Power BI Tableau or similar)
5. Familiarity with data governance and data quality frameworks
6. Experience working in hybrid environments combining legacy systems and modern cloud platforms

Additional Comments:

1. Position is based out of our corporate office in Wayne PA where we work on a hybrid schedule (Monday and Friday remote and Tuesday Wednesday and Thursday in the offices in Wayne PA)
2. Travel: None

AD is proud to be an equal employment opportunity employer. Qualified candidates are considered for employment without regard to race religion gender gender identity sexual orientation national origin age military or veteran status disability or any other characteristic protected by applicable law. At AD we support a collaborative and inclusive environment. We value open participation from individuals with different ideas experiences and perspectives which we believe make AD a better place to work.