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

Hudson's Furniture

Furniture Delivery Driver- Independent Contractor Job at Hudson's Furniture

 ...Turning Houses into Homes' since 1982. Hudson's Furniture is seeking to contract with Owner Operators / Independent Contractors. This is an opportunity for delivery drivers with experience operating 26' box trucks. Commission based pay. Average driver makes $60-80k/... 

Reliable Roofing

Sales Manger Job at Reliable Roofing

 ...We are a construction company with a focus on Roofing Serving our customers for over 20 years With a strong local presence This position is the leader of a selling Team comprised of Outside Sales Reps and Project Managers. This leader is accountable for achieving... 

Larimer Law

Document Review Attorneys needed (REMOTE) Job at Larimer Law

 ...Job Description Larimer Law in Upstate, NY is hiring remote Attorneys for new matters. THE COMPANY: Larimer Law, PLLC, has offices...  ...attorneys who are trained and experienced in electronic document review, information governance and data management. Our company works... 

SFM Companies (SFM Mutual Insurance)

Medical Coder Team Leader - Insurance Operations Job at SFM Companies (SFM Mutual Insurance)

 ...As the leader of the Medical Support Reps, you will lead a team of bill coders to successfully...  ...complex and escalated medical billing/coding issues, complicated requests, complaints...  ...s degree or equivalent work/education experience. Seven years, or more, experience... 

Pyramid Consulting

Senior RPA Developer Job at Pyramid Consulting

Immediate need for a talented Senior RPA Developer . This is a Full Time opportunity with long-term potential and is located in Washington, DC (Hybrid). Please review the job description below and contact me ASAP if you are interested. Job ID:24-467...