Snowflake Application DBADepartment at One America is seeking an experienced Snowflake Application DBA who is looking to join a fast paced, growing, team focused on growing and managing the Snowflake platform. The ideal candidate should have a desire to leverage and build on their DBA knowledge as well as deepen their understanding of the Snowflake platform. The Snowflake Application DBA will play a central critical role for identifying performing core database administration for the Snowflake environment, build automation to optimize the environment, build pipelines to define metrics related to all things snowflake and be key central point of contact for Snowflake within the organization.
The role involves logical database design, reporting and the ongoing support and primary responsibilities include, but are not limited to:Actively work with Snowflake support for raising support tickets and triaging outagesImplement/support automation for production deployment in SnowflakeDevelop, build & maintain mission critical centralized data platform using SnowflakeDiagnose and troubleshoot Snowflake database errorsImplement Snowflake user /query log analysis and alertsShould work with heterogeneous user groups from data engineers to data scientistsImplement data encryption/decryption/masking policies to protect PII/PCI dataDemonstrated proficiency of index design, query plan optimization and analysis requiredUser security auditingCreate Snowflake utilization and capacity planTune the database to improve Snowflake queriesProvide technical leadership, fosters a team environment, and provides mentorship and feedback to technical resourcesTrain users and answer questionsOn-call responsibilities on rotational basis for Snowflake database administration