Principal - Database Administrator

1 week ago


Bengaluru, Karnataka, 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 Coordinate 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 forwardlooking 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 onprem.
  • 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.

  • Bengaluru, Karnataka, 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 as...


  • Bengaluru, Karnataka, India Oracle Full time

    Job Opening: Principal Database Administrator - RAC / Python /Shell ScriptingLocation: BengaluruExperience: 9-16 yearsWelcome to an Exciting Opportunity! Join our team and be part of developing test methodologies for high-scale applications on Oracle's Engineered Systems platforms.Key Responsibilities:Develop innovative test methodologies to maximize system...


  • Bengaluru, Karnataka, 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 enjoy working with data using various cutting-edge technologies on the cloud, this opportunity could be a great fit for you.The Purpose of Your RoleLead Database Administration will act as an Oracle...


  • Bengaluru, Karnataka, India Informatica Full time

    External Description:Build Your Career at Informatica. We're searching for a diverse group of collaborators who believe in the transformative power of data to enhance society.We're on the lookout for ambitious individuals, with the flexibility to work from anywhere, who are passionate about tackling some of the most complex challenges the world faces.At our...


  • Bengaluru, Karnataka, India Fidelity Investments Full time

    Job Title : Principal - Database AdministrationThe 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 DeliverThe Mainframe DBA group...


  • Bengaluru, Karnataka, India Fidelity Investments Full time

    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 youThe Purpose of Your RoleLead Database Administration will function as an Oracle DBA,...


  • Bengaluru, Karnataka, India timesjobs Full time

    Job Number: 37070Primary Location: Bangalore, Karnataka INExperience Level: Mid-Senior LevelTravel Requirement: LimitedBuild 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....


  • Bengaluru, Karnataka, India timesjobs Full time

    Job Number: 37070Primary Location: Bangalore, Karnataka INExperience Level: Mid-Senior LevelTravel Requirement: LimitedBuild 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....


  • Bengaluru, Karnataka, India timesjobs Full time

    Job Number: 37070Primary Location: Bangalore, Karnataka INExperience Level: Mid-Senior LevelTravel Requirement: LimitedBuild 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....


  • Bengaluru, Karnataka, India Epsilon Full time

    Job Description About BU At 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...


  • Bengaluru, Karnataka, 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 Oracle.Key...

  • Office Manager

    1 week ago


    Bengaluru, Karnataka, India Principal Axis Full time

    Company OverviewPrincipal Axis Systems is a network of businesses based in central Bangalore.Job DescriptionWe are looking for a dedicated Office Manager to join our team at Principal Axis. As the Office Manager, you will take charge of the daily office operations, from administrative support to customer service and office equipment management. This is an...


  • Bengaluru, Karnataka, India Oracle Full time

    Work with Oracle's world class technology to develop, implement, and support Oracle's global infrastructure.As a member of the IT organization, assist with the analyze of existing complex programs and formulate logic for new complex internal systems. Prepare flowcharting, perform coding, and test/debug programs. Develop conversion and system implementation...


  • Bengaluru, Karnataka, India Stanch Full time

    is an all-in-one business application that provides Accounting, HRM-Payroll, and Compliance as SaaS and services through its unified Cloud business application. Our application is managed by dedicated finance experts and offers features such as Order-to-Cash, Procure-to-Pay, Inventory Management, Financial Reporting, Employee Self Service, Compliance...


  • Bengaluru, Karnataka, India growel softech Full time

    1& 21 contract resource; - DBA - 1 contract resource. Budge t - 2 to 2.5 L/pm for the below Experience 6+ yrs. for Azure DevOpsDatabase Administrator DBA yrsLocation - Bangalore (Remote is fine for Azure DevOps ) Database Administrator 25% Database administration and troubleshooting skills with PostgreSQL, MySQL, MongoDB, Elasticsearch, and Redis.


  • Bengaluru, Karnataka, India Stanch Full time

    is an all-in-one business application that provides Accounting, HRM-Payroll, and Compliance as SaaS and services through its unified Cloud business application. Our application is managed by dedicated finance experts and offers features such as Order-to-Cash, Procure-to-Pay, Inventory Management, Financial Reporting, Employee Self Service, Compliance...


  • Bengaluru, Karnataka, India Black Box Full time

    Database ADMINISTRATOR:Location:Manyata Tech ParkShift:6 PM - 3 AM ISTOverview:A professional Database Administrator (DBA) will keep the database up and running smoothly 24/7. The goal is to provide a seamless flow of information throughout the company, considering both backend data structure and frontend accessibility for end-users.Responsibilities:...


  • Bengaluru, Karnataka, India Andor Tech Full time

    Responsibilities : Design, implement, and maintain database systems, with a primary focus on MySQL databases, to ensure optimal performance, reliability, and security. Perform database administration tasks including installation, configuration, backup and recovery, monitoring, and troubleshooting. Develop and implement automation scripts using PowerShell or...


  • Bengaluru, Karnataka, India Oracle Full time

    Oracle Health and AI Building off our Cloud momentum, Oracle has formed a new organization - Oracle Health Applications & Infrastructure. This team will focus on product development and product strategy for Oracle Health while building out a complete platform supporting modernized, automated healthcare. This is a net new line of business, constructed...


  • Bengaluru, Karnataka, India Oracle Full time

    As a member of the DBA team, you should:Be experienced in defining maintenance operations like backup strategy, patching process etc for production databasesPossess strong work experience in Oracle Autonomous DatabaseHave extensive experience on daily operational responsibilities for live production databasesPossess the expertise to troubleshoot database...