Principal Database Administrator

Job Description:

Position Description:

Develops and drives database performance, standards, and initiatives using database technologies -- Oracle, Postgres, and SQL. Improves and maintains end-to-end database technology stacks -- Exadata within Oracle Database environments. Improves and maintains database performance within platforms -- Cassandra and engineered systems. Performs application database administration using Aurora PostgresSQL services, SQL code review, performance analysis, query tuning, database application design, physical data modeling, development support, and software engineering. Participates in database replication using distributed replication technologies -- Oracle Goldengate and EDB Replication. Facilitates data migration to cloud database platforms -- Cosmos DB, Yugabyte, Cockroach DB, Azure, and other cloud native databases. Visualizes and structures workflows and tasks using agile methodologies -- Scrum and Kanban.

Primary Responsibilities:

• Tests, defines, and evaluates database maintenance tools and build processes.
• Establishes performance tuning criteria and methods in coordination with internal and external technical resources.
• 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 collaborates with programmers and analysts to make changes.
• Develops methods for integrating products so they work properly together -- customizing commercial databases to fit specific needs.
• Confers with systems analysts and other software engineers/developers to design systems and to obtain information on project limitations and capabilities, performance requirements and interfaces.

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) developing database performance standards, and initiatives using database technologies -- Oracle, Postgres, and SQL.

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) developing database performance standards, and initiatives using database technologies -- Oracle, Postgres, and SQL.

Skills and Knowledge:

Candidate must also possess:

• Demonstrated Expertise (\u201CDE\u201D) designing, installing, configuring, and performance tuning data replication across homogeneous and heterogenous databases; performing end-to-end replication (Uni and Bi-directional) across Oracle RAC multi-sites using Oracle Golden Gate replication; and setting up Disaster Recovery (DR) solutions for highly critical databases residing on engineered systems -- Exadata and Oracle Database Appliance (ODA) -- using Dataguard.
• DE designing, planning, and implementing database migration practices from On-premises data centers to Amazon Web Services (AWS) Cloud Infrastructure within a Continuous Integration/Continuous Delivery (CI/CD) data environment using Oracle Data Pump (expdp and impdp), database links, and Database Management Systems (DMS); and setting up infrastructure on Azure using Terraform code.
• DE coordinating and supporting database objects (stored procedures, functions, views, indexes, materialized views, triggers, partitioning tables, tablespaces, and schemas) by deploying changes for On-premises, Oracle, MongoDB, and Microsoft SQL server databases, and AWS Cloud RDS instances using Toad, Mongo Atlas, PLSQL, and SQL tools (Plus, Developer, and Server Management Studio).
• DE performing database optimization, storage management, and performance tuning using Realtime SQL; monitoring alerts and reports using Oracle Enterprise Manager, AWS CloudWatch, and performance insights; optimizing queries using SQL Tuning advisor and SQL Profiling; and implementing database upgrades, patching, backup/recovery, full/differential backups, and refreshes using RMAN, Data Guard, OPtach, CronJobs, Bash Scripts, and SQL server scheduler jobs.

#PE1M2

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.