Job Title: Snowflake Administrator
Location: Westlake, TX (Onsite only)
Duration: 12+ Months
MUST HAVE: Recent hands-on experience with Snowflake DBA tasks (maintenance, upgrades, troubleshooting), AWS, and Python expertise.
Position Overview:
We are seeking a Snowflake Database Administrator (DBA) to join the Data and Architecture Group . The selected candidate will be part of the Database, ERP, Platform Engineering & Datalake Operations team, offering end-to-end support for various products and services. A primary focus will be on managing Fidelity’s Snowflake databases and providing critical support to the internal business units and external clients as they onboard new projects to the Snowflake platform.
Key Responsibilities:
- Provide hands-on Snowflake Database Administration, including maintenance, upgrades, and troubleshooting.
- Participate in design discussions with Architects, Security Teams, and Development Teams.
- Manage the Snowflake ecosystem, ensuring efficient performance and stability for enterprise Snowflake databases and associated tools.
- Support database optimization, monitoring, and alerting for Snowflake environments.
- Contribute to disaster recovery and business continuity planning.
- Ensure secure data ingress/egress between Snowflake and various Cloud Service Providers (CSPs).
- Participate in on-call rotations for production support.
Required Qualifications:
- Education: Bachelor's or Master’s degree in Engineering, Information Systems, Computer Science, or related field (or equivalent experience).
- Experience:
- 3-4 years of hands-on Snowflake administration experience, preferably in AWS environments (Azure is also acceptable).
- 5+ years of experience with MPP systems and large data warehouses.
- 5+ years of scripting and automation experience using Python, Shell, or Perl.
- Skills:
- Proficiency in Snowflake platform architecture, features, and security mechanisms.
- Knowledge of DB optimization techniques pertinent to Snowflake.
- Strong understanding of SQL and other procedural database languages (Oracle, DB2, PostgreSQL, SQL Server).
- Hands-on experience with big data ecosystems like Hadoop.
- Ability to manage multiple RDBMS platforms including Postgres, SQL Server, DB2, Netezza, and Snowflake.
Preferred Skills & Expertise:
- Experience with backend programming languages such as PL/SQL, T-SQL, and NZ SQL.
- Familiarity with Java, J2EE, Embedded SQL, and similar technologies.
- Proficiency in working with other MPP systems such as Teradata, Greenplum, and Netezza.
- Ability to collaborate effectively with Application teams, Business experts, and Data modelers in database design and implementation.
- Experience with high availability, disaster recovery, and business continuity architectures.
- Strong communication skills, with an ability to work across teams and present ideas effectively.