Snowflake Security Admin / Architect
Location: US East Coast preferred - may consider Remote
Duration: 12 Months

Job Description:

Position is created to address concern on cyber security for data on cloud. Candidate should have a broad understanding of security in database layer, application layer and how they are connected..

Client has a need to handle data in most secure way possible. The consultant should understand privacy, utilize modern tools, and best practices.

Experience on Azure ADLS, Snowflake, Data privacy and protection on ADLS. Ability to provide solutions on handling and management of data and data privacy

 

  • Daily maintenance, monitoring, performance analysis, trouble shooting, problem resolution, and user assistance required for all the Snowflake database environments.

  • Work with a cross-section of internal IT organizations, including other DBA's, systems analysts, developers, outside consultants and the management team.

  • Participate in Information Technology projects as the primary DBA from inception of the project up and through the daily maintenance phase of a project.

  • Provide input into new and existing projects.

  • Responsible for the physical design and architecture

  • Create, monitor and maintain Virtual Data Warehouse(s) supporting various use cases.

  • Collaborate with the CMS enterprise data Modeling team and DBA team regarding optimal clustering and partitioning of data. • Develop project estimates for database activities.

  • Develop database design documentation such as data decompositions and data flow diagrams.

  • Perform database, application and system architecture design.

  • Responsible for developing and maintaining scripts to create appropriate roles for the application teams, implementing Role Based Access Control (RBAC) and Row and Column Level Security (RCLS) for the Snowflake objects.

  • Participate as Subject Matter Expert (SME) as required for design reviews and technology and tool selection

  • Create and execute scripts for various database maintenance activities.

  • Provide guidelines for development and production environments.

  • Perform database tuning including monitoring, troubleshooting and optimizing performance of the databases • Develop archival, backup and recovery strategy.

  • Plan, perform and monitor database backups.

  • Perform database recoveries as appropriate.

  • Provide 24x7 on call production support.

  • Serve as escalation point for database issues.

  • Diagnose database problems and implement solutions.

Qualifications and Education Requirements

Education: Bachelor's degree from an accredited college or university, in lieu of a Bachelor's degree, must have four years related work experience.

  • The Senior Database Administrator must be a certified Snowflake expert with in-depth knowledge in large-scale Snowflake implementations.

  • S/he shall administer and maintain the IDR Cloud Snowflake databases in all environments ensuring their optimal performance and security

  • Extensive experience with Enterprise Data Warehouses and Data Marts required.

  • Capable of supporting and implementing technology projects as the primary DBA in support of business initiatives.

  • Ability to create and maintain positive and professional business relationships with both internal associates and external customers.