Principal Cloud Database Engineer

Fidelity Investments • Merrimack, NH

3d • Hybrid

About The Position

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. The Fidelity Enterprise Infrastructure & Operations Capacity Database team provides business facing database capacity solutions, encompassing the application/business aspects of databases, including database engineering, application-data-database integration, data replication, performance consulting, and support, using world-class methodologies & technologies. Fidelity Investments is an equal opportunity employer. Fidelity will reasonably accommodate applicants with disabilities who need adjustments to participate in the application or interview process. To initiate a request for an accommodation please contact the following: For roles based in the US: Contact the HR Leave of Absence/Accommodation Team by sending an email to [e-mail], or by calling 800-835-5099, prompt 2, option 2 For roles based in Ireland: Contact [e-mail] For roles based in Germany: Contact [e-mail] Fidelity Privacy Policy

Requirements

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

Responsibilities

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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed
• Number of Employees: 101-250 employees