Software Engineer, Tech Lead

Freddie Mac • McLean, VA

66d • $138,000 - $206,000

About The Position

At Freddie Mac, our mission of Making Home Possible is what motivates us, and it’s at the core of everything we do. Since our charter in 1970, we have made home possible for more than 90 million families across the country. Join an organization where your work contributes to a greater purpose. Position Overview: The Enterprise Business Technology Office (BTO) at Freddie Mac enables business operational excellence through the flexible use of technology. The team supports the needs of the enterprise groups, including the chief administrative office, compliance, enterprise risk management, finance, human resources, diversity and outreach, internal audit and legal. In addition to championing and empowering business partners, Enterprise BTO takes steps to improve efficiency and effectiveness across the organization. Our IT Development Tech Lead position is in the Development Factory Group, which sits in the Enterprise BTO. We are a fast-paced team that interacts with all areas of Freddie Mac’s business, provides solid experience and knowledge across the IT spectrum. Our team is made up of hardworking individuals who thrive in an exciting work environment and enjoy utilizing their problem-solving skills. The role will act as a Lead on database upgrade projects on different platforms, driving end to end implementation in all environments while simultaneously providing technical guidance to project execution team. The position will also ensure adherence to standards and procedures across all platforms and be ready to step outside of his/her comfort zone to troubleshoot software issues. This role will ensure a high level of quality and accuracy in project delivery across all lines.

Requirements

• Bachelor's degree in Computer Science or Engineering or equivalent.
• Production / Application DBA with 10 - 15 years of experience in database administration.
• Proficient in multiple RDBMS platforms including SAP ASE (Sybase), Oracle, MSSQL Server, PostgreSQL, DB2 and AWS Aurora.
• Hands-on experience with AWS database services (Amazon RDS, Aurora, DMS, SCT).
• Understanding of AWS networking, security (IAM, VPC, Security Groups), and storage options.
• 10+ years of experience in database version upgrades and cross-platform migrations.
• Experience migrating from on-prem databases to AWS Aurora.
• Proficient in different replication technologies/high availability solutions for databases.
• Strong UNIX knowledge and proficiency in shell scripts.
• Working knowledge of PERL, Python and other similar scripting languages.
• Strong troubleshooting and problem-solving skills.
• Good understanding of hardware performance, memory and I/O.
• Experience with DBMS specific tools for query/explain plans, database advisors, query snapshots, ability to understand them and troubleshoot the problems.
• Strong understanding of database interfacing technologies such as ODBC, JDBC and DBMS Native clients.
• Working knowledge of Snowflake and data pipelines is a plus.

Nice To Haves

• Good interpersonal, communication, relationship building and team working skills.
• Proven ability to communicate optimally with various teams, both business and technical, to achieve goals.
• Ability to communicate clearly, efficiently, persuasively.
• Motivated to learn new technologies and identify process improvements and efficiencies.

Responsibilities

• Lead database upgrade projects from analysis to implementation, owning and overseeing all activities involved for various RDBMS platforms (SAP ASE, Oracle, PostgreSQL, DB2, MSSQL Server, AWS Aurora, etc.)
• Provide subject matter expertise in AWS Aurora and at least two of the above technologies.
• Drive technical decisions in collaboration with engineering teams, providing insights based on a deep understanding of the architecture and technologies involved.
• Lead performance troubleshooting and tuning tasks.
• Provide technical leadership and strategic direction for database transformation initiatives from one platform to another.
• Document standard operating procedures and platform level checklists for the team to follow and ensure compliance across the board.
• Mentor junior team members and provide direction wherever necessary.
• Identify areas for continuous improvement and automate tasks, wherever possible.
• Provide DB SME support to a large group of developers and testers, sometimes in parallel.
• Provide troubleshooting support for application/database issues involving multiple technologies during development/testing and deployment phases and provide solutions.
• Work with TS counterparts and coordinate server/instance and database builds, database refreshes and security implementations.
• Employ extensive professional experience and creativity to resolve sophisticated technical problems.
• Document lessons learned, help maintain knowledge database.

Benefits

• Competitive compensation and market-leading benefit programs.
• Annual incentive program.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: Bachelor's degree
• Number of Employees: 5,001-10,000 employees