WHO WE ARE:
Goldman Sachs is a leading global investment banking, securities and investment management firm that provides a wide range of services worldwide to a substantial and diversified client base that includes corporations, financial institutions, governments and high net-worth individuals.
Founded in 1869, it is one of the oldest and largest investment banking firms. The firm is headquartered in New York and maintains offices in London, Bengaluru, Dallas, Tokyo, Hong Kong and other major financial centres around the world.
We are committed to growing our distinctive Culture and holding to our core values which always place our client's interests first. These values are reflected in our Business Principles, which emphasize integrity, commitment to excellence, innovation and teamwork.
BUSINESS UNIT OVERVIEW:
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.
Job Summary:
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.
Responsibilities include:
- 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.
SKILLS / EXPERIENCE:
- Experience: 12+ years as an Oracle Database Administrator, with at least 4+ years of hands-on experience managing Oracle databases on Amazon RDS.
- Oracle Expertise: Deep knowledge of Oracle Database architecture (12c/19c), including instance management, memory structures, and management of schema objects, Undo, and Redo.
- AWS RDS Expertise: Extensive, hands-on experience with Amazon RDS for Oracle, including Multi-AZ deployments, Cross-Region Automated Backups, Read Replicas, parameter groups, and option groups.
- Performance Tuning: Proven expertise in troubleshooting and resolving complex performance issues using tools like AWR, ASH, ADDM, and SQL execution plan analysis.
- Backup & Recovery: Mastery of Oracle RMAN and a thorough understanding of RDS snapshot and point-in-time recovery mechanisms.
- AWS Infrastructure: Strong understanding of core AWS services, including VPC, Subnets, Security Groups, IAM, and CloudWatch.
- Licensing: Familiarity with Oracle licensing models on AWS, particularly Bring-Your-Own-License (BYOL) and its implications for features like Data Guard.
- Scripting: 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.
COMPETENCIES:
- Ownership & Accountability: Demonstrates a high degree of ownership and the ability to manage critical database systems single-handedly with minimal supervision.
- Technical Skills - Demonstrates strong technical skills required for the role, pays attention to detail, takes initiative to broaden his/her knowledge and demonstrates appropriate financial/analytical skills
- Drive and Motivation - Successfully handles multiple tasks, takes initiative to improve his/her own performance, works intensely towards extremely challenging goals and persists in the face of obstacles or setbacks
- Client and Business Focus - Effectively handles difficult requests, builds trusting, long-term relationships with clients, helps the client to identify/define needs and manages client/business expectations
- Teamwork – Gives evidence of being a strong team player, collaborates with others within and across teams, encourages other team members to participate and contribute and acknowledges others' contributions
- Communication Skills - Communicates what is relevant and important in a clear and concise manner and shares information/new ideas with others
- Judgement and Problem solving - Thinks ahead, anticipates questions, plans for contingencies, finds alternative solutions and identifies clear objectives. Sees the big picture and effectively analyses complex issues
- Creativity/Innovation - Looks for new ways to improve current processes and develop creative solutions that are grounded in reality and have practical value
- Influencing Outcomes - Presents sound, persuasive rationale for ideas or opinions. Takes a position on issues and influences others' opinions and presents persuasive recommendations