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 [email protected], or by calling 800-835-5099, prompt 2, option 2 For roles based in Ireland: Contact [email protected] For roles based in Germany: Contact [email protected] 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.

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume