Senior database administrator (cockroachdb)

Apply now

Location

onsite, Salt Lake City, UT, United States

Commitment

Full Time

Level

Senior (5+ years)

Required skills

YugabyteDBSQL ServerOraclePostgreSQLDatabase AdministrationPerformance TuningSQLPL/SQLAWSAzureData ModelingDisaster RecoveryShellPythonDatabase SecurityCI/CD

Job Description

Job Description:

The Role

Fidelity Investments is seeking an experienced and highly motivated Database Administrator to provide operational excellence across our Development, Test, and Production database environments. This role will be responsible for the ongoing support of mission-critical database platforms supporting multiple Fidelity business units and enterprise applications.

The successful candidate will possess deep expertise in YugabyteDB database administration and strong working knowledge of SQL Server and Oracle platforms as a bonus. As a member of the team, you will lead complex troubleshooting efforts, improve reliability through maintaining up to date patching and release cycles, SQL analysis and performance analysis. This role includes participation in an on-call rotation supporting highly available, 24x7 production environments.

The Expertise You Have

  • 3-7 years of experience administering RDS databases, YugabyteDB, in enterprise-scale, highly available production environments.
  • Deep expertise supporting YugabyteDB and newer database platforms and performance optimization.
  • Strong experience administering Microsoft SQL Server in mission-critical environments.
  • Hands-on experience with PostgreSQL; experience with Oracle or distributed database technologies is a plus.
  • Experience supporting databases in public cloud environments, preferably AWS and/or Azure.
  • Bachelor's degree in Computer Science, Information Technology, Engineering, or related field, or equivalent practical experience.
  • Extensive experience performing Application DBA functions, including:
    • SQL and PL/SQL code review
    • Query optimization and performance tuning
    • Data modeling and physical database design
    • Database application architecture reviews
    • Development lifecycle support
    • Data engineering and integration support
  • Experience designing and implementing database high availability, disaster recovery, backup, recovery, and replication solutions.
  • Proven ability to lead root cause analysis efforts for complex production incidents and drive permanent corrective actions.
  • Experience mentoring junior DBAs and sharing knowledge across engineering teams.

The Skills You Bring

  • Expert-level proficiency with SQL and PL/SQL development, performance tuning, and troubleshooting.
  • Advanced knowledge of YugabyteDB internals, optimizer behavior, indexing strategies, partitioning, and database performance diagnostics.
  • Strong experience implementing database infrastructure solutions with minimal supervision.
  • Demonstrated ability to lead complex production incident resolution efforts across multiple teams.
  • 5 plus years experience in scripting and automation using Shell, Python, or equivalent languages.
  • Expertise with Oracle GoldenGate, database replication technologies, and enterprise data movement strategies.
  • Strong understanding of database security, access controls, encryption, auditing, and compliance requirements.
  • Experience with DevOps practices, CI/CD pipelines, and database deployment automation.
  • Familiarity with observability, monitoring, and performance management tools.
  • Experience supporting 24x7 mission-critical enterprise systems with aggressive service-level objectives.
  • Strong communication skills with the ability to explain technical concepts to both technical and non-technical stakeholders.

The Value You Deliver

  • Lead the administration, support, and continuous improvement of YugabyteDB, Oracle, SQL Server, PostgreSQL, and emerging database platforms.
  • Proactively identify operational risks and implement solutions to improve system resilience and availability.
  • Partner with application development teams to design efficient and scalable database solutions.
  • Lead performance tuning efforts and optimize database workloads to meet business and service-level objectives.
  • Design, implement, and maintain high-availability and disaster recovery solutions.
  • Troubleshoot and resolve complex production issues while leading root cause analysis and corrective action planning.
  • Collaborate with cloud, infrastructure, and application teams to support modernization and cloud migration initiatives.
  • Contribute to database strategy, standards, governance, and best practices across the organization.

Preferred Qualifications

  • Oracle, Microsoft SQL Server, or PostgreSQL certifications.
  • Experience supporting large-scale financial services, healthcare, or other highly regulated environments.
  • Experience with YugabyteDB, CockroachDB, or equivalent technologies.

The Team

As part of the Advanced Process Solutions (APS) team, you will collaborate with engineering teams building software that enables business process automation and workflow management across Fidelity. Our platforms facilitate the movement of critical business transactions between multiple applications and business units, helping deliver exceptional customer experiences.

The database team is responsible for the reliability, scalability, security, and operational support of the databases that power these applications. We strive to leverage automation and engineering best practices to deliver resilient and highly available database services.

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.

Ready to join the team?

Apply now