Principal Database Administrator Job at Fidelity Investments, Roanoke, TX

Mnlrb0dOeUxYUjZkc1RYUVVLM05KMlVXd3c9PQ==
  • Fidelity Investments
  • Roanoke, TX

Job Description

Job Description:

Position Description :

Executes database performance tuning, query optimization, and database troubleshooting/SQL issue resolution using multitenant database toolsOracle 12c or 19c RAC. Deploys database schema management and implementing database configuration changes in production within cloud environments - Amazon Web Services (AWS) and Azure. Simplifies and modernizes the data ecosystem to ensure efficient and compliant delivery of database capabilities by using Linux shell scripting, PL/SQL, and Python. Builds automation pipelines for database infrastructure by using Continuous Integration and Continuous Delivery (CI/CD) tools such as Jenkins, Jenkins Core, Stash, Artifactory, uDeploy, Terraform, and Concourse. Designs the code architecture in line with business requirements and updating JIRA with story requirements.

Primary Responsibilities:

  • Defines and evaluates database maintenance tools and builds processes.
  • Establishes performance tuning criteria and methods in coordination with internal and external technical resources.
  • Designs, evaluates, and performs highly complex database performance and functionality testing.
  • Establishes full project life cycle plans for complex projects.
  • Provides technical evaluation estimates on technology initiatives.
  • Develops and maintains policies, procedures, and techniques in order to minimize future incident occurrence.
  • Defines security requirements and operational procedures to ensure network integrity, physical protection, and authorized access to the network and applications.
  • Develops business cases to justify information security architecture initiatives.
  • Enforces storage management standards.
  • Defines the scope of change and impact to other interfaces.
  • Creates high level architecture design for the enterprise.
  • Mentors junior team members.
  • Modifies existing databases and database management systems or collaborate with programmers and analysts to make changes.

Education and Experience :

Bachelor's degree (or foreign education equivalent) in Computer Science, Engineering, Information Technology, Information Systems, Mathematics, Physics, or a closely related field and five (5) years of experience as a Principal Database Administrator (or closely related occupation) performing database modernization functions- migrating Oracle and PostgreSQL databases from on-prem data centers to the AWS cloud using Terraform or Cloudformation, and enabling database monitoring using Datadog.

Or, alternatively, Master's degree (or foreign education equivalent) in Computer Science, Engineering, Information Technology, Information Systems, Mathematics, Physics, or a closely related field and three (3) years of experience as a Principal Database Administrator (or closely related occupation) performing database modernization functions- migrating Oracle and PostgreSQL databases from on-prem data centers to the AWS cloud using Terraform or Cloudformation, and enabling database monitoring using Datadog.

Skills and Knowledge :

Candidate must also possess:

  • Demonstrated Expertise ("DE") leading and executing Oracle database migration and modernization projects on external Cloud provider offeringsOracle on AWS EC2, Oracle AWS RDS, or Aurora Postgres.
  • DE writing Infrastructure as a Code (IaS) using Terraform modules or Cloud formation templates for the following AWS services - Oracle RDS, EC2, IAM, Security Groups, or Aurora Postgres.
  • DE setting up database monitoring and observability frameworks using Datadog, Cloudwatch, Oracle Enterprise Manager, Prometheus or Grafana.
  • DE developing Continuous Integration/Continuous Deployment (CI/CD) pipelines to automate database deployments using Github, Bitbucket, Jenkins, Jenkinscore, Concourse, Artifactory, or uDeploy.
#PE1M2

Certifications:

Category:

Information Technology

Fidelity's working model blends the best of working offsite with maximizing time together in person to meet associate and business needs. Currently, most hybrid roles require associates to work onsite all business days of one assigned week per four-week period (beginning in September 2024, the requirement will be two full assigned weeks).

Job Tags

Similar Jobs

JM HOME HEALTHCARE LLC

Caregiver/ HHA / CNA - COMPETITIVE PAY + FLEXIBLE HOURS Job at JM HOME HEALTHCARE LLC

Job Description Job Description JM Home Healthcare is currently hiring CNA/HHA to care for elderly clients. Job includes but is not limited to: -Assisting with bathing, dressing, meal prep, light housekeeping (including laundry), socialization, and encouraging exercise...

JJ'S FINE DINE KITCHEN LTD

Waiter Waitress Job at JJ'S FINE DINE KITCHEN LTD

 ...Job Description Job Description We are seeking a Waiter Waitress to become an integral part of our team!You will take orders and serve food to patrons at thedining establishment. Responsibilities: Serve food and beverages to guests Explain to guests about... 

Creative Circle

Print Textile Designer - Print Design, technical repeats Job at Creative Circle

Full Job DescriptionOur client is looking for a Print Textile Designer. This role will be primarily focused on print design for the apparel line, with additional contributions to the home collection, which has two major launches each year. You will work independently in... 

RECON

Class A Heavy Equipment Operator FL Job at RECON

Overview Moretrench Class A operators are the top skill level of Moretrench heavy equipment operators. Moretrench, a Keller Company, has been in existence since the late 1800s. We perform industrial work in Florida with the majority of our work in the Tampa area... 

Relay Therapeutics

AD / Director, Regulatory Affairs Job at Relay Therapeutics

The Opportunity:We are looking for a strategic regulatory leader to join our growing regulatory team at Relay Tx. You will have the opportunity...  ....Your Role:You will report to our Head of Regulatory Affairs and work side by side with your research and development...