Principal | Database Administrator

Job Description:
Job Title – Principal - Database Administrator

The Purpose of This Role

Associate will be part of Data Operations COE group within Fidelity Data Architecture Engineering Division that primarily provides DBA support for multiple RDBMS like Oracle, Oracle E-Business Suite, DB2, PostgreSQL, MongoDB, SQL Server, Netezza RDS on AWS. In addition, this team is also responsible for Data Lake Operations on Cloud that supports Nifi (ELT Tool), Collibra Data Governance, Alation Data Catalogue Enterprise Tools Platform Engineering (Informatica, Middleware), Data masking (TDM) Enterprise Snowflake Admin Support

The Value You Deliver

Work closely with CTG BU in supporting their databases, ensuring the stability, performance help migrate them to public cloud as part of the organization data strategy by partnering with Product teams Architects

Core duties include:

Work closely with the product development team from the design phase of application throughout their Agile development journey, the future enhancements releases

Be part of their Agile Squad planning, understand the priorities roadmap

Participate in the application stress/load test proactively identify resolve the DB performance (batch/OLTP) issues that can potentially breach the SLA’s when the code moves to production

Highlight the new DB features to the product teams that could be used in the application as future enhancements releases

Support the Database Migration, Upgrades as part of Technology Life Cycle Management to be compliant with organization standards

Provide DB Capacity Analysis provide insights to product teams on future storage hardware requirements based on the current data growth overall performance

Identify aging data, propose/develop/implement data archiving, purging partitioning solutions to manage the data growth

Handling Database/Schema Refreshes for the lower database environments

Understand the RTO/RPO requirements for the application databases to define the database backup and restore policy

Managing Database Security Audit violations resolving them

DB User/Access/Roles management

Troubleshooting fixing production DB/SQL performance issues

Providing Oncall support (12/7), working with vendor on DB issues, bugs provide solution

Schedule and Co-ordinate various maintenance activities with Support teams.

Replication design and implementation using Golden Gate

Work on any new DB technology/new-features, POC requirements from application team

Help the application team in migrating their databases to public cloud (AWS).

The Skills that are Key to this role

Technical / Behavioral

Core Oracle DBA skills (Oracle 12c/1+c), RAC Data guard

Strong in Oracle Internals DBA_ Dictionary views

Oracle DB/SQL Performance Tuning relevant tools (SQLTRACE, TKPROF, AWR, ADDM, SQL PROFILE, SQL BASELINES)

Good understanding on Access Methods, Joins, different Indexes its usage, Index scans, interpreting EXECUTION PLANS, Table/Index Statistics, Histograms, wait events etc

Working experience on Oracle Golden Gate for Data Replication, PostgresDB managing RDS on AWS

Strong on PL/SQL Programming

Working experience on Shell scripting for Automation

Problem solving and good analytical skills

Communication, teamwork and negotiation skills

Ability to work in tight deadlines under pressure

Flexible and adaptable to changing business/technology requirements

A sense of ownership that drives quality in everything you do

A forward-looking attitude that keeps you aware of the latest in database cloud technology space

The Skills those are good to have for this role

AWS or relevant cloud technology experience on DB migration to public AWS/Azure from on-prem.

Open Source Database like Maria DB or MySQL etc.

Knowledge on NO-SQL DB’s like MongoDB or Cassandra

Working experience on Snowflake Cloud Datawarehouse DB

Python Programming for Automation or Oracle Apex for building dashboards

Basic knowledge on Tableau/PowerBI for reporting

How Your Work Impacts the Organization

Helping the product teams to migrate their databases to public cloud achieving the organization’s data strategy on having 70% applications migrated to cloud by 2024

The Expertise we’re looking for

8 to 13 years of Oracle DBA (IT) experience

3 + years of experience on Oracle DB/SQL Performance Tuning

1 to 2 years of experience in managing other databases like MS SQL Server, MySQL, PostgresDB RDS on AWS

Experience on automation using shell scripting or python programming or Oracle APEX

Bachelor’s degree in any technology related field (e.g, Engineering, Computer Science, Maths, etc.) required.

Oracle Certification or other RDBMS certifications

AWS/Azure/OCI cloud Certified

Location: Bangalore – Manyata

Shift timings: 11 AM to 8 PM

Certifications:
At Fidelity, building a better financial future— for everyone— is our mission. For the last 75+ years, our privately-held company has remained committed to supporting our clients throughout their lifelong financial journeys.

Our formula is simple: we support our team, and they support our customers. That culture begins with our employees, whose personal and professional growth is key to our collective success. In keeping with that legacy, our privately-held company offers associates career stability and security, while at the same time encouraging your professional exploration and growth. At Fidelity India, we are proud to continue that legacy. With offices in Bangalore and Chennai, our Indian branch is now celebrating 20 years as a Global Capability Center. To find out more, visit India.Fidelity.com, or our global site at FidelityCareers.com.

Fidelity Investments is an equal opportunity employer, and whenever possible we accommodate applicants with disabilities who need adjustments to complete the application or interview process. Please email us at@accommodations@fmr.com or call 800-835-50++ for more information Read more