Database Administrator

$102,170 - $114,566/Yr

Plymouth Housing Group - Seattle, WA

Full-time - Mid Level

Seattle, WA

Real Estate

About the position

The Database Administrator at Plymouth Housing is responsible for the development and implementation of the Plymouth Housing Group Data Warehouse. This role involves managing, customizing, and synchronizing all databases with the Data Warehouse, ensuring data integrity and security, and collaborating with various stakeholders to maintain seamless database operations. The position plays a critical role in supporting the organization's mission to provide permanent supportive housing for individuals experiencing chronic homelessness.

Responsibilities

• Develop and implement the PHG Data Warehouse, integrating data from various sources.
• Collaborate with software vendors, IT, and Data Analytics staff to configure and maintain databases (e.g., SQL Server, Oracle, MySQL).
• Design and customize applications to track programs and activities.
• Oversee data ELT processes, including migration and data entry.
• Ensure data security, including PII and HIPAA compliance.
• Maintain access control, audit records, and system security.
• Develop and manage backup and recovery plans.
• Monitor and optimize data warehouse performance.
• Diagnose and resolve data warehouse issues.
• Integrate data from various sources into the data warehouse.
• Adapt the database to meet evolving organizational needs.
• Modify the database for new programs, funding changes, and compliance requirements.
• Conduct regular audits to verify data accuracy.
• Ensure compliance with reporting requirements.
• Maintain comprehensive documentation of data warehouse configurations and policies.
• Develop user manuals, policies, procedures, and training for end-users.
• Serve as the primary contact for vendor updates and troubleshooting.
• Collaborate with IT and Data Analytics staff to ensure data stability and accessibility.

Requirements

• Bachelor's degree in computer science or a related field, or equivalent combination of experience and training.
• At least 2 years' experience in database programming and/or administration.
• At least 2 years' experience with data warehousing.
• Proven experience with SQL and data analytics.
• Experience in testing and verifying data accuracy.
• Strong knowledge of database design, implementation, operation, and maintenance.
• Excellent analytical and problem-solving skills with a keen attention to detail.
• Strong project management skills with the ability to meet deadlines.
• Effective oral and written communication skills, particularly in explaining technical concepts to non-technical staff.
• Ability to multitask and prioritize in a dynamic environment.

Nice-to-haves

• Familiarity with Microsoft Azure Services, Microsoft SQL and SAP SQL is a plus.

Benefits

• Health insurance
• Dental insurance
• Vision insurance
• Paid time off
• Employee assistance program
• 403(b) options
• Supplementary benefits such as a subsidized ORCA pass.