Principal - Database Administrator

2 days 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**:
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.



  • Bengaluru, India Epsilon Full time

    Company Description **Job Description**: Seeking a highly motivated and well-rounded Principal Oracle DBA with a strong development background to be part of a fast-paced production support and full-lifecycle implementation team. **Duties And Responsibilities**: - Full life cycle support of client's database(s). Database system uses RAC and non-RAC for...


  • 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...


  • Bengaluru, India Nuance Full time

    We are currently hiring fresh engineering graduate for Database Administrator position who will keep the database up and running smoothly 24/7. Your responsibility as a Database Administrator (DBA) will be the performance, integrity, and security of a database. You'll be involved in the planning and development of the database, as well as in troubleshooting...


  • Bengaluru, Karnataka, India Informatica Full time

    **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 world where data...


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


  • Bengaluru, India Sabre Full time

    This position is in a centralized database administration team, which provides 7x24 support in test/cert/prod environments. You will regularly lead multiple small to medium-size projects or one large project and perform project management activities such as planning, sizing, configuring and scheduling. **Job Requirements**: - 11+ years of experience with...


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

  • HR Administrator

    1 week ago


    Bengaluru, Karnataka, India beBeeHR Administrator Full time ₹ 6,00,000 - ₹ 12,00,000

    As a Human Resources Intern, you will play a vital role in supporting our HR team with essential administrative tasks.\The internship is an excellent opportunity to gain hands-on experience in HR administration and develop your skills in timesheet management, employee record maintenance, and general HR support.\Key Responsibilities:\\Coordinate with team...


  • Bengaluru, India RELX Full time

    Elsevier is a global information analytics company that helps institutions and professionals progress science, advance healthcare and improve performance for the benefit of humanity. Our innovative technology platforms and smart content solutions operate at the cutting edge of big data, semantic web, and cloud technology, enabling faster more effective...


  • Bengaluru, India EFI Full time

    EFI is looking for a Database Administrator to join our IT Team at our Bangalore office. ***Key Responsibilities** Provide database administration support for different types of databases such as MySQL and NoSQL DB. Providing 24/7 support for critical production databases Database Administration (Installing, administrating, implementing, and...