Principal Cloud Database Engineer

We are seeking a highly skilled Principal Cloud Database Engineer to join the Enterprise Infrastructure & Operations Capacity Database team. This role focuses on capacity & performance reviews, database and SQL performance optimization, best practices, scalability, and reliability across hybrid cloud and on-prem mission critical environments. You will collaborate with our other Capacity teams, application & database teams, Business units, Fidelity Support Center, and our support partners.

As a team, we are responsible for:

• Optimize and tune databases: Oracle, PostgreSQL (Aurora, RDS, Microsoft - Azureflex), some understanding of SQL Server, SQLMI, Snowflake and distributed (YugabyteDB, CockroachdB).
• Diagnosing and resolving performance issues through query analysis, indexing strategies, execution plans, and system-level profiling.
• Familiar with database tools like OEM - Oracle Enterprise Manager, Datadog, Grafana, Prometheus, PGAdmin, and SSMS - SQLServer Management Studio
• Conduct capacity reviews for complex applications across cloud and on-prem environments (Linux, AIX, Exadata, AWS, Azure).
• Support AWS (EC2/RDS) and Azure database services and contribute to hybrid architecture improvements.
• Implement proactive alerting and observability enhancements using AI/ML tools (e.g., Anodot).
• Collaborate with developers to optimize SQL and reduce latency in high-volume applications.
• Drive automation and reliability engineering practices to minimize manual intervention.

• 8+ years' experience in Oracle Database technologies with proven understanding of end-to-end database tech-stack specializing in Capacity & Performance on Exadata, AIX, Linux, AWS & Azure
• 2+ years of Cloud database performance expertise in PostgreSQL (Aurora, RDS, Azure Azureflex) in large-scale environments.
• Other database experience is a plus for YugabyteDB, CockroachdB, SQLMI, SQLServer, Snowflake, etc.
• Expertise in SQL, PL/SQL tuning, execution plan analysis, and OS-level performance debugging.
• Strong knowledge of AWS and Azure database services.
• Proficiency in shell scripting and some Python for automation and performance tooling.
• Familiarity with DevOps principles, modern application frameworks, and cloud operational models
• Deep Oracle & Postgres internals knowledge: database tuning, optimizer, statistics, partitioning, workload management.
• Advanced SQL query tuning, OEM Grid Control, Linux shell scripting, PL/SQL monitoring jobs.
• Experience with database replication (e.g. Goldengate) across different database engine types.
• Strong understanding of Oracle RAC performance challenges.
• Ability and understanding how to design resilient, high-performing database platforms using distributed technologies.
• Team-oriented with strong communication and time management skills.
• Participate in 24X7 on call rotation for our database capacity Level 3 incident remediation.
• Write clear, concise, well organized technical documentation to maintain standards and procedures.
• Should have strong time management skills with willingness and ability to handle multiple projects/initiatives at the same time.