Fidelity Investments

Job Description:

Job Title – Senior 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, RDS & Ec2 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 Platform Support

The Value You Deliver

Work closely with CST/ETGS BU’s in supporting their databases, ensuring stability, performance & help migrate them to public cloud as part of the organization data strategy by partnering with Product teams & Architects

Core duties include:

• Partner closely with product development teams from the design phase through the full Agile development lifecycle, including future enhancements and production releases.
• Actively participate in Agile squad ceremonies, including sprint planning, to understand product priorities, roadmaps, and delivery timelines.
• Lead and support application stress and load testing, proactively identifying and resolving database performance bottlenecks (OLTP and batch) to ensure SLA compliance before production releases.
• Proactively recommend and evangelize new database features and capabilities that can be leveraged by product teams for future enhancements.
• Support database migrations and version upgrades as part of Technology Lifecycle Management, ensuring compliance with organizational and audit standards.
• Perform database capacity planning and growth analysis, providing insights on future storage, compute, and hardware requirements based on data growth trends and performance metrics.
• Identify aging and high-volume data and design, develop, and implement data archiving, purging, and partitioning strategies to efficiently manage database growth.
• Manage and execute database and schema refreshes for lower (non-production) environments.
• Define and implement backup, recovery, and restore strategies aligned with application RTO/RPO requirements.
• Address and remediate database security audit findings, ensuring adherence to security, compliance, and governance standards.
• Manage database users, access controls, roles, and privileges in line with least-privilege and compliance principles.
• Troubleshoot and resolve production database and SQL performance issues, ensuring high availability and system stability.
• Provide 12x7 on-call support, collaborate with vendors on database-related issues and bugs, and drive issues to resolution.
• Plan, schedule, and coordinate database maintenance activities with application and support teams to minimize operational impact.

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, Azure SQL MI & managing RDS/Databases 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

• Knowledge of distributed databases like Yugabyte, Cockroach DB, etc
• Experience on Snowflake Cloud Datawarehouse DB
• Basic knowledge BI tools Tableau/PowerBI for reporting

How Your Work Impacts the Organization

Enabling stable, high‑performing database environments while delivering an exceptional customer experience

The Expertise we’re looking for

• 5 to 9 years of DBA (IT) experience
• 2 + years of experience on Oracle DB/SQL Performance Tuning
• 1 to 2 years’ experience on managing other databases like MS SQL Server, PostgresDB, Snowflake & cloud
• Experience Automation skills using Shell scripting, Python etc
• 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 – EGL/Manyata

Shift timings: 11 AM to 8 PM

Certifications:

Category:

Information Technology