Job Description
Job Title Principal 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
- 12 + years of IT experience
- 5 + years of experience as Core DBA on Oracle, MS SQL Server or any other RDBMS
- 3 + years of experience on supporting Snowflake Data Warehouse production platform
- 3 + years of 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
- 9 to 12 years of Database Administration (IT) experience
- 3 + years of 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
Certifications
Category:
Information Technology
