F

Freddie Mac

Buys home loans from lenders and sells them as bonds

Multiplatform Database Administrator Senior

Database AdministrationConfirmed live in the last 24 hours
Full-timeMcLean, VA, USAIn-person

About the Job

Requirements

  • Bachelor's degree in Computer Science or Engineering, or equivalent experience; advanced studies or a degree are preferred.
  • At least 5–7 years of experience as a production or application database administrator.
  • Proficiency in multiple RDBMS platforms, including SAP ASE (Sybase), Oracle, Microsoft SQL Server, PostgreSQL, DB2, and AWS Aurora.
  • Hands-on experience with AWS database services, including Amazon RDS, Aurora, DMS, and SCT.
  • Understanding of AWS networking, security (IAM, VPC, and security groups), and storage options.
  • At least 5 years of experience in database version upgrades and cross-platform migrations.
  • Experience migrating on-premises databases to AWS Aurora.
  • Proficiency in database replication technologies and high-availability solutions.
  • Strong UNIX knowledge and proficiency in shell scripting.
  • Working knowledge of Perl, Python, or similar scripting languages.
  • Strong troubleshooting and problem-solving skills.
  • Understanding of hardware performance, memory, and I/O.
  • Experience with DBMS-specific tools for query/explain plans, database advisors, and query snapshots, including interpreting them and troubleshooting problems.
  • Strong understanding of database interfacing technologies such as ODBC, JDBC, and DBMS native clients.
  • Good interpersonal, communication, relationship-building, and teamwork skills.
  • Ability to communicate effectively with business and technical teams to achieve goals.
  • Motivation to learn new technologies and identify process improvements and efficiencies.

Responsibilities

  • Lead database upgrade projects from analysis through implementation, owning and executing activities across RDBMS platforms including SAP ASE, Oracle, PostgreSQL, DB2, Microsoft SQL Server, and AWS Aurora.
  • Provide subject matter expertise in AWS Aurora and at least two other listed database technologies.
  • Contribute to technical decisions with engineering teams, drawing on knowledge of the architecture and technologies involved.
  • Lead performance troubleshooting and tuning tasks.
  • Provide technical leadership and strategic direction for database transformation initiatives between platforms.
  • Document standard operating procedures and platform-level checklists, and ensure compliance with them.
  • Mentor junior team members and provide direction as needed.
  • Identify opportunities for continuous improvement and automate tasks where possible.
  • Provide database subject matter expertise to developers and testers across concurrent workstreams.
  • Troubleshoot application and database issues involving multiple technologies during development, testing, and deployment, and provide solutions.
  • Coordinate server, instance, and database builds, database refreshes, and security implementations with technical services counterparts.
  • Resolve complex technical problems using professional experience and creative approaches.
  • Document lessons learned and help maintain the knowledge database.
  • Collaborate with IT teams to identify opportunities to improve efficiency.
  • Influence technology decisions with business partners, IT management, and team members across complex projects while negotiating and maintaining effective working relationships.
  • Partner with Engineering and Architecture Services to promote current industry trends.
  • Drive technical solutions aligned with architectural roadmaps.
  • Engage Engineering and other technology partners during project inception to understand environmental complexities and define remediation and testing strategies.

Desired Qualifications

  • Working knowledge of Snowflake and data pipelines.

About the Company

Freddie Mac

Buys home loans from lenders and sells them as bonds

Freddie Mac buys home and apartment loans from banks, credit unions and other lenders so they have fresh money to keep lending to American homebuyers and renters. Congress created it to bring liquidity, stability and affordability to the U.S. housing market, and it sits with Fannie Mae at the center of the country's mortgage system. It never lends to borrowers directly; instead it purchases loans that meet its standards, pools them into mortgage-backed securities sold to investors worldwide, and guarantees the payments. It earns money from guarantee fees and interest on the loans it holds. Freddie Mac was chartered in 1970 and is based in McLean, Virginia.

Company size
5,001-10,000
Company stage
IPO
Headquarters
McLean, VA
Founded
1970

Recently Posted Jobs

Explore more opportunities at Freddie Mac

See more jobs