PENNYMAC
Pennymac (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.
Job Overview
The Senior Database Architect is responsible for the design, implementation, architecture, performance, integrity, security of databases best practice and implementation. Providing day to day operational support to the Database Administration and Database Architect. Troubleshoots and debugs to identify root cause of database performance and exceptions. Collaborates on corporate projects and initiatives regarding Database and Data Management.
A Typical Day

• Design and build highly available and high-volume relational databases
• Perform backups, restores, and recovery models as needed
• Plan, prepare, test and perform database patches and upgrades
• Implement operational automation and monitoring using scripts and SQL jobs
• Performance tune and write code for database data manipulation
• Able to prioritize and execute tasks in a high-pressure environment
• Highly self-motivated and directed
• Proven analytical, evaluative and problem-solving abilities
• Provides and designs tools to assist in the automated management of the database and transaction processing environment
• Establish and monitor database processes and periodic maintenance tasks
• Create, implement, and manage data management and migration processes
• Analyze, develop and implement solutions that meet the companies capacity and performance requirements
• Analyze and tune databases for optimal efficiency
• Assist with backup, clustering, mirroring, replication and failover activities
• Provide assistance in the areas of database security and the security of the data in the database
• Optimize SQL performance, work with database partitioning, compression and indexing
• T-SQL coding; including stored procedures, views, and triggers as needed
• Experience participating in the support of large scale databases
• Ability to work flexible hours under minimal supervision.
• Being strong in team Orientation, Customer Thinking, Focus and Responsiveness, Drive for Results, Applying Technical Expertise, Analytical Thinking
• Provide and enforce best practice

What You'll Bring

• Bachelor's Degree in Computer Science or related Field or equivalent work experience
• 10+ years of experience in database architectural design
• Architectural knowledge of the following database engine best practices: MS SQL, PostgreSQL, MongoDB, MySQL, DynamoDB, Snowflake, & Redshift
• Architectural knowledge of AWS database DevOps best practices and implementation
• Architectural knowledge of database replication : AlwaysOn, Transactional replication, DMS
• Working knowledge of differing approaches to data storage in AWS
• Working knowledge of AWS Database Migration Service
• Experience working in an Agile environment

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

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
$91,500 - $223,500