Principal, Data Engineer

The Role

The Institutional Brokerage Database Services Center of Excellence (COE) COE is seeking a highly capable and motivated Director of Database Engineering and Administration to lead the design and delivery of database engineering solutions for mission-critical platforms. This role offers an excellent opportunity to work with leading database technologies, including Oracle, PostgreSQL, CockroachDB, SingleStore, NoSQL, and Snowflake. It is ideal for building and applying end-to-end database service expertise, with a strong emphasis on application database administration and solution design.

Expertise And Skills You Bring

• 12+ years of deep experience in Oracle database technologies, with a proven end-to-end understanding of the database stack, including Exadata, PostgreSQL, and distributed SQL databases, along with strong technical leadership on strategic initiatives.
• Experience with Db2 is an added advantage.
• 5+ years of cloud experience

The Skills You Bring

• 12+ years of experience in Oracle database administration, performance engineering, and replication engineering across Linux and engineered systems.
• 3+ years of database performance experience on additional platforms, including PostgreSQL, Snowflake, CockroachDB, SingleStore, and Microsoft SQL Server, across Linux and engineered systems.
• 5+ years of experience with distributed replication technologies (for example, Oracle Golden Gate, HVR and EDB Replication); preferred.
• Experience with cloud database platforms; AWS, Azure, or Oracle OCI certification is a plus.
• Deep domain expertise in Oracle internals, optimizer behavior, statistics management, partitioning, physical implementation, and workload management for highly scalable, resilient database platforms.
• Advanced skills in query performance tuning and optimization, Oracle Enterprise Manager, Linux shell scripting, and building database monitoring jobs using PL/SQL.
• Strong Linux shell scripting skills, with a solid understanding of Linux performance, preferred.
• Strong understanding of Oracle RAC performance challenges.
• Proven ability to work effectively in team environments while maintaining a positive, collaborative attitude.
• Ability to define and drive database performance standards, best practices, and improvement initiatives; AWS cloud experience is desired.

The Value You Deliver

• Perform applications database administration services including SQL code review, performance analysis, query tuning, database application design, physical data modeling, development support and Engineering.
• Lead proof of concept efforts to evaluate and enable new technology solutions.
• Interface with enterprise teams for Systems Administrators, Cyber Security and Capacity Planning groups as and when situation demands.
• Should have strong time management skills with willingness and ability to handle multiple projects/initiatives at the same time.
• Self-motivated with strong team, interpersonal and communication skills!
• Establish database standards for operations, upgrades, migrations and onboarding new applications and/or clients.
• Write clear, concise, well organized technical documentation to maintain standards and procedures.

The Team

The Institutional Brokerage Database Services Center of Excellence (COE), delivers business-facing database solutions that cover the full application and business lifecycle of data platforms, including database design, solution engineering, database engineering, application-data-database integration, replication, performance consulting, deployment, and support, using world-class methodologies and technologies. The team provides end-to-end database services across a broad set of platforms, including Db2, Oracle, PostgreSQL, SQL Server, CockroachDB, Singlestore, DynamoDB, Aerospike, and Snowflake.

Fidelity’s Onsite Working Model

Fidelity is transitioning to a full-time onsite working model through a phased rollout across regions and roles. Currently, some roles and locations require 100% onsite presence, while others require less. Onsite expectations are likely to evolve as the rollout continues. This transition does not apply to fully remote roles.