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.
Education and Experience:
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).
Skills and Knowledge:
Candidate must also possess:
- 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.
#PE1M2
#LI-DNI
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 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.
Top Skills
What We Do
At Fidelity, our goal is to make financial expertise broadly accessible and effective in helping people live the lives they want. We do this by focusing on a diverse set of customers: - from 23 million people investing their life savings, to 20,000 businesses managing their employee benefits to 10,000 advisors needing innovative technology to invest their clients’ money. We offer investment management, retirement planning, portfolio guidance, brokerage, and many other financial products.
Privately held for nearly 70 years, we’ve always believed by providing investors with access to the information and expertise, we can help them achieve better results. That’s been our approach- innovative yet personal, compassionate yet responsible, grounded by a tireless work ethic—it is the heart of the Fidelity way.
