What are the responsibilities and job description for the Database Administrator position at Affiliated Independent Distributors, Inc.?
Job Type
Full-time
Description
Position Summary :
The Database Administrator (DBA) at Affiliated Distributors (AD) manages the design, performance, and security of AD's databases (Oracle, MySQL, SQL Server, Postgres). This role ensures database reliability, backups, and smooth integration 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.
Primary 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
Qualifications :
Desired Skills :
Additional Comments :
1. Hours : 8 : 00 a.m. - 5 : 00 p.m.
2. Position is based in Wayne, PA where we have a hybrid work schedule with 3 days in the office (Tuesdays-Thursdays in office & Mondays and Fridays remote).
