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
Apply Now
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