Principal Oracle DBA, Merrimack, New Hampshire

Description

The Purpose of This Role
The FFIO Data Technology Services team provides Data services to the FFIO business unit. The team provides Database support, Design and Development support to Delivery teams and in the Cloud Migration & Management. Apart from this, the Data Technology Services team also builds utilities that help in increasing efficiency of the database platforms and increases productivity of the teams. In this role, you will be working with multiple teams including Architects & Product Development teams
The Value You Deliver

You will use your experience and subject matter expertise to help the product teams implement the best practices from a data perspective.
You will leverage your experience in providing analytical inputs and insights to the team when needed and your overall guidance to the team in line with the Business Unit priorities.
Your experience and expertise will be leveraged by teams in their areas.
You will define, own and drive initiatives within the team that increase productivity and add value to the business unit. Some examples include self service capabilities, automation of regular activities and reporting.
You have a very good understanding of the Cloud environments (AWS) and have managed large scale environments in Cloud.

The Skills that are Key to this role
Technical / Behavioral
Demonstration of Experience and Expertise in the following areas.

Working with Application Development and Performance Teams on Tuning Database components during the Design to Deployment phases in the areas of Oracle SQL and PLSQL, RAC & Golden gate
In depth knowledge of Cloud components (AWS platform) that include Databases, underlying infrastructure and related components.
In-depth knowledge Oracle RAC, Oracle Performance & Tuning and SQL Tuning
Application Areas such as Schema Design, Data Models, Best Practices, Database Features
To work with the Application support functions team on database related activities with in-depth knowledge of concepts of Oracle database environments including Oracle RAC,
Experience and Expertise in Oracle SQL Tuning and Instance Tuning
To identify and execute improvements in database services, through automation, self-service enablement and process improvements
Work with Application Development and Performance Teams on Tuning Database part during the Design to Deployment phases in the areas of Oracle SQL and PLSQL, RAC & Golden gate
Participates in design reviews
Participate in level 3 on-call rotation to support critical applications based on business requirements
Work with the systems analysts to define requirements
Work with multiple projects and product teams simultaneously.
Traditional Database Technologies – Oracle, DB2 UDB, MS SQL Server, Sybase
Big Data Technologies Exposure – No SQL Databases such as Cassandra, MongoDB
AWS Cloud Technologies such as RDS, EC2, EKS
AWS Cloud Concepts
Excellent troubleshooting and error analysis skills
Working knowledge of Information Security concepts
Solid understanding of software development lifecycle
Exceptional customer service skills
Ability to learn and adapt to new technologies
Ability to work in fast paced, highly demanding environment
Qualified applicant should have 15+ years of Oracle Database Support, Design, Performance & Tuning experience working in a complex, multi-platform environment and should have done production support

The Skills that are Good to Have for this role

Strong verbal and written communication skills, both technical and non-technical
Ability to communicate based on the target audience.
Agile Methodology

How Your Work Impacts the Organization
The FFIO (Fidelity Fund and Investment Operations) Technology Group is responsible for delivering top quality scalable systems solutions for the Asset Management business functions within Fidelity Investments. The FFIO Technology Platform consists of mainframe and distributed architecture including multiple interfaces both internal and external to the FFIO Organization. The systems employed include the source fund accounting, pricing, tax and data exchange platforms. The data is sourced from multiple accounting, trading and reference data systems within Fidelity, stored in central database and shared with internal or external customer groups through system-to-system interfaces to support fund setup, reporting, analytic and oversight functions. The DTS team has visibility to senior management by virtue of their activities and their impact.
The Expertise We’re Looking For

Bachelors or Masters Engineering Degree or any equivalent degree with the relevant experience.
12-15 years of relevant experience.

Company Overview
Fidelity Investments is one of the world's largest providers of financial services. Headquartered in Boston, US, Fidelity's goal is to make financial expertise broadly accessible and effective in helping people live the lives they want. Privately held for nearly 75 years, Fidelity employs 80,000+ associates who are focused on the long-term success of our customers.

The hourly pay rate range for this position is $60.00 – $80.00 per hour.

Placement in the range will vary based on job responsibilities and scope, geographic location, candidate’s relevant experience, and other factors