Database Administrator

Affiliated Independent Distributors - Wayne, PA

Full-time

Wayne, PA

Professional, Scientific, and Technical Services

About the position

The Database Administrator (DBA) at Affiliated Distributors (AD) is responsible for managing the design, performance, and security of the company's databases, including Oracle, MySQL, SQL Server, and Postgres. This role ensures database reliability, performs backups, and integrates smoothly with production systems while optimizing performance and maintaining system stability. The DBA also develops SQL procedures, conducts audits, and collaborates with IT teams to ensure database availability and security across all environments.

Responsibilities

• Serve as the primary technical resource for designing, managing, and documenting databases (Oracle, MySQL, SQL Server, Postgres), ensuring continuous access and system stability.
• Safeguard vital data with robust security measures, perform regular backups, and maintain documentation of backup/recovery plans.
• Optimize database performance and capacity across all environments (production, QA, development), including conducting audits to maintain security and performance.
• Develop SQL procedures for enterprise database queries, updates, and performance tuning; ETLs, security, and availability.
• Implement security by design within databases and oversee the in-house security of all databases, minimizing the reliance on third-party solutions; conduct periodic audits for security improvements.
• Assist with system changes, new implementations, and IT budget planning by recommending database-related equipment, software, and upgrades.
• Collaborate with IT teams on system integrity, availability, and security, while supporting internal applications and the AD Public & Private Websites.
• Archive and manage historical data for performance optimization and data management.
• Establish best practices, identify enhancements, and perform regular reviews and audits to improve database systems.

Requirements

• Bachelor's degree in Computer Science, Business Administration, or equivalent experience.
• At least three years of hands-on experience with Oracle databases.
• Proficient in writing complex SQL queries.
• Experience working in both Windows and Linux operating systems.
• Familiarity with extraction, transformation, and loading (ETL) tools.
• Strong written and verbal communication skills.
• Experience migrating databases to cloud platforms (AWS, Azure, Oracle) is a plus.

Nice-to-haves

• Proficient in administering Microsoft SQL Server and PostgreSQL databases.
• Able to design and implement security protocols within database structures.
• Experienced in managing and improving in-house database security, minimizing reliance on third-party services.
• Regularly conducts database audits to ensure security and performance optimization.
• Establishes and enforces database management best practices with a focus on continuous improvement.
• Skilled in performing security audits to enhance database access controls and improve performance.