Principal Oracle DBA

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

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

• 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

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

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…