Database Engineer
About The Position
Redwood Trust is seeking a Database Engineer to join its Core Data Services team. Reporting to the SVP, Application Development Manager, this role supports, maintains, and improves the SQL Server databases, enterprise data pipelines, and integrations that power operational and analytical systems. The work focuses primarily on day-to-day support and administration of on-premises data systems, with targeted development to fix and extend existing processes, while also supporting readiness for future cloud adoption and modernization. The Database Engineer manages SQL Server operations and maintenance, monitors SSIS packages and ETL/ELT processes, responds to production incidents, and troubleshoots database and ETL performance. The role also maintains data access controls, enhances pipelines and database objects, supports data models and data marts, and documents data processes. The engineer partners with application development, corporate technology, business stakeholders, and adjacent engineering teams, and contributes to cloud migration evaluations, code reviews, mentoring, and automation of recurring support tasks.
Requirements
- A bachelor’s degree in Computer Science, Information Systems, or a related field, or equivalent practical experience.
- At least 5 years of experience in SQL Server database administration, ETL/data engineering, or database support, with demonstrated success supporting production data environments.
- Advanced T-SQL skills, including query and performance tuning, troubleshooting, and a solid working knowledge of data modeling in Microsoft environments.
- Strong hands-on experience with SQL Server and SSIS, including supporting, debugging, and modifying existing packages in production.
- Experience troubleshooting production incidents and balancing multiple assignments and changing priorities.
- Ability to learn complex business processes and technologies quickly, work independently, and collaborate effectively across teams.
- Sound judgment, clear communication, and a calm, practical approach to production issues.
Nice To Haves
- Additional depth in SQL Server administration, including backup and recovery, SQL Agent job management, indexing, security, and permissions.
- Exposure to Azure Data Factory, Microsoft Fabric, cloud data platforms, or data migration initiatives, with an interest in building skills as the platform evolves.
- Experience supporting Oracle databases.
- Experience using Python, PowerShell, or other scripting languages to automate data operations and support activities.
- Familiarity with CI/CD pipelines, DevOps practices, data governance frameworks, and compliance-oriented controls.
Responsibilities
- Manage SQL Server database operations, including patches and updates, SQL Agent job monitoring, backup and restore validation, index and statistics maintenance, capacity monitoring, and routine health checks.
- Monitor and maintain SSIS packages and ETL/ELT processes, resolve scheduled load failures, and ensure data is delivered accurately and on time.
- Respond to production incidents, identify root causes, resolve issues, and coordinate deployments and recovery activities with infrastructure and application teams.
- Troubleshoot and tune database and ETL performance through query and execution plan analysis, addressing bottlenecks to improve reliability, throughput, and scalability.
- Maintain database access controls, permissions, password management, and auditability to protect data integrity and meet enterprise security standards.
- Enhance existing pipelines, stored procedures, and database objects, and develop new ETL processes as needed using SQL Server, SSIS, and, where applicable, Azure Data Factory or Microsoft Fabric.
- Maintain and improve data models, data marts, and database structures that support enterprise processing, operational reporting, and downstream integrations.
- Create and maintain runbooks, source-to-target mappings, data dictionaries, process documentation, and data flow diagrams to support ongoing operations.
- Partner with Application Development, Corporate Technologies, business stakeholders, and adjacent engineering teams to resolve data issues and improve processes.
- Support cloud migration and modernization evaluations, connecting current on-premises operations with potential cloud and Microsoft Fabric capabilities.
- Participate in code reviews, mentor junior team members, and automate recurring support tasks to improve monitoring and operational resilience.
Benefits
- Medical, dental, and vision coverage.
- A 401(k) plan with company match.
- Discretionary corporate bonus program.
- Employee stock purchase program.
- Life insurance and disability coverage.
- Mortgage and renter’s insurance reimbursement program.
- Flexible spending accounts and an employee assistance program.
- Paid holidays and generous paid time off.
- Paid time off for volunteering.
- Paid family leave, fertility and adoption benefits.
- Wellness programs and fitness-related expense reimbursements up to $1,000 per year.
- Free on-site gyms and weekly catered lunches at many office locations.
- Professional learning and development opportunities.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
