Principal Cloud Database Engineer

FMR LLC

Smithfield, RI

JOB DETAILS
SKILLS
Amazon Elastic Compute Cloud (EC2), Amazon Relational Database Service (RDS), Amazon Web Services (AWS), Analysis Skills, Application Framework, Artificial Intelligence (AI), Automation, Best Practices, Cloud Applications, Cloud Computing, Communication Skills, Consulting, Database Optimization, Database Programming, Database Replication, Database Technology, Debugging Skills, DevOps, Documentation Standards, Hybrid Cloud, IBM AIX Operating System, Identify Issues, Linux Operating System, Machine Tool, Microsoft Product Family, Microsoft SQL Server, Microsoft Windows Azure, Multitasking, OEM (Original Equipment Manufacturer), On Call, Operating Systems, Oracle, Oracle Database, Oracle Enterprise Manager, Oracle PL-SQL, Oracle RAC (Real Application Clusters), Organizational Skills, Performance Reviews, Performance Tuning/Optimization, PostgreSQL, Problem Solving Skills, Python Programming/Scripting Language, Query Analysis, Reliability Engineering, SQL (Structured Query Language), Statistics, Strategic Planning, Team Player, Technical Writing, Time Management, Unix Shell Programming
LOCATION
Smithfield, RI
POSTED
30+ days ago

Job Description:Note: Fidelity will not provide immigration sponsorship for this positionWe 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 Expertise You Have and The Skills You Bring8+ 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. The Team 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. Certifications:Category:Information TechnologyMost roles at Fidelity are Hybrid, requiring associates to work onsite every other week (all business days, M-F) in a Fidelity office. This does not apply to Remote or fully Onsite roles. Some roles may have unique onsite requirements. Please consult with your recruiter for the specific expectations for this position.Please be advised that Fideli

About the Company

F

FMR LLC

We help over ~40 million people feel more confident in their most important financial goals, manage employee benefit programs for nearly 23,000 businesses, and support more than 3,600 advisory firms* with innovative investment and technology solutions to grow their businesses. Our diverse businesses and independence give us insight into the entire market and the stability needed to think and act for the long term as we deliver value to you.
COMPANY SIZE
10,000 employees or more
INDUSTRY
Banking
FOUNDED
1946
WEBSITE
https://jobs.fidelity.com/