Affiliated Independent Distributors, Inc.
Database Administrator
Affiliated Independent Distributors, Inc., Wayne, Pennsylvania, United States, 19087
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:
• 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.
Desired Skills:
• 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.
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).
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:
• 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.
Desired Skills:
• 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.
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).