Principal Data Engineer

Fidelity Investments • Merrimack, New Hampshire, United States • $119.56k - $151.43k / year • 2h ago

Job Description:

The Role

The Fidelity Institutional Technology, Database Center of Excellence (COE), requires a highly competent and highly motivated Principal Database Engineer with strong technical skills to support challenging mission critical database platforms. This position would provide an excellent opportunity to work on leading database technologies like Oracle, Postgres, Distributed SQL, NoSQL, Snowflake etc. It is a great place to experience & learn end to end DBA service capabilities!

This role requires a service-oriented mentality, high sense of ownership of the problems and requests assigned. Provides enormous opportunity to learn cutting edge technologies like machine learning!

The Expertise and Skills You Bring

8+ years of experience in Oracle Database technologies with very proven understanding of end to end database tech-stack including Exadata and provide technical leadership for strategic projects.
3+ years of Cloud experience

The Skills You Bring

8+ experience in Oracle Database Administration / Performance Engineering / Relplication Engineering across multiple platforms - Linux and Engineered systems.
1+ experience in DB performance for other database platforms (Postgres, CockroachDB, Snowflake, Cassandra, MS SQL server, Netezza etc) across multiple platforms - Linux and Engineered systems.
5+ years of experience in Distributed replication technologies (Oracle Goldengate, EDB Replication, etc), preferred
Experience with cloud databases platforms (AWS/Azure/Oracle OCI certification is helpful), on both Linux and Windows environments
Designing and implementing highly resilient and performing Oracle database platforms, using distributed database technologies.
Domain specialist in Oracle internals, Optimizer , Statistics management , Partition management , Physical implementation & Workload management for highly scalable and resilient database platforms.
Sophisticated skills in Query Performance Tuning and Optimization (PTO), Oracle Enterprise Manager Grid control (OEM 12c), Linux shell scripting, and writing database monitoring jobs in PL/SQL.
Strong Linux shell scripting experience preferred with a good understanding of Linux Performance
A good understanding of Oracle RAC related performance challenges
Ability to work well in a team environment, as well as maintaining a positive attitude are a must
Ability to develop and drive database performance standards, standard methodologies and initiatives. AWS cloud experience desired.

The Value You Deliver

Perform applications database administration (Oracle/Postgres) services including SQL code review, performance analysis, query tuning, database application design, physical data modeling, development support & Engineering.
Lead proof of concept efforts to evaluate and enable new technology solutions
Proactively monitor databases servers and respond to any alerts.
Designing and implementing highly resilient and performing Oracle database platforms, using distributed database technologies.
Provide database development support in all phases of SDLC and agile experience is preferred including logical and physical data model review, SQL performance, Data injection etc.
Participate in 24X7 on call rotation schedule for various production support, database maintenance, housekeeping and installs
Interface with enterprise teams for Systems Administrators, Cyber Security and Capacity Planning groups as and when situation demands
Ability to quickly diagnose the problem areas and come up with solutions and/or workarounds
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 Fidelity Institutional Technology, Database Center of Excellence (COE), provides business facing database solutions, encompassing the application/business aspects of databases, including database design, solution design, database engineering, application-data-database integration, data replication, performance consulting, deployment, and support, using world-class methodologies & technologies. This team provides end to end DBA services for distributed database technologies like Oracle, Postgres, NoSQL, Snowflake, SQL server, Sybase, MariaDB etc.

Certifications:

Category:

Information Technology

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

Please be advised that Fidelity’s business is governed by the provisions of the Securities Exchange Act of 1934, the Investment Advisers Act of 1940, the Investment Company Act of 1940, ERISA, numerous state laws governing securities, investment and retirement-related financial activities and the rules and regulations of numerous self-regulatory organizations, including FINRA, among others. Those laws and regulations may restrict Fidelity from hiring and/or associating with individuals with certain Criminal Histories.