Senior Oracle Database Engineer

Freddie Mac•McLean, VA

3d•$118,000 - $176,000•Onsite

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 Platform Infrastructure and Network Services (PINS) team at Freddie Mac is seeking a skilled Senior Database Engineer with deep expertise in Oracle. In this role, you will oversee on-premises database administration in a dynamic, fast-paced operations environment, supporting 24x7 mission-critical applications that utilize both analytical and transactional databases. Key responsibilities include: Administering and maintaining Oracle databases to ensure optimal performance, reliability, and security. Developing and maintaining automation scripts to streamline on-premises database operations. Troubleshooting and resolving complex database issues promptly to minimize downtime. Conducting comprehensive performance analysis and tuning of Oracle databases. Implementing and enforcing database security best practices. Researching, evaluating, and recommending emerging database trends and technologies. Designing, developing, and testing automation scripts and code to support database administration and related tools. The ideal candidate will demonstrate strong Oracle database expertise, scripting and automation skills, and a proactive approach to problem-solving in a 24x7 operational environment. Our Impact: The Enterprise Operations + Technology Division helps enable and transform Freddie Mac business through operational resilience and technology innovation. Your Impact: The addition of a Senior Database Engineer specializing in Oracle will ensure optimal configuration, tuning, and maintenance of our database systems. This will result in improved system performance, reduced downtime, and increased reliability for all division-critical applications. The new hire will strengthen our data security posture by implementing best practices in Oracle database management, backup, and disaster recovery. This reduces the risk of data loss and ensures compliance with regulatory requirements. Senior Database Engineer will streamline routine database operations, freeing up resources and allowing the division to focus on strategic initiatives. In addition, the engineer will impact the following: Provide DBA support on all aspects of databases administration including provisioning, backup/recovery, replication, deployment and real time production troubleshooting responsibilities on Oracle Install, configure, monitor, upgrade and maintain database in production and non-production environments Provide DBA support for production environment on rotation schedule and on adhoc need basis Ensure database security , user access controls and compliance with industry standards Build scripts in Shell or python to automate routine tasks. Diagnose and address database performance issues using performance monitors and various tuning techniques Interact with Systems administrators on Linix/Unix/VM operating systems issues related to Databases Able to write database provisioning, maintenance and reporting automation scripts Configure and maintain Database High availability Support data replication and Sharding Troubleshoot database production problems and database connectivity issues Implement Disaster Recovery (DR) solutions

Requirements

7 + years of experience in Oracle Database administration
Extensive Database performance tuning experience
Deep knowledge of industry-standard, enterprise-class best practices for a large database environment
Deep understanding of high availability (HA), DR Database and storage technologies
Data replication Experience implementing, supporting and auditing database security
Experience supporting Oracle on prem, preferred
Experience with Database monitoring tools, preferred
Excellent written and verbal communication skills
Experience working in virtual environment using VMware, preferred
Proficiency in automation using scripting languages like Shell and Python, along with configuration management tools like Ansible, preferred

Nice To Haves

Database and Cloud vendor certification, preferred
Anticipate issues before they arise and implement preventive measures.
Ability to work well as a team and as an individual with minimal supervision
Deep expertise in oracle technologies and ability to stary current with emerging tools
Work seamlessly across teams, translating technical concepts into business value

Responsibilities

Administering and maintaining Oracle databases to ensure optimal performance, reliability, and security.
Developing and maintaining automation scripts to streamline on-premises database operations.
Troubleshooting and resolving complex database issues promptly to minimize downtime.
Conducting comprehensive performance analysis and tuning of Oracle databases.
Implementing and enforcing database security best practices.
Researching, evaluating, and recommending emerging database trends and technologies.
Designing, developing, and testing automation scripts and code to support database administration and related tools.
Provide DBA support on all aspects of databases administration including provisioning, backup/recovery, replication, deployment and real time production troubleshooting responsibilities on Oracle
Install, configure, monitor, upgrade and maintain database in production and non-production environments
Provide DBA support for production environment on rotation schedule and on adhoc need basis
Ensure database security , user access controls and compliance with industry standards
Build scripts in Shell or python to automate routine tasks.
Diagnose and address database performance issues using performance monitors and various tuning techniques
Interact with Systems administrators on Linix/Unix/VM operating systems issues related to Databases
Able to write database provisioning, maintenance and reporting automation scripts
Configure and maintain Database High availability
Support data replication and Sharding
Troubleshoot database production problems and database connectivity issues
Implement Disaster Recovery (DR) solutions