
Senior Oracle Database Engineer
Freddie Mac
full-time
Posted on:
Location Type: Office
Location: McLean • Texas • Virginia • United States
Visit company websiteExplore more
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