Database Administrator

Job Description

The Database Administrator manages an MS-SQL-based data warehouse critical for team operations and organizational insights. This role involves consolidating data from various sources, ensuring high performance, and facilitating data-driven decision-making. The ideal candidate possesses SQL server administration skills, data engineering expertise, and proficiency in tools like Excel or Tableau for business analysis. The role contributes to the company's mission by supporting scalable operations and informed decision-making.

To perform this job successfully, an individual must be able to perform each of the essential duties and responsibilities satisfactorily. Additionally, the person must possess and adhere to the following core company values:

• Integrity

• Passion

• Work Ethic

Essential Duties and Responsibilities:

• Takes ownership in managing all aspects of the DW and its core functions.

• Monitor SQL Server Agent to ensure daily/monthly SSIS packages execute successfully; troubleshoot and resolve intermittent job failures, occasionally outside of normal business hours (including weekends).

• Test and deploy enhancements to SSIS packages and data transfer protocols, including QA to avoid downstream data dependency errors.

• Integrate 3rd party data sources using API's / SFTP, and support changes to existing integrations.

• Maintain account management policies; recommend and implement approved security policies.

• Assess historical performance, and recommend strategies for optimizing the data processing model, data storage, and indexing structure.

• Detect issues concerning data integrity and assume responsibility for resolving those issues.

• Document SQL server changes and SSIS package enhancements in Azure DevOps; document key datasets and database structure.

• Become a subject matter expert of our existing datasets and infrastructure; provide technical guidance to BI developers and SQL Server end-users by assisting with query tuning and educating on best practices.

• Collaborate with cross functional teams across the organization to establish robust data processes/pipelines.

• Actively participate in the expansion of the mortgage analytics team to support other business units and initiatives that help elevate the team.