2065041
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 2026
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@
[email protected] or call 800-835-50++ for more information
