Principal Database Administrator

4 weeks ago

Westlake, United States Fidelity TalentSource LLC Full time



Job Description:

Position Description:

Executes database performance tuning, query optimization, and database troubleshooting/SQL issue resolution using multitenant database tools -- Oracle 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 (\u201CDE\u201D) leading and executing Oracle database migration and modernization projects on external Cloud provider offerings -- Oracle 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:

Company Overview

Fidelity Investments is a privately held company with a mission to strengthen the financial well-being of our clients. We help people invest and plan for their future. We assist companies and non-profit organizations in delivering benefits to their employees. And we provide institutions and independent advisors with investment and technology solutions to help invest their own clients money.

Join Us

At Fidelity, you ll find endless opportunities to build a meaningful career that positively impacts peoples lives, including yours. You can take advantage of flexible benefits that support you through every stage of your career, empowering you to thrive at work and at home. Honored with a Glassdoor Employees Choice Award, we have been recognized by our employees as a top 10 Best Place to Work in 2024. And you don t need a finance background to succeed at Fidelity\u2014we offer a range of opportunities for learning so you can build the career you ve always imagined.

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).

At Fidelity, we value honesty, integrity, and the safety of our associates and customers within a heavily regulated industry. Certain roles may require candidates to go through a preliminary credit check during the screening process. Candidates who are presented with a Fidelity offer will need to go through a background investigation, detailed in this document, and may be asked to provide additional documentation as requested. This investigation includes but is not limited to a criminal, civil litigations and regulatory review, employment, education, and credit review (role dependent). These investigations will account for 7 years or more of history, depending on the role. Where permitted by federal or state law, Fidelity will also conduct a pre-employment drug screen, which will review for the following substances: Amphetamines, THC (marijuana), cocaine, opiates, phencyclidine.

We invite you to Find Your Fidelity at fidelitycareers.com.

Fidelity Investments is an equal opportunity employer. We believe that the most effective way to attract, develop and retain a diverse workforce is to build an enduring culture of inclusion and belonging.

