Principal - Database Administrator

1 month ago

Bengaluru, India Fidelity Investments Full time

**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**:

- Be part of their Agile Squad planning, understand the priorities & roadmap
- 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
- 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

**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
- 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**

**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**:
Company Overview

Fidelity Investments is an equal opportunity employer.

  • Principal - Database Administrator

    1 month ago

    Bengaluru, India Fidelity Investments Full time

    **Job Title - Principal - Database Administrator** **The Purpose of This Role** Hired associate would be responsible for providing end to end support for the backend databases of Fidelity. The associate in this role would work towards providing stability in the environment, ensure databases and services are up and running always, ensure compliance of...

  • Principal - Database Administrator

    6 days ago

    Bengaluru, India Fidelity Investments Full time

    **Job Title - Principal - Database Administrator** **The Purpose of This Role** Hired associate would be responsible for providing end to end support for the backend databases of Fidelity. The associate in this role would work towards providing stability in the environment, ensure databases and services are up and running always, ensure compliance of...

  • Principal Database Administrator

    2 weeks ago

    Bengaluru, India Oracle Full time

    Job Title : Principal Database Administrator - RAC / Python /Shell ScriptingJob Location : BengaluruExp Range : 9-16 yearsPosition Overview : As a member of the team, you will have the opportunity to work on high scale test development and complete end-to-end automation of high scale applications on Oracle’s Engineered Systems platforms.Roles &...

  • Principal - Database Administration

    2 months ago

    Bengaluru, India Fidelity Investments Full time

    Job Description: Job Title: Principal – Database Administration Build a data platform to support Asset Management’s data analytics and discovery needs. If you have a passion for working with data using multiple emerging technologies on the cloud, this might be the right opportunity for you! The Purpose of Your Role Lead Database...

  • Principal - Database Administration

    1 week ago

    Bengaluru, India Fidelity Investments Full time

    Job Description: Job Title: Principal – Database Administration Build a data platform to support Asset Management’s data analytics and discovery needs. If you have a passion for working with data using multiple emerging technologies on the cloud, this might be the right opportunity for you! The Purpose of Your Role Lead Database...

  • Principal - Database Administration

    1 month ago

    Bengaluru, Karnataka, India Fidelity Investments Full time

    **Job Title : Principal - Database Administration** **The Purpose of This Role** - Provide Database Administration to Mainframe DB2 systems. Work with senior level business and technology partners to define and implement database solutions. The person will be responsible in providing Database Administration to DB2 systems. **The Value You Deliver** The...

  • Principal Database Administrator

    1 month ago

    Bengaluru, India Informatica Full time

    External Description: Build Your Career at Informatica We're looking for a diverse group of collaborators who believe data has the power to improve society. Adventurous, work-from-anywhere minds who value solving some of the world's most challenging problems. Here, employees are encouraged to push their boldest ideas forward, united by a passion to create a...

  • Principal Database Administrator

    1 week ago

    Bengaluru, India Informatica Full time

    External Description: Build Your Career at Informatica We're looking for a diverse group of collaborators who believe data has the power to improve society. Adventurous, work-from-anywhere minds who value solving some of the world's most challenging problems. Here, employees are encouraged to push their boldest ideas forward, united by a passion to create a...

  • Principal Database Administrator

    1 month ago

    Bengaluru, India Informatica Full time

    External Description:Build Your Career at InformaticaWe're looking for a diverse group of collaborators who believe data has the power to improve society. Adventurous, work-from-anywhere minds who value solving some of the world's most challenging problems. Here, employees are encouraged to push their boldest ideas forward, united by a passion to create a...

  • Principal Database Administrator

    3 weeks ago

    Bengaluru, India Epsilon Full time

    Job DescriptionAbout BUAt the heart of everything we do is data and this team. Our premium data assets empower the team to drive desirable outcomes for leading brands across industries. Armed with high volumes of transactional data, digital expertise and unmatched data quality, the team plays a key role in improving all our product offerings. Our data...

  • Principal, Database Administration

    6 days ago

    Bengaluru, India AT&T Full time

    **Position overview**: AT&T Consumer Technology eXperience product team is looking for a Principal Database administrator who is passionate about the eCommerce industry and has analytical and multi-task abilities to thrive in a fast-paced environment. This role requires familiarity with a wide variety of data platforms, including Cassandra, Mongo, and...

  • Principal Database Administrator

    7 days ago

    Bengaluru, India Oracle Full time

    Job Title : Principal Database Administrator - RAC / Python /Shell ScriptingJob Location : BengaluruExp Range : 9-16 yearsPosition Overview: As a member of the team, you will have the opportunity to work on high scale test development and complete end-to-end automation of high scale applications on Oracle’s Engineered Systems platforms.Roles &...

  • Principal - Database Administration

    1 month ago

    Bengaluru, Karnataka, India Fidelity Investments Full time

    **Job Title: Principal - Database Administration** Build a data platform to support Asset Management’s data analytics and discovery needs. If you have a passion for working with data using multiple emerging technologies on the cloud, this might be the right opportunity for you! **The Purpose of Your Role** Lead Database Administration will function as...

  • Principal - Database Administration

    2 months ago

    Bengaluru, India Fidelity Investments Full time

    Job Description:Job Title: Principal – Database AdministrationBuild a data platform to support Asset Management’s data analytics and discovery needs. If you have a passion for working with data using multiple emerging technologies on the cloud, this might be the right opportunity for you!The Purpose of Your RoleLead Database Administration will function...

  • Principal - Database Administration

    5 days ago

    Bengaluru, India Fidelity Investments Full time

    Job Description:Job Title: Principal – Database AdministrationBuild a data platform to support Asset Management’s data analytics and discovery needs. If you have a passion for working with data using multiple emerging technologies on the cloud, this might be the right opportunity for you!The Purpose of Your RoleLead Database Administration will function...

  • Principal Database Administrator

    2 weeks ago

    Bengaluru, India Oracle Full time

    Job Title : Principal Database Administrator - RAC / Python /Shell ScriptingJob Location : BengaluruExp Range : 9-16 years Position Overview : As a member of the team, you will have the opportunity to work on high scale test development and complete end-to-end automation of high scale applications on Oracle’s Engineered Systems platforms. Roles &...

  • Principal Database Administrator

    2 weeks ago

    Bengaluru, India Oracle Full time

    Job Title : Principal Database Administrator - RAC / Python /Shell ScriptingJob Location : BengaluruExp Range : 9-16 years Position Overview : As a member of the team, you will have the opportunity to work on high scale test development and complete end-to-end automation of high scale applications on Oracle’s Engineered Systems platforms. Roles &...

  • Principal Database Administrator

    1 week ago

    Bengaluru, India Oracle Full time

    Job Title : Principal Database Administrator - RAC / Python /Shell ScriptingJob Location : BengaluruExp Range : 9-16 years Position Overview : As a member of the team, you will have the opportunity to work on high scale test development and complete end-to-end automation of high scale applications on Oracle’s Engineered Systems platforms. Roles &...

  • Principal Database Administrator

    1 week ago

    Bengaluru, India Oracle Full time

    Job Title : Principal Database Administrator - RAC / Python /Shell ScriptingJob Location : BengaluruExp Range : 9-16 years Position Overview : As a member of the team, you will have the opportunity to work on high scale test development and complete end-to-end automation of high scale applications on Oracle’s Engineered Systems platforms. Roles &...

  • Principal Database Administrator

    7 days ago

    Bengaluru, India Oracle Full time

    Job Title : Principal Database Administrator - RAC / Python /Shell Scripting Job Location : Bengaluru Exp Range : 9-16 years Position Overview : As a member of the team, you will have the opportunity to work on high scale test development and complete end-to-end automation of high scale applications on Oracle’s Engineered Systems platforms. Roles &...