Principal Database Administrator

Fidelity Investments•Westlake, TX

14d•Onsite

About The Position

Designs and enforces database security policies, including encryption, auditing, and compliance with global regulatory standards. Supports strategic database initiatives to meet business objectives in the United States and globally. Architects and tests robust disaster recovery and high-availability solutions using Oracle Data Guard and Recovery Manager (RMAN). Conducts performance tuning, including SQL query optimization, indexing strategies, and workload balancing across Real Application Clusters (RAC) clusters. Provides technical expertise and guidance on critical projects, ensuring database solutions are reliable, secure, and scalable. Works on complex technology challenges in cloud and hybrid environments. Participates in the design, implementation, and optimization of enterprise databases to maintain high availability and performance. Drives large-scale database migrations to cloud platforms. Performs independent and complex technical and functional analysis for multiple projects supporting several divisional initiatives.

Requirements

Bachelor’s degree in Computer Science, Engineering, Information Technology, Information Systems, or a closely related field (or foreign education equivalent) and five (5) years of experience as a Principal Database Administrator (or closely related occupation) performing database administration and migration in enterprise financial services environments using Oracle Database and Oracle Golden Gate.
Master’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 Principal Database Administrator (or closely related occupation) performing database administration and migration in enterprise financial services environments using Oracle Database and Oracle Golden Gate.
Demonstrated Expertise (“DE”) performing Oracle RAC database administration -- capacity planning, indexing, partitioning, archiving, compression, and designing and implementing enhanced database monitoring and alerting solutions -- using Linux Shell scripting, Oracle PL/SQL programs, and Oracle Enterprise manager scheduler.
DE developing, installing, and maintaining Oracle replication technologies using Oracle GoldenGate and Oracle Data Guard; performing infrastructure development on Amazon Web Services (AWS); migrating databases from on-premise to AWS Cloud using DMS; and configuring, enabling, and administering NiFi data ingestion services, Service Oriented Architecture (SOA), Web Center Interaction (WCI), and Hyperion Financial Management (HFM).
DE performing SQL performance tuning and optimization (PTO) using Oracle Enterprise Manager Grid control (OEM 12c) and Linux shell scripting; designing and implementing database monitoring jobs in PL/SQL; and implementing Guardium and CyberArk for critical on-premises and AWS databases for privileges access management and auditing.
DE administrating Oracle E Business Suite using Oracle Applications DBA tools, including Oracle AD Utilities, AD Online Patching (ADOP), Patch wizard tools, and Shell scripting; performing database administration -- upgrading, cloning, and configuring Single Sign On (SSO), performing Oracle E-Business database upgrades, and converting databases to multitenant -- using Oracle Applications DBA Oracle AD Utilities, ADOP, and Patch wizard tools; installing, configuring, upgrading, and managing an Oracle E‑Business Suite (EBS suite) of applications, and integrating the suite with Enterprise Command Centers (ECC), More4Apps, Virtual Trader, Ping, and Noetix analytics tools and applications.

Responsibilities

Defines and implements standards for database design and performance.
Provides expert-level support for complex database issues.
Drives strategic database initiatives in support of business objectives globally.
Designs and implements database solutions, including migration strategies to cloud environments.
Establishes performance tuning standards and troubleshooting practices for complex systems.
Automates processes to improve efficiency and reduce operational risk.
Ensures database security, integrity, and compliance with organizational standards.
Documents architecture, operational procedures, and best practices for critical systems.
Provides technical leadership and guidance across projects and teams.
Mentors junior DBAs.
Collaborates with teams to integrate systems and deliver efficient solutions.
Advises senior leadership on database technologies.