Fidelity will reasonably accommodate applicants with disabilities who need adjustments to participate in the application or interview process. To initiate a request for an accommodation, contact the HR Accommodation Team by sending an email to accommodations@fmr.com.

  • Principal Database Administrator

    1 month ago

    Westlake, United States Fidelity TalentSource LLC Full time

    Job Description:Position Description: Executes database performance tuning, query optimization, and database troubleshooting/SQL issue resolution using multitenant database tools -- Oracle 12c or 19c RAC. Deploys database schema management and implementing database configuration changes in production within cloud environments Amazon Web Services (AWS) and...

  • Director, Database Administration

    2 months ago

    Westlake, United States Fidelity TalentSource LLC Full time

    Job Description:Position Description:\u00A0\u00A0Develops and drives database performance standards and initiatives using relational database management technologies -- Oracle, Postgres, SQL, DB2, Neteezza, and Snowflake. Performs and evaluates data migration and integration using Extract Transform and Load (ETL), data structures, and real-time...

  • Director, Database Administration

    3 weeks ago

    Westlake, United States Fidelity TalentSource LLC Full time

    Job Description:Position Description:\u00A0\u00A0Develops and drives database performance standards and initiatives using relational database management technologies -- Oracle, Postgres, SQL, DB2, Neteezza, and Snowflake. Performs and evaluates data migration and integration using Extract Transform and Load (ETL), data structures, and real-time...

  • Principal Data Engineer

    3 months ago

    Westlake, United States Fidelity Investments Full time

    Job Description : Position Description: Develops Web based applications for database use within Cloud environments – Snowflake and Amazon Web Services (AWS). Designs software capabilities for data engineering, modeling, and analysis in an Oracle Exadata Platform and Snowflake Enterprise Data Lake. Develops and deploys pipelines within a Cloud...

  • Senior Database Architect

    19 hours ago

    Westlake, Ohio, United States Fidelity TalentSource LLC Full time

    About the RoleWe are seeking a highly skilled Senior Database Engineer to join our Database Services Technology team. As a key member of our team, you will play a critical role in providing technical leadership and expertise to drive the development and implementation of our data platforms.Key ResponsibilitiesTechnical Leadership: Provide technical guidance...

  • Principal Software Engineer

    2 weeks ago

    Westlake, Ohio, United States Fidelity TalentSource LLC Full time

    Job Overview:Principal Full Stack EngineerPosition SummaryAre you a seasoned Principal Full Stack Engineer with a strong inclination towards crafting and implementing innovative data solutions utilizing cutting-edge technologies? Would you like to contribute to a recommendation platform that fosters a collaborative environment, providing ample opportunities...

  • Principal Software Engineer/Developer

    2 months ago

    Westlake, United States Fidelity TalentSource LLC Full time

    Job Description:Position Description: Architects, designs, develops, deploys, automates, administers, supports, and maintains global deployments of database activity monitoring capabilities and software applications. Develops software applications using DevOps automation. Provides ongoing software application production support for incident, change, and...

  • Principal Data Engineer

    2 months ago

    Westlake, United States Fidelity TalentSource LLC Full time

    Job Description:Position Description: Develops technical solutions to prevent cyber fraud using a wide range of technical and data management tools and technologies -- DB2, Snowflake, Oracle, MongoDB, Redshift, and PostgreSQL. Architects, crafts, and develops highly scalable distributed data processing systems using Amazon Web Services (AWS), Python, Spark,...

  • Principal Software Engineer

    21 hours ago

    Westlake, Ohio, United States Fidelity TalentSource LLC Full time

    About the RoleWe are seeking a highly skilled Principal Software Engineer to join our team at Fidelity TalentSource LLC. As a key member of our engineering team, you will be responsible for designing and building common capabilities that support projects spanning multiple engineering groups.Key ResponsibilitiesDesign and develop large-scale production...

  • Principal Data Engineer

    6 days ago

    Westlake, Ohio, United States Fidelity TalentSource LLC Full time

    Job DescriptionPosition OverviewFidelity TalentSource LLC is seeking a highly skilled Principal Data Engineer to join our team. As a Principal Data Engineer, you will be responsible for designing, developing, and implementing scalable and efficient data architectures using data warehousing solutions, including Amazon Redshift, Oracle, Snowflake, and ETL...

  • Principal Data Engineer

    3 weeks ago

    Westlake, United States Fidelity TalentSource LLC Full time

    Job Description:Position Description:***Multiple Positions Available***Develops PL/SQL and Extract Transfer and Load (ETL) code using Oracle and Informatica to ensure other teams have the correct data. Works in an agile manner within squad and across other teams to deliver and release valuable source code to the application and its users, uses JIRA. Performs...

  • Principal Data Engineer

    1 month ago

    Westlake, United States Fidelity TalentSource LLC Full time

    Job Description:Position Description: ***Multiple Positions Available*** Develops PL/SQL and Extract Transfer and Load (ETL) code using Oracle and Informatica to ensure other teams have the correct data. Works in an agile manner within squad and across other teams to deliver and release valuable source code to the application and its users, uses JIRA....

  • Snowflake Administrator

    1 month ago

    Westlake, Ohio, United States Fidelity TalentSource Full time

    Snowflake Administrator Fidelity TalentSource is your destination for discovering your next temporary role at Fidelity Investments. We are currently sourcing for a Snowflake DBA to work in Fidelity's Data and Architecture Group in Westlake, TX.The Role Fidelity Data Architecture & Engineering is seeking an experienced Database Administrator to join our DBA...

  • Principal, Full Stack Engineer

    3 weeks ago

    Westlake, United States Fidelity Investments Full time

    Job Description:Principal Full Stack Engineer We are seeking a dynamic and experienced individual with a proven track record of collaborating with business partners, understanding business requirements, translating business requirements into system requirements, and making recommendations regarding system functionality. This individual will work closely with...

  • Principal, Full Stack Engineer

    3 weeks ago

    Westlake, United States Fidelity TalentSource LLC Full time

    Job Description:Principal Full Stack Engineer We are seeking a dynamic and experienced individual with a proven track record of collaborating with business partners, understanding business requirements, translating business requirements into system requirements, and making recommendations regarding system functionality. This individual will work closely with...

  • Principal, Full Stack Engineer

    4 weeks ago

    Westlake, United States Fidelity TalentSource LLC Full time

    Job Description:Principal Full Stack Engineer We are seeking a dynamic and experienced individual with a proven track record of collaborating with business partners, understanding business requirements, translating business requirements into system requirements, and making recommendations regarding system functionality. This individual will work closely with...

  • Principal Software Engineer/Developer

    2 months ago

    Westlake, United States Fidelity TalentSource LLC Full time

    Job Description:Position Description: Develops and supports reusable and scalable brokerage account maintenance applications. Develops customer-facing Web applications. Develops Java RESTful services and middle-tier, multi-threaded applications according to Agile methodologies using Java and Typescript. Enhances DevOps technologies, practices, and...

  • Raiser's Edge Database Manager

    2 weeks ago

    Westlake Village, United States momentum-formerly-ucpla Full time

    This position is not a remote position and is located in Thousand Oaks, CA.Candidates with Blackbaud Raisers' Edge platform and functions experience are highly encouraged to applyMomentum seeks the talents and engagement of a Database Manager whose experience reflects mastery in the use of all modules and features of Blackbaud Raiser's Edge and NXT CRM...

  • Principal Application Analyst

    2 weeks ago

    Westlake, Ohio, United States Fidelity TalentSource LLC Full time

    Position Overview:The OpportunityFidelity is in search of a dedicated Agile Principal Systems Analyst to become part of a dynamic team focused on developing innovative applications centered around Student Debt. In this role, you will have the opportunity to create and shape solutions that fulfill not only functional needs but also performance, scalability,...

  • Principal, Data Engineer

    2 weeks ago

    Westlake, United States Fidelity TalentSource LLC Full time

    Job Description:Principal Data Engineer\u00A0The RoleIf you are an experienced Data Engineer with a passion for crafting and delivering Data solutions using leading-edge technologies, looking for a collaborative team environment where you will have wealth of opportunities to innovate and have intellectual curiosity to learn, a career in the Data Platform...