Senior Data Engineer

Fidelity Investments • Westlake, TX

9h • Hybrid

About The Position

Position Description: Provides end to end database administrator (DBA) services for distributed database technologies -- Oracle, Postgres, NoSQL, Snowflake, SQL server, Cockroach, Neo4j, and MariaDB. Designs and implements highly resilient and high-performance database platforms, using distributed database technologies -- Oracle, Postgres, Cockroach, Snowflake and NoSQL databases. Provides database design, solutions, and engineering support to microservices/data as a service Application Programming Interface (API) development, using SQL, PL/SQL, Java, Python, and NodeJS. Supports Cloud database platforms (Amazon Web Services (AWS), Azure, Oracle OCI) on both Linux and Windows environment. Utilizes container technologies (Docker and Kubernetes) to enhance database deployment and management. Primary Responsibilities: Delivers business-facing database solutions, including design, engineering, integration, replication, performance tuning, deployment, and support. Collaborates with agile development teams, enterprise groups, and departments -- Systems Administration, Cybersecurity, and Capacity Planning. Writes clear, concise, well organized technical documentation to maintain standards and procedures for database operations, upgrades, migrations, and onboarding new applications and/or clients. Monitors databases servers and respond to alerts. Analyzes information to determine, recommend, and plan computer software specifications on major projects. Proposes modifications and improvements based on user need. Develops software system testing and validation procedures, programming, and documentation.

Requirements

• Bachelor’s degree in Computer Science, Engineering, Information Technology, Information Systems, or a closely related field (or foreign education equivalent) and three (3) years of experience as a Senior Data Engineer (or closely related occupation) performing data engineering and database administration of Oracle and CockroachDB (CRDB) environments supporting a trading platform in the financial industry, using replication technologies (Golden gate, Changefeed, and Replicator).
• Or, alternatively, Master’s degree in Computer Science, Engineering, Information Technology, Information Systems, or a closely related field (or foreign education equivalent) and one (1) year of experience as a Senior Data Engineer (or closely related occupation) performing data engineering and database administration of Oracle and CockroachDB (CRDB) environments supporting a trading platform in the financial industry, using replication technologies (Golden gate, Changefeed, and Replicator).
• Demonstrated Expertise (“DE”) building secure Cloud database environments, using AWS, Relational Database Service (RDS), Elastic Compute Cloud (EC2), Elastic Block Store (EBS), Terraform, and Jenkins-core.
• DE performance tuning complex queries in Relational Database Management System (RDBMS) to optimize the workload for improved production stability, using Oracle Active Session History (ASH) reports, Oracle Enterprise Manager (OEM), Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR), SQL Monitor reports, SQL Plan Management (SPM) Baselines, SQL Profiles, and Statement Diagnostics.
• DE supporting mission critical Tier-0 brokerage database platform (Oracle and CRDB) to operationalize resilient database infrastructure, using Goldengate bidirectional replication, Oracle Dataguard, Real application clusters, CRDB Changefeed, Replicator, Grafana, and Datadog monitors.
• DE performing database administration across On-premises and Cloud platforms, using data distribution techniques, Statistics Management, indexing strategy, backup and recovery, schema evolution and migration, Automation and scripting.

Responsibilities

• Delivers business-facing database solutions, including design, engineering, integration, replication, performance tuning, deployment, and support.
• Collaborates with agile development teams, enterprise groups, and departments -- Systems Administration, Cybersecurity, and Capacity Planning.
• Writes clear, concise, well organized technical documentation to maintain standards and procedures for database operations, upgrades, migrations, and onboarding new applications and/or clients.
• Monitors databases servers and respond to alerts.
• Analyzes information to determine, recommend, and plan computer software specifications on major projects.
• Proposes modifications and improvements based on user need.
• Develops software system testing and validation procedures, programming, and documentation.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level