SQL DBA - Site Reliability Operations

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

As a member of the Site Reliability Operations (SRO) team, you will help provide 24/7 monitoring and support of Pennymac's database infrastructure and related systems. This role focuses specifically on database operations, performance optimization, and ensuring the reliability of our database platforms. Ideal candidates should have strong experience in database administration, SQL development, and AWS database services. Individuals in this role should be comfortable working in a fast-paced environment. Multitasking, in addition to communicating quickly and accurately, is critical to the success of anyone in this role.

Responsibilities

• Database Monitoring - 24/7 health monitoring of Pennymac's database infrastructure using tools such as AWS CloudWatch, New Relic, and database-specific monitoring solutions.
• Database Incident Management - Coordinate with Pennymac's Incident Management team and key stakeholders to help resolve database-related production incidents quickly and accurately.
• Database Administration - Responsible for various database administrative tasks including, but not limited to: user management, security configuration, backup validation, and query optimization.
• Database Job Management - Monitoring and troubleshooting of database jobs, batch processes, and scheduled maintenance tasks. Ensure job execution meets SLA requirements and troubleshoot failures promptly.
• SQL Development and Optimization - Write, review, and optimize SQL queries for performance. Analyze query execution plans and recommend improvements to application teams.
• Database Performance Tuning - Investigate and troubleshoot database performance issues, including slow queries, blocking, deadlocks, and resource contention. Implement performance improvements and capacity planning recommendations.
• Internal and External Escalation - Act as a point of escalation for any database-related production incidents. Ensure that key stakeholders are contacted in a timely manner to ensure quick and accurate resolution.
• Change Management - Follow and enforce Pennymac's established Change Management processes and procedures for all database-related changes.
• Communication - Monitor and respond to Call, Chat, and Email inquiries related to database operations sent to the SRO team.
• Ticket Queue Management - Manage database-related requests using tools such as ServiceNow and JIRA to ensure deliverables are on time and accurate.
• Documentation - Assist in maintaining the team's knowledge base of database support articles, runbooks, and Standard Operating Procedures. Play an active role in the creation of new database documentation as needed.
• Database Backup and Recovery - Responsible for various tasks related to database backup management, validation, and recovery testing using tools like CommVault. Ensure backup integrity and recovery readiness.
• Capacity Planning - Monitor database growth trends, analyze resource utilization, and provide recommendations for capacity planning and infrastructure scaling.
• Database Security and Compliance - Maintain database security standards, access controls, and ensure compliance with regulatory requirements and company policies.
  
  

Qualifications

What You’ll Bring

• Bachelor's Degree in Computer Science, Information Systems, or comparable experience
• Proficiency in SQL development and database query optimization
• Strong experience with SQL Server Management Studio (SSMS) and database administration tools
• Experience with multiple database platforms (SQL Server, PostgreSQL, Snowflake, etc.)
• AWS Cloud Practitioner or Solutions Architect certification
• AWS Database Specialty certification is a plus
• Experience with AWS database services including RDS, Aurora, and DynamoDB
• Experience monitoring database performance using tools such as New Relic and AWS CloudWatch
• Experience with programming languages such as PowerShell or Python
• Understanding of database security best practices and access management
• Knowledge of database clustering, replication, and high availability configurations
• Familiarity with CI/CD pipelines for database deployments
• Strong attention to detail with focus on data integrity and accuracy
• Able to prioritize tasks and have a sense of urgency with critical database issues or requests
• Excellent written and verbal communication skills
• Must be comfortable completing annual role-based training and certification assignments
• Ability to work onsite in Westlake Village, CA
  
  

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

$75,000 - $130,000

Work Model

OFFICE