Multiplatform Database Administrator Senior

Freddie Mac•McLean, VA

6d•$116,000 - $174,000

About The Position

The Multiplatform Database Administrator Senior will serve as a technical authority on complex database migration and upgrade initiatives within the Development Factory Group at Freddie Mac. This role involves active participation in end-to-end project implementations, providing hands-on guidance to execution teams, and ensuring adherence to enterprise standards. The position requires deep technical expertise, adaptability, and a proactive, solutions-oriented approach to troubleshooting software challenges in a fast-paced environment.

Requirements

Bachelor's degree in Computer Science or Engineering or equivalent experience.
Production/Application DBA with 5-7 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.
5+ 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.
Strong understanding of database interfacing technologies such as ODBC, JDBC and DBMS Native clients.

Nice To Haves

Advanced studies/degree
Working knowledge of Snowflake and data pipelines

Responsibilities

Lead database upgrade projects from analysis to implementation.
Provide subject matter expertise in AWS Aurora and at least two other RDBMS platforms.
Collaborate with engineering teams on technical decisions.
Lead performance troubleshooting and tuning tasks.
Provide technical leadership and strategic direction for database transformation initiatives.
Document standard operating procedures and platform level checklists.
Mentor junior team members.
Identify areas for continuous improvement and automate tasks.
Provide DB SME support to developers and testers.
Provide troubleshooting support for application/database issues during development, testing, and deployment phases.
Coordinate server/instance and database builds, database refreshes, and security implementations with TS counterparts.
Document lessons learned and maintain a knowledge database.
Collaborate with IT teams to identify efficiency opportunities.
Champion and influence technology decisions with business partners and IT management.
Champion current industry trends.
Drive technical solutions in alignment with architectural roadmaps.
Engage with engineering and technology partners to define remediation and test strategies.