PENNYMAC Pennymac is (NYSE: PFSI) is a specialty financial services firm with a comprehensive mortgage platform and integrated business focused on the production and servicing of U.S. mortgage loans and the management of investments related to the U.S. mortgage market. At Pennymac, our people are the foundation of our success and at the heart of our dynamic work culture. Together, we work towards a unified goal of helping millions of Americans achieve aspirations of homeownership through the complete mortgage journey. A Typical Day Pennymac is seeking a highly skilled and experienced Database Architect to design, implement, and manage our critical data infrastructure. You will play a pivotal role in shaping our data strategy, ensuring the performance, scalability, security, and availability of our database systems. This is an exciting opportunity to work with a diverse technology stack, including Microsoft SQL Server, PostgreSQL, Delphix, various NoSQL databases including DynamoDB, and AWS cloud services. You will be expected to bring an expert-level focus to automation across all aspects of database management and deployment, including infrastructure provisioning using Terraform or OpenTofu, experience with SQL Server to PostgreSQL migrations, deep expertise in query optimization across all database platforms (both SQL and NoSQL), and a strong understanding of SQL and NoSQL database principles. The Database Architect will: Design and implement robust and scalable database solutions leveraging Microsoft SQL Server, PostgreSQL, various NoSQL databases, ensuring optimal query performance from the outset. Develop and maintain data models, database schemas (both relational and NoSQL), stored procedures, with a focus on automation for deployment and management and inherent query efficiency. Architect and implement data replication and masking strategies using Delphix, with a strong emphasis on automated provisioning and configuration, including support for Microsoft SQl / PostgreSQL. Design and manage database infrastructure on AWS, including RDS for SQL Server and PostgreSQL, DynamoDB and other NoSQL services, and other data-related services, leveraging Infrastructure-as-Code (IaC) principles and automation tools, specifically Terraform or OpenTofu, while ensuring cost-effective and performant database configurations for both SQL and NoSQL environments. Proactively identify opportunities for automation across database operations, including provisioning, patching, backups, monitoring, performance tuning, with a strong focus on automating infrastructure deployment using Terraform or OpenTofu and automating performance analysis and optimization across all database types. Develop and implement expert-level automation scripts and frameworks using tools such as Python, PowerShell, AWS CLI, and other relevant technologies, including specific tooling for PostgreSQL and NoSQL database management and migration, as well as performance monitoring and optimization, and integration with Terraform or OpenTofu for infrastructure automation. Actively monitor and analyze query/data access performance across Microsoft SQL Server, PostgreSQL, and various NoSQL databases, identifying and resolving performance bottlenecks specific to each type. Develop and implement advanced query/data access optimization techniques, including index tuning (where applicable), query/data access pattern rewriting, and the use of database-specific performance analysis tools for both SQL and NoSQL databases. Optimize database performance across different database platforms through automated monitoring, alerting, and self-healing mechanisms, with a strong emphasis on query/data access efficiency and leveraging infrastructure automation where possible. Collaborate with development teams to understand data access patterns for various database backends (SQL and NoSQL) and design efficient and effective database solutions, ensuring seamless integration with automated deployment pipelines and optimal query/data access performance. Design and implement database schema and data model changes for Microsoft SQL Server, PostgreSQL, and NoSQL databases that are fully compatible with automated CI/CD pipelines and optimized for data retrieval and manipulation, with infrastructure dependencies managed by Terraform or OpenTofu. Develop and maintain highly sophisticated scripts and automation for database deployments and migrations within CI/CD workflows, minimizing manual intervention and ensuring consistency across database platforms (SQL and NoSQL), with built-in performance testing and validation, and infrastructure provisioning handled by Terraform or OpenTofu. Document database designs, configurations, and automation workflows in detail, including specific documentation for PostgreSQL and NoSQL environments and migration processes. Stay up-to-date with the latest trends and technologies in database management, cloud computing, and automation, with a strong focus on both Microsoft SQL Server and PostgreSQL ecosystems, including advanced query optimization techniques and the evolving landscape of IaC tools like Terraform and OpenTofu, as well as the latest developments in NoSQL database technologies and best practices. Provide technical guidance and mentorship to other team members, promoting a culture of automation and best practices for managing diverse database environments, including Microsoft SQL Server, PostgreSQL, DyanmoDB, and various NoSQL databases, with a strong emphasis on writing and optimizing efficient queries/data access patterns and leveraging Terraform or OpenTofu for infrastructure management. What You’ll Bring Bachelor's degree in Computer Science, or a related field. Master's degree preferred. Minimum of 5-7 years of experience as a Database Architect or in a similar role. Minimum of 5-7 years of experience with Microsoft SQL Server, including database design, administration, performance tuning, and high availability solutions, with a strong focus on automation and expert-level query optimization skills. Significant experience with PostgreSQL, including database design, administration, performance tuning, high availability, and replication, with a deep understanding of PostgreSQL-specific query optimization techniques. Significant hands-on experience with Delphix for data masking, virtualization, and replication, including advanced automation of workflows and support for PostgreSQL. Proven experience designing, implementing, and managing NoSQL databases, particularly DynamoDB on AWS, including data modeling, performance optimization, and scalability strategies. Experience with other NoSQL databases (e.g., MongoDB, Cassandra) is a plus. Deep understanding of AWS cloud services related to data, such as RDS for SQL Server and PostgreSQL, DynamoDB and other NoSQL services, S3, and data warehousing solutions (e.g., Redshift, Snowflake), and a proven ability to automate their deployment and management using IaC tools, specifically Terraform or OpenTofu, while ensuring optimal performance and cost-efficiency across all database types. Solid understanding of database security principles and best practices, with experience implementing automated security controls across different database platforms, including Microsoft SQL Server, PostgreSQL, and NoSQL databases. Expertise in data modeling techniques (e.g., relational, dimensional, NoSQL) with consideration for automated deployment across various database systems and optimal query/data access performance. Expert proficiency in writing complex SQL queries and stored procedures for both Microsoft SQL Server and PostgreSQL, with a strong focus on generating scripts for automated deployment and writing highly efficient queries, as well as understanding data access patterns and optimization techniques for NoSQL databases. Expert-level skills in scripting languages (e.g., Python, PowerShell) and automation frameworks for database tasks, with specific experience automating PostgreSQL and NoSQL database administration, maintenance, and performance analysis, and integration with Terraform or OpenTofu. Significant experience in planning and executing database migrations, particularly to and from PostgreSQL, including schema conversion, data migration, validation, and thorough performance testing and optimization on the target system, with infrastructure adjustments automated using Terraform or OpenTofu. Experience with data migration strategies for NoSQL databases is highly desirable. Proven experience in designing and implementing fully automated CI/CD pipelines for database changes using tools such as Jenkins, GitLab CI, AWS CodePipeline, or similar, with specific expertise in managing PostgreSQL and NoSQL database schema/data model changes and migrations within these pipelines, including automated performance testing, rollback strategies, and infrastructure provisioning using Terraform or OpenTofu. Demonstrated expertise in query/data access optimization techniques and tools for Microsoft SQL Server, PostgreSQL, and NoSQL databases (e.g., execution plans, index analysis, query hints, understanding NoSQL data access patterns and performance considerations). Strong hands-on experience with Infrastructure-as-Code (IaC) tools, specifically Terraform or OpenTofu, for provisioning and managing database infrastructure on AWS, including NoSQL services like DynamoDB. Excellent problem-solving, analytical, and communication skills, with the ability to articulate complex automation and migration strategies for diverse database environments, as well as provide clear recommendations for query/data access optimization and infrastructure management across SQL and NoSQL systems. Ability to work independently and collaboratively in a fast-paced environment, driving automation and efficient migration initiatives, with a strong focus on performance and infrastructure efficiency across all database technologies. Why You Should Join As one of the top mortgage lenders in the country, Pennymac has helped over 4 million lifetime homeowners achieve and sustain their aspirations of home. Our vision is to be the most trusted partner for home. Together, 4,000 Pennymac team members across the country are guided by our core values: to be Accountable, Reliable and Ethical in all that we do. Pennymac is committed to conducting a business that makes positive contributions and promotes long-term sustainable growth and to fostering an equitable and inclusive environment, where all employees and customers feel valued, respected and supported. Benefits That Bring It Home: Whether you're looking for flexible benefits for today, setting up short-term goals for tomorrow, or planning for long-term success and retirement, Pennymac's benefits have you covered. Some key benefits include: Comprehensive Medical, Dental, and Vision Paid Time Off Programs including vacation, holidays, illness, and parental leave Wellness Programs, Employee Recognition Programs, and onsite gyms and cafe style dining (select locations) Retirement benefits, life insurance, 401k match, and tuition reimbursement Philanthropy Programs including matching gifts, volunteer grants, charitable grants and corporate sponsorships We value the hard work and dedication of our employees. In addition to a competitive salary, positions may offer bonus opportunities. To learn more about our benefits visit: https://pennymacnews.page.link/benefits Compensation: Individual salary may vary based on multiple factors including specific role, geographic location / market data, and skills and experience as defined below: Lower in range - Building skills and experience in the role Mid-range - Experience and skills align with proficiency in the role Higher in range - Experience and skills add value above typical requirements of the role Some roles may be eligible for performance-based compensation and/or stock-based incentives awarded to employees based on company and individual performance. Salary $95,000 - $155,000 Work Model OFFICE