Principal - Database Administrator

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

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

• 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

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 were looking for

• Bachelors or masters 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

Shift timings: 11 AM to 8 PM

Certifications

Category:

Information Technology