Lead - Database Administrator

Job Title – Lead Database Administrator

The Purpose of This Role

 Data Operations COE is part of Enterprise Data & AI Division that primarily provides DBA support for multiple RDBMS like Oracle, DB2, PostgreSQL, SQL Server, Yugabyte & RDS on AWS. In addition, this team is also responsible for Data Lake Operations on Cloud that supports Nifi (ELT Tool), Collibra, Alation Enterprise Tools & Platform Engineering (Middleware), Data masking (TDM) & Enterprise Snowflake Admin Support

Work closely with Fidelity Business Units in onboarding their data into Enterprise Datawarehouse Snowflake DB platform (SaaS) & implement the security/audit requirements/standards by partnering with Enterprise Cloud Computing, Cyber Security & manage it

The Value You Deliver

Core duties include:

• Define best practices on Snowflake & implement them by closely working with Data Architects & Product Teams

• Maintain deep understanding of complex technologies and help business units to leverage Enterprise Snowflake as part of their data analytics strategy

• Work with product teams, help them in designing & onboarding their warehouse data to Enterprise Datawarehouse Snowflake platform

• Build, design, architect and implement high-volume, high-scale data analytics and machine learning Snowflake solutions in the cloud.

• Provide technology leadership in driving large complex Snowflake implementations

• Provide guidance on how to resolve customer-specific technical challenges & work with the snowflake vendor on resolving bugs or any new requirements

• Tune Snowflake for better performance and optimize the utilization of both storage & processing thereby leading to cost efficiency

• Design the monitoring requirements, automate them using python programming & shell scripting

• Understand Data Classification (PII) defined by Information Security Office (ISO) & implement auditing measures to ensure strict controls on data access

• Provide snowflake trainings on new features & how they can be leveraged by the product teams

• Being a Technical SME for Snowflake platform

The Skills that are Key to this role

Technical / Behavioral

• 5+ years of IT experience

• Relevant experience as Core DBA on Oracle, MS SQL Server or any other RDBMS

• Experience on supporting Snowflake Data Warehouse production platform

• Experience on supporting any databases on public cloud (AWS, Azure)

• Proficient in SQL for complex querying, data transformation, and demonstrate expertise in query performance optimization

• Deep understanding of Snowflake architecture, including virtual warehouses, micro-partitions, and caching.

• Hands-on experience with Snowflake account-level management: User and role administration, Resource monitoring, credit usage, Cost optimization and billing insights

• Skilled in Snowflake integration with external systems and cloud storage (AWS S3, Azure Blob, GCP)

• Expertise in Snowflake Secure Data Sharing setup and management

• Experience with Snowflake replication and failover strategies across regions/accounts

• Knowledge of network policies for securing access (IP whitelisting, private connectivity)

• Familiarity with cloud platforms (AWS, Azure, GCP) and their data services.

• Optional: Exposure to BI tools like Tableau & Power BI

• Designing & implementing High Availability, Disaster Recovery solutions

• Providing Oncall support (12/7), working with vendor on DB issues, bugs & provide solution

• Problem solving and good analytical skills

• Exhibit Thought leadership, be a Team Player, good communication and negotiation skills

• Ability to work in tight deadlines under pressure

• Flexible and adaptable to changing business/technology requirements

The Skills those are good to have for this role

• Prior experience in migrating Data to Public Cloud (AWS/Azure)

• Knowledge on Datawarehouse & Data Modelling concepts

• Snowflake/AWS certifications will be an added plus

• Python Programming skills

• Tableau or PowerBI reporting tools for building dashboards

How Your Work Impacts the Organization

Transforming our data environment to a highly valued business asset supporting enhanced customer experience, rapid creation of new products, advanced AI and analytics by moving the data to Enterprise Snowflake Platform

The Expertise we’re looking for

• Bachelors or master’s in Engineering, Information Systems, Computer Science or Information Technology or equivalent experience

• 5+ years of Database Administration (IT) experience

• Experience managing Snowflake Data Warehouse production platform

• Managing databases on public Cloud (AWS/Azure)

• AWS/Snowflake/DB certifications

Location: Bangalore / Chennai

Shift timings: 11 AM to 8 PM