Database Administrator

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.

Primary Responsibilities

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...