System Engineer - Dallas- Vice President

Goldman Sachs • Dallas, TX

3h • Onsite

About The Position

Our team of engineers builds solutions to the most complex problems. We develop cutting-edge systems and processes that form the core of our key business and enable transactions to move in milliseconds. We provide real-time access to critical deal information and crunch billions of data points each day to inform firm-wide market insights and strategies. Team members have the opportunity to work at the forefront of technology innovation alongside industry leaders and make significant contributions to the field.
The team ensures knowledge, best practices and expertise are all shared between regions promoting teamwork and collaboration.
Candidates should be able to demonstrate sound technical knowledge. They will be motivated by their passion for technology. They will be able to manage the balance of innovation over risk, and act as a source of thought leadership within the data community.
We are seeking a highly skilled and self-motivated Senior Oracle Cloud Database Administrator to take complete ownership of our entire fleet of Amazon RDS for Oracle databases. The ideal candidate is a subject matter expert with deep technical knowledge of both Oracle and AWS, capable of managing the full database lifecycle from design and implementation to performance tuning and disaster recovery. This role requires a proactive individual who can work independently to ensure the stability, integrity, and performance of our cloud database environment while providing expert guidance to internal clients.

Requirements

• Experience: 12+ years as an Oracle Database Administrator, with at least 4+ years of hands-on experience managing Oracle databases on Amazon RDS.
• Deep knowledge of Oracle Database architecture (12c/19c), including instance management, memory structures, and management of schema objects, Undo, and Redo.
• Extensive, hands-on experience with Amazon RDS for Oracle, including Multi-AZ deployments, Cross-Region Automated Backups, Read Replicas, parameter groups, and option groups.
• Proven expertise in troubleshooting and resolving complex performance issues using tools like AWR, ASH, ADDM, and SQL execution plan analysis.
• Mastery of Oracle RMAN and a thorough understanding of RDS snapshot and point-in-time recovery mechanisms.
• Strong understanding of core AWS services, including VPC, Subnets, Security Groups, IAM, and CloudWatch.
• Familiarity with Oracle licensing models on AWS, particularly Bring-Your-Own-License (BYOL) and its implications for features like Data Guard.
• Proficiency in at least one scripting language (e.g., Python, Bash) for automation and reporting.
• Familiar with SRE principles, SLO monitoring and management.
• Ability to work effectively with a globally distributed team, while able to operate independently.

Responsibilities

• Oversee the entire lifecycle of Oracle RDS instances, including provisioning, configuration, patching, and upgrades across multiple AWS accounts and regions.
• Serve as the primary SME for development teams and clients, providing expert guidance on AWS and Oracle best practices for high availability, disaster recovery (Multi-AZ and Cross-Region), security, and cost optimization.
• Proactively monitor database performance, identify bottlenecks, and perform advanced tuning of the database and complex SQL queries. Provide end-to-end, hands-on troubleshooting for all database-related issues, from connectivity to data corruption.
• Design and implement secure, scalable, and resilient database solutions on RDS, including robust connectivity patterns using VPCs, security groups, and other AWS networking constructs.
• Define, implement, and regularly test backup and recovery strategies using both RDS automated backups and native Oracle RMAN where applicable, ensuring RPO and RTO objectives are met.
• Implement and manage database security controls, including user access management, data encryption, and audit logging to meet compliance requirements.
• Develop and maintain scripts (Shell, Python) to automate routine database tasks. Configure and manage comprehensive monitoring and alerting to ensure proactive issue resolution.
• Analyze performance and usage trends to perform capacity planning and forecast future database needs.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed