Principal - Database Administrator at Fidelity Investments

Bangalore, karnataka, India -

Full Time

Start Date

Immediate

Expiry Date

16 Mar, 26

Salary

0.0

Posted On

16 Dec, 25

Experience

10 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Oracle DBA, RAC, Data Guard, SQL Performance Tuning, PL/SQL Programming, Shell Scripting, Data Migration, Database Security, Database Backup, Data Replication, AWS, PostgreSQL, MongoDB, Oracle Golden Gate, Cloud Technology, Data Governance, Data Lake Operations

Industry

Financial Services

Description

Job Description: Job Title – Principal - Database Administrator The Purpose of This Role Associate will be part of Data Operations COE group within Enterprise Data & AI Division that primarily provides DBA support for multiple RDBMS like Oracle, Oracle E-Business Suite, Db2, PostgreSQL, MongoDB, SQL Server, Ec2/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 Analytical Platform (Snowflake) Admin/Operational Support The Value You Deliver Work closely with CTG & EDAI 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 system 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, restore policy & solutioning the MAA (Maximum Availability Architecture) Managing Database Security Audit violations & resolving them DB User/Access/Roles management Troubleshooting & fixing production DB/SQL performance issues (CPU intensive & long running) Providing Oncall support (12/7), working with vendor on DB issues, bugs & provide solution Schedule and Co-ordinate various maintenance activities with Support teams. Data 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/19c), RAC & Data guard Strong in Oracle Internals, DBA_ Dictionary views & basic Data modelling concepts 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 & partitioning. Analyze Oracle 19c database workloads with emphasis on I/O-intensive & long running SQL queries Review execution plans, table/index statistics, and storage usage Identify performance bottlenecks due to full table scans, large table joins, and high-latency disk operations & fine tune the system Strong on PL/SQL Programming Working experience on Oracle Golden Gate for Data Replication 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 PostgreSQL etc. Knowledge on NO-SQL/Distributed DB’s like MongoDB or Cassandra & Yugabyte or Cockroach. Basic knowledge on Tableau/PowerBI/Oracle Apex for building dashboards AWS/Azure/OCI cloud Certified 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 & also providing a stable & highly performing DB environment The Expertise we’re looking for 10 to 13 years of Oracle DBA (IT) experience 4 + years of experience on Oracle DB & SQL Performance Tuning using various Oracle tools is a must. 1 to 2 or experience in PL/SQL Development & strong in writing effective SQL Queries Experience on automation using shell scripting or python programming or Oracle APEX Certification in Oracle or other RDBMS Location: Bangalore – Manyata/ EGL Shift timings: 11 AM to 8 PM Certifications: Category: Information Technology At Fidelity, we are passionate about making our financial expertise broadly accessible and effective in helping people live the lives they want! We are a privately held company that places a high degree of value in creating and nurturing a work environment that attracts the best talent and reflects our commitment to our associates. We are proud of our diverse and inclusive workplace where we respect and value our associates for their unique perspectives and experiences. For information about working at Fidelity, visit FidelityCareers.com. Fidelity Investments is an equal opportunity employer. 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 please contact the following: For roles based in the US: Contact the HR Leave of Absence/Accommodation Team by sending an email to accommodations@fmr.com, or by calling 800-835-5099, prompt 2, option 2 For roles based in Ireland: Contact AccommodationsIreland@fmr.com For roles based in Germany: Contact Accommodationsgermany@fmr.com Fidelity Privacy Policy

Responsibilities

The Principal Database Administrator will provide DBA support for multiple RDBMS and assist in migrating databases to the public cloud. They will also participate in Agile development processes and ensure database performance and stability.