Senior Data Engineer

Fidelity Investments; Roanoke (TX); On-site; USD 140,000 - 170,000; Full time

Job summary

Fidelity Investments in Roanoke, TX, seeks Senior Database Administrator to support mission-critical database platforms (Oracle, Postgres, Cockroach, NoSQL, Snowflake). This role offers opportunity to learn end-to-end DBA services and work with cutting-edge technologies.

Ideal candidates have 7+ years in database engineering, hands-on with cloud databases, containers, IaC, and observability tools; strong collaboration across teams and a service-oriented mindset.

Qualifications

• 7+ years in database design, engineering and support for microservices/Data as a service APIs.
• 5+ years with cloud databases on Linux/Windows, AWS/Azure/OCI knowledge helpful.
• 7+ years in Oracle DB, performance and replication across platforms.
• Experience with IaC and observability/tools.

Responsibilities

• Design and implement resilient cloud database platforms using distributed DB tech.
• Perform DBA services: SQL review, performance analysis, tuning, data modeling.
• Monitor DB servers and respond to alerts; support SDLC/Agile practices.
• Collaborate with Agile squads, security and capacity planning teams.

Skills

Database design

SQL/PLSQL

Java

Python

NodeJS

Cloud databases

Docker

Kubernetes

Terraform

CI/CD tooling

Tools

Docker

Kubernetes

Terraform

Chef

GitHub

Jenkins

Udeploy

JMeter

DataDog

Prometheus

Splunk

Grafana

Job description

Job Description

Note: Fidelity will not provide immigration sponsorship for this position

The Fidelity Institutional Technology, Database Center of Excellence (COE), requires a highly competent and highly motivated Senior Database Administrator 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, Cockroach, 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

• 7+ experience in providing Database design, solutioning and providing database engineering support to microservices/Data as a service API development team using SQL, PL/SQL, Java, Python and NodeJS.
• 5+Experience with cloud databases platforms (AWS/Azure/Oracle OCI certification is helpful), on both Linux and Windows environments.
• 7+ Experience in Container technologies like Docker and Kubernetes
• 5+ experience in Oracle Database Administration / Performance Engineering / Resiliency Engineering and Replication Engineering across multiple platforms — Linux and Engineered systems.
• Experience managing systems using infrastructure as code tools (IAM, ARM, Terraform, Chef)
• Experience in modern observability tools (DataDog, Prometheus, Splunk, Grafana,etc)
• Experience on CI/CD process, tools, testing frameworks and practices (GitHub, Jenkins, Udeploy and Jmeter)
• 1+ experience in DB performance for other RDBMS/NOsql/Distributed database platforms (Postgres, Snowflake, Cassandra, MS SQL server, Cockroach etc) across multiple platforms — Linux and Engineered systems.
• Designing and implementing highly resilient and performing Oracle database platforms, using distributed database technologies.
• Interface with agile development squads, 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
• Self-motivated with strong team, interpersonal and communication skills
• Write clear, concise, well organized technical documentation to maintain standards and procedures

The Value You Deliver

• Designing and implementing highly resilient and performing cloud database platforms, using distributed database technologies.
• Perform applications database administration (Oracle/Postgres/Cockroach) services including SQL code review, performance analysis, query tuning, database application design, physical data modeling, development support & Engineering.
• Proactively monitor databases servers and respond to any alerts.
• 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.
• Interface with agile development squad, 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, Cockroach, Neo4j, MariaDB etc

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.

Certifications Category:

Information Technology

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.