Freddie Mac

Senior Oracle Database Engineer

Freddie Mac

full-time

Posted on:

Location Type: Office

Location: McLeanTexasVirginiaUnited States

Visit company website

Explore more

AI Apply
Apply

Salary

💰 $118,000 - $176,000 per year

Job Level

About the role

  • 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.

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
  • Database and Cloud vendor certification, preferred
Benefits
  • Comprehensive total rewards package
  • Competitive compensation
  • Market-leading benefit programs
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
Oracle Database administrationDatabase performance tuningAutomation scriptingShell scriptingPython scriptingDatabase securityHigh availability (HA)Disaster Recovery (DR)Data replicationDatabase provisioning
Soft Skills
Excellent written communicationExcellent verbal communication
Certifications
Database certificationCloud vendor certification